I_PREPAYMENTHISTORYSALESTP

CDS View

Prepayment Sales History Trans view

I_PREPAYMENTHISTORYSALESTP is a CDS View in S/4HANA. Prepayment Sales History Trans view. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PrepaymentHistorySalesTP view from CONSUMPTION Prepayment Sales History Consumtion View
C_PrepaymentRenegttnHistSaleTP view from CONSUMPTION Prepayment Agreement Sales History

Fields (8)

KeyField CDS FieldsUsed in Views
KEY PrepaymentHistorySalesUUID PrepaymentHistorySalesUUID 2
CreationDateTime CreationDateTime 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
PrepaymentAgreementUUID PrepaymentAgreementUUID 2
PrepaymentHistoryRegion PrepaymentHistoryRegion 2
PrepaymentHistPlantedAreaQty PrepaymentHistPlantedAreaQty 2
PrepaymentHistPlantedAreaUoM PrepaymentHistPlantedAreaUoM 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 Sales History Trans view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTHISTORYSALESTP (
    PREPAYMENTHISTORYSALESUUID,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PREPAYMENTAGREEMENTUUID,
    PREPAYMENTHISTORYREGION,
    PREPAYMENTHISTPLANTEDAREAQTY,
    PREPAYMENTHISTPLANTEDAREAUOM,
    PRIMARY KEY (PREPAYMENTHISTORYSALESUUID)
);