P_GRIRPurchaseOrderHistory1

GR/IR Purchase Order History | view: PFIGRIRPOHIS1 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: EKKOEKBEEKPOEKBEHEKBZEKBZHT001TKA02
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
GRIRAcctClrgAmtInCoCodeCrcy GR/IR account clearing value 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
GRIRAcctClrgAmtInOrdTrnsacCrcy Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy Invoice Amount in PO Currency
InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
Column Name Description
Quantity Quantity
QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit
GdsRcptBlkdStkQtyInOrdPrcUnit Quantity in GR blocked stock in order price unit
GdsRcptBlkdStkQtyInOrdQtyUnit Goods Receipt Blocked Stock in Order Unit
QuantityInBaseUnit Quantity
VltdGdsRcptBlkdQtyInOrdPrcUnit Quantity in Valuated GR Blocked Stock in Order Price Unit
VltdGdsRcptBlkdStkQtyInOrdUnit Valuated Goods Receipt Blocked Stock in Order Unit
📏 Unit of Measure From Delivery Note (DeliveryQuantityUnit):
QuantityInDeliveryQtyUnit Quantity in Unit of Measure from Delivery Note
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
Column Name Description Domain name
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
ConditionStep Step Number STUNR
ConditionCount Condition Counter ZAEHK
PurchasingHistoryDocumentYear Material Document Year GJAHR
PurchasingHistoryDocument Number of Material Document BELNR
PurchasingHistoryDocumentItem Item in Material Document MBLPO
ConditionType Condition Type KSCHL
ReferenceDocument Document No. of a Reference Document BELNR
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
ReferenceDocumentItem Item of a Reference Document MBLPO
DocumentReferenceID Reference Document Number XBLNR1
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == TCURC.MANDT
  • P_GRIRPURCHASEORDERHISTORY1.COMPANYCODECURRENCY == TCURC.WAERS
  • P_GRIRPURCHASEORDERHISTORY1.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == TCURC.MANDT
  • P_GRIRPURCHASEORDERHISTORY1.COMPANYCODECURRENCY == TCURC.WAERS
  • P_GRIRPURCHASEORDERHISTORY1.CURRENCY == TCURC.WAERS
Unit of Measure From Delivery Note
  • Unit of Measure From Delivery Note
  • Client
  • P_GRIRPURCHASEORDERHISTORY1.DELIVERYQUANTITYUNIT == T006.MSEHI
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == T006.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • P_GRIRPURCHASEORDERHISTORY1.GOODSMOVEMENTTYPE == T156.BWART
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == T156.MANDT
Valuation Type
  • Client
  • Valuation Type
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == T149D.MANDT
  • P_GRIRPURCHASEORDERHISTORY1.INVENTORYVALUATIONTYPE == T149D.BWTAR
Material Number
  • Client
  • Material Number
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == MARA.MANDT
  • P_GRIRPURCHASEORDERHISTORY1.MATERIAL == MARA.MATNR
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • P_GRIRPURCHASEORDERHISTORY1.PURCHASINGHISTORYCATEGORY == T163B.BEWTP
  • P_GRIRPURCHASEORDERHISTORY1.MANDT == T163B.MANDT