SAP table VZGPODEB (Tab. VZGPO + customer-relevant data)

SAP table VZGPODEB 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 * 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 * 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
EXTPARTNR External Business Partner ID CHAR 15 0 BP_EXT_PNR
XROLETYP Name of Role Category CHAR 30 0 BP_XROLTYP
XPARTNER Partner/address string CHAR 60 0 VVXPAADR
KUNNR Customer Number CHAR 10 0 * KUNNR
ROLE Business Partner Role Type CHAR 4 0 * BP_ROLE
APPL Application Category CHAR 4 0 * BP_APPL
ADR_REF Address ID CHAR 10 0 * BP_ADR_REF
PBEZ Percentage rate of relationship DEC 10 7 PBEZ
BBEZ Relationship amount CURR 13 2 BBEZ
SBBEZ Currency Key CUKY 5 0 * WAERS
ZLSCH Payment Method CHAR 1 0 * DZLSCH
BVTYP Partner bank type CHAR 4 0 BVTYP
MABER Dunning Area CHAR 2 0 * MABER
SDEBZUSA Customer indicator CHAR 1 0 KZDEB
KNRZE Head Office Account Number (in branch accounts) CHAR 10 0 * KNRZE
SANTART Type of share in an object in partner role NUMC 2 0 * VVSANTART
NAME1 Name 1 CHAR 35 0 NAME1_GP
XDEBFI Customer transferred from FI CHAR 1 0 VVXDEBFI
ROLE_ALLG Business Partner Role CHAR 4 0 BP_ROLE_G
XROLE_ALLG Description of Role CHAR 30 0 BP_XROLE_G
PAY_DATA_C Change payment method or bank cat. CHAR 1 0 PAY_DATA_C
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
LIFNR Account Number of Supplier CHAR 10 0 * LIFNR
LIFBVTYP Partner bank type CHAR 4 0 BVTYP

VZGPODEB foreign key relationships

Table Field Check Table Check Field
0 VZGPODEB ROLETYP TPZ3 BP: Business Partner - Role Category MANDT
0 VZGPODEB ROLETYP TPZ3 BP: Business Partner - Role Category ROLETYP