SAP table BPID001 (Additional Partner Numbers)

SAP table BPID001 has 4 primary key fields being CLIENT,PARTNER,IDTYPE,IDNUM.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
PARTNER Business Partner Number CHAR 10 0 BUT000 BU_PARTNER
IDTYPE ID Number Category for Business Partner CHAR 6 0 BPID003_E BP_IDTYPE
IDNUM Identification Number for Business Partner CHAR 60 0 BP_IDNUM

BPID001 foreign key relationships

Table Field Check Table Check Field
0 BPID001 CLIENT T000 Clients MANDT
1 BPID001 IDTYPE BPID003_E ID Number Category CLIENT
0 BPID001 PARTNER BUT000 BP: General data I PARTNER