C_ImportSupplierInvoice

Import Supplier Invoice List | view: CAPISINVOICE | TRAN | Extraction: Not supported | Component: Fiori UI for Accounts Payable
Column Name Description
SupplierInvoiceUploadUUID UUID of Invoice Upload
Column Name Description
💲 Currency Key (DocumentCurrency):
InvoiceGrossAmount Gross Invoice Amount in Document Currency
ManualCashDiscount Cash Discount Amount in Document Currency
UnplannedDeliveryCost Unplanned Delivery Costs
Column Name Description
Column Name Description
CreationDate Day On Which Accounting Document Was Entered
DocumentDate Value Date
PostingDate Value Date
DueCalculationBaseDate Value Date
Column Name Description
SupplierInvoiceUploadStatus Import Supplier Invoice Status Show values
SupplierInvoiceOrigin Origin of a Logistics Invoice Verification Document Show values
SupplierInvoiceStatus Invoice document status Show values
FixedCashDiscount Fixed Payment Terms Show values
BusinessNetworkOrigin Origin of the Business Network Document Show values
IsDoubleInvoice Check Flag for Double Invoices or Credit Memos Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
RootDraftKey NodeID /BOBF/CONF_KEY
SupplierInvoice Document Number of an Invoice Document BELNR
FiscalYear Fiscal Year GJAHR
CreatedByUser User Name UNAME
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
DocumentHeaderText Document Header Text TEXT25
PaymentReference Payment Reference CHAR30
InvoiceReference Invoice reference: Document number for invoice reference AWREF
InvoiceReferenceFiscalYear Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
PaymentTerms Terms of payment key ZTERM
CashDiscount2Days Cash discount days 2 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
NetPaymentDays Net Payment Terms Period ZBDXT
UnplndDelivCostTaxJurisdiction Tax Jurisdiction TXJCD
AssignmentReference Assignment number ZUONR
SupplierPostingLineItemText Item Text TEXT50
PaytSlipWthRefSubscriber ISR subscriber number ESRNR
PaytSlipWthRefCheckDigit POR check digit CHAR2
PaytSlipWthRefReference ISR/QR Reference Number ESRRE
InvoiceStatusAndOrigin null
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • C_IMPORTSUPPLIERINVOICE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_IMPORTSUPPLIERINVOICE.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_IMPORTSUPPLIERINVOICE.COMPANYCODE == T001.BUKRS
  • C_IMPORTSUPPLIERINVOICE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_IMPORTSUPPLIERINVOICE.DOCUMENTCURRENCY == TCURC.WAERS
  • C_IMPORTSUPPLIERINVOICE.MANDT == TCURC.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_IMPORTSUPPLIERINVOICE.INVOICINGPARTY == LFA1.LIFNR
  • C_IMPORTSUPPLIERINVOICE.MANDT == LFA1.MANDT
Payment Block Key
  • Payment Block Key
  • Client
  • C_IMPORTSUPPLIERINVOICE.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_IMPORTSUPPLIERINVOICE.MANDT == T008.MANDT
Payment Method
  • ?
  • Payment Method
  • Client
  • C_IMPORTSUPPLIERINVOICE.[column in domain "LAND1"] == T042Z.LAND1
  • C_IMPORTSUPPLIERINVOICE.PAYMENTMETHOD == T042Z.ZLSCH
  • C_IMPORTSUPPLIERINVOICE.MANDT == T042Z.MANDT
Tax Code
  • Client
  • Tax Code
  • ?
  • C_IMPORTSUPPLIERINVOICE.MANDT == T007A.MANDT
  • C_IMPORTSUPPLIERINVOICE.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ
  • C_IMPORTSUPPLIERINVOICE.[column in domain "KALSM_D"] == T007A.KALSM