CKMLAVRDOCIT SAP (Lines for Cumulation Posting Document) Table details
Description: Lines for Cumulation Posting Document
Table field list including key, data, relationships and ABAP select examples
CKMLAVRDOCIT is a standard SAP Table which is used to store Lines for Cumulation Posting Document data and is available within R/3 SAP systems depending on the version and release level.
The CKMLAVRDOCIT table consists of various fields, each holding specific information or linking keys about Lines for Cumulation Posting Document data available in SAP. These include BELNR (Document Number of a Closing Document for Cumulation), KJAHR (Year in Which Closing Document for Cumulation Was Saved), POSNR (Accounting Document Line Item Number), URZEILE (Original item in material or invoice document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP CKMLAVRDOCIT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BELNR | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR | 10 | ALPHA | BELNR | |||
KJAHR | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC | 4 | GJAHR | GJAHR | |||
POSNR | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | POSNR_ACC | ||||
URZEILE | Original item in material or invoice document | CK_URZEILE | NUMC | 6 | NUMC6 | ||||
KALN1 | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
BUSTW | Posting string for values | BUSTW | CHAR | 4 | BUSTW | ||||
VORSL | Transaction/event key for account determination | VORSL | CHAR | 3 | VORSL | ||||
FELDN | Name of field | FELDN | CHAR | 16 | CHAR16 | ||||
KOMOK | Account Modification | KOMOK | CHAR | 3 | KOMOK | ||||
LOGVO | Logical Transaction | LOGVO | CHAR | 6 | LOGVO | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
BWKEY | Valuation Area | BWKEY | CHAR | 4 | T001K | BWKEY | BWK | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
MAT_KDAUF | Sales Order Number of Valuated Sales Order Stock | MAT_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6 | NUM06 | KPO | |||
MAT_PSPNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
BKLAS | Valuation Class | BKLAS | CHAR | 4 | T025 | BKLAS | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4 | Assigned to domain | HRKFT | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
VORGN | Transaction Type for General Ledger | VORGN | CHAR | 4 | VORGN | ||||
BEKNZ | Debit/credit indicator | BEKNZ | CHAR | 1 | BEKNZ | BEKNZ | |||
BWMOD | Valuation Grouping Code | BWMOD | CHAR | 4 | CHAR4 | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | Assigned to domain | KTOPL | KPL | C_KTOPL | |
KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KSCHL | Condition Type | KSCHL | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
STATUS | Delta Posting Status from AVR | STATUS_AVR_DELTA_POST | CHAR | 4 | CKML_ICON4 | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
AWREF_REV | Reversal: Reverse Document Reference Document Number | AWREF_REV | CHAR | 10 | ALPHA | AWREF | |||
AWORG_REV | Reversal: Reverse Document Reference Organization | AWORG_REV | CHAR | 10 | AWORG | ||||
STATUS_IT | Status of Cumulation Closing Document | CKMLAVRDOC_STATUS | CHAR | 2 | CKMLAVRDOC_STATUS | ||||
BELNR_POST | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR | 10 | ALPHA | BELNR | |||
KJAHR_POST | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC | 4 | GJAHR | GJAHR | |||
BELNR_REV | Document Number of a Closing Document for Cumulation | CKCUM_BELNR | CHAR | 10 | ALPHA | BELNR | |||
KJAHR_REV | Year in Which Closing Document for Cumulation Was Saved | CKCUM_KJAHR | NUMC | 4 | GJAHR | GJAHR | |||
REVERSAL_ITEM | Reversal Item | CKMLAVRDOC_REVERSAL_ITEM | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table CKMLAVRDOCIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on CKMLAVRDOCIT to SELECT all data from the tableDATA: WA_CKMLAVRDOCIT TYPE CKMLAVRDOCIT.
SELECT SINGLE *
FROM CKMLAVRDOCIT
INTO CORRESPONDING FIELDS OF WA_CKMLAVRDOCIT
WHERE...
How to access SAP table CKMLAVRDOCIT
Within an ECC or HANA version of SAP you can also view further information about CKMLAVRDOCIT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects