SAP Table VBPA
Sales Document: Partner
VBPA (Sales Document: Partner) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VBPA to other SAP tables.
VBPA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||
|
VBELN
Sales and Distribution Document Number
|
VBELN | VBUK |
CHAR
|
10 | 0 | |||||||||||||||||||
|
POSNR
Item number of the SD document
|
POSNR | VBUP |
NUMC
|
6 | 0 | |||||||||||||||||||
|
PARVW
Partner Function
|
PARVW | TPAR |
CHAR
|
2 | 0 | |||||||||||||||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||
|
PERNR
Personnel Number
|
PERNR_D |
NUMC
|
8 | 0 | ||||||||||||||||||||
|
PARNR
Number of contact person
|
PARNR |
NUMC
|
10 | 0 | ||||||||||||||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||||||||||||||
|
ABLAD
Unloading Point
|
ABLAD |
CHAR
|
25 | 0 | ||||||||||||||||||||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||||||||||||
|
ADRDA
Address indicator
|
ADRDA |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
XCPDK
Indicator: Is the account a one-time account?
|
XCPDK |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
HITYP
Customer hierarchy type
|
HITYP_KH | THIT |
CHAR
|
1 | 0 | |||||||||||||||||||
|
PRFRE
Relevant for price determination ID
|
PRFRE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
BOKRE
Indicator: Customer Is Rebate-Relevant
|
BOKRE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
HISTUNR
Level number within hierarchy
|
HISTUNR |
NUMC
|
2 | 0 | ||||||||||||||||||||
|
KNREF
Customer description of partner (plant, storage location)
|
KNREF |
CHAR
|
30 | 0 | ||||||||||||||||||||
|
LZONE
Transportation zone to or from which the goods are delivered
|
LZONE |
CHAR
|
10 | 0 | ||||||||||||||||||||
|
HZUOR
Assignment to Hierarchy
|
HZUOR |
NUMC
|
2 | 0 | ||||||||||||||||||||
|
STCEG
VAT Registration Number
|
STCEG |
CHAR
|
20 | 0 | ||||||||||||||||||||
|
PARVW_FF
Indicator 'further partners in this function' (VBPA2)
|
PARTNER_FF |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
ADRNP
Person number
|
AD_PERSNUM | ADRP |
CHAR
|
10 | 0 | |||||||||||||||||||
|
KALE
Maintain appointments in calendar
|
KALE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
OIPBL
Business location identifier (IS-Oil MRN)
|
OIF_PBLNRP | OIFSPBL |
CHAR
|
10 | 0 | |||||||||||||||||||
VBPA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VBPA | ADRNP | VBPA | MANDT |
ADRP
Persons (Business Address Services)
|
CLIENT |
| VBPA | ADRNP | VBPA | ADRNP |
ADRP
Persons (Business Address Services)
|
PERSNUMBER |
| VBPA | ADRNP | * |
ADRP
Persons (Business Address Services)
|
DATE_FROM | |
| VBPA | ADRNP | * |
ADRP
Persons (Business Address Services)
|
NATION | |
| VBPA | HITYP | VBPA | MANDT |
THIT
Customer Hierarchy Types
|
MANDT |
| VBPA | HITYP | VBPA | HITYP |
THIT
Customer Hierarchy Types
|
HITYP |
| VBPA | KUNNR | VBPA | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| VBPA | KUNNR | VBPA | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| VBPA | LAND1 | VBPA | MANDT |
T005
Countries
|
MANDT |
| VBPA | LAND1 | VBPA | LAND1 |
T005
Countries
|
LAND1 |
| VBPA | LIFNR | VBPA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| VBPA | LIFNR | VBPA | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| VBPA | MANDT | VBPA | MANDT |
T000
Clients
|
MANDT |
| VBPA | OIPBL | VBPA | MANDT |
OIFSPBL
Physical Location - Master Data
|
MANDT |
| VBPA | OIPBL | VBPA | OIPBL |
OIFSPBL
Physical Location - Master Data
|
PBLNR |
| VBPA | PARVW | VBPA | PARVW |
TPAR
Business Partner: Functions
|
PARVW |
| VBPA | PARVW | VBPA | MANDT |
TPAR
Business Partner: Functions
|
MANDT |
| VBPA | POSNR | VBPA | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| VBPA | POSNR | VBPA | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| VBPA | POSNR | VBPA | POSNR |
VBUP
Sales Document: Item Status
|
POSNR |
| VBPA | VBELN | VBPA | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| VBPA | VBELN | VBPA | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |