SAP Table VZGPO

Partner/role object relationship

VZGPO (Partner/role object relationship) 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 VZGPO to other SAP tables.

Source: VZGPO (Partner/role object relationship)

VZGPO table fields

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

VZGPO foreign key relationships

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