I_SupplierInvoice

Supplier Invoice | view: ISUPPLIERINVOICE | TRAN | Extraction: Not supported | Component: Logistics Invoice Verification
Tables used: RBKP, RBKPB
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
UnplannedDeliveryCost Unplanned Delivery Costs
ManualCashDiscount Cash Discount Amount in Document Currency
SuplrInvcManuallyReducedAmount Supplier Error (Exclusive of Tax)
SuplrInvcManualReductionTaxAmt Tax in Supplier Error
SuplrInvcAutomReducedAmount Automatic Invoice Reduction Amount (Net)
SuplrInvcAutomReductionTaxAmt Sales Tax Portion of Automatic Invoice Reduction Amount
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
InvoiceReceiptDate Invoice Receipt Date
CreationDate Day On Which Accounting Document Was Entered
DueCalculationBaseDate Baseline Date for Due Date Calculation
TaxDeterminationDate Date for Determining Tax Rates
TaxReportingDate Tax Reporting Date
TaxFulfillmentDate Tax Fulfillment Date
JrnlEntryCntrySpecificDate1 Country/Region Specific Date 1 in the Document
JrnlEntryCntrySpecificDate2 Country/Region Specific Date 2 in the Document
JrnlEntryCntrySpecificDate3 Country/Region Specific Date 3 in the Document
JrnlEntryCntrySpecificDate4 Country/Region Specific Date 4 in the Document
JrnlEntryCntrySpecificDate5 Country/Region Specific Date 5 in the Document
Column Name Description
IsInvoice Indicator: post invoice Show values
SupplierInvoiceStatus Invoice document status Show values
SupplierInvoiceOrigin Origin of a Logistics Invoice Verification Document Show values
BusinessNetworkOrigin Origin of the Business Network Document Show values
SuplrInvcTransactionCategory Transaction Type in AG08 (Internal Document Type) Show values
FixedCashDiscount Fixed Payment Terms Show values
TaxIsCalculatedAutomatically Calculate Tax Automatically Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
SuplrInvcPrepaymentStatus Prepayment Status Show values
SuplrInvcDebitCrdtCodeDelivery Posting logic for delivery items (invoice/credit memo) Show values
SuplrInvcDebitCrdtCodeReturns Posting logic for returns items (invoice/credit memo) Show values
Column Name Description Domain name
SupplierInvoiceUUID GUID: MM Supplier Invoice in S-Innovations MRM_SI_GUID
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
DocumentHeaderText Document Header Text TEXT25
CreatedByUser Name of the Processor Who Entered the Object USNAM
LastChangedByUser User Name XUBNAME
SuplrInvcExtCreatedByUser Entered by external system user SBNAM
PaymentTerms Terms of payment key ZTERM
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
ReverseDocument Reversal document number BELNR
ReverseDocumentFiscalYear Fiscal year of reversal document GJAHR
BPBankAccountInternalID Partner bank type BVTYP
ExchangeRate Exchange rate KURSF
PaymentMethodSupplement Payment method supplement UZAWE
PaymentReference Payment Reference CHAR30
InvoiceReference Invoice reference: Document number for invoice reference AWREF
InvoiceReferenceFiscalYear Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
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
BusinessArea Business Area GSBER
ElectronicInvoiceUUID (obsolete) Mexico UUID
DeliveryOfGoodsReportingCntry Reporting Country/Region for Delivery of Goods Within the EU LAND1
SupplierVATRegistration VAT Registration Number STCEG
TaxCountry Tax Reporting Country/Region LAND1
UnplndDeliveryCostTaxCountry Tax Reporting Country/Region LAND1
JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
JrnlEntryCntrySpecificRef3 Country/Region Specific Reference 3 in the Document FAC_GLO_REF3_HD
JrnlEntryCntrySpecificRef4 Country/Region Specific Reference 4 in the Document FAC_GLO_REF4_HD
JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5 in the Document FAC_GLO_REF5_HD
JrnlEntryCntrySpecificBP1 Country/Region specific Business Partner 1 in the Document BU_PARTNER
JrnlEntryCntrySpecificBP2 Country/Region Specific Business Partner 2 in the Document BU_PARTNER
IN_GSTPartner GST Partner J_1IG_PARTNER
IN_InvoiceReferenceNumber Invoice Reference Number J_1IG_IRN
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • I_SUPPLIERINVOICE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_SUPPLIERINVOICE.MANDT == T003.MANDT
Section Code
  • Section Code
  • Client
  • Company Code
  • I_SUPPLIERINVOICE.BUSINESSSECTIONCODE == SECCODE.SECCODE
  • I_SUPPLIERINVOICE.MANDT == SECCODE.MANDT
  • I_SUPPLIERINVOICE.COMPANYCODE == SECCODE.BUKRS
Company Code
  • Client
  • Company Code
  • I_SUPPLIERINVOICE.MANDT == T001.MANDT
  • I_SUPPLIERINVOICE.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_SUPPLIERINVOICE.MANDT == TCURC.MANDT
  • I_SUPPLIERINVOICE.DOCUMENTCURRENCY == TCURC.WAERS
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_SUPPLIERINVOICE.INVOICINGPARTY == LFA1.LIFNR
  • I_SUPPLIERINVOICE.MANDT == LFA1.MANDT
Place of Supply
  • Client
  • Place of Supply
  • ?
  • I_SUPPLIERINVOICE.MANDT == T005S.MANDT
  • I_SUPPLIERINVOICE.IN_GSTPLACEOFSUPPLY == T005S.BLAND
  • I_SUPPLIERINVOICE.[column in domain "LAND1"] == T005S.LAND1
Payment Block Key
  • Client
  • Payment Block Key
  • I_SUPPLIERINVOICE.MANDT == T008.MANDT
  • I_SUPPLIERINVOICE.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Method
  • Payment Method
  • ?
  • Client
  • I_SUPPLIERINVOICE.PAYMENTMETHOD == T042Z.ZLSCH
  • I_SUPPLIERINVOICE.[column in domain "LAND1"] == T042Z.LAND1
  • I_SUPPLIERINVOICE.MANDT == T042Z.MANDT
FK State central bank indicator
  • State Central Bank Indicator
  • Client
  • I_SUPPLIERINVOICE.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_SUPPLIERINVOICE.MANDT == T015L.MANDT
FK Supplying country
  • Supplying Country/Region
  • Client
  • I_SUPPLIERINVOICE.SUPPLYINGCOUNTRY == T005.LAND1
  • I_SUPPLIERINVOICE.MANDT == T005.MANDT
Tax Code
  • Tax Code
  • ?
  • Client
  • I_SUPPLIERINVOICE.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ
  • I_SUPPLIERINVOICE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_SUPPLIERINVOICE.MANDT == T007A.MANDT