Customer Master (General Section) — client-level customer identity, address, and control data shared across company codes.
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 | — |
| PTR_CLV | patria clavis | Country Key | LAND1_GP | CHAR 3 | T005 |
| NOM | nomen | Name 1 | NAME1_GP | CHAR 35 | — |
| NOM2 | nomen | Name 2 | NAME2_GP | CHAR 35 | — |
| URB | urbs | City | ORT01_GP | CHAR 35 | — |
| COD | codex | Postal Code | PSTLZ | CHAR 10 | — |
| REG | regio | Region (State, Province, County) | REGIO | CHAR 3 | T005S |
| CMP | campus | Sort field | SORTL | CHAR 10 | — |
| NUM | numerus | House number and street | STRAS_GP | CHAR 35 | — |
| PRI_TEL_NUM | primus telephonum numerus | First telephone number | TELF1 | CHAR 16 | — |
| NUM2 | numerus | Fax Number | TELFX | CHAR 31 | — |
| IDX_RAT_TMP | index ratio tempus | Indicator: Is the account a one-time account? | XCPDK | CHAR 1 | — |
| DML | domicilium | Address | ADRNR | CHAR 10 | — |
| MCOD1 | Search term for matchcode search | MCDD1 | CHAR 25 | — | |
| MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR 25 | — | |
| MCOD3 | Search term for matchcode search | MCDD3 | CHAR 25 | — | |
| TTL | titulus | Title | ANRED | CHAR 15 | — |
| MND_OBX_EMP | mandatum obex emptor | Central order block for customer | AUFSD_X | CHAR 2 | TVAST |
| BAHNE | Express train station | BAHNE | CHAR 25 | — | |
| BAHNS | Train station | BAHNS | CHAR 25 | — | |
| LOC_NUM | locus numerus | International location number (part 1) | BBBNR | NUMC 7 | — |
| LOC_NUM2 | locus numerus | International location number (Part 2) | BBSNR | NUMC 5 | — |
| CTS | coetus | Authorization Group | BRGRU | CHAR 4 | — |
| CLV | clavis | Industry key | BRSCH | CHAR 4 | T016 |
| LOC_NUM3 | locus numerus | Check digit for the international location number | BUBKZ | NUMC 1 | — |
| DATLT | Data communication line no. | DATLT | CHAR 14 | — | |
| 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 | — |
| IDX | index | Indicator: Unloading points exist | EXABL | CHAR 1 | — |
| FAC_OBX_EMP | factura obex emptor | Central billing block for customer | FAKSD_X | CHAR 2 | TVFS |
| RAT_NUM_TPR | ratio numerus tabula principalis | Account number of the master record with the fiscal address | FISKN_D | CHAR 10 | KNA1 |
| TMP | tempus | Working Time Calendar | KNAZK | CHAR 2 | TFACD |
| RAT_NUM | ratio numerus | Account number of an alternative payer | KNRZA | CHAR 10 | KNA1 |
| CTS_CLV | coetus clavis | Group key | KONZS | CHAR 10 | — |
| EMP_RAT_CTS | emptor ratio coetus | Customer Account Group | KTOKD | CHAR 4 | T077D |
| EMP | emptor | Customer classification | KUKLA | CHAR 2 | TKUKL |
| RAT_NUM_VEN | ratio numerus venditor | Account Number of Vendor or Creditor | LIFNR | CHAR 10 | LFA1 |
| TRD_OBX_EMP | traditio obex emptor | Central delivery block for the customer | LIFSD_X | CHAR 2 | TVLS |
| URB2 | urbs | City Coordinates | LOCCO | CHAR 10 | — |
| SGN_TPR | signum tabula principalis | Central Deletion Flag for Master Record | LOEVM_X | CHAR 1 | — |
| NOM3 | nomen | Name 3 | NAME3_GP | CHAR 35 | — |
| NOM4 | nomen | Name 4 | NAME4_GP | CHAR 35 | — |
| NIELS | Nielsen ID | NIELS | CHAR 2 | TNLS | |
| ORT02 | District | ORT02_GP | CHAR 35 | — | |
| PFACH | PO Box | PFACH | CHAR 10 | — | |
| COD2 | codex | P.O. Box Postal Code | PSTL2 | CHAR 10 | — |
| COD3 | codex | County Code | COUNC | CHAR 3 | T005E |
| URB_COD | urbs codex | City Code | CITYC | CHAR 4 | T005G |
| RPMKR | Regional Market | RPMKR | CHAR 5 | — | |
| INS_OBX | inscriptio obex | Central posting block | SPERB_X | CHAR 1 | — |
| LNG_CLV | lingua clavis | Language Key | SPRAS | LANG 1 | T002 |
| TRB_NUM | tributum numerus | Tax Number 1 | STCD1 | CHAR 16 | — |
| TRB_NUM2 | tributum numerus | Tax Number 2 | STCD2 | CHAR 11 | — |
| IDX_SCS_TRB | index socius tributum | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR 1 | — |
| STKZU | Liable for VAT | STKZU | CHAR 1 | — | |
| NUM3 | numerus | Telebox number | TELBX | CHAR 15 | — |
| TEL_NUM | telephonum numerus | Second telephone number | TELF2 | CHAR 16 | — |
| NUM4 | numerus | Teletex number | TELTX | CHAR 30 | — |
| NUM5 | numerus | Telex number | TELX1 | CHAR 30 | — |
| MRC | merces | Transportation zone to or from which the goods are delivered | LZONE | CHAR 10 | TZONE |
| IDX_DOC | index documentum | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR 1 | — |
| SOC_SNG | societas socius negotiationis | Company ID of trading partner | RASSC | CHAR 6 | T880 |
| NUM6 | numerus | VAT Registration Number | STCEG | CHAR 20 | — |
| STA | status | Legal status | GFORM | CHAR 2 | TVGF |
| VDT | venditio | Annual sales | UMSAT | CURR 8,2 | — |
| ANN_VDT | annus venditio | Year For Which Sales are Given | UMJAH | NUMC 4 | — |
| MON_VDT | moneta venditio | Currency of sales figure | UWAER | CUKY 5 | TCURC |
| NUM7 | numerus | Yearly number of employees | JMZAH | NUMC 6 | — |
| ANN_NUM | annus numerus | Year for which the number of employees is given | JMJAH | NUMC 4 | — |
| PSN | persona | Natural Person | STKZN | CHAR 1 | — |
| TRB | tributum | Tax Jurisdiction | TXJCD | CHAR 15 | TTXJ |
| ANF | annus fiscalis | Fiscal Year Variant | PERIV | CHAR 2 | T009 |
| RFR_RAT_CTS | referentia ratio coetus | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR 4 | T077D |
| URB3 | urbs | PO Box city | PFORT_GP | CHAR 35 | — |
| OFC | officina | Plant | WERKS_D | CHAR 4 | T001W |
| STA_EMS | status emissio | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR 1 | — |
| SOL_OBX | solutio obex | Payment Block | SPERZ | CHAR 1 | — |
| TRB_GEN | tributum genus | Tax type | J_1AFITP_D | CHAR 2 | J_1AFITP |
| TRB_NUM_GEN | tributum numerus genus | Tax Number Type | J_1ATOID | CHAR 2 | J_1ATODC |
| TRB_NUM3 | tributum numerus | Tax Number 3 | STCD3 | CHAR 18 | — |
| TRB_NUM4 | tributum numerus | Tax Number 4 | STCD4 | CHAR 18 | — |
| TRB_NUM5 | tributum numerus | Tax Number 5 | STCD5 | CHAR 60 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
LAND1 | T005 | LAND1 |
REGIO | T005S | REGIO |
AUFSD | TVAST | AUFSP |
BRSCH | T016 | BRSCH |
FAKSD | TVFS | FAKSP |
FISKN | KNA1 | KUNNR |
KNAZK | TFACD | IDENT |
KNRZA | KNA1 | KUNNR |
KTOKD | T077D | KTOKD |
KUKLA | TKUKL | KUKLA |
LIFNR | LFA1 | LIFNR |
LIFSD | TVLS | LIFSP |
NIELS | TNLS | NIELS |
COUNC | T005E | COUNC |
CITYC | T005G | CITYC |
SPRAS | T002 | SPRAS |
LZONE | TZONE | ZONE1 |
VBUND | T880 | RCOMP |
GFORM | TVGF | GFORM |
UWAER | TCURC | WAERS |
TXJCD | TTXJ | TXJCD |
PERIV | T009 | PERIV |
KTOCD | T077D | KTOKD |
WERKS | T001W | WERKS |
FITYP | J_1AFITP | J_1AFITP |
STCDT | J_1ATODC | J_1ATODC |