SAP VBPA Sales Document: Partner Table
Overview
VBPA is a standard SAP S/4HANA table that stores Sales Document: Partner data. There are total 26 fields in the VBPA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBPA belongs to Basic Functions (SD-BF) module and is located in the package Application development R/3 RV central functions (VZ).
In addition, following links provide an overview of foreign key relationships, if any, that link VBPA to other SAP tables and standard CDS views available based on VBPA table in S/4HANA 2020.
Techincal Settings of VBPA
Below are technical details of the table VBPA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBPA Fields
The following table gives you an overview of the fields available in VBPA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | |
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| PARNR | Number of contact person | PARNR | NUMC | 10 | |
| ADRNR | Address | ADRNR | CHAR | 10 | |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| ADRDA | Address indicator | ADRDA | CHAR | 1 | |
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | |
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 |
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | |
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | |
| HISTUNR | Level number within hierarchy | HISTUNR | NUMC | 2 | |
| KNREF | Customer description of partner (plant storage location) | KNREF | CHAR | 30 | |
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | |
| HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | |
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | |
| PARVW_FF | Indicator 'further partners in this function' (VBPA2) | PARTNER_FF | CHAR | 1 | |
| ADRNP | Person Number | AD_PERSNUM | ADRP | CHAR | 10 |
| KALE | Maintain appointments in calendar | KALE | CHAR | 1 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_SDDOCPARTNER_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBPA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBPA | ADRNP | 1: CN | ADRP |
| VBPA | HITYP | C: CN | THIT |
| VBPA | KUNNR | C: CN | KNA1 |
| VBPA | LAND1 | C: CN | T005 |
| VBPA | LIFNR | C: CN | LFA1 |
| VBPA | MANDT | 1: CN | T000 |
| VBPA | PARVW | 1: CN | TPAR |