I_CNTRLPURCONTRWTHPRICEHIST

CDS View
16 Fields 5 CDS Views

Central Contracts Price data

I_CNTRLPURCONTRWTHPRICEHIST is a CDS View in S/4HANA. Central Contracts Price data. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_CCTRPriceHistoryVersion view from CONSUMPTION CCTR Price History Version for Fragment
P_CCTRPriceHistoryVersion view union_all CONSUMPTION CCTR Price History Version for Fragment
P_CntrlContrPriceComponents view inner CONSUMPTION Price Components
P_CntrlContrPriceHistComp view from CONSUMPTION Cenral Contract Price history Components
P_CntrlPurContrWthPriceHist view from CONSUMPTION Central Contract Price History

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ActivePurchasingDocument ActivePurchasingDocument 1
KEY CentralPurchaseContractItem CentralPurchaseContractItem 1
KEY PurchasingDocumentVersion PurchasingDocumentVersion 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DocumentCurrency DocumentCurrency 1
Material Material 1
MaterialGroup MaterialGroup 1
OrderQuantityUnit OrderQuantityUnit 1
PaymentTerms PaymentTerms 1
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID 1
PurchaseContractType PurchaseContractType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Supplier Supplier 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.

-- Central Contracts Price data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNTRLPURCONTRWTHPRICEHIST (
    ACTIVEPURCHASINGDOCUMENT,
    CENTRALPURCHASECONTRACTITEM,
    PURCHASINGDOCUMENTVERSION,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    ORDERQUANTITYUNIT,
    PAYMENTTERMS,
    PROCMTHUBCOMPANYCODEGROUPINGID,
    PURCHASECONTRACTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (ACTIVEPURCHASINGDOCUMENT, CENTRALPURCHASECONTRACTITEM, PURCHASINGDOCUMENTVERSION)
);

Learn More