1. Home
  2. Resources
  3. SAP Tables
  4. WBPA - Agency Business: Business Partner Assignment

SAP Table WBPA

Agency Business: Business Partner Assignment

WBPA (Agency Business: Business Partner Assignment) 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 WBPA to other SAP tables.

WBPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WBELN Agency Business: Document Number WBELN_AG WBRK CHAR 10 0
POSNR Agency business: Document item WPOSNR_LF WBRP NUMC 6 0
PARVW Partner Function PARVW TPAR CHAR 2 0
PARZA Partner counter PARZA NUMC 3 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
LIFNR Reference to other vendor LIFN2 LFA1 CHAR 10 0
KUNNR Customer number of business partner KUNN2 KNA1 CHAR 10 0
DEFPA Default Partner DEFPA CHAR 1 0
X Yes
NULL No
PARNR Number of contact person PARNR KNVK NUMC 10 0
PERNR Personnel Number PERNR_D NUMC 8 0
ADDRESS Address ADRNR CHAR 10 0
PLACE_HOLDER CHAR 1 0
ADRDAT 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
ADRNR Address ADRNR SADRP CHAR 10 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
STCEG VAT Registration Number STCEG CHAR 20 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

WBPA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WBPA ADRNR * SADRP Address Management: Personal Data NATIO
WBPA ADRNR WBPA MANDT SADRP Address Management: Personal Data MANDT
WBPA ADRNR WBPA ADRNR SADRP Address Management: Personal Data ADRNR
WBPA KUNNR WBPA MANDT KNA1 General Data in Customer Master MANDT
WBPA KUNNR WBPA KUNNR KNA1 General Data in Customer Master KUNNR
WBPA LIFNR WBPA MANDT LFA1 Vendor Master (General Section) MANDT
WBPA LIFNR WBPA LIFNR LFA1 Vendor Master (General Section) LIFNR
WBPA MANDT WBPA MANDT T000 Clients MANDT
WBPA PARNR WBPA MANDT KNVK Customer Master Contact Partner MANDT
WBPA PARNR WBPA PARNR KNVK Customer Master Contact Partner PARNR
WBPA PARVW WBPA MANDT TPAR Business Partner: Functions MANDT
WBPA PARVW WBPA PARVW TPAR Business Partner: Functions PARVW
WBPA POSNR WBPA MANDT WBRP Agency business: Item MANDT
WBPA POSNR WBPA WBELN WBRP Agency business: Item WBELN
WBPA POSNR WBPA POSNR WBRP Agency business: Item POSNR
WBPA WBELN WBPA WBELN WBRK Agency business: Header WBELN
WBPA WBELN WBPA MANDT WBRK Agency business: Header MANDT