Accounting: Secondary Index for Customers — open (uncleared) customer line items. This is the SAP analogue of a CDK accounting schedule sitting behind an AR reconciliation account: one row per open item, keyed by company code + customer + document, until AUGBL/AUGDT clear it into BSAD.
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 | T074U |
| CPN_DIE | compensatio dies | Clearing Date | AUGDT | DATS 8 | — |
| NDO_CPN_DOC | numerus documenti compensatio documentum | Document Number of the Clearing Document | AUGBL | CHAR 10 | — |
| ASG_NUM_PAP | assignatio numerus positio aperta | Assignment Number — the open-item control key. This is where a CDK accounting-schedule reference (RO number, stock number, VIN-last-8) lands when a dealer transaction is projected into an SAP-shaped subledger. | 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_CMP | referentia numerus documenti campus | Reference Document Number — the field a dealer's own document number (invoice, RO number) lands on for schedule-to-GL reconciliation when ZUONR alone is not descriptive enough. | XBLNR1 | CHAR 16 | — |
| GDO | genus documenti | Document Type | BLART | CHAR 2 | T003 |
| PER | periodus | Fiscal Period | MONAT | NUMC 2 | — |
| INS_CLV | inscriptio clavis | Posting Key | BSCHL | CHAR 2 | TBSL |
| 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 | TGSB |
| TRB_VDT_COD | tributum venditio codex | Tax on sales/purchases code | MWSKZ | CHAR 2 | T007A |
| 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_EMP | mandatum numerus emptor | Order Number — where a repair order's SAP analogue (AUFK-AUFNR) is carried on a customer-pay open item | AUFNR | CHAR 12 | AUFK |
| PTM_NUM | patrimonium numerus | Main Asset Number | ANLN1 | CHAR 12 | — |
| PTM | patrimonium | Asset Subnumber | ANLN2 | CHAR 4 | — |
| RAT_NUM | ratio numerus | G/L Account Number | SAKNR | CHAR 10 | — |
| LBR_RAT_PAP | liber ratio positio aperta | General Ledger Account — the reconciliation account this open item sits behind | HKONT | CHAR 10 | — |
| DIE_PAP | dies positio aperta | Baseline Date for Due Date Calculation — the date open-item aging is computed from | DZFBDT | DATS 8 | — |
| SOL_CLV | solutio clavis | Terms of Payment Key | DZTERM | CHAR 4 | — |
| DDC | deductio | Cash discount days 1 | DZBD1T | DEC 3 | — |
| DDC2 | deductio | Cash discount days 2 | DZBD2T | DEC 3 | — |
| NET_SOL_PER | netus solutio periodus | Net Payment Terms Period | DZBD3T | DEC 3 | — |
| SUM_DDC_DOC | summa deductio documentum | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR 13,2 | — |
| DDC_SUM_MON | deductio summa moneta | Cash discount amount in local currency | SKNTO | CURR 13,2 | — |
| SOL | solutio | Payment Method | DZLSCH | CHAR 1 | T042Z |
| SOL_OBX_CLV | solutio obex clavis | Payment Block Key | DZLSPR | CHAR 1 | T008 |
| CLV_ARG | clavis argentaria | Short Key for a House Bank | HBKID | CHAR 5 | T012 |
| 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 | — |
| OBX | obex | Dunning block | MANSP | CHAR 1 | T040S |
| CLV | clavis | Dunning key | MSCHL | CHAR 1 | T040 |
| ULT | ultimus | Last dunned on | MADAT | DATS 8 | — |
| GRD | gradus | Dunning level | MAHNS_D | NUMC 1 | — |
| SOC_SNG | societas socius negotiationis | Company ID of trading partner | RASSC | CHAR 6 | T880 |
| FAC_DOC | factura documentum | Billing Document | VBELN_VF | CHAR 10 | — |
| NUM | numerus | VAT Registration Number | STCEG | CHAR 20 | — |
| CSA_COD | causa codex | Reason Code for Payments | RSTGR | CHAR 3 | T053R |
| 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 | T059Q |
| 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 | — |
| DVD_POS | documentum venditionis positio | Sales Document Item | POSNR_VA | NUMC 6 | — |
| TRD_LOR_NUM | traditio linea ordinis numerus | Delivery Schedule Line Number | ETENR | NUMC 4 | — |
| 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 |
UMSKZ | T074U | UMSKZ |
ZUMSK | T074U | UMSKZ |
WAERS | TCURC | WAERS |
BLART | T003 | BLART |
BSCHL | TBSL | BSCHL |
GSBER | TGSB | GSBER |
MWSKZ | T007A | MWSKZ |
AUFNR | AUFK | AUFNR |
ZLSCH | T042Z | ZLSCH |
ZLSPR | T008 | ZAHLS |
HBKID | T012 | HBKID |
MANSP | T040S | MANSP |
MSCHL | T040 | MSCHL |
VBUND | T880 | RCOMP |
RSTGR | T053R | RSTGR |
KKBER | T014 | KKBER |
QSSKZ | T059Q | QSSKZ |
PSWSL | TCURC | WAERS |