SAP table WBPA (Business Partner Assignment)

SAP table WBPA has 5 primary key fields being MANDT,WBELN,POSNR,PARVW,PARZA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WBELN Document Number CHAR 10 0 WBRK WBELN_AG
POSNR Document Item NUMC 6 0 WBRP WPOSNR_LF
PARVW Partner Function CHAR 2 0 TPAR PARVW
PARZA Partner counter NUMC 3 0 PARZA
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
LIFNR Reference to other supplier CHAR 10 0 LFA1 LIFN2
KUNNR Customer number of business partner CHAR 10 0 KNA1 KUNN2
DEFPA Default Partner CHAR 1 0 DEFPA
PARNR Number of Contact Person NUMC 10 0 KNVK PARNR
PERNR Personnel Number NUMC 8 0 PERNR_D
ADDRESS Address CHAR 10 0 ADRNR
KNREF Customer description of partner (plant, storage location) CHAR 30 0 KNREF
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
ASSIGNED_BP Business Partner Number CHAR 10 0 BUT000 BU_PARTNER
ADDR_OPERATION Address Determination in Document CHAR 6 0 TB008S SD_ADDR_OPERATION
ADDR_TYPE Address type (1=Organization, 2=Person, 3=Contact person) CHAR 1 0 AD_ADRTYPE
1 Organization, Company
2 Private address
3 Contact person (in company)
ADRNP Person Number CHAR 10 0 ADRP AD_PERSNUM
BP_REF_ADRNR BP Reference Address Number CHAR 10 0 SDPD_BP_REF_ADDRNUM
PLACE_HOLDER CHAR 1 0
ADRDAT Address indicator CHAR 1 0 ADRDA
No address exists
A Address from master data - obsolete
B Address entered in document manually - obsolete
C Address entered in Doc manually /dependent on 'B' - obsolete
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
H ADRC address from business partner master data
I Workplace address from relationship master data
ADRNR Address CHAR 10 0 * ADRNR
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
STCEG VAT Registration Number CHAR 20 0 STCEG
ADRDA Address indicator CHAR 1 0 ADRDA
No address exists
A Address from master data - obsolete
B Address entered in document manually - obsolete
C Address entered in Doc manually /dependent on 'B' - obsolete
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
H ADRC address from business partner master data
I Workplace address from relationship master data

WBPA foreign key relationships

Table Field Check Table Check Field
0 WBPA ADRNP ADRP Persons (Business Address Services) PERSNUMBER
0 WBPA ADRNP ADRP Persons (Business Address Services) DATE_FROM
0 WBPA ADRNP ADRP Persons (Business Address Services) NATION
1 WBPA ASSIGNED_BP BUT000 BP: General data I PARTNER
0 WBPA KUNNR KNA1 General Data in Customer Master MANDT
0 WBPA KUNNR KNA1 General Data in Customer Master KUNNR
1 WBPA LAND1 T005 Countries MANDT
1 WBPA LAND1 T005 Countries LAND1
0 WBPA LIFNR LFA1 Supplier Master (General Section) MANDT
0 WBPA LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WBPA MANDT T000 Clients MANDT
0 WBPA PARNR KNVK Customer Master Contact Partner MANDT
0 WBPA PARNR KNVK Customer Master Contact Partner PARNR
1 WBPA PARVW TPAR Business Partner: Functions PARVW
0 WBPA POSNR WBRP Settlement Management Document Item MANDT
0 WBPA POSNR WBRP Settlement Management Document Item WBELN
0 WBPA POSNR WBRP Settlement Management Document Item POSNR
1 WBPA REGIO T005S Taxes: Region (Province) Key LAND1
0 WBPA WBELN WBRK Settlement Management Document Header MANDT
0 WBPA WBELN WBRK Settlement Management Document Header WBELN