I_PURCHASECONTRACTHISTORYAPI01

CDS View
15 Fields 2 CDS Views

Purchase Contract History

I_PURCHASECONTRACTHISTORYAPI01 is a CDS View in S/4HANA. Purchase Contract History. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PurchaseContractHistoryDEX view from CONSUMPTION Purchase Contract History Data Extractor
C_PurchaseContractHistoryDP view_entity from CONSUMPTION Purchase Contract History

Fields (15)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 1
KEY PurchaseContractItem PurchaseContractItem 1
KEY ReleaseOrder ReleaseOrder 1
KEY ReleaseOrderItem ReleaseOrderItem 1
CompanyCode CompanyCode 1
ExchangeRate ExchangeRate 1
Plant Plant 1
PurchasingOrganization PurchasingOrganization 1
ReleaseOrderCurrency ReleaseOrderCurrency 1
ReleaseOrderDate ReleaseOrderDate 1
ReleaseOrderItemIsDeleted ReleaseOrderDeletionCode 1
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate 1
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount 1
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity 1
ReleaseOrderItemQuantityUnit ReleaseOrderItemQuantityUnit 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.

-- Purchase Contract History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASECONTRACTHISTORYAPI01 (
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    RELEASEORDER,
    RELEASEORDERITEM,
    COMPANYCODE,
    EXCHANGERATE,
    PLANT,
    PURCHASINGORGANIZATION,
    RELEASEORDERCURRENCY,
    RELEASEORDERDATE,
    RELEASEORDERITEMISDELETED,
    RELEASEORDERITEMLASTCHGDATE,
    RELEASEORDERITEMNETAMOUNT,
    RELEASEORDERITEMORDERQUANTITY,
    RELEASEORDERITEMQUANTITYUNIT,
    PRIMARY KEY (PURCHASECONTRACT, PURCHASECONTRACTITEM, RELEASEORDER, RELEASEORDERITEM)
);

Learn More