PO_HISTORY

14 Fields

PO_HISTORY is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY InvtryMgmtReferenceDocument InvtryMgmtReferenceDocument 1
KEY MaterialDocument MaterialDocument,PurchasingHistoryDocument 2
KEY MaterialDocumentYear PurchasingHistoryDocumentYear 1
KEY PurchaseOrder PurchaseOrder 1
KEY PurchasingDocument PurchasingDocument 3
KEY PurchasingDocumentItem PurchasingDocumentItem 3
KEY PurchasingHistoryDocument PurchasingHistoryDocument 2
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem 1
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear 2
KEY ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 1
GoodsMovementType GoodsMovementType 1
MaterialDocumentItem MaterialDocumentItem 1
PurchaseOrderTransactionType PurchaseOrderTransactionType 1
ReferenceDocument ReferenceDocument 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 PO_HISTORY (
    INVTRYMGMTREFERENCEDOCUMENT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENTYEAR,
    REFERENCEDOCUMENTFISCALYEAR,
    GOODSMOVEMENTTYPE,
    MATERIALDOCUMENTITEM,
    PURCHASEORDERTRANSACTIONTYPE,
    REFERENCEDOCUMENT,
    PRIMARY KEY (INVTRYMGMTREFERENCEDOCUMENT, MATERIALDOCUMENT, MATERIALDOCUMENTYEAR, PURCHASEORDER, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTITEM, PURCHASINGHISTORYDOCUMENTYEAR, REFERENCEDOCUMENTFISCALYEAR)
);

Learn More