C_SupplierInvoiceItemDEX

Data Extraction for Supplier Invoice Item | view: CMMSUPINVCITMDEX | TRAN | Extraction: Full or Incremental | Component: Reporting
Tables used: RBKPRBKPBRBDRSEGRSEG
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (DocumentCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
SuplrInvcAutomReducedAmount Automatic Invoice Reduction Amount (Net)
UnplannedDeliveryCost Unplanned Delivery Costs
Column Name Description
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
QuantityInPurchaseOrderUnit Quantity
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
Column Name Description
SuplrInvcItmHasQualityVariance Blocking Reason: Quality Show values
SuplrInvcItemHasOrdPrcQtyVarc Blocking Reason: Order Price Quantity Show values
SuplrInvcItemHasQtyVariance Blocking Reason: Quantity Show values
SuplrInvcItemHasPriceVariance Blocking Reason: Price Show values
SuplrInvcItemHasOtherVariance Manual Blocking Reason Show values
SuplrInvcItemHasAmountOutsdTol Blocking Reason: Item Amount Show values
SuplrInvcItemHasDateVariance Blocking Reason: Date Show values
SupplierInvoiceOrigin Origin of a Logistics Invoice Verification Document Show values
IsInvoice Indicator: post invoice Show values
SupplierInvoiceStatus Invoice document status Show values
Column Name Description Domain name
PrmtHbReferenceDocument Document No. of a Reference Document BELNR
PrmtHbReferenceDocumentFsclYr Fiscal Year of Current Period GJAHR
PrmtHbReferenceDocumentItem Item of a Reference Document MBLPO
IsSubsequentDebitCredit Indicator: Subsequent Debit/Credit TBTKZ
DocumentHeaderText Document Header Text TEXT25
ReverseDocument Reversal document number BELNR
ReverseDocumentFiscalYear Fiscal year of reversal document GJAHR
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_SUPPLIERINVOICEITEMDEX.MANDT == T001.MANDT
  • C_SUPPLIERINVOICEITEMDEX.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_SUPPLIERINVOICEITEMDEX.MANDT == TCURC.MANDT
  • C_SUPPLIERINVOICEITEMDEX.DOCUMENTCURRENCY == TCURC.WAERS
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_SUPPLIERINVOICEITEMDEX.MANDT == LFA1.MANDT
  • C_SUPPLIERINVOICEITEMDEX.INVOICINGPARTY == LFA1.LIFNR
Plant
  • Client
  • Plant
  • C_SUPPLIERINVOICEITEMDEX.MANDT == T001W.MANDT
  • C_SUPPLIERINVOICEITEMDEX.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • C_SUPPLIERINVOICEITEMDEX.MANDT == MARA.MANDT
  • C_SUPPLIERINVOICEITEMDEX.PURCHASEORDERITEMMATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • C_SUPPLIERINVOICEITEMDEX.MANDT == T006.MANDT
  • C_SUPPLIERINVOICEITEMDEX.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_SUPPLIERINVOICEITEMDEX.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • C_SUPPLIERINVOICEITEMDEX.MANDT == T006.MANDT
Tax Code
  • Client
  • ?
  • Tax Code
  • C_SUPPLIERINVOICEITEMDEX.MANDT == T007A.MANDT
  • C_SUPPLIERINVOICEITEMDEX.[column in domain "KALSM_D"] == T007A.KALSM
  • C_SUPPLIERINVOICEITEMDEX.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ