C_GRIRSupplierInvoiceItem

GR/IR Supplier Invoice Item | view: CFIGRIRSUPINITM | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: EKKO, EKPO, RBKP, RBKPB, RBDRSEG, RSEG
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (TransactionCurrency):
FreightCost Unplanned Delivery Costs
ManualCashDiscount Cash Discount Amount in Document Currency
AmountInTransactionCurrency Amount in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
QuantityInPurchaseOrderUnit Quantity
OrderQuantity Purchase Order Quantity
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Invoice Date in Document
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
CreatedByUser Name of the Processor Who Entered the Object USNAM
DocumentReferenceID Reference Document Number XBLNR1
ExchangeRate Exchange rate KURSF
DocumentHeaderText Document Header Text TEXT25
ReferenceDocumentItem Item of a Reference Document MBLPO
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • C_GRIRSUPPLIERINVOICEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T001.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.COMPANYCODE == T001.BUKRS
Payment Block Key
  • Client
  • Payment Block Key
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T008.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Plant
  • Client
  • Plant
  • Plant
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T001W.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PLANT == T001W.WERKS
  • C_GRIRSUPPLIERINVOICEITEM.PRODUCTIONPLANT == T001W.WERKS
Plant
  • Client
  • Plant
  • Plant
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T001W.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PLANT == T001W.WERKS
  • C_GRIRSUPPLIERINVOICEITEM.PRODUCTIONPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == MARA.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PURCHASEORDERITEMMATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T006.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • C_GRIRSUPPLIERINVOICEITEM.PURCHASINGGROUP == T024.EKGRP
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T024.MANDT
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T024E.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.PURCHASINGORGANIZATION == T024E.EKORG
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == LFA1.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.SUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == T007A.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.TAXCODE == T007A.MWSKZ
  • C_GRIRSUPPLIERINVOICEITEM.[column in domain "KALSM_D"] == T007A.KALSM
Currency Key
  • Client
  • Currency Key
  • C_GRIRSUPPLIERINVOICEITEM.MANDT == TCURC.MANDT
  • C_GRIRSUPPLIERINVOICEITEM.TRANSACTIONCURRENCY == TCURC.WAERS