PPMGAG_T_COMMREF

Transparent Table Application Table

Prepayment Agreement Commercial References

PPMGAG_T_COMMREF is an SAP database table in S/4HANA. Prepayment Agreement Commercial References. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PrepaymentAgrmtReference view from EXTENSION Extension View for Reference
I_PrepaymentAgrmtCommlRef view from BASIC Prepayment Agrmt Commercial Ref Int View

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY prepaymentcommlrefuuid /bobf/uuid Key
prepaymentagreementuuid /bobf/uuid Key
prepaymentcommlreftype ppmgag_e_commlreftype Commercial Ref Type
prepaymentcommercialreference ppmgag_e_commlreftype2 Commercial Ref Type
prepaymentcommlrefname ppmgag_e_commlrefname Commercial Ref Name
prepaymentrefcontactpersonname ppmgag_e_commlrefname Commercial Ref Name
prepaymentcommlrefcurjobtitle ppmgag_e_commlrefcurrjobtitle Current Job Title
prepaymentcommlrefsegment ppmgag_e_commlrefsegment Comml Ref Segment
prepaymentcommlrefindstryfunc ppmgag_e_commlrefindfunction Industry Function
prepaymentcommlrefcity ppmgag_e_commlrefcity Reference City
prepaymentcommlrefcontnumber ppmgag_e_commlrefcontnumber Commercial Ref No.
prepaymentcommlrefcontemail ppmgag_e_commlrefcontemail CommRef Email
prepaymentcommlrefdivision ppmgag_e_commlrefdivision Division
ppmgac_sur_dummy cfd_dummy Dummy
ppmgac_bp_dummy cfd_dummy Dummy

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.

-- Prepayment Agreement Commercial References
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_COMMREF (
    MANDT,                           -- Client [mandt]
    PREPAYMENTCOMMLREFUUID,          -- Key [/bobf/uuid]
    PREPAYMENTAGREEMENTUUID,         -- Key [/bobf/uuid]
    PREPAYMENTCOMMLREFTYPE,          -- Commercial Ref Type [ppmgag_e_commlreftype]
    PREPAYMENTCOMMERCIALREFERENCE,   -- Commercial Ref Type [ppmgag_e_commlreftype2]
    PREPAYMENTCOMMLREFNAME,          -- Commercial Ref Name [ppmgag_e_commlrefname]
    PREPAYMENTREFCONTACTPERSONNAME,  -- Commercial Ref Name [ppmgag_e_commlrefname]
    PREPAYMENTCOMMLREFCURJOBTITLE,   -- Current Job Title [ppmgag_e_commlrefcurrjobtitle]
    PREPAYMENTCOMMLREFSEGMENT,       -- Comml Ref Segment [ppmgag_e_commlrefsegment]
    PREPAYMENTCOMMLREFINDSTRYFUNC,   -- Industry Function [ppmgag_e_commlrefindfunction]
    PREPAYMENTCOMMLREFCITY,          -- Reference City [ppmgag_e_commlrefcity]
    PREPAYMENTCOMMLREFCONTNUMBER,    -- Commercial Ref No. [ppmgag_e_commlrefcontnumber]
    PREPAYMENTCOMMLREFCONTEMAIL,     -- CommRef Email [ppmgag_e_commlrefcontemail]
    PREPAYMENTCOMMLREFDIVISION,      -- Division [ppmgag_e_commlrefdivision]
    PPMGAC_SUR_DUMMY,                -- Dummy [cfd_dummy]
    PPMGAC_BP_DUMMY,                 -- Dummy [cfd_dummy]
    PRIMARY KEY (MANDT, PREPAYMENTCOMMLREFUUID)
);