A_SupplierInvoice

Header Data | view: ASUPPLIERINVOICE | TRAN | Extraction: Not supported | Component: General Functions
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
UnplannedDeliveryCost Unplanned Delivery Costs
ManualCashDiscount Cash Discount Amount in Document Currency
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
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
InvoiceReceiptDate Invoice Receipt Date
Column Name Description
SupplierInvoiceStatus Invoice document status Show values
FixedCashDiscount Fixed Payment Terms Show values
TaxIsCalculatedAutomatically Calculate Tax Automatically 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
IsEndOfPurposeBlocked Business Purpose Completed Show values
SupplierInvoiceOrigin Origin of a Logistics Invoice Verification Document Show values
IsReversal Is Reversal Show values
IsReversed Is Reversed Show values
Column Name Description Domain name
SupplierInvoiceIDByInvcgParty Reference Document Number XBLNR1
DocumentHeaderText Document Header Text TEXT25
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
IndirectQuotedExchangeRate Direct Quoted Exchange Rate PKURS
DirectQuotedExchangeRate Indirect Quoted Exchange Rate PKURS
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
UnplndDeliveryCostTaxCountry Tax Reporting Country/Region LAND1
AssignmentReference Assignment number ZUONR
SupplierPostingLineItemText Item Text TEXT50
BusinessArea Business Area GSBER
SupplierInvoiceIsCreditMemo Single-Character Flag CHAR1
PaytSlipWthRefSubscriber ISR subscriber number ESRNR
PaytSlipWthRefCheckDigit POR check digit CHAR2
PaytSlipWthRefReference ISR/QR Reference Number ESRRE
DeliveryOfGoodsReportingCntry Reporting Country/Region for Delivery of Goods Within the EU LAND1
SupplierVATRegistration VAT Registration Number STCEG
ReverseDocument Reversal document number BELNR
ReverseDocumentFiscalYear Fiscal year of reversal document GJAHR
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
  • A_SUPPLIERINVOICE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • A_SUPPLIERINVOICE.MANDT == T003.MANDT
Section Code
  • Company Code
  • Client
  • Section Code
  • A_SUPPLIERINVOICE.COMPANYCODE == SECCODE.BUKRS
  • A_SUPPLIERINVOICE.MANDT == SECCODE.MANDT
  • A_SUPPLIERINVOICE.BUSINESSSECTIONCODE == SECCODE.SECCODE
Company Code
  • Company Code
  • Client
  • A_SUPPLIERINVOICE.COMPANYCODE == T001.BUKRS
  • A_SUPPLIERINVOICE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • A_SUPPLIERINVOICE.DOCUMENTCURRENCY == TCURC.WAERS
  • A_SUPPLIERINVOICE.MANDT == TCURC.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • A_SUPPLIERINVOICE.MANDT == LFA1.MANDT
  • A_SUPPLIERINVOICE.INVOICINGPARTY == LFA1.LIFNR
Place of Supply
  • ?
  • Client
  • Place of Supply
  • A_SUPPLIERINVOICE.[column in domain "LAND1"] == T005S.LAND1
  • A_SUPPLIERINVOICE.MANDT == T005S.MANDT
  • A_SUPPLIERINVOICE.IN_GSTPLACEOFSUPPLY == T005S.BLAND
Payment Block Key
  • Client
  • Payment Block Key
  • A_SUPPLIERINVOICE.MANDT == T008.MANDT
  • A_SUPPLIERINVOICE.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Method
  • ?
  • Client
  • Payment Method
  • A_SUPPLIERINVOICE.[column in domain "LAND1"] == T042Z.LAND1
  • A_SUPPLIERINVOICE.MANDT == T042Z.MANDT
  • A_SUPPLIERINVOICE.PAYMENTMETHOD == T042Z.ZLSCH
FK State central bank indicator
  • Client
  • State Central Bank Indicator
  • A_SUPPLIERINVOICE.MANDT == T015L.MANDT
  • A_SUPPLIERINVOICE.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
FK Supplying country
  • Client
  • Supplying Country/Region
  • A_SUPPLIERINVOICE.MANDT == T005.MANDT
  • A_SUPPLIERINVOICE.SUPPLYINGCOUNTRY == T005.LAND1
Tax Code
  • ?
  • Client
  • Tax Code
  • A_SUPPLIERINVOICE.[column in domain "KALSM_D"] == T007A.KALSM
  • A_SUPPLIERINVOICE.MANDT == T007A.MANDT
  • A_SUPPLIERINVOICE.UNPLANNEDDELIVERYCOSTTAXCODE == T007A.MWSKZ