I_SupplierInvoiceAPI01

Supplier Invoice | view: ISUPLRINVCAPI01 | 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)
SuplrInvcAutomReducedAmount Automatic Invoice Reduction Amount (Net)
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
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
TaxIsCalculatedAutomatically Calculate Tax Automatically Show values
FixedCashDiscount Fixed Payment Terms Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU 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
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
ExchangeRate Exchange rate KURSF
CreatedByUser Name of the Processor Who Entered the Object USNAM
LastChangedByUser User Name XUBNAME
InvoiceReference Invoice reference: Document number for invoice reference AWREF
InvoiceReferenceFiscalYear Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
AssignmentReference Assignment number ZUONR
UnplndDelivCostTaxJurisdiction Tax Jurisdiction TXJCD
DocumentHeaderText Document Header Text TEXT25
SupplierPostingLineItemText Item Text TEXT50
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
BPBankAccountInternalID Partner bank type BVTYP
PaymentReference Payment Reference CHAR30
PaytSlipWthRefSubscriber ISR subscriber number ESRNR
PaytSlipWthRefCheckDigit POR check digit CHAR2
PaytSlipWthRefReference ISR/QR Reference Number ESRRE
ReverseDocument Reversal document number BELNR
ReverseDocumentFiscalYear Fiscal year of reversal document GJAHR
TaxCountry Tax Reporting Country/Region LAND1
UnplndDeliveryCostTaxCountry Tax Reporting Country/Region LAND1
DeliveryOfGoodsReportingCntry Reporting Country/Region for Delivery of Goods Within the EU LAND1
SupplierVATRegistration VAT Registration Number STCEG
ElectronicInvoiceUUID (obsolete) Mexico UUID
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
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • I_SUPPLIERINVOICEAPI01.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_SUPPLIERINVOICEAPI01.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • I_SUPPLIERINVOICEAPI01.COMPANYCODE == T001.BUKRS
  • I_SUPPLIERINVOICEAPI01.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SUPPLIERINVOICEAPI01.MANDT == TCURC.MANDT
  • I_SUPPLIERINVOICEAPI01.DOCUMENTCURRENCY == TCURC.WAERS
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_SUPPLIERINVOICEAPI01.INVOICINGPARTY == LFA1.LIFNR
  • I_SUPPLIERINVOICEAPI01.MANDT == LFA1.MANDT
Payment Method
  • ?
  • Payment Method
  • Client
  • I_SUPPLIERINVOICEAPI01.[column in domain "LAND1"] == T042Z.LAND1
  • I_SUPPLIERINVOICEAPI01.PAYMENTMETHOD == T042Z.ZLSCH
  • I_SUPPLIERINVOICEAPI01.MANDT == T042Z.MANDT
FK State central bank indicator
  • State Central Bank Indicator
  • Client
  • I_SUPPLIERINVOICEAPI01.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_SUPPLIERINVOICEAPI01.MANDT == T015L.MANDT
FK Supplying country
  • Supplying Country/Region
  • Client
  • I_SUPPLIERINVOICEAPI01.SUPPLYINGCOUNTRY == T005.LAND1
  • I_SUPPLIERINVOICEAPI01.MANDT == T005.MANDT
Tax Code
  • Tax Code
  • ?
  • Client
  • I_SUPPLIERINVOICEAPI01.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ
  • I_SUPPLIERINVOICEAPI01.[column in domain "KALSM_D"] == T007A.KALSM
  • I_SUPPLIERINVOICEAPI01.MANDT == T007A.MANDT