I_PURCHASEORDERHISTORY

CDS View
28 Fields 48 CDS Views

Purchase Order History

I_PURCHASEORDERHISTORY is a CDS View in S/4HANA. Purchase Order History. It contains 28 fields. 48 CDS views read from this table.

CDS Views using this table (48)

ViewTypeJoinVDMDescription
C_Purdoclistgrquantity view inner CONSUMPTION GR Quantity
C_Purdoclistgrreference view inner CONSUMPTION GR Reference
C_Purdoclistpoitemstatusekbe view from CONSUMPTION Helper for PO History in PO Item Status
C_PurgDocGRSts view from CONSUMPTION Goods Receipt document status
C_ServiceEntrySheetProcessFlow view from CONSUMPTION Process Flow For Service Entry Sheet
C_ServiceEntrySheetProcessFlow view union_all CONSUMPTION Process Flow For Service Entry Sheet
I_GoodsInvoiceHistory view from COMPOSITE Goods Invoice History Data
I_PlantOfGRBlockStock_VH view inner TRANSACTIONAL Value Help for Plant of GR Blocked Stock
I_StorLocOfGRBlockStock_VH view inner TRANSACTIONAL Value Help for Storage Location of GR Blocked Stock
P_GetGRPostingDate view from TRANSACTIONAL
P_GRBlockedStockTotal view from TRANSACTIONAL
P_GrInvQtyInd view from CONSUMPTION
P_GRItmOvw view from CONSUMPTION Overview of Goods Receipt Items
P_HistoryMigration view from CONSUMPTION PO History for Migration Report
P_InvoicePriceVariance1 view from CONSUMPTION
P_MPPurchaseOrder view from COMPOSITE
P_MPSESData view from COMPOSITE
P_POandSAdocs view from CONSUMPTION Union of PO and SA History
P_POHistInDateRange view from CONSUMPTION PO History in date range
P_POHistory view from CONSUMPTION PO History for Invoice Price
P_POHistoryForGR view from CONSUMPTION
P_POHistoryForInvoice view from CONSUMPTION
P_POItemDwnPaytCalc1 view from CONSUMPTION Down Payment done Calc for PO Item
P_POItemGRHistory view from CONSUMPTION
P_PriceAndQuantityVariance view from CONSUMPTION Price And Quantity Variance
P_PriceVariance4 view from CONSUMPTION Price Variance 4
P_PurchaseOrderHistDetail view from CONSUMPTION PurchaseOrderHistDetail
P_PurchaseOrderHisTimVar view from CONSUMPTION Purchase Order History for time Variance
P_PurchaseOrderItemHistory view from CONSUMPTION Purchase Order Item History
P_PurOrdDeliveredQty view inner CONSUMPTION Purchase Order Delivered Quantity
P_PurOrdGRAndInvoices view from CONSUMPTION Purchase Order Item GR and Invoices
P_PurOrdHistDelivCost view from CONSUMPTION Purchase Order History Delivery Cost
P_PurOrdItemGRAndInvoices view from CONSUMPTION Purchase Order Item GR and Invoices
P_PurOrdServiceInvoice1 view from CONSUMPTION Purchase Order Service Invoice
P_PurReqTrkGRInv view from CONSUMPTION GR and Invoices without parameter
P_RU_GtdFromPOMM3 view from COMPOSITE
P_RU_GtdFromPOMM4 view from COMPOSITE
P_RU_GtdFromPOMM4 view inner COMPOSITE
P_RU_MaterialRcptDateMM2 view from CONSUMPTION
P_RU_MaterialRcptDateMM3 view inner CONSUMPTION
P_RU_MaterialReceiptDateMM2 view from COMPOSITE
P_RU_MaterialReceiptDateMM2 view inner COMPOSITE
P_RU_MaterialReceiptDateMM3 view from COMPOSITE
P_RU_MaterialReceiptDateMM3 view left_outer COMPOSITE
P_RU_MaterialReceiptDateMM4 view left_outer COMPOSITE
P_RU_MaterialReceiptDateMM5 view from COMPOSITE
P_RU_MaterialReceiptDateMM5 view inner COMPOSITE
P_SuplrEvalByQltyNotif1 view from CONSUMPTION Supplier Eval By Quality Notification

Fields (28)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 4
KEY MaterialDocument IR_MaterialDocument,MaterialDocument 12
KEY MaterialDocumentItem IR_MaterialDocumentItem,MaterialDocumentItem 10
KEY MaterialDocumentYear IR_MaterialDocumentYear,MaterialDocumentYear 12
KEY PurchaseOrder PurchaseOrder,PurchasingDocument 21
KEY PurchaseOrderItem PurchaseOrderItem,PurchasingDocumentItem 16
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType 3
_PurchaseOrderItem _PurchaseOrderItem 1
Currency Currency,InvoiceCurrency 4
DebitCreditCode DebitCreditCode 3
DocumentCurrency Currency 1
DocumentDate DocumentDate 3
GdsRcptBlkdStkQtyInOrdQtyUnit GdsRcptBlkdStkQtyInOrdQtyUnit 2
GoodsMovementType GoodsMovementType 2
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy,PurchaseOrderAmount 2
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInCoCodeCrcy 1
Material Material 2
Plant Plant 1
PostingDate InvoiceDate,PostingDate 11
PurchaseOrderAmount PurchaseOrderAmount,PurOrdAmountInCompanyCodeCrcy 2
PurchaseOrderHistCategory IR_PurchaseOrderHistCategory,PurchaseOrderHistCategory 4
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy 1
Quantity NetPriceQuantity,Quantity 7
ReferenceDocument IR_ReferenceDocument,ReferenceDocument 3
ReferenceDocumentFiscalYear IR_ReferenceDocumentFiscalYear,ReferenceDocumentFiscalYear 4
ReferenceDocumentItem IR_ReferenceDocumentItem,ReferenceDocumentItem 3

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 Order History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDERHISTORY (
    ACCOUNTASSIGNMENTNUMBER,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERTRANSACTIONTYPE,
    _PURCHASEORDERITEM,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    GDSRCPTBLKDSTKQTYINORDQTYUNIT,
    GOODSMOVEMENTTYPE,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEAMTINCOCODECRCY,
    INVOICEAMTINPURORDTRANSACCRCY,
    MATERIAL,
    PLANT,
    POSTINGDATE,
    PURCHASEORDERAMOUNT,
    PURCHASEORDERHISTCATEGORY,
    PURCHASEORDERQUANTITYUNIT,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEORDERTRANSACTIONTYPE)
);

Learn More