CKMLAVRDOCIT SAP table for – Lines for Cumulation Posting Document

Here we would like to draw your attention to CKMLAVRDOCIT table in SAP. As we know it is being mainly used with the SAP CO-PC (Product Cost Controlling in CO) component which is coming under CO module (Controlling). CKMLAVRDOCIT is a SAP standard transparent table used for storing Lines for Cumulation Posting Document related data in SAP. It comes under the package CO_ML_AVR.

SAP CKMLAVRDOCIT table

Table CKMLAVRDOCIT technical data

TableCKMLAVRDOCIT
Data storingLines for Cumulation Posting Document
ModuleCO
ComponentCO-PC
SAP PackageCO_ML_AVR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CKMLAVRDOCIT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CKMLAVRDOCIT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KOMOK
    Its data type is C (Character String) with field length 3
  • LOGVO : Logical Transaction
    Its data type is C (Character String) with field length 6
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • MAT_KDAUF : Sales order number of valuated sales order stock
    Its data type is C (Character String) with field length 10
  • MAT_KDPOS : Sales Order Item of Valuated Sales Order Stock
    Its data type is N (Character String with Digits Only) with field length 6
  • MAT_PSPNR : Valuated customer stock WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • BELNR : Accounting Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • BKLAS : Valuation Class
    Its data type is C (Character String) with field length 4
  • BSCHL : Posting Key
    Its data type is C (Character String) with field length 2
  • PPRCTR : Partner Profit Center
    Its data type is C (Character String) with field length 10
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is C (Character String) with field length 4
  • SGTXT : Item Text
    Its data type is C (Character String) with field length 50
  • MONAT : Fiscal period
    Its data type is N (Character String with Digits Only) with field length 2
  • GJAHR : Fiscal Year
    Its data type is N (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BLART : Document type
    Its data type is C (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KJAHR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • VORGN : Transaction Type for General Ledger
    Its data type is C (Character String) with field length 4
  • BEKNZ
    Its data type is C (Character String) with field length 1
  • BWMOD : Valuation grouping code
    Its data type is C (Character String) with field length 4
  • PERIV
    Its data type is C (Character String) with field length 2
  • KTOPL
    Its data type is C (Character String) with field length 4
  • KTOSL : Transaction Key
    Its data type is C (Character String) with field length 3
  • KOART : Account type
    Its data type is C (Character String) with field length 1
  • KSCHL : Condition Type
    Its data type is C (Character String) with field length 4
  • SAKNR : G/L Account Number
    Its data type is C (Character String) with field length 10
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • HKONT : From Number of G/L Account
    Its data type is C (Character String) with field length 10
  • STATUS : AC: Context Status
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CKML_S_ACCIT_COBL
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • LSTAR : Activity Type
    Its data type is C (Character String) with field length 6
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • KSTRG : Cost Object
    Its data type is C (Character String) with field length 12
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • URZEILE : Original item in material or invoice document
    Its data type is N (Character String with Digits Only) with field length 6
  • NPLNR : Network Number for Account Assignment
    Its data type is C (Character String) with field length 12
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • AUPOS : Sales Document Item
    Its data type is N (Character String with Digits Only) with field length 6
  • KDAUF : Sales Order Number
    Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is N (Character String with Digits Only) with field length 10
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • KALN1
    Its data type is N (Character String with Digits Only) with field length 12
  • PRZNR : Business Process
    Its data type is C (Character String) with field length 12
  • IMKEY : Internal Key for Real Estate Object
    Its data type is C (Character String) with field length 8
  • DABRZ : Reference date for settlement
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VBUND : Company ID of trading partner
    Its data type is C (Character String) with field length 6
  • AWREF_REV : Reversal: Reverse Document Reference Document Number
    Its data type is C (Character String) with field length 10
  • AWORG_REV : Reversal: Reverse Document Reference Organization
    Its data type is C (Character String) with field length 10
  • STATUS_IT
    Its data type is C (Character String) with field length 2
  • BELNR_POST
    Its data type is C (Character String) with field length 10
  • KJAHR_POST
    Its data type is N (Character String with Digits Only) with field length 4
  • BELNR_REV
    Its data type is C (Character String) with field length 10
  • BUSTW : Posting string for values
    Its data type is C (Character String) with field length 4
  • KJAHR_REV
    Its data type is N (Character String with Digits Only) with field length 4
  • REVERSAL_ITEM
    Its data type is C (Character String) with field length 1
  • VORSL
    Its data type is C (Character String) with field length 3
  • FELDN
    Its data type is C (Character String) with field length 16