P_SettlmtMgmtDoc

Settlement Management Document Basic | view: PWLF_WBRK | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK
Column Name Description
SettlmtMgmtDoc Document Number
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
SupplierTotalTaxAmount Total Tax Amount for Supplier in Document Currency
CustomerTotalGrossAmount Total Gross Amount for Customer in Document Currency
CustomerTotalNetAmount Total Net Amount for Customer in Document Currency
CustomerTotalTaxAmount Total Tax Amount for Customer in Document Currency
SuplrTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Supplier
CustTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Customer
💲 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
Column Name Description
PostingDate Posting Date
DocumentDate Document Date in Settlement Management Document
CreationDate Date of Document Creation
CreationTime Time of Document Creation
LastChangeDate Date of Last Document Change
ExchangeRateDate Exchange Rate Date
SupplierFixedValueDate Fixed Value Date for Supplier
CustomerFixedValueDate Fixed Value Date for Customer
ActualSettlmtDate Actual Settlement Date
SettlmtDate Rebates: Settlement Date
RefSettlmtDate Reference Date for a Delta Settlement
SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate End Date of Settlement Period
JournalEntryCreationDate Journal Entry Creation Date in UTC
JournalEntryCreationTime Journal Entry Creation Time in UTC
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
SettlmtMgmtDocCat Settlement Management Document Category Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
SettlmtMgmtDocIsCancelled Settlement Management Document is Reversed Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
SettlmtReltdRefDocCat Contract Category of Related Contract Show values
SettlmtDocSmmrznCat Document Summarization Category Show values
SettlmtMgmtDocCollSts Collective Settlement Status of Settlement Documents Show values
SettlmtMgmtDocIsCollvDoc Indicator that Document Is a Collective Document 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
DocIntrastatRelevance Document is Relevant for Intrastat Declarations Show values
IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations Show values
SettlmtBusProcCat Use Case Type Show values
PostingPartnerCat Posting Partner Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
SettlmtHasDvtgCndnContrData Deviating Settlement Data on Item Level Show values
SettlmtMgmtDocHasNoTexts No Texts Exist Show values
SettlmtMgmtDocIsRlvtForOutp Output Control Framework Indicator Show values
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
SupplierPricingDocument Supplier Document Condition of Settlement Document KNUMV
CustomerPricingDocument Customer Document Condition of Settlement Document KNUMV
CustSettlmtCompanyCode Customer Company Code BUKRS
CreatedByUser Name of User who Created the Document USNAM
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
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
SupplierAdditionalValueDays Additional Value Days for Supplier TAGE2
CustomerAdditionalValueDays Additional Value Days for Customer TAGE2
TaxExchangeRate Tax Conversion Rate (Not Converted)
IntercompanyTaxExchangeRate Intercompany Tax Conversion Rate (Not Converted)
SupplierVATRegistration Supplier VAT Registration Number STCEG
CustomerVATRegistration Customer VAT Registration Number STCEG
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
TrdgExpnSettlmtDoc Settlement Document of planned Trading Expenses WBELN
TrdgExpnSupplier Trading Expense Supplier LIFNR
TrdgExpnCustomer Trading Expense Customer KUNNR
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
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
PersonWorkAgreement Personnel Number PERNR
PersonnelCostCenter Personnel Cost Center KOSTL
ContractAccount Contract Account VKONT_KK
SettlmtMgmtDocChangeState Change State of a Settlement Management Document (ETag) WLF_CHANGE_STATE
Master Data Relations Join Conditions
Alternative Supplier
  • Client
  • Alternative Supplier
  • P_SETTLMTMGMTDOC.MANDT == LFA1.MANDT
  • P_SETTLMTMGMTDOC.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
Element Behavior Group for SAP Fiori Applications
  • Client
  • ?
  • Element Behavior Group for SAP Fiori Applications
  • P_SETTLMTMGMTDOC.MANDT == WLF_C_FVISG.MANDT
  • P_SETTLMTMGMTDOC.[column in domain "WLF_BO_TYPE"] == WLF_C_FVISG.BO_TYPE
  • P_SETTLMTMGMTDOC.APPLELMNTBEHAVIORGRP == WLF_C_FVISG.VISIBILITY_GROUP
Bill-to Party
  • Client
  • Bill-to Party
  • P_SETTLMTMGMTDOC.MANDT == KNA1.MANDT
  • P_SETTLMTMGMTDOC.BILLTOPARTY == KNA1.KUNNR
Condition Contract Process Variant
  • Condition Contract Process Variant
  • Client
Condition Contract Type
  • Condition Contract Type
  • Client
Reason for Collective Settlement Block
  • Reason for Collective Settlement Block
  • Client
  • P_SETTLMTMGMTDOC.COLLSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
  • P_SETTLMTMGMTDOC.MANDT == TMSB.MANDT
Supplier Company Code
  • Client
  • Supplier Company Code
  • P_SETTLMTMGMTDOC.MANDT == T001.MANDT
  • P_SETTLMTMGMTDOC.COMPANYCODE == T001.BUKRS
Application P_SETTLMTMGMTDOC.CONDITIONAPPLICATION == T681A.KAPPL
Credit Control Area
  • Credit Control Area
  • Client
  • P_SETTLMTMGMTDOC.CREDITCONTROLAREA == T014.KKBER
  • P_SETTLMTMGMTDOC.MANDT == T014.MANDT
Customer Payment Currency for Automatic Payment
  • Client
  • Customer Payment Currency for Automatic Payment
  • P_SETTLMTMGMTDOC.MANDT == TCURC.MANDT
  • P_SETTLMTMGMTDOC.CUSTOMERPAYMENTCURRENCY == TCURC.WAERS
Customer Payment Method
  • ?
  • Client
  • Customer Payment Method
  • P_SETTLMTMGMTDOC.[column in domain "LAND1"] == T042Z.LAND1
  • P_SETTLMTMGMTDOC.MANDT == T042Z.MANDT
  • P_SETTLMTMGMTDOC.CUSTOMERPAYMENTMETHOD == T042Z.ZLSCH
Customer Related Pricing Procedure
  • Customer Related Pricing Procedure
  • Application
  • Client
  • ?
  • P_SETTLMTMGMTDOC.CUSTOMERPRICINGPROCEDURE == T683.KALSM
  • P_SETTLMTMGMTDOC.CONDITIONAPPLICATION == T683.KAPPL
  • P_SETTLMTMGMTDOC.MANDT == T683.MANDT
  • P_SETTLMTMGMTDOC.[column in domain "KVEWE"] == T683.KVEWE
Reason for Customer Settlement Block
  • Client
  • Reason for Customer Settlement Block
  • P_SETTLMTMGMTDOC.MANDT == TMSB.MANDT
  • P_SETTLMTMGMTDOC.CUSTOMERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Distribution Channel
  • Distribution Channel
  • Client
  • P_SETTLMTMGMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SETTLMTMGMTDOC.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • P_SETTLMTMGMTDOC.MANDT == TSPA.MANDT
  • P_SETTLMTMGMTDOC.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • P_SETTLMTMGMTDOC.EXCHANGERATETYPE == TCURV.KURST
  • P_SETTLMTMGMTDOC.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_SETTLMTMGMTDOC.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SETTLMTMGMTDOC.MANDT == TINC.MANDT
Incoterms Version
  • Client
  • Incoterms Version
  • P_SETTLMTMGMTDOC.MANDT == TINCV.MANDT
  • P_SETTLMTMGMTDOC.INCOTERMSVERSION == TINCV.INCOV
Customer Company Code
  • Client
  • Customer Company Code
  • P_SETTLMTMGMTDOC.MANDT == T001.MANDT
  • P_SETTLMTMGMTDOC.INTERCOMPANYCOMPANYCODE == T001.BUKRS
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • P_SETTLMTMGMTDOC.MANDT == LFA1.MANDT
  • P_SETTLMTMGMTDOC.INVOICINGPARTY == LFA1.LIFNR
Address of One-Time Customer
  • Posting Date
  • Address of One-Time Customer
  • Client
  • ?
  • P_SETTLMTMGMTDOC.POSTINGDATE == ADRC.DATE_FROM
  • P_SETTLMTMGMTDOC.ONETIMECUSTOMERADDRESSID == ADRC.ADDRNUMBER
  • P_SETTLMTMGMTDOC.MANDT == ADRC.CLIENT
  • P_SETTLMTMGMTDOC.[column in domain "AD_NATION"] == ADRC.NATION
Address of One-Time Supplier
  • Posting Date
  • Address of One-Time Supplier
  • Client
  • ?
  • P_SETTLMTMGMTDOC.POSTINGDATE == ADRC.DATE_FROM
  • P_SETTLMTMGMTDOC.ONETIMESUPPLIERADDRESSID == ADRC.ADDRNUMBER
  • P_SETTLMTMGMTDOC.MANDT == ADRC.CLIENT
  • P_SETTLMTMGMTDOC.[column in domain "AD_NATION"] == ADRC.NATION
Payee
  • Client
  • Payee
  • P_SETTLMTMGMTDOC.MANDT == LFA1.MANDT
  • P_SETTLMTMGMTDOC.PAYEEPARTY == LFA1.LIFNR
Payer
  • Client
  • Payer
  • P_SETTLMTMGMTDOC.MANDT == KNA1.MANDT
  • P_SETTLMTMGMTDOC.PAYERPARTY == KNA1.KUNNR
Purchasing Group
  • Purchasing Group
  • Client
  • P_SETTLMTMGMTDOC.PURCHASINGGROUP == T024.EKGRP
  • P_SETTLMTMGMTDOC.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SETTLMTMGMTDOC.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SETTLMTMGMTDOC.MANDT == T024E.MANDT
Check Sales Group
  • Client
  • Sales group
  • P_SETTLMTMGMTDOC.MANDT == TVKGR.MANDT
  • P_SETTLMTMGMTDOC.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Client
  • Sales office
  • P_SETTLMTMGMTDOC.MANDT == TVBUR.MANDT
  • P_SETTLMTMGMTDOC.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • P_SETTLMTMGMTDOC.MANDT == TVKO.MANDT
  • P_SETTLMTMGMTDOC.SALESORGANIZATION == TVKO.VKORG
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • P_SETTLMTMGMTDOC.MANDT == TMPA2.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • P_SETTLMTMGMTDOC.MANDT == TMPA4.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Tax Country/Region Company Code
  • Tax Country/Region Company Code
  • Client
  • P_SETTLMTMGMTDOC.SETTLMTCOCODETAXCOUNTRY == T005.LAND1
  • P_SETTLMTMGMTDOC.MANDT == T005.MANDT
Compensation Reason for a Settlement Management Document
  • Compensation Reason for a Settlement Management Document
  • Client
Compensation Variant
  • Client
  • Compensation Variant
Header Activity Reason for Document Creation
  • Client
  • Header Activity Reason for Document Creation
  • P_SETTLMTMGMTDOC.MANDT == TMLFG.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • P_SETTLMTMGMTDOC.MANDT == TCURC.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document List Type
  • Client
  • Settlement Document List Type
  • P_SETTLMTMGMTDOC.MANDT == TRRLCG.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTDOCLISTTYPE == TRRLCG.RRLCG
Settlement Document Type
  • Settlement Document Type
  • Client
  • P_SETTLMTMGMTDOC.SETTLMTDOCTYPE == TMFK.LFART
  • P_SETTLMTMGMTDOC.MANDT == TMFK.MANDT
Tax Country/Region Company Code Customer
  • Client
  • Tax Country/Region Company Code Customer
  • P_SETTLMTMGMTDOC.MANDT == T005.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTINTCOCOCODETAXCOUNTRY == T005.LAND1
Incompleteness Reason of Settlement Management Document
  • Client
  • Incompleteness Reason of Settlement Management Document
  • P_SETTLMTMGMTDOC.MANDT == TWLF_IR.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTMGMTDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
Settlement Process Type
  • Client
  • Settlement Process Type
  • P_SETTLMTMGMTDOC.MANDT == TMZR.MANDT
  • P_SETTLMTMGMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • P_SETTLMTMGMTDOC.MANDT == T015L.MANDT
  • P_SETTLMTMGMTDOC.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplier Payment Currency for Automatic Payment
  • Client
  • Supplier Payment Currency for Automatic Payment
  • P_SETTLMTMGMTDOC.MANDT == TCURC.MANDT
  • P_SETTLMTMGMTDOC.SUPPLIERPAYMENTCURRENCY == TCURC.WAERS
Payment Method
  • ?
  • Client
  • Payment Method
  • P_SETTLMTMGMTDOC.[column in domain "LAND1"] == T042Z.LAND1
  • P_SETTLMTMGMTDOC.MANDT == T042Z.MANDT
  • P_SETTLMTMGMTDOC.SUPPLIERPAYMENTMETHOD == T042Z.ZLSCH
Supplier Related Pricing Procedure
  • Application
  • Supplier Related Pricing Procedure
  • Client
  • ?
  • P_SETTLMTMGMTDOC.CONDITIONAPPLICATION == T683.KAPPL
  • P_SETTLMTMGMTDOC.SUPPLIERPRICINGPROCEDURE == T683.KALSM
  • P_SETTLMTMGMTDOC.MANDT == T683.MANDT
  • P_SETTLMTMGMTDOC.[column in domain "KVEWE"] == T683.KVEWE
Reason for Supplier Settlement Block
  • Client
  • Reason for Supplier Settlement Block
  • P_SETTLMTMGMTDOC.MANDT == TMSB.MANDT
  • P_SETTLMTMGMTDOC.SUPPLIERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • P_SETTLMTMGMTDOC.SUPPLYINGCOUNTRY == T005.LAND1
  • P_SETTLMTMGMTDOC.MANDT == T005.MANDT
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • P_SETTLMTMGMTDOC.MANDT == T005.MANDT
  • P_SETTLMTMGMTDOC.TAXDEPARTURECOUNTRY == T005.LAND1
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • P_SETTLMTMGMTDOC.TAXDESTINATIONCOUNTRY == T005.LAND1
  • P_SETTLMTMGMTDOC.MANDT == T005.MANDT
Points Unit for Total Points
  • Client
  • Points Unit for Total Points
  • P_SETTLMTMGMTDOC.MANDT == T006.MANDT
  • P_SETTLMTMGMTDOC.TOTALSETTLMTPOINTSQTYUNIT == T006.MSEHI
Volume Unit for Total Volume
  • Client
  • Volume Unit for Total Volume
  • P_SETTLMTMGMTDOC.MANDT == T006.MANDT
  • P_SETTLMTMGMTDOC.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
Unit of Weight for Total Weight
  • Client
  • Unit of Weight for Total Weight
  • P_SETTLMTMGMTDOC.MANDT == T006.MANDT
  • P_SETTLMTMGMTDOC.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI
Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • Client
  • Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
  • P_SETTLMTMGMTDOC.MANDT == TCURC.MANDT
  • P_SETTLMTMGMTDOC.TRDGEXPNCURRENCY == TCURC.WAERS