I_PREPAYMENTHISTORYPRODTP

CDS View
14 Fields 2 CDS Views

Prepayment Prod Hist Transactional view

I_PREPAYMENTHISTORYPRODTP is a CDS View in S/4HANA. Prepayment Prod Hist Transactional view. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PrepaymentHistoryProdTP view from CONSUMPTION Prepayment Histroy consumtion view
C_PrepaymentRenegttnHistProdTP view from CONSUMPTION Prepayment Agreement Production History

Fields (14)

KeyField CDS FieldsUsed in Views
KEY PrepaymentHistoryProdUUID PrepaymentHistoryProdUUID 2
CreationDateTime CreationDateTime 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
PrepaymentAgreementCommodity PrepaymentAgreementCommodity,PrepaymentAgreementCrop 2
PrepaymentAgreementUUID PrepaymentAgreementUUID 2
PrepaymentAgrmtHarvestYear PrepaymentAgrmtHarvestYear 2
PrepaymentHistAvgProdQty PrepaymentHistAvgProdQty 2
PrepaymentHistAvgProdUoM PrepaymentHistAvgProdUoM 2
PrepaymentHistoryCommentText PrepaymentHistoryCommentText 2
PrepaymentHistPlantedAreaQty PrepaymentHistPlantedAreaQty 2
PrepaymentHistPlantedAreaUoM PrepaymentHistPlantedAreaUoM 2
PrepaymentHistTotProductionQty PrepaymentHistTotProductionQty 2
PrepaymentHistTotProductionUoM PrepaymentHistTotProductionUoM 2

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 Prod Hist Transactional view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTHISTORYPRODTP (
    PREPAYMENTHISTORYPRODUUID,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PREPAYMENTAGREEMENTCOMMODITY,
    PREPAYMENTAGREEMENTUUID,
    PREPAYMENTAGRMTHARVESTYEAR,
    PREPAYMENTHISTAVGPRODQTY,
    PREPAYMENTHISTAVGPRODUOM,
    PREPAYMENTHISTORYCOMMENTTEXT,
    PREPAYMENTHISTPLANTEDAREAQTY,
    PREPAYMENTHISTPLANTEDAREAUOM,
    PREPAYMENTHISTTOTPRODUCTIONQTY,
    PREPAYMENTHISTTOTPRODUCTIONUOM,
    PRIMARY KEY (PREPAYMENTHISTORYPRODUUID)
);

Learn More