C_GRIRPurchaseOrderHistory

GR/IR Purchase Order History | view: CFIGRIRPURORDHIS | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: EKKO, EKBE, EKPO, EKBEH, EKBZ, EKBZH, T001, TKA02

🔑 Keys (9)
💰 Amounts (2)
∑ Quantities (3)
📅 Dates (2)
☰ Categorical (4)
Other (6)
🔗 Relations (17)

Column Name	Description
PurchasingDocument FK	Purchasing Document
PurchasingDocumentItem FK	Purchasing Document Item
AccountAssignmentNumber	Sequential Number of Account Assignment
ConditionStep	Condition Step Number
ConditionCount	Condition Counter
PurchasingHistoryDocumentType	Transaction Type	Show values
PurchasingHistoryDocumentYear	Document Year
PurchasingHistoryDocument	Document
PurchasingHistoryDocumentItem	Document Item

Column Name	Description
💲 Company Code Currency (CompanyCodeCurrency):
PurOrdAmountInCompanyCodeCrcy	Amount in Company Code Currency
💲 Transaction Currency (PurgDocTransactionCurrency):
PurchaseOrderAmount	Amount in Transaction Currency

Column Name	Description
📏 Order Quantity Unit (OrderQuantityUnit):
Quantity	Quantity
📏 Order Price Unit (Purchasing) (OrderPriceUnit):
QtyInPurchaseOrderPriceUnit	Purchase Order Quantity
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit	Quantity in Base Unit

Column Name	Description
PostingDate	Posting Date in the Document
DocumentDate	Document Date in Document

Column Name	Description
PurchasingHistoryDocumentType	Transaction Type	Show values
DebitCreditCode	Debit/Credit Indicator	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
PurchasingDocumentCategory	Purchasing Document Category	Show values

Column Name	Description	Domain name
SupplierInvoice	Document Number of an Accounting Document	BELNR
SupplierInvoiceItem	Document Item in Invoice Document	NUMC6
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
Base Unit of Measure Base Unit of Measure Client	`C_GRIRPURCHASEORDERHISTORY.BASEUNIT == T006.MSEHI` `C_GRIRPURCHASEORDERHISTORY.MANDT == T006.MANDT`
Company Code Company Code Client	`C_GRIRPURCHASEORDERHISTORY.COMPANYCODE == T001.BUKRS` `C_GRIRPURCHASEORDERHISTORY.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Transaction Currency Client	`C_GRIRPURCHASEORDERHISTORY.COMPANYCODECURRENCY == TCURC.WAERS` `C_GRIRPURCHASEORDERHISTORY.PURGDOCTRANSACTIONCURRENCY == TCURC.WAERS` `C_GRIRPURCHASEORDERHISTORY.MANDT == TCURC.MANDT`
Movement type (inventory management) Movement type (inventory management) Client	`C_GRIRPURCHASEORDERHISTORY.GOODSMOVEMENTTYPE == T156.BWART` `C_GRIRPURCHASEORDERHISTORY.MANDT == T156.MANDT`
Material Number Material Number Client	`C_GRIRPURCHASEORDERHISTORY.MATERIAL == MARA.MATNR` `C_GRIRPURCHASEORDERHISTORY.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_GRIRPURCHASEORDERHISTORY.MATERIALGROUP == T023.MATKL` `C_GRIRPURCHASEORDERHISTORY.MANDT == T023.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_GRIRPURCHASEORDERHISTORY.ORDERPRICEUNIT == T006.MSEHI` `C_GRIRPURCHASEORDERHISTORY.MANDT == T006.MANDT`
Order Quantity Unit Order Quantity Unit Client	`C_GRIRPURCHASEORDERHISTORY.ORDERQUANTITYUNIT == T006.MSEHI` `C_GRIRPURCHASEORDERHISTORY.MANDT == T006.MANDT`
Plant Client Plant	`C_GRIRPURCHASEORDERHISTORY.MANDT == T001W.MANDT` `C_GRIRPURCHASEORDERHISTORY.PLANT == T001W.WERKS`
Purchasing Document Type Purchasing Document Category Purchasing Document Type Client	`C_GRIRPURCHASEORDERHISTORY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `C_GRIRPURCHASEORDERHISTORY.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_GRIRPURCHASEORDERHISTORY.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_GRIRPURCHASEORDERHISTORY.PURCHASINGGROUP == T024.EKGRP` `C_GRIRPURCHASEORDERHISTORY.MANDT == T024.MANDT`
Purchase Order History Category Purchase Order History Category Client	`C_GRIRPURCHASEORDERHISTORY.PURCHASINGHISTORYCATEGORY == T163B.BEWTP` `C_GRIRPURCHASEORDERHISTORY.MANDT == T163B.MANDT`
Purchasing Organization Purchasing Organization Client	`C_GRIRPURCHASEORDERHISTORY.PURCHASINGORGANIZATION == T024E.EKORG` `C_GRIRPURCHASEORDERHISTORY.MANDT == T024E.MANDT`
Transaction Currency Company Code Currency Transaction Currency Client	`C_GRIRPURCHASEORDERHISTORY.COMPANYCODECURRENCY == TCURC.WAERS` `C_GRIRPURCHASEORDERHISTORY.PURGDOCTRANSACTIONCURRENCY == TCURC.WAERS` `C_GRIRPURCHASEORDERHISTORY.MANDT == TCURC.MANDT`
Supplier Supplier Client	`C_GRIRPURCHASEORDERHISTORY.SUPPLIER == LFA1.LIFNR` `C_GRIRPURCHASEORDERHISTORY.MANDT == LFA1.MANDT`