C_MngSettlmtDoc

Manage Settlement Documents [Obsolete] | view: CWZREMNGSETDOC | Extraction: Not supported | Component: Settlement Management
Tables used: SCAL_TT_DATE, WBRK, TWCBCONTRTYPET, T001, TKA02, KNA1, TMFKT, TMZRT, LFA1, USR21, TWCBCONTRTYPE, TMFK, TMZR
Column Name Description
SettlmtDoc Settlement Document Number
Column Name Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
SupplierTotalGrossAmount Supplier Total Gross Amount in Document Currency
SupplierTotalNetAmount Supplier Total Net Amount In Document Currency
CustomerTotalGrossAmount Customer Total Gross Amount in Document Currency
CustomerTotalNetAmount Customer Total Net Amount in Document Currency
SuplrTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Supplier
CustTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Customer
SupplierTotalTaxAmount Supplier Total Tax Amount in Document Currency
CustomerTotalTaxAmount Customer Total Tax Amount in Document Currency
💲 Display Currency (DisplayCurrency):
CnvrtdSupplierTotalGrossAmount Converted Supplier Total Gross Amount in Display Currency
CnvrtdSupplierTotalNetAmount Converted Supplier Total Net Amount in Display Currency
CnvrtdCustomerTotalGrossAmount Converted Customer Total Gross Amount in Display Currency
CnvrtdCustomerTotalNetAmount Converted Customer Total Net Amount in Display Currency
CnvrtdSupplierTotalTaxAmount Converted Supplier Total Tax Amount in Display Currency
CnvrtdCustomerTotalTaxAmount Converted Customer Total Tax Amount in Display Currency
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
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
SettlmtDate Rebates: Settlement Date
ActualSettlmtDate Actual Settlement Date
SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate End Date of Settlement Period
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
SettlmtDateCat Rebates: Settlement Date Type 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
CombinedSettlmtPostgSts Posting Status for Combined Settlement 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
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
Column Name Description Domain name
SettlmtDocTypeDesc Settlement Document Type Description TEXT40
SettlmtProcessTypeDesc Settlement Process Type Description TEXT40
SettlmtMgmtAcctgTransfStsName Description of Posting Status DDTEXT
InvoicingPartyName Name of Invoicing Party TEXT80
PayeePartyName Name of Payee TEXT80
BillToPartyName Bill-to Party Name TEXT80
PayerPartyName Payer Party TEXT80
SuplrSettlmtCompanyCodeName Name of Company Code or Company
CustSettlmtCompanyCode Customer Company Code BUKRS
CustSettlmtCompanyCodeName Name of Company Code or Company
CreatedByUser Name of User who Created the Document USNAM
CreatedByUserFullName User Description SUIDTECHDESC
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
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
SettlmtReltdCndnContr Condition Contract WCB_COCO_NUM
CndnContrTypeDesc Description WCB_TEXT
SettlmtDateCatName Rebates: Settlement Date Type Description
FiscalPeriod Fiscal Period POPER
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
CalendarYear Calendar Year NUM4
Master Data Relations Join Conditions
Alternative Supplier
  • Alternative Supplier
  • Client
  • C_MNGSETTLMTDOC.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • C_MNGSETTLMTDOC.MANDT == LFA1.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • C_MNGSETTLMTDOC.MANDT == KNA1.MANDT
  • C_MNGSETTLMTDOC.BILLTOPARTY == KNA1.KUNNR
Condition Contract Type
  • Client
  • Condition Contract Type
Reason for Collective Settlement Block
  • Client
  • Reason for Collective Settlement Block
  • C_MNGSETTLMTDOC.MANDT == TMSB.MANDT
  • C_MNGSETTLMTDOC.COLLSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Credit Control Area
  • Credit Control Area
  • Client
  • C_MNGSETTLMTDOC.CREDITCONTROLAREA == T014.KKBER
  • C_MNGSETTLMTDOC.MANDT == T014.MANDT
Customer Payment Currency for Automatic Payment
  • Customer Payment Currency for Automatic Payment
  • Client
  • C_MNGSETTLMTDOC.CUSTOMERPAYMENTCURRENCY == TCURC.WAERS
  • C_MNGSETTLMTDOC.MANDT == TCURC.MANDT
Customer Payment Method
  • Client
  • Customer Payment Method
  • ?
  • C_MNGSETTLMTDOC.MANDT == T042Z.MANDT
  • C_MNGSETTLMTDOC.CUSTOMERPAYMENTMETHOD == T042Z.ZLSCH
  • C_MNGSETTLMTDOC.[column in domain "LAND1"] == T042Z.LAND1
Reason for Customer Settlement Block
  • Client
  • Reason for Customer Settlement Block
  • C_MNGSETTLMTDOC.MANDT == TMSB.MANDT
  • C_MNGSETTLMTDOC.CUSTOMERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
Distribution Channel
  • Client
  • Distribution Channel
  • C_MNGSETTLMTDOC.MANDT == TVTW.MANDT
  • C_MNGSETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • C_MNGSETTLMTDOC.DIVISION == TSPA.SPART
  • C_MNGSETTLMTDOC.MANDT == TSPA.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_MNGSETTLMTDOC.MANDT == TCURV.MANDT
  • C_MNGSETTLMTDOC.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_MNGSETTLMTDOC.MANDT == TINC.MANDT
  • C_MNGSETTLMTDOC.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_MNGSETTLMTDOC.INCOTERMSVERSION == TINCV.INCOV
  • C_MNGSETTLMTDOC.MANDT == TINCV.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_MNGSETTLMTDOC.MANDT == LFA1.MANDT
  • C_MNGSETTLMTDOC.INVOICINGPARTY == LFA1.LIFNR
Payee
  • Payee
  • Client
  • C_MNGSETTLMTDOC.PAYEEPARTY == LFA1.LIFNR
  • C_MNGSETTLMTDOC.MANDT == LFA1.MANDT
Payer
  • Client
  • Payer
  • C_MNGSETTLMTDOC.MANDT == KNA1.MANDT
  • C_MNGSETTLMTDOC.PAYERPARTY == KNA1.KUNNR
Purchasing Group
  • Purchasing Group
  • Client
  • C_MNGSETTLMTDOC.PURCHASINGGROUP == T024.EKGRP
  • C_MNGSETTLMTDOC.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_MNGSETTLMTDOC.MANDT == T024E.MANDT
  • C_MNGSETTLMTDOC.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Group
  • Client
  • Sales group
  • C_MNGSETTLMTDOC.MANDT == TVKGR.MANDT
  • C_MNGSETTLMTDOC.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Client
  • Sales office
  • C_MNGSETTLMTDOC.MANDT == TVBUR.MANDT
  • C_MNGSETTLMTDOC.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • C_MNGSETTLMTDOC.MANDT == TVKO.MANDT
  • C_MNGSETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • C_MNGSETTLMTDOC.MANDT == TMPA2.MANDT
  • C_MNGSETTLMTDOC.SETTLMTAPPLSTS == TMPA2.ESTATUS
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Header Activity Reason for Document Creation
  • Client
  • Header Activity Reason for Document Creation
  • C_MNGSETTLMTDOC.MANDT == TMLFG.MANDT
  • C_MNGSETTLMTDOC.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • C_MNGSETTLMTDOC.SETTLMTDOCCURRENCY == TCURC.WAERS
  • C_MNGSETTLMTDOC.MANDT == TCURC.MANDT
Incompleteness Reason of Settlement Management Document
  • Client
  • Incompleteness Reason of Settlement Management Document
  • C_MNGSETTLMTDOC.MANDT == TWLF_IR.MANDT
  • C_MNGSETTLMTDOC.SETTLMTDOCINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
Settlement Document Type
  • Client
  • Settlement Document Type
  • C_MNGSETTLMTDOC.MANDT == TMFK.MANDT
  • C_MNGSETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • C_MNGSETTLMTDOC.MANDT == TMZR.MANDT
  • C_MNGSETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • C_MNGSETTLMTDOC.MANDT == T015L.MANDT
  • C_MNGSETTLMTDOC.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplier Company Code
  • Supplier Company Code
  • Client
  • C_MNGSETTLMTDOC.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS
  • C_MNGSETTLMTDOC.MANDT == T001.MANDT
Supplier Payment Currency for Automatic Payment
  • Client
  • Supplier Payment Currency for Automatic Payment
  • C_MNGSETTLMTDOC.MANDT == TCURC.MANDT
  • C_MNGSETTLMTDOC.SUPPLIERPAYMENTCURRENCY == TCURC.WAERS
Supplier Payment Method
  • Supplier Payment Method
  • Client
  • ?
  • C_MNGSETTLMTDOC.SUPPLIERPAYMENTMETHOD == T042Z.ZLSCH
  • C_MNGSETTLMTDOC.MANDT == T042Z.MANDT
  • C_MNGSETTLMTDOC.[column in domain "LAND1"] == T042Z.LAND1
Reason for Supplier Settlement Block
  • Reason for Supplier Settlement Block
  • Client
  • C_MNGSETTLMTDOC.SUPPLIERSETTLMTBLKGREASON == TMSB.SETTLEMENT_BLOCK
  • C_MNGSETTLMTDOC.MANDT == TMSB.MANDT
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • C_MNGSETTLMTDOC.MANDT == T005.MANDT
  • C_MNGSETTLMTDOC.SUPPLYINGCOUNTRY == T005.LAND1
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • C_MNGSETTLMTDOC.TAXDEPARTURECOUNTRY == T005.LAND1
  • C_MNGSETTLMTDOC.MANDT == T005.MANDT
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • C_MNGSETTLMTDOC.TAXDESTINATIONCOUNTRY == T005.LAND1
  • C_MNGSETTLMTDOC.MANDT == T005.MANDT
Points Unit for Total Points
  • Client
  • Points Unit for Total Points
  • C_MNGSETTLMTDOC.MANDT == T006.MANDT
  • C_MNGSETTLMTDOC.TOTALSETTLMTPOINTSQTYUNIT == T006.MSEHI
Volume Unit for Total Volume
  • Volume Unit for Total Volume
  • Client
  • C_MNGSETTLMTDOC.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
  • C_MNGSETTLMTDOC.MANDT == T006.MANDT
Unit of Weight for Total Weight
  • Client
  • Unit of Weight for Total Weight
  • C_MNGSETTLMTDOC.MANDT == T006.MANDT
  • C_MNGSETTLMTDOC.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI