PPMGAG_T_COMMREF
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PrepaymentAgrmtReference | view | from | EXTENSION | Extension View for Reference |
| I_PrepaymentAgrmtCommlRef | view | from | BASIC | Prepayment Agrmt Commercial Ref Int View |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA