I_PPS_PURCHASINGHISTORY

CDS View
25 Fields 2 CDS Views

History Per Purchasing Document

I_PPS_PURCHASINGHISTORY is a CDS View in S/4HANA. History Per Purchasing Document. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPS_PurgHistWthAcctgDoc view from COMPOSITE Extended PO History EKBE and BSEG
I_USFedPurchasingHistory view_entity from COMPOSITE History per Purchasing Document and Item

Fields (25)

KeyField CDS FieldsUsed in Views
AmountInLocalCurrency AmountInLocalCurrency 1
CompanyCode CompanyCode 1
DocumentCurrency DocumentCurrency 1
FiscalYear FiscalYear 1
LocalCurrency LocalCurrency 1
NetValueAmountInDocCurrency NetValueAmountInDocCurrency 1
PostingDate PostingDate 1
POUnitOfMeasure POUnitOfMeasure 1
PPSPurgHistDocumentCategory PPSPurgHistDocumentCategory 1
PPSPurgHistDocumentType PPSPurgHistDocumentType 1
PPSReferenceDocument PPSReferenceDocument 1
PPSReferenceDocumentItem PPSReferenceDocumentItem 1
PPSReferenceDocumentType PPSReferenceDocumentType 1
PurchaseOrderQty PurchaseOrderQty 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingGroup PurchasingGroup 1
PurchasingHistoryDocument PurchasingHistoryDocument 1
PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem 1
PurchasingOrganization PurchasingOrganization 1
Quantity Quantity 1
ReferenceDocumentCategory ReferenceDocumentCategory 1
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 1
SemanticObject SemanticObject 1
UnitOfMeasure UnitOfMeasure 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.

-- History Per Purchasing Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPS_PURCHASINGHISTORY (
    AMOUNTINLOCALCURRENCY,
    COMPANYCODE,
    DOCUMENTCURRENCY,
    FISCALYEAR,
    LOCALCURRENCY,
    NETVALUEAMOUNTINDOCCURRENCY,
    POSTINGDATE,
    POUNITOFMEASURE,
    PPSPURGHISTDOCUMENTCATEGORY,
    PPSPURGHISTDOCUMENTTYPE,
    PPSREFERENCEDOCUMENT,
    PPSREFERENCEDOCUMENTITEM,
    PPSREFERENCEDOCUMENTTYPE,
    PURCHASEORDERQTY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUP,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGORGANIZATION,
    QUANTITY,
    REFERENCEDOCUMENTCATEGORY,
    REFERENCEDOCUMENTFISCALYEAR,
    SEMANTICOBJECT,
    UNITOFMEASURE
);

Learn More