SAP VZGPO Partner/role object relationship Table

Overview

VZGPO is a standard SAP S/4HANA table that stores Partner/role object relationship data. There are total 21 fields in the VZGPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VZGPO belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package R/3 application development for Financial Assets Management (FVV).

In addition, following links provide an overview of foreign key relationships, if any, that link VZGPO to other SAP tables and standard CDS views available based on VZGPO table in S/4HANA 2020.

Techincal Settings of VZGPO

Below are technical details of the table VZGPO

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VZGPO Fields

The following table gives you an overview of the fields available in VZGPO

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
SNUMOBJKey for number range objectVVNUMOBJCHAR2
SOBJEKTInternal key for object for business partner tableVVSOBJGPOCHAR13
PARTNRBusiness Partner NumberBP_PARTNRBP000CHAR10
ROLETYPBusiness Partner Role CategoryBP_ROLETYPTPZ3CHAR4
DTRANSFlow data key: System dateVVDTRANSDATS8
DBEBEZDate of start of relationshipDBEBEZDATS8
DENBEZDate of end of relationshipDENBEZDATS8
APPLApplication CategoryBP_APPLTPZ12CHAR4
ADR_REFAddress IDBP_ADR_REF*CHAR10
ROLEBusiness Partner Role TypeBP_ROLETPZ6CHAR4
PBEZPercentage rate of relationshipPBEZDEC10
BBEZRelationship amountBBEZCURR13
SBBEZCurrency KeyWAERSTCURCCUKY5
KUNNRCustomer NumberKUNNRKNA1CHAR10
GZLSCHPayment method for credit memosVVGZLSCH*CHAR1
BVTYPPartner bank typeBVTYPCHAR4
ZLSCHPayment MethodDZLSCH*CHAR1
SDUNNDOCType of Dunning LetterSDUNNDOCCHAR1
SDUNNBUCPost Dunning Charges and Interest to This PartnerSDUNNBUCCHAR1
NORDEROrder NumberNORDERNUMC8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VZGPO

Table NameFieldCardinalityCheck Table
VZGPOAPPL:TPZ12
VZGPOKUNNR:KNA1
VZGPOMANDT:T000
VZGPOPARTNR:BP000
VZGPOROLE:TPZ6
VZGPOROLETYP:TPZ3
VZGPOSBBEZ:TCURC

Other References