CKML_AVR_ALV_DELTAPOSTINGS SAP (Structure for Displaying Delta Postings) Structure details
Description: Structure for Displaying Delta Postings
Related tables to CKML_AVR_ALV_DELTAPOSTINGS
Access table CKML_AVR_ALV_DELTAPOSTINGS
Structure field list including key, data, relationships and ABAP select examples
CKML_AVR_ALV_DELTAPOSTINGS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for Displaying Delta Postings" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CKML_AVR_ALV_DELTAPOSTINGS TYPE CKML_AVR_ALV_DELTAPOSTINGS.
The CKML_AVR_ALV_DELTAPOSTINGS table consists of various fields, each holding specific information or linking keys about Structure for Displaying Delta Postings data available in SAP. These include MANDT (Client), 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).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CKML_AVR_ALV_DELTAPOSTINGS structure 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 | ||||
CURTP | Currency Type and Valuation View | CURTP | CHAR | 2 | CURTP | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 |
Key field | Non-key field |
How do I retrieve data from SAP structure CKML_AVR_ALV_DELTAPOSTINGS using ABAP code?
As CKML_AVR_ALV_DELTAPOSTINGS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CKML_AVR_ALV_DELTAPOSTINGS as there is no data to select.How to access SAP table CKML_AVR_ALV_DELTAPOSTINGS
Within an ECC or HANA version of SAP you can also view further information about CKML_AVR_ALV_DELTAPOSTINGS 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