SAP VDGPO Loan: Relationship Partner/Role Object Table

Overview

VDGPO is a standard SAP S/4HANA table that stores Loan: Relationship Partner/Role Object data. There are total 22 fields in the VDGPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDGPO belongs to Loans Management (FS-CML) module and is located in the package Loans Specific Objects in SAP Business Partner (FVVD_PARTNER).

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

Techincal Settings of VDGPO

Below are technical details of the table VDGPO

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

List of VDGPO Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
SNUMOBJKey for number range objectVVNUMOBJCHAR2
SOBJEKTInternal key for object for business partner tableVVSOBJGPOCHAR13
PARTNRBusiness Partner NumberBP_PARTNR_NEW*CHAR10
ROLETYPBP RoleBU_PARTNERROLE*CHAR6
DTRANSFlow data key: System dateVVDTRANSDATS8
DBEBEZDate of start of relationshipDBEBEZDATS8
DENBEZDate of end of relationshipDENBEZDATS8
APPLApplication CategoryBP_APPLTPZ12CHAR4
ADR_REFAddress IDBP_ADR_REF_NEW*CHAR10
ROLECML Correspondence Role Type of RecipientTB_ROLE_CORRTDPZ6CHAR4
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
MNDIDUnique Reference to Mandate for each PayeeSEPA_MNDIDCHAR35

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 VDGPO

Table NameFieldCardinalityCheck Table
VDGPOAPPL:TPZ12
VDGPOKUNNR:KNA1
VDGPOMANDT:T000
VDGPOPARTNR:*
VDGPOROLE:TDPZ6
VDGPOROLETYP:*
VDGPOSBBEZ:TCURC

Other References