C_SupplierInvoiceDEX

Data Extraction for Supplier Invoice | view: CMMSUPINVC | TRAN | Extraction: Full or Incremental | Component: Reporting
Tables used: RBKPRBKPB
Column Name Description
SupplierInvoice Document Number of an Invoice Document
FiscalYear Fiscal Year
Column Name Description
💲 Currency Key (DocumentCurrency):
InvoiceGrossAmount Gross Invoice Amount in Document Currency
SuplrInvcAutomReducedAmount Automatic Invoice Reduction Amount (Net)
UnplannedDeliveryCost Unplanned Delivery Costs
SuplrInvcManuallyReducedAmount Supplier Error (Exclusive of Tax)
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
Column Name Description
IsInvoice Indicator: post invoice Show values
SupplierInvoiceOrigin Origin of a Logistics Invoice Verification Document Show values
SupplierInvoiceStatus Invoice document status Show values
Column Name Description Domain name
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
DocumentHeaderText Document Header Text TEXT25
ReverseDocument Reversal document number BELNR
ReverseDocumentFiscalYear Fiscal year of reversal document GJAHR
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SUPPLIERINVOICEDEX.COMPANYCODE == T001.BUKRS
  • C_SUPPLIERINVOICEDEX.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SUPPLIERINVOICEDEX.MANDT == TCURC.MANDT
  • C_SUPPLIERINVOICEDEX.DOCUMENTCURRENCY == TCURC.WAERS
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_SUPPLIERINVOICEDEX.INVOICINGPARTY == LFA1.LIFNR
  • C_SUPPLIERINVOICEDEX.MANDT == LFA1.MANDT
Tax Code
  • ?
  • Client
  • Tax Code
  • C_SUPPLIERINVOICEDEX.[column in domain "KALSM_D"] == T007A.KALSM
  • C_SUPPLIERINVOICEDEX.MANDT == T007A.MANDT
  • C_SUPPLIERINVOICEDEX.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ