I_PurchaseOrderHistoryAPI01

Purchase Order History | view: IMMPURORDHISAP01 | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKBE, EKPO, EKBEH, EKKO, T001, TKA02

🔑 Keys (7)
💰 Amounts (9)
∑ Quantities (8)
📅 Dates (3)
☰ Categorical (5)
Other (9)
🔗 Relations (16)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem FK	Item Number of Purchasing Document
AccountAssignmentNumber	Sequential Number of Account Assignment
PurchasingHistoryDocumentType	Transaction/event type, purchase order history	Show values
PurchasingHistoryDocumentYear	Material Document Year
PurchasingHistoryDocument	Number of Material Document
PurchasingHistoryDocumentItem	Item in Material Document

Column Name	Description
💲 Currency Key (CompanyCodeCurrency):
PurOrdAmountInCompanyCodeCrcy	Amount in Local Currency
GRIRAcctClrgAmtInCoCodeCrcy	GR/IR account clearing value in local currency
InvoiceAmtInCoCodeCrcy	Invoice Value Entered (in Local Currency)
💲 Currency Key (Currency):
PurchaseOrderAmount	Amount in Document Currency
InvoiceAmountInFrgnCurrency	Invoice Value in Foreign Currency
GRIRAcctClrgAmtInTransacCrcy	Clearing value on GR/IR clearing account (transac. currency)
ExchangeRateDifferenceAmount	Exchange Rate Difference Amount
💲 Currency Key (DocumentCurrency):
GRIRAcctClrgAmtInOrdTrnsacCrcy	Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy	Invoice Amount in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
Quantity	Quantity
GdsRcptBlkdStkQtyInOrdQtyUnit	Goods Receipt Blocked Stock in Order Unit
VltdGdsRcptBlkdStkQtyInOrdUnit	Valuated Goods Receipt Blocked Stock in Order Unit
📏 Order Price Unit (Purchasing) (OrderPriceUnit):
QtyInPurchaseOrderPriceUnit	Quantity in purchase order price unit
GdsRcptBlkdStkQtyInOrdPrcUnit	Quantity in GR blocked stock in order price unit
VltdGdsRcptBlkdQtyInOrdPrcUnit	Quantity in Valuated GR Blocked Stock in Order Price Unit
📏 Unit of Measure From Delivery Note (DeliveryQuantityUnit):
QuantityInDeliveryQtyUnit	Quantity in Unit of Measure from Delivery Note
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit	Quantity

Column Name	Description
PostingDate	Posting Date in the Document
DocumentDate	Document Date in Document
AccountingDocumentCreationDate	Day On Which Accounting Document Was Entered

Column Name	Description
PurchasingHistoryDocumentType	Transaction/event type, purchase order history	Show values
DebitCreditCode	Debit/Credit Indicator	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
RvslOfGoodsReceiptIsAllowed	Reversal of GR allowed for GR-based IV despite invoice	Show values
IsToBeAcceptedAtOrigin	Acceptance At Origin	Show values

Column Name	Description	Domain name
ReferenceDocumentFiscalYear	Fiscal Year of a Reference Document	GJAHR
ReferenceDocument	Document No. of a Reference Document	BELNR
ReferenceDocumentItem	Item of a Reference Document	MBLPO
PricingDocument	Number of the Document Condition	KNUMV
TaxCode	Tax on sales/purchases code	MWSKZ
DocumentReferenceID	Reference Document Number	XBLNR1
ExchangeRate	Exchange Rate	FIS_UKURS
DeliveryDocument	Delivery	VBELN
DeliveryDocumentItem	Delivery Item	POSNR

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`I_PURCHASEORDERHISTORYAPI01.BASEUNIT == T006.MSEHI` `I_PURCHASEORDERHISTORYAPI01.MANDT == T006.MANDT`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYAPI01.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYAPI01.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.DOCUMENTCURRENCY == TCURC.WAERS`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYAPI01.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYAPI01.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.DOCUMENTCURRENCY == TCURC.WAERS`
Unit of Measure From Delivery Note Client Unit of Measure From Delivery Note	`I_PURCHASEORDERHISTORYAPI01.MANDT == T006.MANDT` `I_PURCHASEORDERHISTORYAPI01.DELIVERYQUANTITYUNIT == T006.MSEHI`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYAPI01.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYAPI01.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYAPI01.DOCUMENTCURRENCY == TCURC.WAERS`
Movement type (inventory management) Movement type (inventory management) Client	`I_PURCHASEORDERHISTORYAPI01.GOODSMOVEMENTTYPE == T156.BWART` `I_PURCHASEORDERHISTORYAPI01.MANDT == T156.MANDT`
Valuation Type Client Valuation Type	`I_PURCHASEORDERHISTORYAPI01.MANDT == T149D.MANDT` `I_PURCHASEORDERHISTORYAPI01.INVENTORYVALUATIONTYPE == T149D.BWTAR`
Material number Material number Client	`I_PURCHASEORDERHISTORYAPI01.MANUFACTURERMATERIAL == MARA.MATNR` `I_PURCHASEORDERHISTORYAPI01.MANDT == MARA.MANDT`
Material Number Client Material Number	`I_PURCHASEORDERHISTORYAPI01.MANDT == MARA.MANDT` `I_PURCHASEORDERHISTORYAPI01.MATERIAL == MARA.MATNR`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`I_PURCHASEORDERHISTORYAPI01.ORDERPRICEUNIT == T006.MSEHI` `I_PURCHASEORDERHISTORYAPI01.MANDT == T006.MANDT`
Plant Plant Client	`I_PURCHASEORDERHISTORYAPI01.PLANT == T001W.WERKS` `I_PURCHASEORDERHISTORYAPI01.MANDT == T001W.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_PURCHASEORDERHISTORYAPI01.PURCHASEORDERQUANTITYUNIT == T006.MSEHI` `I_PURCHASEORDERHISTORYAPI01.MANDT == T006.MANDT`
Purchase Order History Category Purchase Order History Category Client	`I_PURCHASEORDERHISTORYAPI01.PURCHASINGHISTORYCATEGORY == T163B.BEWTP` `I_PURCHASEORDERHISTORYAPI01.MANDT == T163B.MANDT`
Compliance with Shipping Instructions Client Compliance with Shipping Instructions ?	`I_PURCHASEORDERHISTORYAPI01.MANDT == T027C.MANDT` `I_PURCHASEORDERHISTORYAPI01.SHIPGINSTRNSUPPLIERCOMPLIANCE == T027C.EVERE` `I_PURCHASEORDERHISTORYAPI01.[column in domain "EVERS"] == T027C.EVERS`