_PURCHASEORDERHISTORY

5 Fields

_PURCHASEORDERHISTORY is an SAP database table in S/4HANA. It contains 5 fields.

Fields (5)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
GoodsReceiptAmount PPSDocTotalAmount 1
PurchaseOrderAmount PPSOpenInvoiceReceiptAmount 1
PurchaseOrderHistCategory PurchaseOrderHistCategory 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 _PURCHASEORDERHISTORY (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    GOODSRECEIPTAMOUNT,
    PURCHASEORDERAMOUNT,
    PURCHASEORDERHISTCATEGORY,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More