SAP table VZGPO (Partner/role object relationship)

SAP table VZGPO has 6 primary key fields being MANDT,SNUMOBJ,SOBJEKT,PARTNR,ROLETYP,DTRANS.

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
SNUMOBJ Key for number range object CHAR 2 0 VVNUMOBJ
VB Collateral value
VD Loans
VI Real Estate
VN Loan interested parties
VO Loan collateral object
VS Loan collateral
VW Securities
SOBJEKT Internal key for object for business partner table CHAR 13 0 VVSOBJGPO
PARTNR Business Partner Number CHAR 10 0 BP000 BP_PARTNR
ROLETYP Business Partner Role Category CHAR 4 0 TPZ3 BP_ROLETYP
DTRANS Flow data key: System date DATS 8 0 VVDTRANS
DBEBEZ Date of start of relationship DATS 8 0 DBEBEZ
DENBEZ Date of end of relationship DATS 8 0 DENBEZ
APPL Application Category CHAR 4 0 TPZ12 BP_APPL
ADR_REF Address ID CHAR 10 0 * BP_ADR_REF
ROLE Business Partner Role Type CHAR 4 0 TPZ6 BP_ROLE
PBEZ Percentage rate of relationship DEC 10 7 PBEZ
BBEZ Relationship amount CURR 13 2 BBEZ
SBBEZ Currency Key CUKY 5 0 TCURC WAERS
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
GZLSCH Payment method for credit memos CHAR 1 0 * VVGZLSCH
BVTYP Partner bank type CHAR 4 0 BVTYP
ZLSCH Payment Method CHAR 1 0 * DZLSCH
SDUNNDOC Type of Dunning Letter CHAR 1 0 SDUNNDOC
No dunning letter
C Copy of dunning letter
O Original dunning letter
SDUNNBUC Post Dunning Charges and Interest to This Partner CHAR 1 0 SDUNNBUC
NORDER Order Number NUMC 8 0 NORDER

VZGPO foreign key relationships

Table Field Check Table Check Field
0 VZGPO APPL TPZ12 Business partner: Application category MANDT
0 VZGPO APPL TPZ12 Business partner: Application category APPL
1 VZGPO KUNNR KNA1 General Data in Customer Master MANDT
1 VZGPO KUNNR KNA1 General Data in Customer Master KUNNR
0 VZGPO MANDT T000 Clients MANDT
1 VZGPO PARTNR BP000 Business Partner Master (General Data) PARTNR
0 VZGPO ROLE TPZ6 BP: Business Partner - Role Type MANDT
0 VZGPO ROLE TPZ6 BP: Business Partner - Role Type ROLE
1 VZGPO ROLETYP TPZ3 BP: Business Partner - Role Category MANDT
1 VZGPO ROLETYP TPZ3 BP: Business Partner - Role Category ROLETYP
0 VZGPO SBBEZ TCURC Currency Codes MANDT
0 VZGPO SBBEZ TCURC Currency Codes WAERS