C_GRIRMaterialDocumentItem

GR/IR Material Document Item | view: CFIGRIRMATDOCITM | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: MATDOCEKKOEKPOT001TKA02
Column Name Description
MaterialDocument Number of Material Document
MaterialDocumentItem Material Document Item
MaterialDocumentYear Material Document Year
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Local Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
InventoryTransactionType Transaction/Event Type VGART
AccountingDocumentType Document Type BLART
MaterialDocumentHeaderText Document Header Text TEXT25
CreatedByUser User Name XUBNAME
ReferenceDocument Reference Document Number XBLNR1
GoodsMovementType Movement type (inventory management) BWART
Plant Plant WERKS
StorageLocation Storage location LGORT
Supplier Vendor's account number LIFNR
Material Material Number MATNR
PurchasingDocument Purchasing Document EBELN
PurchasingDocumentItem Purchasing Document Item EBELP
PurchaseOrderItemText Short Text TEXT40
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_GRIRMATERIALDOCUMENTITEM.MANDT == TCURC.MANDT
  • C_GRIRMATERIALDOCUMENTITEM.COMPANYCODECURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_GRIRMATERIALDOCUMENTITEM.MANDT == T006.MANDT
  • C_GRIRMATERIALDOCUMENTITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • C_GRIRMATERIALDOCUMENTITEM.PURCHASINGGROUP == T024.EKGRP
  • C_GRIRMATERIALDOCUMENTITEM.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_GRIRMATERIALDOCUMENTITEM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_GRIRMATERIALDOCUMENTITEM.MANDT == T024E.MANDT