PPMGAG_T_PRDHS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PrepaymentHistoryProd | view | from | EXTENSION | Extension View for Hist Prod |
| I_PrepaymentHistoryProd | view | from | BASIC | Prepayment Agreement Production History |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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