Vendor Master (Company Code) — company-code-specific vendor control data: reconciliation account, payment terms, dunning, banking.
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 | LFA1 |
| 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 |
| RAT_LBR | ratio liber | Reconciliation Account in General Ledger | AKONT | CHAR 10 | SKB1 |
| CTS | coetus | Authorization Group | BRGRU | CHAR 4 | — |
| USU_IDX | usura index | Interest calculation indicator | VZSKZ | CHAR 2 | T056 |
| 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_LFB1 | 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 | — |
| RAT_NUM_VEN2 | ratio numerus venditor | Our account number with the vendor | EIKTO_K | CHAR 12 | — |
| VEN | venditor | Clerk at vendor | DZSABE_K | CHAR 15 | — |
| KVERM | Memo | KVERM | CHAR 30 | — | |
| CNS_CTS | consilium coetus | Planning group | FDGRV | CHAR 10 | T035 |
| BUSAB | Accounting clerk | BUSAB | CHAR 2 | T001S | |
| RAT_NUM | ratio numerus | Head office account number | LNRZE | CHAR 10 | LFA1 |
| RAT_NUM2 | ratio numerus | Account number of the alternative payee | LNRZB | CHAR 10 | LFA1 |
| 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 | — |
| DIE_ULT_USU | dies ultimus usura | Date of the last interest calculation run | DATLZ | DATS 8 | — |
| IDX | index | Indicator: Local processing? | XDEZV | CHAR 1 | — |
| MON | moneta | Bill of exchange limit (in local currency) | WEBTR | CURR 13,2 | — |
| TMP | tempus | Probable time until check is paid | KULTG | DEC 3 | — |
| SGN_CRD | signum creditum | Check Flag for Double Invoices or Credit Memos | REPRF | CHAR 1 | — |
| CTS_SCS_RAT | coetus socius ratio | Tolerance group for the business partner/G/L account | TOGRU | CHAR 4 | T043G |
| CLV_ARG | clavis argentaria | Short Key for a House Bank | HBKID | CHAR 5 | T012 |
| IDX2 | index | Indicator: Pay all items separately? | XPORE | CHAR 1 | — |
| NUM_TRB | numerus tributum | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR 10 | — |
| DIE_TRB | dies tributum | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS 8 | — |
| TRB_COD | tributum codex | Withholding Tax Code | QSSKZ | CHAR 2 | — |
| IDX3 | index | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR 2 | — |
| MINDK | Minority Indicators | MINDK | CHAR 3 | T059M | |
| 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 | Key for dunning notice grouping | MGRUP | CHAR 2 | T047R |
| SOL2 | solutio | Payment Method Supplement | UZAWE | CHAR 2 | T042F |
| VEN_GEN | venditor genus | Vendor Recipient Type | QSREC | CHAR 2 | T059A |
| TRB | tributum | Authority for Exemption from Withholding Tax | QSBGR | CHAR 1 | — |
| TRB_PTR_CLV | tributum patria clavis | Withholding Tax Country Key | QLAND | CHAR 3 | T005Q |
| IDX_SOL | index solutio | Indicator: Send Payment Advices by EDI | XEDIP | CHAR 1 | — |
| EMS_APB_CTS | emissio approbatio coetus | Release Approval Group | FRGRP | CHAR 4 | VBWF08 |
| CTS_FAC_VRF | coetus factura verificatio | Tolerance group; Invoice Verification | TOGRR | CHAR 4 | T169L |
| 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 payee using account number | XLFZB | 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 |
| IDX_RAT | index ratio | Indicator for periodic account statements | XAUSZ | CHAR 1 | T048K |
| DIE | dies | Certification date | CERDT | DATS 8 | — |
| 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 | — |
| IDX_SOL2 | 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 | — |
| COD | codex | Intercompany code | OIU_INTERCOCD | CHAR 4 | T001 |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
LIFNR | LFA1 | LIFNR |
BUKRS | T001 | BUKRS |
AKONT | SKB1 | SAKNR |
ZAHLS | T008 | ZAHLS |
FDGRV | T035 | GRUPP |
BUSAB | T001S | BUSAB |
LNRZE | LFA1 | LIFNR |
LNRZB | LFA1 | LIFNR |
TOGRU | T043G | TOGRU |
HBKID | T012 | HBKID |
MINDK | T059M | MINDK |
ZGRUP | TZGR | ZGRUP |
MGRUP | T047R | MGRUP |
UZAWE | T042F | UZAWE |
QSREC | T059A | QSREC |
QLAND | T005Q | QLAND |
FRGRP | VBWF08 | FRGRP |
TOGRR | T169L | TOGRR |
GRICD | J_1AGICD | J_1AGICD |
GRIDT | J_1ADTYP | J_1ADTYP |
XAUSZ | T048K | XAUSZ |
VZSKZ | T056 | VZSKZ |
ZUAWA | TZUN | ZUAWA |
INTERCOCD | T001 | BUKRS |