I_SuplrBillgDoc

Supplier Billing Document | view: IWLFSUPLRBGD | ATTR | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRK
Column Name Description
SuplrBillgDoc Supplier Billing Document Number
Column Name Description
💲 Currency of Settlement Document (SuplrBillgDocCurrency):
SupplierTotalGrossAmount Gross Settlement Amount in Document Currency
SupplierTotalNetAmount Net Settlement Amount in Document Currency
SuplrTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
SupplierTotalTaxAmount Total Tax Amount in Document Currency
💲 Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit) (TrdgExpnCurrency):
TrdgExpnAmount Reference Value for Trading Expenses
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Date of Document Creation
CreationTime Time of Document Creation
LastChangeDate Date of Last Document Change
DocumentDate Document Date in Settlement Management Document
ExchangeRateDate Exchange Rate Date
SupplierFixedValueDate Fixed Value Date
SettlmtDate Rebates: Settlement Date
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtCat Settlement Category Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
SuplrBillgDocIsCanceled Settlement Document is Reversed Show values
SettlmtDocSmmrznCat Document Summarization Category Show values
SettlmtClassificationCat Settlement Classification Category Show values
TrdgExpnDocSettled Trading Expense Document Settled Indicator Show values
DocIntrastatRelevance Document is Relevant for Intrastat Declarations Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations Show values
SettlmtBusProcCat Use Case Type Show values
Column Name Description Domain name
SupplierPricingProcedure Pricing Procedure KALSM
CreatedByUser Name of User who Created the Document USNAM
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
ExchangeRate Conversion Rate (Not Converted)
SupplierPaymentTerms Terms of Payment Key ZTERM
SupplierCashDiscount1Days Cash Discount Days 1 ZBDXT
SupplierCashDiscount2Days Cash Discount Days 2 ZBDXT
SupplierNetPaymentDays Net Payment Terms Period ZBDXT
SupplierCashDiscount1Percent Cash Discount Percentage 1 PRZ23
SupplierCashDiscount2Percent Cash Discount Percentage 2 PRZ23
SupplierPricingDocument Number of the Document Condition KNUMV
SupplierAdditionalValueDays Additional Value Days TAGE2
PaymentReference Payment Reference CHAR30
SupplierPaytCurrencyExchRate Exchange Rate of Payment Currency (not converted)
SettlmtReltdTrdgContr Related Trading Contract in Settlement Management TKONN
SettlmtReltdCndnContr Related Condition Contract in Settlement Management WCB_COCO_NUM
TrdgExpnSettlmtDoc Settlement Document of planned Trading Expenses WBELN
FiscalPeriod Fiscal Period POPER
TrdgExpnSupplier Trading Expense Supplier LIFNR
SupplierVATRegistration VAT Registration Number STCEG
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SEPAMandate Unique Reference to Mandate for each Payee ID035
Master Data Relations Join Conditions
Alternative Supplier
  • Alternative Supplier
  • Client
  • I_SUPLRBILLGDOC.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • I_SUPLRBILLGDOC.MANDT == LFA1.MANDT
Condition Contract Type
  • Condition Contract Type
  • Client
Credit Control Area
  • Credit Control Area
  • Client
  • I_SUPLRBILLGDOC.CREDITCONTROLAREA == T014.KKBER
  • I_SUPLRBILLGDOC.MANDT == T014.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_SUPLRBILLGDOC.EXCHANGERATETYPE == TCURV.KURST
  • I_SUPLRBILLGDOC.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SUPLRBILLGDOC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SUPLRBILLGDOC.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SUPLRBILLGDOC.INCOTERMSVERSION == TINCV.INCOV
  • I_SUPLRBILLGDOC.MANDT == TINCV.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_SUPLRBILLGDOC.MANDT == LFA1.MANDT
  • I_SUPLRBILLGDOC.INVOICINGPARTY == LFA1.LIFNR
Address of One-Time Supplier
  • Posting Date
  • ?
  • Client
  • Address of One-Time Supplier
  • I_SUPLRBILLGDOC.POSTINGDATE == ADRC.DATE_FROM
  • I_SUPLRBILLGDOC.[column in domain "AD_NATION"] == ADRC.NATION
  • I_SUPLRBILLGDOC.MANDT == ADRC.CLIENT
  • I_SUPLRBILLGDOC.ONETIMESUPPLIERADDRESSID == ADRC.ADDRNUMBER
Payee
  • Payee
  • Client
  • I_SUPLRBILLGDOC.PAYEEPARTY == LFA1.LIFNR
  • I_SUPLRBILLGDOC.MANDT == LFA1.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPLRBILLGDOC.PURCHASINGGROUP == T024.EKGRP
  • I_SUPLRBILLGDOC.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SUPLRBILLGDOC.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPLRBILLGDOC.MANDT == T024E.MANDT
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • I_SUPLRBILLGDOC.MANDT == TMPA2.MANDT
  • I_SUPLRBILLGDOC.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • I_SUPLRBILLGDOC.MANDT == TMPA4.MANDT
  • I_SUPLRBILLGDOC.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Settlement Management Process Category
  • Client
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • I_SUPLRBILLGDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • I_SUPLRBILLGDOC.MANDT == TMLFG.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • I_SUPLRBILLGDOC.SETTLMTDOCTYPE == TMFK.LFART
  • I_SUPLRBILLGDOC.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • I_SUPLRBILLGDOC.MANDT == TMZR.MANDT
  • I_SUPLRBILLGDOC.SETTLMTPROCESSTYPE == TMZR.WRART
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • I_SUPLRBILLGDOC.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_SUPLRBILLGDOC.MANDT == T015L.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • I_SUPLRBILLGDOC.MANDT == TCURC.MANDT
  • I_SUPLRBILLGDOC.SUPLRBILLGDOCCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Client
  • Incompleteness Reason of Settlement Management Document
  • I_SUPLRBILLGDOC.MANDT == TWLF_IR.MANDT
  • I_SUPLRBILLGDOC.SUPLRBILLGDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
Tax Country/Region Company Code
  • Tax Country/Region Company Code
  • Client
  • I_SUPLRBILLGDOC.SUPLRSETTLMTCOCODETAXCOUNTRY == T005.LAND1
  • I_SUPLRBILLGDOC.MANDT == T005.MANDT
Company Code
  • Client
  • Company Code
  • I_SUPLRBILLGDOC.MANDT == T001.MANDT
  • I_SUPLRBILLGDOC.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS
Payment Currency
  • Client
  • Payment Currency
  • I_SUPLRBILLGDOC.MANDT == TCURC.MANDT
  • I_SUPLRBILLGDOC.SUPPLIERPAYMENTCURRENCY == TCURC.WAERS
Payment Method
  • Client
  • Payment Method
  • ?
  • I_SUPLRBILLGDOC.MANDT == T042Z.MANDT
  • I_SUPLRBILLGDOC.SUPPLIERPAYMENTMETHOD == T042Z.ZLSCH
  • I_SUPLRBILLGDOC.[column in domain "LAND1"] == T042Z.LAND1
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • I_SUPLRBILLGDOC.SUPPLYINGCOUNTRY == T005.LAND1
  • I_SUPLRBILLGDOC.MANDT == T005.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • I_SUPLRBILLGDOC.TAXDEPARTURECOUNTRY == T005.LAND1
  • I_SUPLRBILLGDOC.MANDT == T005.MANDT
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • I_SUPLRBILLGDOC.MANDT == T005.MANDT
  • I_SUPLRBILLGDOC.TAXDESTINATIONCOUNTRY == T005.LAND1
Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • Client
  • I_SUPLRBILLGDOC.TRDGEXPNCURRENCY == TCURC.WAERS
  • I_SUPLRBILLGDOC.MANDT == TCURC.MANDT