1. Home
  2. Resources
  3. SAP Tables
  4. VBPAVB - Reference structure for XVBPA/YVBPA

SAP Table VBPAVB

Reference structure for XVBPA/YVBPA

VBPAVB (Reference structure for XVBPA/YVBPA) 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 VBPAVB to other SAP tables.

Source: VBPAVB (Reference structure for XVBPA/YVBPA)

VBPAVB 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
UPDKZ Update indicator UPDKZ_D CHAR 1 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NRART Type of partner number NRART TVPA CHAR 2 0
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
SPRAS Language Key SPRAS T002 LANG 1 0
TELFX Fax Number TELFX CHAR 31 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
CNTPA Counter for partner functions CNT_PARVW NUMC 6 0
REFOBJTYPE Object Type SWO_OBJTYP CHAR 10 0
REFOBJKEY Object key SWO_TYPEID CHAR 70 0
REFLOGSYS Logical system LOGSYS CHAR 10 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
STCDT Tax Number Type J_1ATOID CHAR 2 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0

VBPAVB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBPAVB ADRNP * ADRP Persons (Business Address Services) NATION
VBPAVB ADRNP * ADRP Persons (Business Address Services) DATE_FROM
VBPAVB ADRNP VBPAVB ADRNP ADRP Persons (Business Address Services) PERSNUMBER
VBPAVB ADRNP VBPAVB MANDT ADRP Persons (Business Address Services) CLIENT
VBPAVB FEHGR VBPAVB FEHGR TVUV Incompletion Control: Procedures FEHGR
VBPAVB FEHGR VBPA MANDT TVUV Incompletion Control: Procedures MANDT
VBPAVB HITYP VBPAVB HITYP THIT Customer Hierarchy Types HITYP
VBPAVB HITYP VBPAVB MANDT THIT Customer Hierarchy Types MANDT
VBPAVB KUNNR VBPAVB MANDT KNA1 General Data in Customer Master MANDT
VBPAVB KUNNR VBPAVB KUNNR KNA1 General Data in Customer Master KUNNR
VBPAVB LAND1 VBPAVB MANDT T005 Countries MANDT
VBPAVB LAND1 VBPAVB LAND1 T005 Countries LAND1
VBPAVB LIFNR VBPAVB LIFNR LFA1 Vendor Master (General Section) LIFNR
VBPAVB LIFNR VBPAVB MANDT LFA1 Vendor Master (General Section) MANDT
VBPAVB MANDT VBPAVB MANDT T000 Clients MANDT
VBPAVB NRART VBPAVB NRART TVPA Partner: Partner Types (Entities) NRART
VBPAVB NRART VBPA MANDT TVPA Partner: Partner Types (Entities) MANDT
VBPAVB OIPBL VBPAVB OIPBL OIFSPBL Physical Location - Master Data PBLNR
VBPAVB OIPBL VBPAVB MANDT OIFSPBL Physical Location - Master Data MANDT
VBPAVB PARVW VBPAVB MANDT TPAR Business Partner: Functions MANDT
VBPAVB PARVW VBPAVB PARVW TPAR Business Partner: Functions PARVW
VBPAVB POSNR VBPAVB MANDT VBUP Sales Document: Item Status MANDT
VBPAVB POSNR VBPAVB VBELN VBUP Sales Document: Item Status VBELN
VBPAVB POSNR VBPAVB POSNR VBUP Sales Document: Item Status POSNR
VBPAVB SPRAS VBPAVB SPRAS T002 Language Keys (Component BC-I18) SPRAS
VBPAVB VBELN VBPAVB MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBPAVB VBELN VBPAVB VBELN VBUK Sales Document: Header Status and Administrative Data VBELN