I_PurgDocRemovedHistory

Removed Purchasing Document Item History | view: IMMPURDOCRH | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKPOEKBEHT001TKA02
Column Name Description
PurchasingDocument Purchasing Document Number
PurchasingDocumentItem 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_PURGDOCREMOVEDHISTORY.BASEUNIT == T006.MSEHI
  • I_PURGDOCREMOVEDHISTORY.MANDT == T006.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • I_PURGDOCREMOVEDHISTORY.MANDT == TCURC.MANDT
  • I_PURGDOCREMOVEDHISTORY.CURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • I_PURGDOCREMOVEDHISTORY.MANDT == TCURC.MANDT
  • I_PURGDOCREMOVEDHISTORY.CURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.COMPANYCODECURRENCY == TCURC.WAERS
Unit of Measure From Delivery Note
  • Unit of Measure From Delivery Note
  • Client
  • I_PURGDOCREMOVEDHISTORY.DELIVERYQUANTITYUNIT == T006.MSEHI
  • I_PURGDOCREMOVEDHISTORY.MANDT == T006.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_PURGDOCREMOVEDHISTORY.GOODSMOVEMENTTYPE == T156.BWART
  • I_PURGDOCREMOVEDHISTORY.MANDT == T156.MANDT
Valuation Type
  • Client
  • Valuation Type
  • I_PURGDOCREMOVEDHISTORY.MANDT == T149D.MANDT
  • I_PURGDOCREMOVEDHISTORY.INVENTORYVALUATIONTYPE == T149D.BWTAR
Material number
  • Client
  • Material number
  • I_PURGDOCREMOVEDHISTORY.MANDT == MARA.MANDT
  • I_PURGDOCREMOVEDHISTORY.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Material Number
  • Client
  • I_PURGDOCREMOVEDHISTORY.MATERIAL == MARA.MATNR
  • I_PURGDOCREMOVEDHISTORY.MANDT == MARA.MANDT
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_PURGDOCREMOVEDHISTORY.MANDT == T006.MANDT
  • I_PURGDOCREMOVEDHISTORY.ORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_PURGDOCREMOVEDHISTORY.MANDT == T006.MANDT
  • I_PURGDOCREMOVEDHISTORY.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_PURGDOCREMOVEDHISTORY.MANDT == T001W.MANDT
  • I_PURGDOCREMOVEDHISTORY.PLANT == T001W.WERKS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • I_PURGDOCREMOVEDHISTORY.MANDT == TCURC.MANDT
  • I_PURGDOCREMOVEDHISTORY.CURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.PURCHASINGDOCUMENTCURRENCY == TCURC.WAERS
  • I_PURGDOCREMOVEDHISTORY.COMPANYCODECURRENCY == TCURC.WAERS
Purchase Order History Category
  • Client
  • Purchase Order History Category
  • I_PURGDOCREMOVEDHISTORY.MANDT == T163B.MANDT
  • I_PURGDOCREMOVEDHISTORY.PURCHASINGHISTORYCATEGORY == T163B.BEWTP
Compliance with Shipping Instructions
  • Compliance with Shipping Instructions
  • ?
  • Client
  • I_PURGDOCREMOVEDHISTORY.SHIPGINSTRNSUPPLIERCOMPLIANCE == T027C.EVERE
  • I_PURGDOCREMOVEDHISTORY.[column in domain "EVERS"] == T027C.EVERS
  • I_PURGDOCREMOVEDHISTORY.MANDT == T027C.MANDT