VDGPO

Transparent Table Application Table
22 Fields 2 CDS Views

Loan: Relationship Partner/Role Object

VDGPO is an SAP database table in S/4HANA. Loan: Relationship Partner/Role Object. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LoanContrBusPartRelshp view from BASIC Business Partner relationship data for loan contract
I_LoanContrBusPartRelshpData view from BASIC Business Partner relationship data for Loan Contract

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY snumobj VVNUMOBJ No.range
KEY sobjekt VVSOBJGPO Object key
KEY partnr BP_PARTNR_NEW BusPartner
KEY roletyp BU_PARTNERROLE BP Role
KEY dtrans VVDTRANS Flow date
dbebez DBEBEZ Start reltnship
denbez DENBEZ End of relat.
appl BP_APPL Application Cat
adr_ref BP_ADR_REF_NEW Address ID
role TB_ROLE_CORR Role Type
pbez PBEZ Percentage
bbez BBEZ Amount
sbbez WAERS Currency
kunnr KUNNR Customer
gzlsch VVGZLSCH Cred.memo pmntM
bvtyp BVTYP Part.bank type
zlsch DZLSCH Pymt Meth.
sdunndoc SDUNNDOC Dunning letter
sdunnbuc SDUNNBUC Dunn.Chrges Pyr
norder NORDER Order Number
mndid SEPA_MNDID Mandate Ref.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Loan: Relationship Partner/Role Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VDGPO (
    MANDT,     -- Client [MANDT]
    SNUMOBJ,   -- No.range [VVNUMOBJ]
    SOBJEKT,   -- Object key [VVSOBJGPO]
    PARTNR,    -- BusPartner [BP_PARTNR_NEW]
    ROLETYP,   -- BP Role [BU_PARTNERROLE]
    DTRANS,    -- Flow date [VVDTRANS]
    DBEBEZ,    -- Start reltnship [DBEBEZ]
    DENBEZ,    -- End of relat. [DENBEZ]
    APPL,      -- Application Cat [BP_APPL]
    ADR_REF,   -- Address ID [BP_ADR_REF_NEW]
    ROLE,      -- Role Type [TB_ROLE_CORR]
    PBEZ,      -- Percentage [PBEZ]
    BBEZ,      -- Amount [BBEZ]
    SBBEZ,     -- Currency [WAERS]
    KUNNR,     -- Customer [KUNNR]
    GZLSCH,    -- Cred.memo pmntM [VVGZLSCH]
    BVTYP,     -- Part.bank type [BVTYP]
    ZLSCH,     -- Pymt Meth. [DZLSCH]
    SDUNNDOC,  -- Dunning letter [SDUNNDOC]
    SDUNNBUC,  -- Dunn.Chrges Pyr [SDUNNBUC]
    NORDER,    -- Order Number [NORDER]
    MNDID,     -- Mandate Ref. [SEPA_MNDID]
    PRIMARY KEY (MANDT, SNUMOBJ, SOBJEKT, PARTNR, ROLETYP, DTRANS)
);

Learn More