I_InvoiceList

Invoice List | view: ISDINVOICELIST | ATTR | Extraction: Not supported | Component: Billing
Tables used: VBRK
Column Name Description
InvoiceList Invoice List
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value in Document Currency
TotalTaxAmount Tax Amount in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
BillingDocumentIsCancelled Billing document is canceled Show values
ManualInvoiceMaintIsRelevant Manual Invoice Maintenance Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
AccountingExchangeRateIsSet Exchange Rate Setting Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingStatus SD Billing Status Show values
AccountingPostingStatus Posting Status of Billing Document Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
BillingIssueType Billing Issue Type Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LogicalSystem Logical system LOGSYS
BillingDocCombinationCriteria Combination criteria in the billing document CHAR40
NmbrOfPages Number of pages of invoice J_1ANOPG
TaxDepartureCountry Tax Departure Country/Region LAND1
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CustomerTaxClassification1 Tax Classification 1 for Customer TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ContractAccount Contract Account Number CORR_VKONT_KK
CustomerPaymentTerms Terms of payment key ZTERM
PaymentReference Payment Reference CHAR30
AdditionalValueDays Additional Value Days TAGE2
SEPAMandate Unique Reference to Mandate for each Payee ID035
FiscalYear Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
FiscalPeriod Posting period POPER
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment Number ZUONR
InternalFinancialDocument Financial doc. processing: Internal financial doc. number LCNUM
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • I_INVOICELIST.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_INVOICELIST.MANDT == TVFK.MANDT
City Code
  • Region (State, Province, County)
  • City Code
  • Destination Country/Region
  • Client
  • I_INVOICELIST.REGION == T005G.REGIO
  • I_INVOICELIST.CITYCODE == T005G.CITYC
  • I_INVOICELIST.COUNTRY == T005G.LAND1
  • I_INVOICELIST.MANDT == T005G.MANDT
Company Code
  • Company Code
  • Client
  • I_INVOICELIST.COMPANYCODE == T001.BUKRS
  • I_INVOICELIST.MANDT == T001.MANDT
Destination Country/Region
  • Destination Country/Region
  • Client
  • I_INVOICELIST.COUNTRY == T005.LAND1
  • I_INVOICELIST.MANDT == T005.MANDT
County Code
  • Region (State, Province, County)
  • Destination Country/Region
  • County Code
  • Client
  • I_INVOICELIST.REGION == T005E.REGIO
  • I_INVOICELIST.COUNTRY == T005E.LAND1
  • I_INVOICELIST.COUNTY == T005E.COUNC
  • I_INVOICELIST.MANDT == T005E.MANDT
Credit control area
  • Credit control area
  • Client
  • I_INVOICELIST.CREDITCONTROLAREA == T014.KKBER
  • I_INVOICELIST.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_INVOICELIST.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_INVOICELIST.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_INVOICELIST.CUSTOMERGROUP == T151.KDGRP
  • I_INVOICELIST.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • I_INVOICELIST.CUSTOMERPRICEGROUP == T188.KONDA
  • I_INVOICELIST.MANDT == T188.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_INVOICELIST.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_INVOICELIST.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_INVOICELIST.DIVISION == TSPA.SPART
  • I_INVOICELIST.MANDT == TSPA.MANDT
Dunning Area
  • Company Code
  • Dunning Area
  • Client
  • I_INVOICELIST.COMPANYCODE == T047M.BUKRS
  • I_INVOICELIST.DUNNINGAREA == T047M.MABER
  • I_INVOICELIST.MANDT == T047M.MANDT
Dunning Block
  • Dunning Block
  • Client
  • I_INVOICELIST.DUNNINGBLOCKINGREASON == T040S.MANSP
  • I_INVOICELIST.MANDT == T040S.MANDT
Dunning Key
  • Dunning Key
  • Client
  • I_INVOICELIST.DUNNINGKEY == T040.MSCHL
  • I_INVOICELIST.MANDT == T040.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_INVOICELIST.EXCHANGERATETYPE == TCURV.KURST
  • I_INVOICELIST.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_INVOICELIST.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_INVOICELIST.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_INVOICELIST.INCOTERMSVERSION == TINCV.INCOV
  • I_INVOICELIST.MANDT == TINCV.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_INVOICELIST.MANDT == T880.MANDT
  • I_INVOICELIST.PARTNERCOMPANY == T880.RCOMP
Payer
  • Payer
  • Client
  • I_INVOICELIST.PAYERPARTY == KNA1.KUNNR
  • I_INVOICELIST.MANDT == KNA1.MANDT
Payment Method
  • Destination Country/Region
  • Payment Method
  • Client
  • I_INVOICELIST.COUNTRY == T042Z.LAND1
  • I_INVOICELIST.PAYMENTMETHOD == T042Z.ZLSCH
  • I_INVOICELIST.MANDT == T042Z.MANDT
Price List Type
  • Client
  • Price List Type
  • I_INVOICELIST.MANDT == T189.MANDT
  • I_INVOICELIST.PRICELISTTYPE == T189.PLTYP
Region (State, Province, County)
  • Region (State, Province, County)
  • Destination Country/Region
  • Client
  • I_INVOICELIST.REGION == T005S.BLAND
  • I_INVOICELIST.COUNTRY == T005S.LAND1
  • I_INVOICELIST.MANDT == T005S.MANDT
Sales District
  • Sales District
  • Client
  • I_INVOICELIST.SALESDISTRICT == T171.BZIRK
  • I_INVOICELIST.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_INVOICELIST.SALESORGANIZATION == TVKO.VKORG
  • I_INVOICELIST.MANDT == TVKO.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • ?
  • Client
  • I_INVOICELIST.SDPRICINGPROCEDURE == T683.KALSM
  • I_INVOICELIST.[column in domain "KAPPL"] == T683.KAPPL
  • I_INVOICELIST.[column in domain "KVEWE"] == T683.KVEWE
  • I_INVOICELIST.MANDT == T683.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_INVOICELIST.SHIPPINGCONDITION == TVSB.VSBED
  • I_INVOICELIST.MANDT == TVSB.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_INVOICELIST.SOLDTOPARTY == KNA1.KUNNR
  • I_INVOICELIST.MANDT == KNA1.MANDT
Statistics Currency
  • Client
  • Statistics Currency
  • I_INVOICELIST.MANDT == TCURC.MANDT
  • I_INVOICELIST.STATISTICSCURRENCY == TCURC.WAERS
SD Document Currency
  • SD Document Currency
  • Client
  • I_INVOICELIST.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_INVOICELIST.MANDT == TCURC.MANDT