N_PurchaseOrderHistoryBasic

Auxiliary View for Purchase Order History | view: NMMPURORDHIST | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKBE, EKKO, EKPO, 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	KURSP
DeliveryDocument	Delivery	VBELN
DeliveryDocumentItem	Delivery Item	POSNR

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