I_PurchasingDocumentHistoryBsc

History per Purchasing Document Item | view: IMMPURDOCHISB | TRAN | Extraction: Not supported | Component: Purchase Orders

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

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

Column Name	Description
PurchasingDocument FK	Purchasing Document Number
PurchasingDocumentItem 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 (PurchasingDocumentCurrency):
GRIRAcctClrgAmtInOrdTrnsacCrcy	Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy	Invoice Amount in PO Currency

Column Name	Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
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
InvtryMgmtReferenceDocument	Document No. of a Reference Document	BELNR
InvtryMgmtRefDocumentItem	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 Base Unit of Measure Client	`I_PURCHASINGDOCUMENTHISTORYBSC.BASEUNIT == T006.MSEHI` `I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T006.MANDT`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == TCURC.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.CURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == TCURC.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.CURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS`
Unit of Measure From Delivery Note Unit of Measure From Delivery Note Client	`I_PURCHASINGDOCUMENTHISTORYBSC.DELIVERYQUANTITYUNIT == T006.MSEHI` `I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T006.MANDT`
Movement type (inventory management) Client Movement type (inventory management)	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T156.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.GOODSMOVEMENTTYPE == T156.BWART`
Valuation Type Valuation Type Client	`I_PURCHASINGDOCUMENTHISTORYBSC.INVENTORYVALUATIONTYPE == T149D.BWTAR` `I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T149D.MANDT`
Material number Client Material number	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == MARA.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == MARA.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.MATERIAL == MARA.MATNR`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`I_PURCHASINGDOCUMENTHISTORYBSC.ORDERPRICEUNIT == T006.MSEHI` `I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`I_PURCHASINGDOCUMENTHISTORYBSC.ORDERQUANTITYUNIT == T006.MSEHI` `I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T006.MANDT`
Plant Client Plant	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T001W.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.PLANT == T001W.WERKS`
Currency Key Client Currency Key Currency Key Currency Key	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == TCURC.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.COMPANYCODECURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.CURRENCY == TCURC.WAERS` `I_PURCHASINGDOCUMENTHISTORYBSC.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS`
Purchase Order History Category Client Purchase Order History Category	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T163B.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.PURCHASINGHISTORYCATEGORY == T163B.BEWTP`
Compliance with Shipping Instructions Client Compliance with Shipping Instructions ?	`I_PURCHASINGDOCUMENTHISTORYBSC.MANDT == T027C.MANDT` `I_PURCHASINGDOCUMENTHISTORYBSC.SHIPGINSTRNSUPPLIERCOMPLIANCE == T027C.EVERE` `I_PURCHASINGDOCUMENTHISTORYBSC.[column in domain "EVERS"] == T027C.EVERS`