Vendor Master (General Section) — client-level vendor 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 |
| RAT_NUM_VEN key | ratio numerus venditor | Account Number of Vendor or Creditor | LIFNR | 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 | — |
| NOM3 | nomen | Name 3 | NAME3_GP | CHAR 35 | — |
| NOM4 | nomen | Name 4 | NAME4_GP | CHAR 35 | — |
| URB | urbs | City | ORT01_GP | CHAR 35 | — |
| ORT02 | District | ORT02_GP | CHAR 35 | — | |
| PFACH | PO Box | PFACH | CHAR 10 | — | |
| COD | codex | P.O. Box Postal Code | PSTL2 | CHAR 10 | — |
| COD2 | 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 | — |
| DML | domicilium | Address | ADRNR | CHAR 10 | — |
| MCOD1 | Search term for matchcode search | MCDK1 | CHAR 25 | — | |
| MCOD2 | Search term for matchcode search | MCDK2 | CHAR 25 | — | |
| MCOD3 | Search term for matchcode search | MCDK3 | CHAR 25 | — | |
| TTL | titulus | Title | ANRED | CHAR 15 | — |
| 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 | — | |
| IDX | index | Indicator for Data Medium Exchange | DTAMS | CHAR 1 | — |
| CLV2 | clavis | Instruction key for data medium exchange | DTAWS | CHAR 2 | — |
| 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 | — |
| NUM2 | numerus | ISR Subscriber Number | ESRNR | CHAR 11 | — |
| CTS_CLV | coetus clavis | Group key | KONZS | CHAR 10 | — |
| VEN_RAT_CTS | venditor ratio coetus | Vendor account group | KTOKK | CHAR 4 | T077K |
| EMP_NUM | emptor numerus | Customer Number | KUNNR | CHAR 10 | KNA1 |
| RAT_NUM | ratio numerus | Account Number of the Alternative Payee | LNRZA | CHAR 10 | LFA1 |
| SGN_TPR | signum tabula principalis | Central Deletion Flag for Master Record | LOEVM_X | CHAR 1 | — |
| INS_OBX | inscriptio obex | Central posting block | SPERB_X | CHAR 1 | — |
| OBX | obex | Centrally imposed purchasing block | SPERM_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 | — |
| PRI_TEL_NUM | primus telephonum numerus | First telephone number | TELF1 | CHAR 16 | — |
| TEL_NUM | telephonum numerus | Second telephone number | TELF2 | CHAR 16 | — |
| NUM4 | numerus | Fax Number | TELFX | CHAR 31 | — |
| NUM5 | numerus | Teletex number | TELTX | CHAR 30 | — |
| NUM6 | numerus | Telex number | TELX1 | CHAR 30 | — |
| IDX_RAT_TMP | index ratio tempus | Indicator: Is the account a one-time account? | XCPDK | CHAR 1 | — |
| IDX_DOC | index documentum | Indicator: Alternative payee in document allowed? | XZEMP | CHAR 1 | — |
| SOC_SNG | societas socius negotiationis | Company ID of trading partner | RASSC | CHAR 6 | T880 |
| RAT_NUM_TPR | ratio numerus tabula principalis | Account number of the master record with fiscal address | FISKN_K | CHAR 10 | LFA1 |
| NUM7 | numerus | VAT Registration Number | STCEG | CHAR 20 | — |
| PSN | persona | Natural Person | STKZN | CHAR 1 | — |
| SPERQ | Function That Will Be Blocked | QSPERRFKT | CHAR 2 | TQ04A | |
| PSN_TRB | persona tributum | Place of birth of the person subject to withholding tax | GBORT_Q | CHAR 25 | — |
| DIE_PSN_TRB | dies persona tributum | Date of birth of the person subject to withholding tax | GBDAT_Q | DATS 8 | — |
| CLV_PSN_TRB | clavis persona tributum | Key for the Sex of the Person Subject to Withholding Tax | SEXKZ | CHAR 1 | — |
| CRD_NUM | creditum numerus | Credit information number | KRAUS_CM | CHAR 11 | — |
| ULT | ultimus | Last review (external) | REVDB_CM | DATS 8 | — |
| VEN | venditor | Vendor's QM system | QSSYS_IST | CHAR 4 | TQ02B |
| RFR_RAT_CTS | referentia ratio coetus | Reference Account Group for One-Time Account (Vendor) | KTOCK | CHAR 4 | T077K |
| URB2 | urbs | PO Box city | PFORT_GP | CHAR 35 | — |
| OFC | officina | Plant (Own or External) | WERKS_EXT | CHAR 4 | — |
| IDX_VEN | index venditor | Indicator: vendor sub-range relevant | LTSNA | CHAR 1 | — |
| IDX_OFC_GRD | index officina gradus | Indicator: plant level relevant | WERKR | CHAR 1 | — |
| CLV3 | clavis | Factory calendar key | FABKL | CHAR 2 | TFACD |
| STA_EMS | status emissio | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR 1 | — |
| TRB | tributum | Tax Jurisdiction | TXJCD | CHAR 15 | TTXJ |
| SOL_OBX | solutio obex | Payment Block | SPERZ | CHAR 1 | — |
| NRM_COD | norma codex | Standard carrier access code | SCACD | CHAR 4 | — |
| CTS2 | coetus | Forwarding agent freight group | SFRGR | CHAR 4 | TSFG |
| MRC | merces | Transportation zone to or from which the goods are delivered | LZONE | CHAR 10 | TZONE |
| IDX_RAT_NUM | index ratio numerus | Indicator: Alternative payee using account number | XLFZA | CHAR 1 | — |
| MIN_CTS | ministerium coetus | Service agent procedure group | DLGRP | CHAR 4 | TVFCD |
| 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 |
| REGSS | Registered for Social Insurance | J_1AREGSS | CHAR 1 | — | |
| ACT_COD | actio codex | Activity Code for Social Insurance | J_1AACTSS | CHAR 3 | J_1AACT |
| 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 | — |
| RAT_NUM_TPR2 | ratio numerus tabula principalis | Account Number of Master Record of Tax Office Responsible | FISKU | CHAR 10 | LFA1 |
| TRB_NUM6 | tributum numerus | Tax Number at Responsible Tax Authority | STENR | CHAR 18 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
LAND1 | T005 | LAND1 |
REGIO | T005S | REGIO |
BRSCH | T016 | BRSCH |
KTOKK | T077K | KTOKK |
KTOCK | T077K | KTOKK |
KUNNR | KNA1 | KUNNR |
LNRZA | LFA1 | LIFNR |
FISKN | LFA1 | LIFNR |
FISKU | LFA1 | LIFNR |
SPRAS | T002 | SPRAS |
VBUND | T880 | RCOMP |
SPERQ | TQ04A | SPERRFKT |
QSSYS | TQ02B | QSSYSFAM |
PLKAL | TFACD | IDENT |
TXJCD | TTXJ | TXJCD |
SFRGR | TSFG | SFRGR |
LZONE | TZONE | ZONE1 |
DLGRP | TVFCD | DLGRP |
FITYP | J_1AFITP | J_1AFITP |
STCDT | J_1ATODC | J_1ATODC |
ACTSS | J_1AACT | J_1AACT |