PPMGAG_T_PRDHS

Transparent Table Application Table

Prepayment Agreement Production History

PPMGAG_T_PRDHS is an SAP database table in S/4HANA. Prepayment Agreement Production History. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PrepaymentHistoryProd view from EXTENSION Extension View for Hist Prod
I_PrepaymentHistoryProd view from BASIC Prepayment Agreement Production History

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prepaymenthistoryproduuid /BOBF/UUID Key
prepaymentagreementuuid /BOBF/UUID Key
prepaymentagrmtharvestyear PPMGAG_E_HARVEST_YEAR Harvest Year
prepaymentagreementcommodity TBA_STOEFFCHEN Commodity
prepaymenthistplantedareaqty PPMGAG_E_PLANTED_AREA_QTY Quantity
prepaymenthistplantedareauom MEINS Base Unit
prepaymenthistavgprodqty PPMGAG_E_AVG_PROD_QTY Avg Prodn Quantity
prepaymenthistavgproduom MEINS Base Unit
prepaymenthisttotproductionqty PPMGAG_E_TOT_PROD_QTY Total Productn Qnty
prepaymenthisttotproductionuom MEINS Base Unit
prepaymenthistorycommenttext PPMGAG_E_HIS_COMMENT_TXT History Comment Text
createdbyuser PPMGAG_E_CREATEDBYUSER Created By
creationdatetime PPMGAG_E_CREATIONDATETIME Rec. Crtn Timestamp
lastchangedbyuser PPMGAG_E_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime PPMGAG_E_LASTCHANGEDATETIME Last Changed On
ppmgag_dummy CFD_DUMMY Dummy
ppmgac_bp_dummy CFD_DUMMY Dummy
ppmgac_sur_dummy CFD_DUMMY Dummy
ppmgag_prdhs_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 Production History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPMGAG_T_PRDHS (
    MANDT,                           -- Client [MANDT]
    PREPAYMENTHISTORYPRODUUID,       -- Key [/BOBF/UUID]
    PREPAYMENTAGREEMENTUUID,         -- Key [/BOBF/UUID]
    PREPAYMENTAGRMTHARVESTYEAR,      -- Harvest Year [PPMGAG_E_HARVEST_YEAR]
    PREPAYMENTAGREEMENTCOMMODITY,    -- Commodity [TBA_STOEFFCHEN]
    PREPAYMENTHISTPLANTEDAREAQTY,    -- Quantity [PPMGAG_E_PLANTED_AREA_QTY]
    PREPAYMENTHISTPLANTEDAREAUOM,    -- Base Unit [MEINS]
    PREPAYMENTHISTAVGPRODQTY,        -- Avg Prodn Quantity [PPMGAG_E_AVG_PROD_QTY]
    PREPAYMENTHISTAVGPRODUOM,        -- Base Unit [MEINS]
    PREPAYMENTHISTTOTPRODUCTIONQTY,  -- Total Productn Qnty [PPMGAG_E_TOT_PROD_QTY]
    PREPAYMENTHISTTOTPRODUCTIONUOM,  -- Base Unit [MEINS]
    PREPAYMENTHISTORYCOMMENTTEXT,    -- History Comment Text [PPMGAG_E_HIS_COMMENT_TXT]
    CREATEDBYUSER,                   -- Created By [PPMGAG_E_CREATEDBYUSER]
    CREATIONDATETIME,                -- Rec. Crtn Timestamp [PPMGAG_E_CREATIONDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [PPMGAG_E_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,              -- Last Changed On [PPMGAG_E_LASTCHANGEDATETIME]
    PPMGAG_DUMMY,                    -- Dummy [CFD_DUMMY]
    PPMGAC_BP_DUMMY,                 -- Dummy [CFD_DUMMY]
    PPMGAC_SUR_DUMMY,                -- Dummy [CFD_DUMMY]
    PPMGAG_PRDHS_DUMMY,              -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PREPAYMENTHISTORYPRODUUID)
);