I_PurchaseOrderHistoryBasic

Purchase Order History | view: IMMPURORDHIST | 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 (10)
🔗 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
📏 Unit of Measure From Delivery Note (DeliveryQuantityUnit):
Quantity	Quantity
QtyInPurchaseOrderPriceUnit	Quantity in purchase order price unit
GdsRcptBlkdStkQtyInOrdQtyUnit	Goods Receipt Blocked Stock in Order Unit
GdsRcptBlkdStkQtyInOrdPrcUnit	Quantity in GR blocked stock in order price unit
QuantityInDeliveryQtyUnit	Quantity in Unit of Measure from Delivery Note
QuantityInBaseUnit	Quantity
VltdGdsRcptBlkdStkQtyInOrdUnit	Valuated Goods Receipt Blocked Stock in Order Unit
VltdGdsRcptBlkdQtyInOrdPrcUnit	Quantity in Valuated GR Blocked Stock in Order Price Unit

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
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
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 Client Base Unit of Measure	`I_PURCHASEORDERHISTORYBASIC.MANDT == T006.MANDT` `I_PURCHASEORDERHISTORYBASIC.BASEUNIT == T006.MSEHI`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYBASIC.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYBASIC.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.DOCUMENTCURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.COMPANYCODECURRENCY == TCURC.WAERS`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYBASIC.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYBASIC.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.DOCUMENTCURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.COMPANYCODECURRENCY == TCURC.WAERS`
Unit of Measure From Delivery Note Client Unit of Measure From Delivery Note	`I_PURCHASEORDERHISTORYBASIC.MANDT == T006.MANDT` `I_PURCHASEORDERHISTORYBASIC.DELIVERYQUANTITYUNIT == T006.MSEHI`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASEORDERHISTORYBASIC.MANDT == TCURC.MANDT` `I_PURCHASEORDERHISTORYBASIC.CURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.DOCUMENTCURRENCY == TCURC.WAERS` `I_PURCHASEORDERHISTORYBASIC.COMPANYCODECURRENCY == TCURC.WAERS`
Movement type (inventory management) Client Movement type (inventory management)	`I_PURCHASEORDERHISTORYBASIC.MANDT == T156.MANDT` `I_PURCHASEORDERHISTORYBASIC.GOODSMOVEMENTTYPE == T156.BWART`
Valuation Type Client Valuation Type	`I_PURCHASEORDERHISTORYBASIC.MANDT == T149D.MANDT` `I_PURCHASEORDERHISTORYBASIC.INVENTORYVALUATIONTYPE == T149D.BWTAR`
Material number Client Material number	`I_PURCHASEORDERHISTORYBASIC.MANDT == MARA.MANDT` `I_PURCHASEORDERHISTORYBASIC.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`I_PURCHASEORDERHISTORYBASIC.MANDT == MARA.MANDT` `I_PURCHASEORDERHISTORYBASIC.MATERIAL == MARA.MATNR`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`I_PURCHASEORDERHISTORYBASIC.MANDT == T006.MANDT` `I_PURCHASEORDERHISTORYBASIC.ORDERPRICEUNIT == T006.MSEHI`
Plant Client Plant	`I_PURCHASEORDERHISTORYBASIC.MANDT == T001W.MANDT` `I_PURCHASEORDERHISTORYBASIC.PLANT == T001W.WERKS`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`I_PURCHASEORDERHISTORYBASIC.MANDT == T006.MANDT` `I_PURCHASEORDERHISTORYBASIC.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order History Category Client Purchase Order History Category	`I_PURCHASEORDERHISTORYBASIC.MANDT == T163B.MANDT` `I_PURCHASEORDERHISTORYBASIC.PURCHASINGHISTORYCATEGORY == T163B.BEWTP`
Compliance with Shipping Instructions ? Client Compliance with Shipping Instructions	`I_PURCHASEORDERHISTORYBASIC.[column in domain "EVERS"] == T027C.EVERS` `I_PURCHASEORDERHISTORYBASIC.MANDT == T027C.MANDT` `I_PURCHASEORDERHISTORYBASIC.SHIPGINSTRNSUPPLIERCOMPLIANCE == T027C.EVERE`