Sales document partner — the partner-function table that answers who the sold-to, ship-to, payer, and bill-to actually were on a given sales document (header, POSNR = '000000') or item, each row keyed by PARVW (partner function, e.g. AG sold-to, WE ship-to, RE bill-to, RG payer) and resolving to a customer (KUNNR) or vendor (LIFNR).
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 |
| VDT_DTB_NDO key | venditio distributio numerus documenti | Sales and Distribution Document Number | VBELN | CHAR 10 | VBUK |
| POS_NUM_DOC key | positio numerus documentum | Item number of the SD document | POSNR | NUMC 6 | VBUP |
| SCS key | socius | Partner Function | PARVW | CHAR 2 | TPAR |
| EMP_NUM | emptor numerus | Customer Number | KUNNR | CHAR 10 | KNA1 |
| RAT_NUM_VEN | ratio numerus venditor | Account Number of Vendor or Creditor | LIFNR | CHAR 10 | LFA1 |
| NPS | numerus personae | Personnel Number | PERNR_D | NUMC 8 | — |
| NUM_PSN | numerus persona | Number of contact person | PARNR | NUMC 10 | — |
| DML | domicilium | Address | ADRNR | CHAR 10 | — |
| ABLAD | Unloading Point | ABLAD | CHAR 25 | — | |
| PTR_CLV | patria clavis | Country Key | LAND1 | CHAR 3 | T005 |
| DML_IDX | domicilium index | Address indicator | ADRDA | CHAR 1 | — |
| IDX_RAT_TMP | index ratio tempus | Indicator: Is the account a one-time account? | XCPDK | CHAR 1 | — |
| EMP_HIR_GEN | emptor hierarchia genus | Customer hierarchy type | HITYP_KH | CHAR 1 | THIT |
| PRE | pretium | Relevant for price determination ID | PRFRE | CHAR 1 | — |
| IDX_EMP | index emptor | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR 1 | — |
| GRD_NUM_HIR | gradus numerus hierarchia | Level number within hierarchy | HISTUNR | NUMC 2 | — |
| EMP_DSC_SCS | emptor descriptio socius | Customer description of partner (plant, storage location) | KNREF | CHAR 30 | — |
| MRC | merces | Transportation zone to or from which the goods are delivered | LZONE | CHAR 10 | — |
| ASG_HIR | assignatio hierarchia | Assignment to Hierarchy | HZUOR | NUMC 2 | — |
| NUM | numerus | VAT Registration Number | STCEG | CHAR 20 | — |
| IDX | index | Indicator 'further partners in this function' (VBPA2) | PARTNER_FF | CHAR 1 | — |
| PSN_NUM | persona numerus | Person number | AD_PERSNUM | CHAR 10 | ADRP |
| KALE | Maintain appointments in calendar | KALE | CHAR 1 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
VBELN | VBUK | VBELN |
POSNR | VBUP | POSNR |
PARVW | TPAR | PARVW |
KUNNR | KNA1 | KUNNR |
LIFNR | LFA1 | LIFNR |
LAND1 | T005 | LAND1 |
HITYP | THIT | HITYP |
ADRNP | ADRP | PERSNUMBER |