R_PRICECHANGEDOCUMENT

CDS View

R_PRICECHANGEDOCUMENT is a CDS View in S/4HANA. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PriceChangeDocument view from COMPOSITE Material Ledger Price Change Documents

Fields (18)

KeyField CDS FieldsUsed in Views
KEY MaterialLedgerDocumentYear MaterialLedgerDocumentYear 1
KEY PriceChangeDocument PriceChangeDocument 1
BusinessTransactionType BusinessTransactionType 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
DocumentDate DocumentDate 1
DocumentHeaderText DocumentHeaderText 1
ExecutedTransaction ExecutedTransaction 1
IsReversalDocument IsReversalDocument 1
LedgerGroup LedgerGroup 1
LogicalSystem LogicalSystem 1
MaterialLedgerTransactionType MaterialLedgerTransactionType 1
MatlPrChgAcctDetnDiffntnRsn MatlPrChgAcctDetnDiffntnRsn 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PRICECHANGEDOCUMENT (
    MATERIALLEDGERDOCUMENTYEAR,
    PRICECHANGEDOCUMENT,
    BUSINESSTRANSACTIONTYPE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTDATE,
    DOCUMENTHEADERTEXT,
    EXECUTEDTRANSACTION,
    ISREVERSALDOCUMENT,
    LEDGERGROUP,
    LOGICALSYSTEM,
    MATERIALLEDGERTRANSACTIONTYPE,
    MATLPRCHGACCTDETNDIFFNTNRSN,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    PRIMARY KEY (MATERIALLEDGERDOCUMENTYEAR, PRICECHANGEDOCUMENT)
);