Customer Master (Company Code) — company-code-specific customer control data: reconciliation account, payment terms, dunning, insurance.
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 |
| EMP_NUM key | emptor numerus | Customer Number | KUNNR | CHAR 10 | KNA1 |
| SOC key | codex societatis | Company Code | BUKRS | CHAR 4 | T001 |
| NPS | numerus personae | Personnel Number | PERNR_D | NUMC 8 | — |
| DIE_TBL_CRE | dies tabula creatus | Date on which the Record Was Created | ERDAT_RF | DATS 8 | — |
| NOM_PSN_CRE | nomen persona creatus | Name of Person who Created the Object | ERNAM_RF | CHAR 12 | — |
| INS_OBX_SOC | inscriptio obex codex societatis | Posting block for company code | SPERB_B | CHAR 1 | — |
| SGN_TPR_SOC | signum tabula principalis codex societatis | Deletion Flag for Master Record (Company Code Level) | LOEVM_B | CHAR 1 | — |
| CLV_ASG | clavis assignatio | Key for sorting according to assignment numbers | DZUAWA | CHAR 3 | TZUN |
| BUSAB | Accounting clerk | BUSAB | CHAR 2 | T001S | |
| RAT_LBR | ratio liber | Reconciliation Account in General Ledger | AKONT | CHAR 10 | SKB1 |
| CTS | coetus | Authorization Group | BRGRU | CHAR 4 | — |
| RAT_NUM | ratio numerus | Head office account number (in branch accounts) | KNRZE | CHAR 10 | KNA1 |
| RAT_NUM2 | ratio numerus | Account number of an alternative payer | KNRZB | CHAR 10 | KNA1 |
| IDX_SOL_EMP | index solutio emptor | Indicator: Payment notice to customer (with cleared items)? | DZAMIM | CHAR 1 | — |
| IDX_SOL_VDT | index solutio venditio | Indicator: payment notice to sales department? | DZAMIV | CHAR 1 | — |
| IDX_SOL | index solutio | Indicator: payment notice to legal department? | DZAMIR | CHAR 1 | — |
| IDX_SOL2 | index solutio | Indicator: Payment notice to the accounting department? | DZAMIB | CHAR 1 | — |
| IDX_SOL_EMP2 | index solutio emptor | Indicator: payment notice to customer (w/o cleared items)? | DZAMIO | CHAR 1 | — |
| SOL | solutio | List of the Payment Methods to be Considered | DZWELS | CHAR 10 | — |
| IDX_CPN_EMP | index compensatio emptor | Indicator: Clearing between customer and vendor? | XVERR_KNB1 | CHAR 1 | — |
| OBX_CLV_SOL | obex clavis solutio | Block Key for Payment | DZAHLS | CHAR 1 | T008 |
| SOL_CLV | solutio clavis | Terms of Payment Key | DZTERM | CHAR 4 | — |
| SOL_CLV2 | solutio clavis | Terms of payment key for bill of exchange charges | WAKON | CHAR 4 | — |
| USU_IDX | usura index | Interest calculation indicator | VZSKZ | CHAR 2 | T056 |
| CLV_DIE_ULT | clavis dies ultimus | Key date of the last interest calculation | DZINDT | DATS 8 | — |
| USU | usura | Interest calculation frequency in months | DZINRT | NUMC 2 | — |
| RAT_NUM_EMP | ratio numerus emptor | Our account number at customer | EIKTO_D | CHAR 12 | — |
| USR_EMP | usor emptor | User at customer | DZSABE_D | CHAR 15 | — |
| KVERM | Memo | KVERM | CHAR 30 | — | |
| CNS_CTS | consilium coetus | Planning group | FDGRV | CHAR 10 | T035 |
| CRD_NUM | creditum numerus | Export credit insurance institution number | VRBKZ | CHAR 2 | — |
| SUM | summa | Amount Insured | VLIBB | CURR 13,2 | — |
| VRSZL | Insurance lead months | VRSZL | DEC 3 | — | |
| RAT | ratio | Deductible percentage rate | VRSPR | DEC 3 | — |
| NUM | numerus | Insurance number | VRSNR | CHAR 10 | — |
| DIE | dies | Insurance validity date | VERDT | DATS 8 | — |
| FAC | factura | Collective invoice variant | PERKZ_KNB1 | CHAR 1 | — |
| IDX | index | Indicator: Local processing? | XDEZV | CHAR 1 | — |
| IDX_RAT | index ratio | Indicator for periodic account statements | XAUSZ | CHAR 1 | T048K |
| MON | moneta | Bill of exchange limit (in local currency) | WEBTR | CURR 13,2 | — |
| REMIT | Next payee | REMIT | CHAR 10 | KNA1 | |
| DIE_ULT_USU | dies ultimus usura | Date of the last interest calculation run | DATLZ | DATS 8 | — |
| IDX_TBL_SOL | index tabula solutio | Indicator: Record Payment History? | XZVER | CHAR 1 | — |
| CTS_SCS_RAT | coetus socius ratio | Tolerance group for the business partner/G/L account | TOGRU | CHAR 4 | T043G |
| TMP | tempus | Probable time until check is paid | KULTG | DEC 3 | — |
| CLV_ARG | clavis argentaria | Short Key for a House Bank | HBKID | CHAR 5 | T012 |
| IDX2 | index | Indicator: Pay all items separately? | XPORE | CHAR 1 | — |
| IDX3 | index | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR 2 | — |
| TPR_NUM | tabula principalis numerus | Previous Master Record Number | ALTKN | CHAR 10 | — |
| CLV_SOL | clavis solutio | Key for Payment Grouping | DZGRUP | CHAR 2 | TZGR |
| CLV | clavis | Short Key for Known/Negotiated Leave | URLID | CHAR 4 | T052A |
| CLV2 | clavis | Key for dunning notice grouping | MGRUP | CHAR 2 | T047R |
| CLV_EMP | clavis emptor | Key of the Lockbox to Which the Customer Is To Pay | LOCKB | CHAR 7 | T049L |
| SOL2 | solutio | Payment Method Supplement | UZAWE | CHAR 2 | T042F |
| RAT_NUM_CTS | ratio numerus coetus | Account Number of Buying Group | EKVBD | CHAR 10 | KNA1 |
| SOL3 | solutio | Selection Rule for Payment Advices | SREGL | CHAR 3 | T053A |
| IDX_SOL3 | index solutio | Indicator: Send Payment Advices by EDI | XEDIP | CHAR 1 | — |
| EMS_APB_CTS | emissio approbatio coetus | Release Approval Group | FRGRP | CHAR 4 | VBWF08 |
| CSA_COD_VRS | causa codex versio | Reason Code Conversion Version | VRSDG | CHAR 3 | T053V |
| NUM_EMP_VEN | numerus emptor venditor | Accounting clerk's fax number at the customer/vendor | TLFXS | CHAR 31 | — |
| DML_SCS_SOC | domicilium socius societas | Internet address of partner company clerk | INTAD | CHAR 130 | — |
| IDX_RAT_NUM | index ratio numerus | Indicator: Alternative payer using account number | XKNZB | CHAR 1 | — |
| SOL_CLV_CRD | solutio clavis creditum | Payment Terms Key for Credit Memos | GUZTE | CHAR 4 | — |
| ACT_COD_GRS | actio codex crassus | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR 2 | J_1AGICD |
| DTB_GEN_TRB | distributio genus tributum | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR 2 | J_1ADTYP |
| VAL_CLV | valor clavis | Value Adjustment Key | WBRSL | CHAR 2 | T044G |
| STA_SOC_GRD | status codex societatis gradus | Status of Change Authorization (Company Code Level) | CONFS_B | CHAR 1 | — |
| DIE2 | dies | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS 8 | — |
| TMP_ULT_CNF | tempus ultimus confirmatio | Time of Last Change Confirmation | UPTIM_RF | TIMS 6 | — |
| TPR_SOC_GRD | tabula principalis codex societatis gradus | Deletion bock for master record (company code level) | NODEL_B | CHAR 1 | — |
| TEL_NUM_SCS | telephonum numerus socius | Accounting clerk's telephone number at business partner | TLFNS | CHAR 30 | — |
| IDX4 | index | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR 2 | TCESSION |
| IDX_SOL4 | index solutio | Indicator: Send Payment Advice by XML | AVSND | CHAR 1 | — |
| DML_HSH_VAL | domicilium summa digesta valor | E-Mail Address for Avis: Hash Value | ADHASH | CHAR 10 | — |
| TRB_PTR_CLV | tributum patria clavis | Withholding Tax Country Key | QLAND | CHAR 3 | T005Q |
| COD | codex | Intercompany code | OIU_INTERCOCD | CHAR 4 | T001 |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
KUNNR | KNA1 | KUNNR |
BUKRS | T001 | BUKRS |
AKONT | SKB1 | SAKNR |
BUSAB | T001S | BUSAB |
KNRZE | KNA1 | KUNNR |
KNRZB | KNA1 | KUNNR |
ZAHLS | T008 | ZAHLS |
VZSKZ | T056 | VZSKZ |
FDGRV | T035 | GRUPP |
XAUSZ | T048K | XAUSZ |
REMIT | KNA1 | KUNNR |
TOGRU | T043G | TOGRU |
HBKID | T012 | HBKID |
ZGRUP | TZGR | ZGRUP |
URLID | T052A | URLID |
MGRUP | T047R | MGRUP |
LOCKB | T049L | LOCKB |
UZAWE | T042F | UZAWE |
EKVBD | KNA1 | KUNNR |
SREGL | T053A | SREGL |
FRGRP | VBWF08 | FRGRP |
VRSDG | T053V | VRSDG |
GRICD | J_1AGICD | J_1AGICD |
GRIDT | J_1ADTYP | J_1ADTYP |
WBRSL | T044G | WBRSL |
CESSION_KZ | TCESSION | CESSION_KZ |
QLAND | T005Q | QLAND |
INTERCOCD | T001 | BUKRS |
ZUAWA | TZUN | ZUAWA |