R_SettlmtDocDEX

Settlement Document Basic Extraction | view: RWLFSDOCDEX | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP, TMFK
Column Name Description
SettlmtDoc Settlement Document Number
SettlmtDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
SupplierTotalGrossAmount Total Gross Amount for Supplier in Document Currency
SupplierTotalNetAmount Total Net Amount for Supplier in Document Currency
CustomerTotalGrossAmount Total Gross Amount for Customer in Document Currency
CustomerTotalNetAmount Total Net Amount for Customer in Document Currency
SuplrTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Supplier
CustTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Customer
SupplierTotalTaxAmount Total Tax Amount for Supplier in Document Currency
CustomerTotalTaxAmount Total Tax Amount for Customer in Document Currency
NetPriceAmount Net Price in Document Currency
SupplierItemGrossAmount Item Gross Amount for Supplier in Document Currency
SupplierItemNetAmount Item Net Amount for Supplier in Document Currency
SupplierSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Supplier
SupplierRebateBasisAmount Rebate Basis of Supplier
SupplierEffectiveItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc Amount eligible for cash discount in document currency
SupplierItemTaxAmount Item Tax Amount of Supplier in Document Currency
CustomerItemGrossAmount Item Gross Amount for Customer in Document Currency
CustomerItemNetAmount Item Net Amount for Customer in Document Currency
CustomerSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Customer
CustomerSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Customer
CustomerSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Customer
CustomerSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Customer
CustomerSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Customer
CustomerSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Customer
CustomerRebateBasisAmount Rebate Basis of Customer
CustomerEffectiveItemAmount Customer Effective Item Amount in Document Currency
CustItmEligibleAmtForCshDisc Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)
CustomerItemTaxAmount Item Tax Amount of Customer in Document Currency
NonDeductibleInputTaxAmount Non-deductible input tax
💲 Currency of Credit Control Area (CreditControlAreaCurrency):
ReleasedCreditAmount Released credit value of the document
💲 Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit) (TrdgExpnCurrency):
TrdgExpnAmount Reference Value for Trading Expenses
Column Name Description
📏 Unit of Measure for Total Quantity (TotalSettlmtQuantityUnit):
TotalSettlmtQuantity Total Quantity of the Business Volume in a Settlement Run
📏 Unit of Weight for Total Weight (TotalSettlmtWeightUnit):
TotalSettlmtNetWeight Total Net Weight of the Business Volume in a Settlement Run
TotalSettlmtGrossWeight Total Gross Weight of the Bus Volume in a Settlement Run
📏 Volume Unit for Total Volume (TotalSettlmtVolumeUnit):
TotalSettlmtVolume Total Volume of the Business Volume in a Settlement Run
📏 Points Unit for Total Points (TotalSettlmtPointsQtyUnit):
TotalSettlmtPointsQty Total Points of the Business Volume in a Settlement Run
📏 Unit of Measure of Settlement Management Doc Item Quantity (SettlmtQuantityUnit):
SettlmtQuantity Quantity of Settlement Management Document Item
📏 Weight Unit (ItemWeightUnit):
ItemNetWeight Net Weight
ItemGrossWeight Gross Weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
📏 Points Unit (ProductPurchasePointsQtyUnit):
ProductPurchasePointsQty Number of Points
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 for Supplier
CustomerFixedValueDate Fixed Value Date for Customer
ActualSettlmtDate Actual Settlement Date
SettlmtDate Rebates: Settlement Date
SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate End Date of Settlement Period
PricingDate Date for Pricing and Exchange Rate
ServicesRenderedDate Date of Services Rendered
Column Name Description
SettlmtDocCat Settlement Document Category Show values
SettlmtProcessCat Settlement Process 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
SettlmtDocIsCanceled Settlement Document is Reversed Show values
SettlmtReltdRefDocCat Contract Category of Related Contract Show values
SettlmtDocSmmrznCat Document Summarization Category Show values
SettlmtClassificationCat Settlement Classification Category Show values
SettlmtPartnerCat Settlement Partner Category Show values
SupplierSettlmtStatus Settlement Status - Supplier Show values
CustomerSettlmtStatus Settlement Status - Customer Show values
SupplierSettlmtDocCat Settlement Document Type - Supplier Show values
CustomerSettlmtDocCat Settlement Document Type - Customer Show values
TrdgExpnDocSettled Trading Expense Document Settled Indicator Show values
SettlmtDateCat Rebates: Settlement Date Type Show values
CombinedSettlmtPostgSts Posting Status for Combined Settlement Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations Show values
SettlmtDocCollSts Collective Settlement Status of Settlement Documents Show values
SettlmtDocIsCollvDoc Indicator that Document Is a Collective Document Show values
SettlmtBusProcCat Use Case Type Show values
PostingPartnerCat Posting Partner Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
SettlmtItmStatisticalPrpty Statistical Property of Settlement Management Item Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
SettlmtSourceDocCat Document Category of Source Document Show values
SupplierPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Supplier Show values
CustomerPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Customer Show values
SettlmtPrecdgDocCat Document Category of Preceding Document Show values
SettlmtDocItemCat Item Category Show values
SettlmtItemReltdRefDocCat Contract Category of Related Contract Show values
SettlmtDocItemStatus Item Status Show values
SettlmtDocItemCancld Item Was Canceled Show values
SupplierItemSettlmtStatus Settlement Status - Item - Supplier Show values
CustomerItemSettlmtStatus Settlement Status - Item - Customer Show values
ItemSettlmtRelevance Item Settlement Relevance Show values
LowerLevelItemExists Subitems Exist Show values
ItemDistributionStatus Status Distribution of Item Show values
SettlmtRefDocCat Reference Document Category in Settlement Management Show values
ItemIntrastatRelevance Document Item is Relevant for Intrastat Declarations Show values
SettlmtDocItemCollSts Status for Collection of Settlement Document Item Show values
ItmSettlmtDocCollRelevance Collective Settlement Relevance of Settlement Documents Show values
SettlmtAddlRefDocCat Additional Reference Document Category Show values
Column Name Description Domain name
CustSettlmtCompanyCode Customer Company Code BUKRS
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 for Supplier ZTERM
SupplierCashDiscount1Days Supplier Cash Discount First Payment in Days ZBDXT
SupplierCashDiscount2Days Supplier Cash Discount Second Payment in Days ZBDXT
SupplierNetPaymentDays Supplier Cash Discount Days ZBDXT
SupplierCashDiscount1Percent Supplier Cash Discount for First Payment in % PRZ23
SupplierCashDiscount2Percent Supplier Cash Discount for Second Payment in % PRZ23
CustomerPaymentTerms Terms of Payment Key for Customer ZTERM
CustomerCashDiscount1Days Customer Cash Discount First Payment in Days ZBDXT
CustomerCashDiscount2Days Customer Cash Discount Second Payment in Days ZBDXT
CustomerNetPaymentDays Customer Cash Discount Days ZBDXT
CustomerCashDiscount1Percent Customer Cash Discount for First Payment in % PRZ23
CustomerCashDiscount2Percent Custromer Cash Discount for Second Payment in % PRZ23
SupplierPricingDocument Supplier Document Condition of Settlement Document KNUMV
CustomerPricingDocument Customer Document Condition of Settlement Document KNUMV
SupplierAdditionalValueDays Additional Value Days for Supplier TAGE2
CustomerAdditionalValueDays Additional Value Days for Customer TAGE2
PaymentReference Payment Reference CHAR30
SupplierPaytCurrencyExchRate Exchange Rate of Supplier Payment Currency (Not Converted)
CustomerPaytCurrencyExchRate Exchange Rate of Customer Payment Currency (Not Converted)
SettlmtReltdRefDoc Related Contract in the Settlement Management Doc. WCONTRACT
SettlmtReltdCndnContr Related Condition Contract in Settlement Management WCB_COCO_NUM
SettlmtReltdTrdgContr Related Trading Contract in Settlement Management TKONN
SettlmtReltdPurgDoc Related Purchasing Document in Settlement Management EBELN
SettlmtReltdBillgDoc Related Billing Document in Settlement Management VBELN
FiscalPeriod Fiscal Period POPER
TrdgExpnSupplier Trading Expense Supplier LIFNR
TrdgExpnCustomer Trading Expense Customer KUNNR
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
SupplierVATRegistration Supplier VAT Registration Number STCEG
CustomerVATRegistration Customer VAT Registration Number STCEG
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SuplrSettlmtCoCodeTaxCountry Tax Country/Region Company Code LAND1
CustSettlmtCoCodeTaxCountry Tax Country/Region Company Code Customer LAND1
SEPAMandate Unique Reference to Mandate for each Payee ID035
NetPriceQuantity Price Unit of Settlement Management Document Item DEC5
SettlmtToBaseQuantityNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
SettlmtToBaseQuantityDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
SettlmtToNetPriceQtyNmrtr Numerator for Converting Settl. UoM to Settl. Price UoM UMBSZ
SettlmtToNetPriceQtyDnmntr Denominator for Converting Settl. UoM to Settl. Price UoM UMBSZ
SettlmtRefDocReltdFiscalYear Fiscal Year GJAHR
SettlmtSourceDoc Document Number of the Source Document CHAR10
SettlmtSourceDocItem Item Number of the Source Document Item NUMC6
SettlmtSourceDocFiscalYear Fiscal Year of a Source Document in Settlement Management GJAHR
SettlmtDocItemText Short Text TEXT40
SupplierProductID Material Number Used by Supplier IDNEX
SuplrSettlmtCostCenter Cost Center KOSTL
SuplrSettlmtProfitCenter Profit Center PRCTR
SettlmtPrecdgDoc Preceding Document of the Settlement Management Document CHAR10
SettlmtPrecdgDocItem Preceding Document Item in the Settlement Management Doc. NUMC6
SettlmtPrecdgDocFiscalYear Fiscal Year of a Preceding Document in Settlement Management GJAHR
SettlmtItemReltdRefDoc Related Contract in the Settlement Management Doc. WCONTRACT
SettlmtItemReltdRefDocItem Related Contract Item in the Settlement Management Doc. NUMC6
SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item WCB_COCO_NUM
SettlmtItemReltdTrdgContr Related Trading Contract of a Settlement Management Item TKONN
SettlmtItemReltdTrdgContrItem Related Trading Contract Item of a Settlmt Mgmt Item TPOSN
SettlmtItemReltdPurgDoc Related Purchasing Document of a Settlement Management Item EBELN
SettlmtItemReltdPurgDocItem Related Purchasing Document Item of a Settlmt Mgmt Item EBELP
SettlmtItemReltdBillgDoc Related Billing Document of a Settlement Management Item VBELN
SettlmtItemReltdBillgDocItem Related Billing Document Item of a Settlmt Mgmt Item POSNR_VF
SettlementFiscalYear CCS: Fiscal Year of Settlement GJAHR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SettlmtRefDoc Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtRefDocFiscalYear Year of Reference Document for Settlement Management GJAHR
SettlmtRefDocLogicalSyst Logical System of Reference Document for Smt Mgmt LOGSYS
SettlmtRefDocItem Reference Document Item for Settlement Management Document WLF_REF_ITEM_NUMBER
SettlmtAddlRefDoc Additional Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtAddlRefDocFiscalYear Year of Additional Reference Document for Smt Mgmt GJAHR
SettlmtAddlRefDocLogicalSyst Logical System of Additional Reference Document for Smt Mgmt LOGSYS
SettlmtAddlRefDocItem Additional Reference Doc Item for Settlement Mgmt. Document WLF_REF_ITEM_NUMBER
Master Data Relations Join Conditions
Alternative Supplier
  • Alternative Supplier
  • Client
  • R_SETTLMTDOCDEX.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • R_SETTLMTDOCDEX.MANDT == LFA1.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Product Number
  • R_SETTLMTDOCDEX.MANDT == MCH1.MANDT
  • R_SETTLMTDOCDEX.BATCH == MCH1.CHARG
  • R_SETTLMTDOCDEX.PRODUCT == MCH1.MATNR
Bill-to Party
  • Client
  • Bill-to Party
  • R_SETTLMTDOCDEX.MANDT == KNA1.MANDT
  • R_SETTLMTDOCDEX.BILLTOPARTY == KNA1.KUNNR
Distribution Channel In a Business Volume Document
  • Client
  • Distribution Channel In a Business Volume Document
  • R_SETTLMTDOCDEX.MANDT == TVTW.MANDT
  • R_SETTLMTDOCDEX.BUSVOLDOCDISTRIBUTIONCHANNEL == TVTW.VTWEG
Division In a Business Volume Document
  • Client
  • Division In a Business Volume Document
  • R_SETTLMTDOCDEX.MANDT == TSPA.MANDT
  • R_SETTLMTDOCDEX.BUSVOLDOCDIVISION == TSPA.SPART
Sales Organization In a Business Volume Document
  • Client
  • Sales Organization In a Business Volume Document
  • R_SETTLMTDOCDEX.MANDT == TVKO.MANDT
  • R_SETTLMTDOCDEX.BUSVOLDOCSALESORGANIZATION == TVKO.VKORG
Condition Contract Type
  • Condition Contract Type
  • Client
Reason for Collective Settlement Block
  • Client
  • Reason for Collective Settlement Block
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.COLLSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Reason for Collective Settlement Item Block
  • Client
  • Reason for Collective Settlement Item Block
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.COLLSETTLMTITEMBLKGREASON == TMSB.SETTLEMENT_BLOCK
Credit Control Area
  • Client
  • Credit Control Area
  • R_SETTLMTDOCDEX.MANDT == T014.MANDT
  • R_SETTLMTDOCDEX.CREDITCONTROLAREA == T014.KKBER
Reason for Customer Settlement Block at Item
  • Client
  • Reason for Customer Settlement Block at Item
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.CUSTOMERITEMSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Customer Payment Currency for Automatic Payment
  • Client
  • Customer Payment Currency for Automatic Payment
  • R_SETTLMTDOCDEX.MANDT == TCURC.MANDT
  • R_SETTLMTDOCDEX.CUSTOMERPAYMENTCURRENCY == TCURC.WAERS
Customer Payment Method
  • ?
  • Client
  • Customer Payment Method
  • R_SETTLMTDOCDEX.[column in domain "LAND1"] == T042Z.LAND1
  • R_SETTLMTDOCDEX.MANDT == T042Z.MANDT
  • R_SETTLMTDOCDEX.CUSTOMERPAYMENTMETHOD == T042Z.ZLSCH
Customer Related Pricing Procedure
  • ?
  • Client
  • ?
  • Customer Related Pricing Procedure
  • R_SETTLMTDOCDEX.[column in domain "KAPPL"] == T683.KAPPL
  • R_SETTLMTDOCDEX.MANDT == T683.MANDT
  • R_SETTLMTDOCDEX.[column in domain "KVEWE"] == T683.KVEWE
  • R_SETTLMTDOCDEX.CUSTOMERPRICINGPROCEDURE == T683.KALSM
Order for Customer related Account Assignment
  • Client
  • Order for Customer related Account Assignment
  • R_SETTLMTDOCDEX.MANDT == AUFK.MANDT
  • R_SETTLMTDOCDEX.CUSTOMERSETTLEMENTORDER == AUFK.AUFNR
Reason for Customer Settlement Block
  • Client
  • Reason for Customer Settlement Block
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.CUSTOMERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Customer Settlement Recipient
  • Customer Settlement Recipient
  • Client
  • R_SETTLMTDOCDEX.CUSTOMERSETTLMTRECIPIENT == KNA1.KUNNR
  • R_SETTLMTDOCDEX.MANDT == KNA1.MANDT
Customer Tax Code
  • Client
  • Supplier Related Pricing Procedure
  • Customer Tax Code
  • R_SETTLMTDOCDEX.MANDT == T007A.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERPRICINGPROCEDURE == T007A.KALSM
  • R_SETTLMTDOCDEX.CUSTOMERTAXCODE == T007A.MWSKZ
Customer Business Area
  • Client
  • Customer Business Area
  • R_SETTLMTDOCDEX.MANDT == TGSB.MANDT
  • R_SETTLMTDOCDEX.CUSTSETTLMTBUSINESSAREA == TGSB.GSBER
Customer Controlling Area
  • Client
  • Customer Controlling Area
  • R_SETTLMTDOCDEX.MANDT == TKA01.MANDT
  • R_SETTLMTDOCDEX.CUSTSETTLMTCONTROLLINGAREA == TKA01.KOKRS
Customer Cost Center
  • Client
  • Customer Controlling Area
  • Customer Cost Center
  • Date for Pricing and Exchange Rate
  • R_SETTLMTDOCDEX.MANDT == CSKS.MANDT
  • R_SETTLMTDOCDEX.CUSTSETTLMTCONTROLLINGAREA == CSKS.KOKRS
  • R_SETTLMTDOCDEX.CUSTSETTLMTCOSTCENTER == CSKS.KOSTL
  • R_SETTLMTDOCDEX.PRICINGDATE == CSKS.DATBI
Alternative Customer Profit Center
  • Client
  • Alternative Customer Profit Center
  • Customer Controlling Area
  • Date for Pricing and Exchange Rate
  • R_SETTLMTDOCDEX.MANDT == CEPC.MANDT
  • R_SETTLMTDOCDEX.CUSTSETTLMTPROFITCENTER == CEPC.PRCTR
  • R_SETTLMTDOCDEX.CUSTSETTLMTCONTROLLINGAREA == CEPC.KOKRS
  • R_SETTLMTDOCDEX.PRICINGDATE == CEPC.DATBI
Distribution Channel
  • Client
  • Distribution Channel
  • R_SETTLMTDOCDEX.MANDT == TVTW.MANDT
  • R_SETTLMTDOCDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • R_SETTLMTDOCDEX.MANDT == TSPA.MANDT
  • R_SETTLMTDOCDEX.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • R_SETTLMTDOCDEX.MANDT == TCURV.MANDT
  • R_SETTLMTDOCDEX.EXCHANGERATETYPE == TCURV.KURST
G/L Account
  • Client
  • G/L Account
  • ?
  • R_SETTLMTDOCDEX.MANDT == SKA1.MANDT
  • R_SETTLMTDOCDEX.GLACCOUNT == SKA1.SAKNR
  • R_SETTLMTDOCDEX.[column in domain "KTOPL"] == SKA1.KTOPL
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • R_SETTLMTDOCDEX.MANDT == TINC.MANDT
  • R_SETTLMTDOCDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • R_SETTLMTDOCDEX.MANDT == TINCV.MANDT
  • R_SETTLMTDOCDEX.INCOTERMSVERSION == TINCV.INCOV
Valuation Type
  • Client
  • Valuation Type
  • R_SETTLMTDOCDEX.MANDT == T149D.MANDT
  • R_SETTLMTDOCDEX.INVENTORYVALUATIONTYPE == T149D.BWTAR
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_SETTLMTDOCDEX.INVOICINGPARTY == LFA1.LIFNR
  • R_SETTLMTDOCDEX.MANDT == LFA1.MANDT
Volume unit
  • Client
  • Volume unit
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.ITEMWEIGHTUNIT == T006.MSEHI
Settlement Management Document Item Price Unit
  • Client
  • Settlement Management Document Item Price Unit
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.NETPRICEQUANTITYUNIT == T006.MSEHI
Address of One-Time Customer
  • Client
  • Address of One-Time Customer
  • ?
  • Posting Date
  • R_SETTLMTDOCDEX.MANDT == ADRC.CLIENT
  • R_SETTLMTDOCDEX.ONETIMECUSTOMERADDRESSID == ADRC.ADDRNUMBER
  • R_SETTLMTDOCDEX.[column in domain "AD_NATION"] == ADRC.NATION
  • R_SETTLMTDOCDEX.POSTINGDATE == ADRC.DATE_FROM
Address of One-Time Supplier
  • Client
  • Address of One-Time Supplier
  • ?
  • Posting Date
  • R_SETTLMTDOCDEX.MANDT == ADRC.CLIENT
  • R_SETTLMTDOCDEX.ONETIMESUPPLIERADDRESSID == ADRC.ADDRNUMBER
  • R_SETTLMTDOCDEX.[column in domain "AD_NATION"] == ADRC.NATION
  • R_SETTLMTDOCDEX.POSTINGDATE == ADRC.DATE_FROM
Payee
  • Client
  • Payee
  • R_SETTLMTDOCDEX.MANDT == LFA1.MANDT
  • R_SETTLMTDOCDEX.PAYEEPARTY == LFA1.LIFNR
Payer
  • Client
  • Payer
  • R_SETTLMTDOCDEX.MANDT == KNA1.MANDT
  • R_SETTLMTDOCDEX.PAYERPARTY == KNA1.KUNNR
Plant
  • Client
  • Plant
  • R_SETTLMTDOCDEX.MANDT == T001W.MANDT
  • R_SETTLMTDOCDEX.PLANT == T001W.WERKS
Product Pricing Group
  • Client
  • Product Pricing Group
  • R_SETTLMTDOCDEX.MANDT == T178.MANDT
  • R_SETTLMTDOCDEX.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM
Prior Supplier
  • Client
  • Prior Supplier
  • R_SETTLMTDOCDEX.MANDT == LFA1.MANDT
  • R_SETTLMTDOCDEX.PRIORSUPPLIER == LFA1.LIFNR
Product Number
  • Client
  • Product Number
  • R_SETTLMTDOCDEX.MANDT == MARA.MANDT
  • R_SETTLMTDOCDEX.PRODUCT == MARA.MATNR
Commission Group
  • Client
  • Commission Group
  • R_SETTLMTDOCDEX.MANDT == TVPR.MANDT
  • R_SETTLMTDOCDEX.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
Product Group
  • Client
  • Product Group
  • R_SETTLMTDOCDEX.MANDT == T023.MANDT
  • R_SETTLMTDOCDEX.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Client
  • Product hierarchy
  • R_SETTLMTDOCDEX.MANDT == T179.MANDT
  • R_SETTLMTDOCDEX.PRODUCTHIERARCHY == T179.PRODH
Points Unit
  • Client
  • Points Unit
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • R_SETTLMTDOCDEX.PURCHASINGGROUP == T024.EKGRP
  • R_SETTLMTDOCDEX.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • R_SETTLMTDOCDEX.MANDT == T024E.MANDT
  • R_SETTLMTDOCDEX.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Group
  • Client
  • Sales group
  • R_SETTLMTDOCDEX.MANDT == TVKGR.MANDT
  • R_SETTLMTDOCDEX.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Client
  • Sales office
  • R_SETTLMTDOCDEX.MANDT == TVBUR.MANDT
  • R_SETTLMTDOCDEX.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • R_SETTLMTDOCDEX.MANDT == TVKO.MANDT
  • R_SETTLMTDOCDEX.SALESORGANIZATION == TVKO.VKORG
Sales-Specific Product Group 1
  • Client
  • Sales-Specific Product Group 1
  • R_SETTLMTDOCDEX.MANDT == TVM1.MANDT
  • R_SETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • R_SETTLMTDOCDEX.MANDT == TVM2.MANDT
  • R_SETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Client
  • Sales-Specific Product Group 3
  • R_SETTLMTDOCDEX.MANDT == TVM3.MANDT
  • R_SETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
Sales-Specific Product Group 4
  • Client
  • Sales-Specific Product Group 4
  • R_SETTLMTDOCDEX.MANDT == TVM4.MANDT
  • R_SETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
Sales-Specific Product Group 5
  • Client
  • Sales-Specific Product Group 5
  • R_SETTLMTDOCDEX.MANDT == TVM5.MANDT
  • R_SETTLMTDOCDEX.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
Sales Volume Rebate Group
  • Client
  • Sales Volume Rebate Group
  • R_SETTLMTDOCDEX.MANDT == TVBO.MANDT
  • R_SETTLMTDOCDEX.SALESVOLUMEREBATEGROUP == TVBO.BONUS
Application Status for a Settlement Management Document
  • Application Status for a Settlement Management Document
  • Client
  • R_SETTLMTDOCDEX.SETTLMTAPPLSTS == TMPA2.ESTATUS
  • R_SETTLMTDOCDEX.MANDT == TMPA2.MANDT
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • R_SETTLMTDOCDEX.MANDT == TMPA4.MANDT
  • R_SETTLMTDOCDEX.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Header Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • R_SETTLMTDOCDEX.MANDT == TMLFG.MANDT
  • R_SETTLMTDOCDEX.SETTLMTITEMACTIVITYREASON == TMLFG.LFGRU
  • R_SETTLMTDOCDEX.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_SETTLMTDOCDEX.MANDT == TCURC.MANDT
  • R_SETTLMTDOCDEX.SETTLMTDOCCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • R_SETTLMTDOCDEX.SETTLMTDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • R_SETTLMTDOCDEX.MANDT == TWLF_IR.MANDT
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_SETTLMTDOCDEX.MANDT == TMFK.MANDT
  • R_SETTLMTDOCDEX.SETTLMTDOCTYPE == TMFK.LFART
Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • R_SETTLMTDOCDEX.MANDT == TMLFG.MANDT
  • R_SETTLMTDOCDEX.SETTLMTITEMACTIVITYREASON == TMLFG.LFGRU
  • R_SETTLMTDOCDEX.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
Settlement Process Type
  • Client
  • Settlement Process Type
  • R_SETTLMTDOCDEX.MANDT == TMZR.MANDT
  • R_SETTLMTDOCDEX.SETTLMTPROCESSTYPE == TMZR.WRART
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.SETTLMTQUANTITYUNIT == T006.MSEHI
Company Code of Reference Document for Settlement Management
  • Client
  • Company Code of Reference Document for Settlement Management
  • R_SETTLMTDOCDEX.MANDT == T001.MANDT
  • R_SETTLMTDOCDEX.SETTLMTREFDOCCOMPANYCODE == T001.BUKRS
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • R_SETTLMTDOCDEX.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • R_SETTLMTDOCDEX.MANDT == T015L.MANDT
Business Area
  • Client
  • Business Area
  • R_SETTLMTDOCDEX.MANDT == TGSB.MANDT
  • R_SETTLMTDOCDEX.SUPLRSETTLMTBUSINESSAREA == TGSB.GSBER
Supplier Company Code
  • Client
  • Supplier Company Code
  • R_SETTLMTDOCDEX.MANDT == T001.MANDT
  • R_SETTLMTDOCDEX.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • R_SETTLMTDOCDEX.MANDT == TKA01.MANDT
  • R_SETTLMTDOCDEX.SUPLRSETTLMTCONTROLLINGAREA == TKA01.KOKRS
Reason for Supplier Settlement Block at Item
  • Client
  • Reason for Supplier Settlement Block at Item
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERITEMSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Supplier Payment Currency for Automatic Payment
  • Client
  • Supplier Payment Currency for Automatic Payment
  • R_SETTLMTDOCDEX.MANDT == TCURC.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERPAYMENTCURRENCY == TCURC.WAERS
Supplier Payment Method
  • ?
  • Client
  • Supplier Payment Method
  • R_SETTLMTDOCDEX.[column in domain "LAND1"] == T042Z.LAND1
  • R_SETTLMTDOCDEX.MANDT == T042Z.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERPAYMENTMETHOD == T042Z.ZLSCH
Supplier Related Pricing Procedure
  • ?
  • Client
  • ?
  • Supplier Related Pricing Procedure
  • R_SETTLMTDOCDEX.[column in domain "KAPPL"] == T683.KAPPL
  • R_SETTLMTDOCDEX.MANDT == T683.MANDT
  • R_SETTLMTDOCDEX.[column in domain "KVEWE"] == T683.KVEWE
  • R_SETTLMTDOCDEX.SUPPLIERPRICINGPROCEDURE == T683.KALSM
Order for Account Assignment
  • Client
  • Order for Account Assignment
  • R_SETTLMTDOCDEX.MANDT == AUFK.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERSETTLEMENTORDER == AUFK.AUFNR
Reason for Supplier Settlement Block
  • Client
  • Reason for Supplier Settlement Block
  • R_SETTLMTDOCDEX.MANDT == TMSB.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Supplier Subrange
  • Supplier Subrange
  • Client
  • Prior Supplier
  • R_SETTLMTDOCDEX.SUPPLIERSUBRANGE == WYT1.LTSNR
  • R_SETTLMTDOCDEX.MANDT == WYT1.MANDT
  • R_SETTLMTDOCDEX.PRIORSUPPLIER == WYT1.LIFNR
Supplier Tax Code
  • Client
  • Supplier Tax Code
  • Supplier Related Pricing Procedure
  • R_SETTLMTDOCDEX.MANDT == T007A.MANDT
  • R_SETTLMTDOCDEX.SUPPLIERTAXCODE == T007A.MWSKZ
  • R_SETTLMTDOCDEX.SUPPLIERPRICINGPROCEDURE == T007A.KALSM
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • R_SETTLMTDOCDEX.MANDT == T005.MANDT
  • R_SETTLMTDOCDEX.SUPPLYINGCOUNTRY == T005.LAND1
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • R_SETTLMTDOCDEX.MANDT == T005.MANDT
  • R_SETTLMTDOCDEX.TAXDEPARTURECOUNTRY == T005.LAND1
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • R_SETTLMTDOCDEX.MANDT == T005.MANDT
  • R_SETTLMTDOCDEX.TAXDESTINATIONCOUNTRY == T005.LAND1
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • Supplier Related Pricing Procedure
  • R_SETTLMTDOCDEX.MANDT == TTXJ.MANDT
  • R_SETTLMTDOCDEX.TAXJURISDICTION == TTXJ.TXJCD
  • R_SETTLMTDOCDEX.SUPPLIERPRICINGPROCEDURE == TTXJ.KALSM
Points Unit for Total Points
  • Client
  • Points Unit for Total Points
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.TOTALSETTLMTPOINTSQTYUNIT == T006.MSEHI
Volume Unit for Total Volume
  • Client
  • Volume Unit for Total Volume
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
Unit of Weight for Total Weight
  • Client
  • Unit of Weight for Total Weight
  • R_SETTLMTDOCDEX.MANDT == T006.MANDT
  • R_SETTLMTDOCDEX.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI
Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • Client
  • Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • R_SETTLMTDOCDEX.MANDT == TCURC.MANDT
  • R_SETTLMTDOCDEX.TRDGEXPNCURRENCY == TCURC.WAERS