1. Home
  2. Resources
  3. SAP Tables
  4. VBPA - Sales Document: Partner

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
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
NULL No address exists
A Address from master data
B Address entered in document manually
C Address entered in document manually / dependent on 'B'
D ADRC address from master data
E ADRC address entered in document manually
F ADRC address entered in document manually / dep. on 'E' doc.
G Private address from master data
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
HITYP Customer hierarchy type HITYP_KH THIT CHAR 1 0
PRFRE Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
BOKRE Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
ADRNP Person number AD_PERSNUM ADRP CHAR 10 0
KALE Maintain appointments in calendar KALE CHAR 1 0
X Yes
NULL NO
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 MANDT TPAR Business Partner: Functions MANDT
VBPA PARVW VBPA PARVW TPAR Business Partner: Functions PARVW
VBPA POSNR VBPA VBELN VBUP Sales Document: Item Status VBELN
VBPA POSNR VBPA POSNR VBUP Sales Document: Item Status POSNR
VBPA POSNR VBPA MANDT VBUP Sales Document: Item Status MANDT
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