Accounting: Secondary Index for Customers (Cleared Items) — same row shape as BSID, but for items that have already been cleared (AUGDT/AUGBL populated). This is the destination an open item on the dealer's accounting schedule moves to the moment a payment or credit is applied — the clearing event a schedule-to-GL reconciliation has to account for, not just the open balance.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| SOC key | codex societatis | Company Code | BUKRS | CHAR 4 | T001 |
| EMP_NUM key | emptor numerus | Customer Number | KUNNR | CHAR 10 | KNA1 |
| GEN key | genus | Special G/L Transaction Type | UMSKS | CHAR 1 | — |
| IDX key | index | Special G/L Indicator | UMSKZ | CHAR 1 | — |
| CPN_DIE_TBL key | compensatio dies tabula | Clearing Date — populated for every row in this table, unlike BSID where it is null until the item clears | AUGDT | DATS 8 | — |
| NDO_CPN_DOC | numerus documenti compensatio documentum | Document Number of the Clearing Document — the payment/credit document that closed the open item | AUGBL | CHAR 10 | — |
| ASG_NUM_PAP | assignatio numerus positio aperta | Assignment Number — the same open-item control key carried over from the BSID row this record clears | DZUONR | CHAR 18 | — |
| ANF key | annus fiscalis | Fiscal Year | GJAHR | NUMC 4 | — |
| NDO key | numerus documenti | Accounting Document Number | BELNR_D | CHAR 10 | — |
| NUM_POS_DOC key | numerus positio documentum | Number of Line Item Within Accounting Document | BUZEI | NUMC 3 | — |
| DIN_DOC | dies inscriptionis documentum | Posting Date in the Document | BUDAT | DATS 8 | — |
| DDC_DOC | dies documenti documentum | Document Date in Document | BLDAT | DATS 8 | — |
| DIE_DOC | dies documentum | Day On Which Accounting Document Was Entered | CPUDT | DATS 8 | — |
| CVM | clavis monetae | Currency Key | WAERS | CUKY 5 | TCURC |
| RFR_NDO | referentia numerus documenti | Reference Document Number | XBLNR1 | CHAR 16 | — |
| GDO | genus documenti | Document Type | BLART | CHAR 2 | — |
| PER | periodus | Fiscal Period | MONAT | NUMC 2 | — |
| INS_CLV | inscriptio clavis | Posting Key | BSCHL | CHAR 2 | — |
| MTA_IDX | meta index | Target Special G/L Indicator | DZUMSK | CHAR 1 | — |
| DBT_CRD_IDX | debitum creditum index | Debit/Credit Indicator | SHKZG | CHAR 1 | — |
| ANG | area negotii | Business Area | GSBER | CHAR 4 | — |
| TRB_VDT_COD | tributum venditio codex | Tax on sales/purchases code | MWSKZ | CHAR 2 | — |
| SUM_MON | summa moneta | Amount in Local Currency | DMBTR | CURR 13,2 | — |
| SUM_DOC_MON | summa documentum moneta | Amount in document currency | WRBTR | CURR 13,2 | — |
| TRB_SUM_MON | tributum summa moneta | Tax Amount in Local Currency | MWSTS | CURR 13,2 | — |
| TRB_SUM_DOC | tributum summa documentum | Tax amount in document currency | WMWST | CURR 13,2 | — |
| POS_TXT | positio textus | Item Text | SGTXT | CHAR 50 | — |
| MND_NUM | mandatum numerus | Order Number | AUFNR | CHAR 12 | — |
| RAT_NUM | ratio numerus | G/L Account Number | SAKNR | CHAR 10 | — |
| LBR_RAT_POS | liber ratio positio | General Ledger Account — the reconciliation account this item cleared against | HKONT | CHAR 10 | — |
| DIE | dies | Baseline Date for Due Date Calculation | DZFBDT | DATS 8 | — |
| SOL_CLV | solutio clavis | Terms of Payment Key | DZTERM | CHAR 4 | — |
| DDC_SUM_MON | deductio summa moneta | Cash discount amount in local currency | SKNTO | CURR 13,2 | — |
| DDC_SUM_DOC | deductio summa documentum | Cash discount amount in document currency | WSKTO | CURR 13,2 | — |
| SOL | solutio | Payment Method | DZLSCH | CHAR 1 | — |
| CLV_ARG | clavis argentaria | Short Key for a House Bank | HBKID | CHAR 5 | — |
| NUM_FAC | numerus factura | Number of the Invoice the Transaction Belongs to | REBZG | CHAR 10 | — |
| ANF_FAC_CRD | annus fiscalis factura creditum | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC 4 | — |
| POS_FAC | positio factura | Line Item in the Relevant Invoice | REBZZ | NUMC 3 | — |
| SOC_SNG | societas socius negotiationis | Company ID of trading partner | RASSC | CHAR 6 | — |
| FAC_DOC | factura documentum | Billing Document | VBELN_VF | CHAR 10 | — |
| CSM | centrum sumptus | Cost Center | KOSTL | CHAR 10 | — |
| AFD | area fidei | Credit control area | KKBER | CHAR 4 | T014 |
| CLU | centrum lucri | Profit Center | PRCTR | CHAR 10 | — |
| TRB_COD | tributum codex | Withholding Tax Code | QSSKZ | CHAR 2 | — |
| MON_LBR | moneta liber | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY 5 | TCURC |
| SUM_LBR | summa liber | Amount for Updating in General Ledger | PSWBT | CURR 13,2 | — |
| DVD | documentum venditionis | Sales Document | VBELN_VA | CHAR 10 | — |
| DOC_STA | documentum status | Document Status | BSTAT_D | CHAR 1 | — |
| IDX_CPN | index compensatio | Indicator: Clearing was Reversed | XRAGL | CHAR 1 | — |
| ANF_CPN_DOC | annus fiscalis compensatio documentum | Fiscal Year of Clearing Document | AUGGJ | NUMC 4 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
BUKRS | T001 | BUKRS |
KUNNR | KNA1 | KUNNR |
WAERS | TCURC | WAERS |
KKBER | T014 | KKBER |
PSWSL | TCURC | WAERS |