C_SettlmtDocDEX

DDL: C_SETTLMTDOCDEX Type: view CONSUMPTION Package: WZRE
281 Fields 1 Data Sources

Settlement Document Extraction

C_SettlmtDocDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Settlement Document · Sales

C_SettlmtDocDEX is a Consumption CDS View (Fact) that provides data about "Settlement Document Extraction" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocDEX) and exposes 281 fields with key fields SettlmtDoc, SettlmtDocItem. Part of development package WZRE.

SAP Help Documentation

CategorySettlement Document
Data CategoryFact
Purpose
This CDS view supports data extraction to SAP BW/4HANA . It enables the data transfer to SAP BW/4HANA for settlement documents. Providing all relevant settlement document information, this CDS view also allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which settled documents are relevant for SAP BW/4HANA data extraction? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BEGRU_KNA1 (Authorization Group for Customers) BEGRU_LFA1 (Authorization Group for Suppliers) COMPANY_ORG_AREA (Company Organizational Area) LFART (Settlement Document Type) W_WBRK_IC (Intercompany Organizational Area) These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description SettlmtDoc Settlement Document Number SettlmtDocItem Settlement Document Item Number Product Product Plant Plant SettlmtDocItemCat Item Category SettlmtDocCurrency Document Currency SupplierItemGrossAmount Supplier-Related Item Gross Amount SupplierItemNetAmount Supplier-Related Item Net Amount SupplierItemTaxAmount Supplier-Related Item Tax Amount CustomerItemGrossAmount Customer-Related Item Gross Amount CustomerItemNetAmount Customer-Related Item Net Amount CustomerItemTaxAmount Customer-Related Item Tax Amount SettlmtQuantity Item Quantity SettlmtQuantityUnit Unit of Measure of Item Quantity

SAP Business Warehouse(SAP BW) Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessSales
Application ComponentLO-AB
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view supports data extraction to SAP BW/4HANA. It enables the data transfer to SAP BW/4HANA for settlement documents. Providing all relevant settlement document information, this CDS view also allows you to build analytical reports.</p> This CDS view provides the data to answer the following business question:<ul> <li> <p>Which settled documents are relevant for SAP BW/4HANA data extraction?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocDEX SettlmtDocDex from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CWLFSDOCDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.compositionRoot true view
ObjectModel.sapObjectNodeType.name SettlementDocument view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Document Extraction view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (281)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Document Number
KEY SettlmtDocItem SettlmtDocItem Document Item
SettlmtDocType R_SettlmtDocDEX SettlmtDocType Settlement Document Type
SettlmtDocCat R_SettlmtDocDEX SettlmtDocCat Settlement Document Category
SettlmtProcessType R_SettlmtDocDEX SettlmtProcessType Settlement Process Type
SettlmtProcessCat R_SettlmtDocDEX SettlmtProcessCat Settlement Process Category
LogisticsDataEntryCat R_SettlmtDocDEX LogisticsDataEntryCat Entry Category for Logistics Data
SettlmtCat R_SettlmtDocDEX SettlmtCat Settlement Category
SupplierPricingProcedure R_SettlmtDocDEX SupplierPricingProcedure Supplier Related Pricing Procedure
CustomerPricingProcedure R_SettlmtDocDEX CustomerPricingProcedure Customer Related Pricing Procedure
PostingDate R_SettlmtDocDEX PostingDate Posting Date for GR
SettlmtMgmtAcctgTransfSts R_SettlmtDocDEX SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting
InvoicingParty R_SettlmtDocDEX InvoicingParty Supplier in Settlement Management
PayeeParty R_SettlmtDocDEX PayeeParty Payee
BillToParty R_SettlmtDocDEX BillToParty Customer in Settlement Management
PayerParty R_SettlmtDocDEX PayerParty Payer
PurchasingOrganization R_SettlmtDocDEX PurchasingOrganization Purchasing Organization
PurchasingGroup R_SettlmtDocDEX PurchasingGroup Purchasing Group
SalesOrganization R_SettlmtDocDEX SalesOrganization Sales Organization
DistributionChannel R_SettlmtDocDEX DistributionChannel Distribution Channel
Division R_SettlmtDocDEX Division Internal Division ID
SuplrSettlmtCompanyCode R_SettlmtDocDEX SuplrSettlmtCompanyCode Supplier Company Code
CustSettlmtCompanyCode R_SettlmtDocDEX CustSettlmtCompanyCode Customer Company Code
CreatedByUser R_SettlmtDocDEX CreatedByUser Name of User who Created the Document
CreationDate R_SettlmtDocDEX CreationDate Date of Document Creation
CreationTime R_SettlmtDocDEX CreationTime Time of Document Creation
LastChangeDate R_SettlmtDocDEX LastChangeDate Date of Last Document Change
DocumentDate R_SettlmtDocDEX DocumentDate Document Date in Settlement Management Document
DocumentReferenceID R_SettlmtDocDEX DocumentReferenceID Reference Document Number
AssignmentReference R_SettlmtDocDEX AssignmentReference Assignment Reference
SettlmtDocCurrency R_SettlmtDocDEX SettlmtDocCurrency Currency of Settlement Document
ExchangeRate R_SettlmtDocDEX ExchangeRate Conversion Rate (Not Converted)
ExchangeRateIsFixed R_SettlmtDocDEX ExchangeRateIsFixed Indicator for Fixed Exchange Rate
ExchangeRateDate R_SettlmtDocDEX ExchangeRateDate Exchange Rate Date
SupplierTotalGrossAmount R_SettlmtDocDEX SupplierTotalGrossAmount Total Gross Amount for Supplier in Document Currency
SupplierTotalNetAmount R_SettlmtDocDEX SupplierTotalNetAmount Total Net Amount for Supplier in Document Currency
CustomerTotalGrossAmount R_SettlmtDocDEX CustomerTotalGrossAmount Total Gross Amount for Customer in Document Currency
CustomerTotalNetAmount R_SettlmtDocDEX CustomerTotalNetAmount Total Net Amount for Customer in Document Currency
SupplierPaymentTerms R_SettlmtDocDEX SupplierPaymentTerms Terms of Payment Key for Supplier
SupplierCashDiscount1Days R_SettlmtDocDEX SupplierCashDiscount1Days Supplier Cash Discount First Payment in Days
SupplierCashDiscount2Days R_SettlmtDocDEX SupplierCashDiscount2Days Supplier Cash Discount Second Payment in Days
SupplierNetPaymentDays R_SettlmtDocDEX SupplierNetPaymentDays Supplier Cash Discount Days
SupplierCashDiscount1Percent R_SettlmtDocDEX SupplierCashDiscount1Percent Supplier Cash Discount for First Payment in %
SupplierCashDiscount2Percent R_SettlmtDocDEX SupplierCashDiscount2Percent Supplier Cash Discount for Second Payment in %
SupplierPaymentMethod R_SettlmtDocDEX SupplierPaymentMethod Supplier Payment Method
CustomerPaymentTerms R_SettlmtDocDEX CustomerPaymentTerms Terms of Payment Key for Customer
CustomerCashDiscount1Days R_SettlmtDocDEX CustomerCashDiscount1Days Customer Cash Discount First Payment in Days
CustomerCashDiscount2Days R_SettlmtDocDEX CustomerCashDiscount2Days Customer Cash Discount Second Payment in Days
CustomerNetPaymentDays R_SettlmtDocDEX CustomerNetPaymentDays Customer Cash Discount Days
CustomerCashDiscount1Percent R_SettlmtDocDEX CustomerCashDiscount1Percent Customer Cash Discount for First Payment in %
CustomerCashDiscount2Percent R_SettlmtDocDEX CustomerCashDiscount2Percent Custromer Cash Discount for Second Payment in %
CustomerPaymentMethod R_SettlmtDocDEX CustomerPaymentMethod Customer Payment Method
SuplrTotEligibleAmtForCshDisc R_SettlmtDocDEX SuplrTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Supplier
CustTotEligibleAmtForCshDisc R_SettlmtDocDEX CustTotEligibleAmtForCshDisc Total Amount Eligible for Cash Discount of Customer
SettlmtDocIsCanceled R_SettlmtDocDEX SettlmtDocIsCanceled Settlement Document is Reversed
CanceledSettlmtDoc R_SettlmtDocDEX CanceledSettlmtDoc Reversed Document
SupplierPricingDocument R_SettlmtDocDEX SupplierPricingDocument Supplier Document Condition of Settlement Document
CustomerPricingDocument R_SettlmtDocDEX CustomerPricingDocument Customer Document Condition of Settlement Document
SupplierAdditionalValueDays R_SettlmtDocDEX SupplierAdditionalValueDays Additional Value Days for Supplier
SupplierFixedValueDate R_SettlmtDocDEX SupplierFixedValueDate Fixed Value Date for Supplier
CustomerAdditionalValueDays R_SettlmtDocDEX CustomerAdditionalValueDays Additional Value Days for Customer
CustomerFixedValueDate R_SettlmtDocDEX CustomerFixedValueDate Fixed Value Date for Customer
SupplierTotalTaxAmount R_SettlmtDocDEX SupplierTotalTaxAmount Total Tax Amount for Supplier in Document Currency
CustomerTotalTaxAmount R_SettlmtDocDEX CustomerTotalTaxAmount Total Tax Amount for Customer in Document Currency
SupplyingCountry R_SettlmtDocDEX SupplyingCountry Supplying Country/Region
StateCentralBankPaymentReason R_SettlmtDocDEX StateCentralBankPaymentReason State Central Bank Indicator
CreditControlArea R_SettlmtDocDEX CreditControlArea Credit Control Area
SettlmtDocActivityReason R_SettlmtDocDEX SettlmtDocActivityReason Header Activity Reason for Document Creation
PaymentReference R_SettlmtDocDEX PaymentReference Payment Reference
SupplierPaymentCurrency R_SettlmtDocDEX SupplierPaymentCurrency Supplier Payment Currency for Automatic Payment
SupplierPaytCurrencyExchRate R_SettlmtDocDEX SupplierPaytCurrencyExchRate Exchange Rate of Supplier Payment Currency (Not Converted)
CustomerPaymentCurrency R_SettlmtDocDEX CustomerPaymentCurrency Customer Payment Currency for Automatic Payment
CustomerPaytCurrencyExchRate R_SettlmtDocDEX CustomerPaytCurrencyExchRate Exchange Rate of Customer Payment Currency (Not Converted)
SettlmtApplSts R_SettlmtDocDEX SettlmtApplSts Application Status for a Settlement Management Document
ExchangeRateType R_SettlmtDocDEX ExchangeRateType Exchange Rate Type
SalesOffice R_SettlmtDocDEX SalesOffice Sales Office
SalesGroup R_SettlmtDocDEX SalesGroup Sales Group
OneTimeCustomerAddressID R_SettlmtDocDEX OneTimeCustomerAddressID Address of One-Time Customer
OneTimeSupplierAddressID R_SettlmtDocDEX OneTimeSupplierAddressID Address of One-Time Supplier
SettlmtReltdCndnContr R_SettlmtDocDEX SettlmtReltdCndnContr Related Condition Contract in Settlement Management
SettlmtReltdTrdgContr R_SettlmtDocDEX SettlmtReltdTrdgContr Related Trading Contract in Settlement Management
SettlmtReltdPurgDoc R_SettlmtDocDEX SettlmtReltdPurgDoc Related Purchasing Document in Settlement Management
SettlmtReltdBillgDoc R_SettlmtDocDEX SettlmtReltdBillgDoc Related Billing Document in Settlement Management
SettlmtDocSmmrznCat R_SettlmtDocDEX SettlmtDocSmmrznCat Document Summarization Category
CreditControlAreaCurrency R_SettlmtDocDEX CreditControlAreaCurrency Currency of Credit Control Area
ReleasedCreditAmount R_SettlmtDocDEX ReleasedCreditAmount Released Credit Value of the Document
SettlmtClassificationCat R_SettlmtDocDEX SettlmtClassificationCat Settlement Classification Category
SettlmtPartnerCat R_SettlmtDocDEX SettlmtPartnerCat Settlement Partner Category
SupplierSettlmtStatus R_SettlmtDocDEX SupplierSettlmtStatus Settlement Status - Supplier
CustomerSettlmtStatus R_SettlmtDocDEX CustomerSettlmtStatus Settlement Status - Customer
SupplierSettlmtDocCat R_SettlmtDocDEX SupplierSettlmtDocCat Settlement Document Type - Supplier
CustomerSettlmtDocCat R_SettlmtDocDEX CustomerSettlmtDocCat Settlement Document Type - Customer
SupplierSettlmtBlkgReason R_SettlmtDocDEX SupplierSettlmtBlkgReason Reason for Supplier Settlement Block
CustomerSettlmtBlkgReason R_SettlmtDocDEX CustomerSettlmtBlkgReason Reason for Customer Settlement Block
FiscalPeriod R_SettlmtDocDEX FiscalPeriod Fiscal Period
TrdgExpnDocSettled R_SettlmtDocDEX TrdgExpnDocSettled Trading Expense Document Settled Indicator
TrdgExpnCurrency R_SettlmtDocDEX TrdgExpnCurrency Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
TrdgExpnAmount R_SettlmtDocDEX TrdgExpnAmount Reference Value for Trading Expenses
TrdgExpnSupplier R_SettlmtDocDEX TrdgExpnSupplier Trading Expense Supplier
TrdgExpnCustomer R_SettlmtDocDEX TrdgExpnCustomer Trading Expense Customer
CndnContrType R_SettlmtDocDEX CndnContrType Condition Contract Type
SettlmtDateCat R_SettlmtDocDEX SettlmtDateCat Rebates: Settlement Date Type
ActualSettlmtDate R_SettlmtDocDEX ActualSettlmtDate Actual Settlement Date
SettlmtDateSequentialID R_SettlmtDocDEX SettlmtDateSequentialID Settlement Date - Sequential ID
SettlmtDocIncmpltnsRsn R_SettlmtDocDEX SettlmtDocIncmpltnsRsn Incompleteness Reason of Settlement Management Document
AlternativeInvoicingParty R_SettlmtDocDEX AlternativeInvoicingParty Alternative Supplier
CombinedSettlmtPostgSts R_SettlmtDocDEX CombinedSettlmtPostgSts Posting Status for Combined Settlement
TaxDepartureCountry R_SettlmtDocDEX TaxDepartureCountry Tax Departure Country/Region
TaxDestinationCountry R_SettlmtDocDEX TaxDestinationCountry Tax Destination Country/Region
IsEUTriangularDeal R_SettlmtDocDEX IsEUTriangularDeal Indicator: Triangular Deal Within the EU
SupplierVATRegistration R_SettlmtDocDEX SupplierVATRegistration Supplier VAT Registration Number
CustomerVATRegistration R_SettlmtDocDEX CustomerVATRegistration Customer VAT Registration Number
IntrastatDeclnGdsFlwCat R_SettlmtDocDEX IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations
IncotermsVersion R_SettlmtDocDEX IncotermsVersion Incoterms Version
IncotermsClassification R_SettlmtDocDEX IncotermsClassification Incoterms (Part 1)
IncotermsTransferLocation R_SettlmtDocDEX IncotermsTransferLocation Incoterms (Part 2)
IncotermsLocation1 R_SettlmtDocDEX IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 R_SettlmtDocDEX IncotermsLocation2 Incoterms Location 2
SettlmtDate R_SettlmtDocDEX SettlmtDate Rebates: Settlement Date
SettlmtBusProcVar R_SettlmtDocDEX SettlmtBusProcVar Settlement Management Process Category
SettlmtDocCollSts R_SettlmtDocDEX SettlmtDocCollSts Collective Settlement Status of Settlement Documents
SettlmtDocIsCollvDoc R_SettlmtDocDEX SettlmtDocIsCollvDoc Indicator that Document is a Collective Document
CollSettlmtBlkgReason R_SettlmtDocDEX CollSettlmtBlkgReason Reason for Collective Settlement Block
SuplrSettlmtCoCodeTaxCountry R_SettlmtDocDEX SuplrSettlmtCoCodeTaxCountry Tax Country/Region Company Code
CustSettlmtCoCodeTaxCountry R_SettlmtDocDEX CustSettlmtCoCodeTaxCountry Tax Country/Region Company Code Customer
SettlmtBusProcCat R_SettlmtDocDEX SettlmtBusProcCat Use Case Type
SEPAMandate R_SettlmtDocDEX SEPAMandate Unique Reference to Mandate for each Payee
TotalSettlmtQuantityUnit R_SettlmtDocDEX TotalSettlmtQuantityUnit Unit of Measure for Total Quantity
TotalSettlmtQuantity R_SettlmtDocDEX TotalSettlmtQuantity Total Quantity of the Business Volume in a Settlement Run
TotalSettlmtWeightUnit R_SettlmtDocDEX TotalSettlmtWeightUnit Unit of Weight for Total Weight
TotalSettlmtNetWeight R_SettlmtDocDEX TotalSettlmtNetWeight Total Net Weight of the Business Volume in a Settlement Run
TotalSettlmtGrossWeight R_SettlmtDocDEX TotalSettlmtGrossWeight Total Gross Weight of the Bus Volume in a Settlement Run
TotalSettlmtVolumeUnit R_SettlmtDocDEX TotalSettlmtVolumeUnit Volume Unit for Total Volume
TotalSettlmtVolume R_SettlmtDocDEX TotalSettlmtVolume Total Volume of the Business Volume in a Settlement Run
TotalSettlmtPointsQtyUnit R_SettlmtDocDEX TotalSettlmtPointsQtyUnit Points Unit for Total Points
TotalSettlmtPointsQty R_SettlmtDocDEX TotalSettlmtPointsQty Total Points of the Business Volume in a Settlement Run
PostingPartnerCat R_SettlmtDocDEX PostingPartnerCat Posting Partner
SettlmtPeriodStartDate R_SettlmtDocDEX SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate R_SettlmtDocDEX SettlmtPeriodEndDate End Date of Settlement Period
CndnContrProcessCategory R_SettlmtDocDEX CndnContrProcessCategory Process Category of a Condition Contract
SettlmtApplStsGrp R_SettlmtDocDEX SettlmtApplStsGrp Status Group for Settlement Management Documents
SettlmtDocAuthznCat R_SettlmtDocDEX SettlmtDocAuthznCat Authorization Category
Product R_SettlmtDocDEX Product Product Sold
ProductGroup R_SettlmtDocDEX ProductGroup Product Sold Group
Plant R_SettlmtDocDEX Plant Valuation Area
SupplierTaxCode R_SettlmtDocDEX SupplierTaxCode Supplier Tax Code
CustomerTaxCode R_SettlmtDocDEX CustomerTaxCode Customer Tax Code
PricingDate R_SettlmtDocDEX PricingDate Date for Pricing and Exchange Rate
SettlmtQuantity R_SettlmtDocDEX SettlmtQuantity Quantity of Settlement Management Document Item
SettlmtQuantityUnit R_SettlmtDocDEX SettlmtQuantityUnit Unit of Measure of Settlement Management Doc Item Quantity
NetPriceAmount R_SettlmtDocDEX NetPriceAmount Net Price in Document Currency
NetPriceQuantityUnit R_SettlmtDocDEX NetPriceQuantityUnit Settlement Management Document Item Price Unit
NetPriceQuantity R_SettlmtDocDEX NetPriceQuantity Price Unit of Settlement Management Document Item
SettlmtToBaseQuantityNmrtr R_SettlmtDocDEX SettlmtToBaseQuantityNmrtr Numerator Converting Qty in Settlement Document to Base Unit
SettlmtToBaseQuantityDnmntr R_SettlmtDocDEX SettlmtToBaseQuantityDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit
SettlmtToNetPriceQtyNmrtr R_SettlmtDocDEX SettlmtToNetPriceQtyNmrtr Numerator for Converting Settl. UoM to Settl. Price UoM
SettlmtToNetPriceQtyDnmntr R_SettlmtDocDEX SettlmtToNetPriceQtyDnmntr Denominator for Converting Settl. UoM to Settl. Price UoM
BaseUnit R_SettlmtDocDEX BaseUnit Base Unit of Measure
ItemWeightUnit R_SettlmtDocDEX ItemWeightUnit Unit of Weight
ItemNetWeight R_SettlmtDocDEX ItemNetWeight Net Weight
ItemGrossWeight R_SettlmtDocDEX ItemGrossWeight Gross Weight
ItemVolumeUnit R_SettlmtDocDEX ItemVolumeUnit Volume Unit
ItemVolume R_SettlmtDocDEX ItemVolume Volume
SupplierItemGrossAmount R_SettlmtDocDEX SupplierItemGrossAmount Item Gross Amount for Supplier in Document Currency
SupplierItemNetAmount R_SettlmtDocDEX SupplierItemNetAmount Item Net Amount for Supplier in Document Currency
SupplierSubtotal1Amount R_SettlmtDocDEX SupplierSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal2Amount R_SettlmtDocDEX SupplierSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal3Amount R_SettlmtDocDEX SupplierSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal4Amount R_SettlmtDocDEX SupplierSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal5Amount R_SettlmtDocDEX SupplierSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Supplier
SupplierSubtotal6Amount R_SettlmtDocDEX SupplierSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Supplier
SupplierRebateBasisAmount R_SettlmtDocDEX SupplierRebateBasisAmount Rebate Basis of Supplier
SupplierEffectiveItemAmount R_SettlmtDocDEX SupplierEffectiveItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc R_SettlmtDocDEX SuplrItmEligibleAmtForCshDisc Cash Discount Base Amount for Item (Supplier-Side)
SupplierItemTaxAmount R_SettlmtDocDEX SupplierItemTaxAmount Item Tax Amount of Supplier in Document Currency
CustomerItemGrossAmount R_SettlmtDocDEX CustomerItemGrossAmount Item Gross Amount for Customer in Document Currency
CustomerItemNetAmount R_SettlmtDocDEX CustomerItemNetAmount Item Net Amount for Customer in Document Currency
CustomerSubtotal1Amount R_SettlmtDocDEX CustomerSubtotal1Amount Subtotal 1 from Prcg. Proced. for Condition of Customer
CustomerSubtotal2Amount R_SettlmtDocDEX CustomerSubtotal2Amount Subtotal 2 from Prcg. Proced. for Condition of Customer
CustomerSubtotal3Amount R_SettlmtDocDEX CustomerSubtotal3Amount Subtotal 3 from Prcg. Proced. for Condition of Customer
CustomerSubtotal4Amount R_SettlmtDocDEX CustomerSubtotal4Amount Subtotal 4 from Prcg. Proced. for Condition of Customer
CustomerSubtotal5Amount R_SettlmtDocDEX CustomerSubtotal5Amount Subtotal 5 from Prcg. Proced. for Condition of Customer
CustomerSubtotal6Amount R_SettlmtDocDEX CustomerSubtotal6Amount Subtotal 6 from Prcg. Proced. for Condition of Customer
CustomerRebateBasisAmount R_SettlmtDocDEX CustomerRebateBasisAmount Rebate Basis of Customer
CustomerEffectiveItemAmount R_SettlmtDocDEX CustomerEffectiveItemAmount Customer Effective Item Amount in Document Currency
CustItmEligibleAmtForCshDisc R_SettlmtDocDEX CustItmEligibleAmtForCshDisc Cash Discount Base Amount for Item (Customer-Side)
CustomerItemTaxAmount R_SettlmtDocDEX CustomerItemTaxAmount Item Tax Amount of Customer in Document Currency
SettlmtItmStatisticalPrpty R_SettlmtDocDEX SettlmtItmStatisticalPrpty Statistical Property of Settlement Management Item
CashDiscountIsDeductible R_SettlmtDocDEX CashDiscountIsDeductible Cash Discount Indicator
SettlmtSourceDoc R_SettlmtDocDEX SettlmtSourceDoc Document Number of the Source Document
SettlmtSourceDocItem R_SettlmtDocDEX SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat R_SettlmtDocDEX SettlmtSourceDocCat Document Category of Source Document
SettlmtSourceDocFiscalYear R_SettlmtDocDEX SettlmtSourceDocFiscalYear Fiscal Year of a Source Document in Settlement Management
SettlmtItemActivityReason R_SettlmtDocDEX SettlmtItemActivityReason Activity Reason for Document Creation
SettlmtDocItemText R_SettlmtDocDEX SettlmtDocItemText Short Text
SupplierProductID R_SettlmtDocDEX SupplierProductID Material Number Used by Supplier
TaxJurisdiction R_SettlmtDocDEX TaxJurisdiction Tax Jurisdiction
ProductPurchasePointsQtyUnit R_SettlmtDocDEX ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty R_SettlmtDocDEX ProductPurchasePointsQty Number of Points
PriorSupplier R_SettlmtDocDEX PriorSupplier Prior Supplier
NonDeductibleInputTaxAmount R_SettlmtDocDEX NonDeductibleInputTaxAmount Non-Deductible Input Tax for Item
InventoryValuationType R_SettlmtDocDEX InventoryValuationType Valuation Type
SuplrSettlmtBusinessArea R_SettlmtDocDEX SuplrSettlmtBusinessArea Business Area
CustSettlmtBusinessArea R_SettlmtDocDEX CustSettlmtBusinessArea Customer Business Area
SuplrSettlmtControllingArea R_SettlmtDocDEX SuplrSettlmtControllingArea Controlling Area
SuplrSettlmtCostCenter R_SettlmtDocDEX SuplrSettlmtCostCenter Cost Center
SuplrSettlmtProfitCenter R_SettlmtDocDEX SuplrSettlmtProfitCenter Profit Center
CustSettlmtControllingArea R_SettlmtDocDEX CustSettlmtControllingArea Customer Controlling Area
CustSettlmtCostCenter R_SettlmtDocDEX CustSettlmtCostCenter Customer Cost Center
CustSettlmtProfitCenter R_SettlmtDocDEX CustSettlmtProfitCenter Alternative Customer Profit Center
Batch R_SettlmtDocDEX Batch Batch Number
SupplierPrcDetnIsIncmplt R_SettlmtDocDEX SupplierPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Supplier
CustomerPrcDetnIsIncmplt R_SettlmtDocDEX CustomerPrcDetnIsIncmplt Item Pricing Incompleteness Indicator for Customer
SettlmtPrecdgDoc R_SettlmtDocDEX SettlmtPrecdgDoc Preceding Document of the Settlement Management Document
SettlmtPrecdgDocItem R_SettlmtDocDEX SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat R_SettlmtDocDEX SettlmtPrecdgDocCat Document Category of Preceding Document
SettlmtPrecdgDocFiscalYear R_SettlmtDocDEX SettlmtPrecdgDocFiscalYear Fiscal Year of a Preceding Document in Settlement Management
SettlmtDocItemCat R_SettlmtDocDEX SettlmtDocItemCat Item Category
SettlmtItemReltdCndnContr R_SettlmtDocDEX SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item
SettlmtItemReltdTrdgContr R_SettlmtDocDEX SettlmtItemReltdTrdgContr Related Trading Contract of a Settlement Management Item
SettlmtItemReltdTrdgContrItem R_SettlmtDocDEX SettlmtItemReltdTrdgContrItem Related Trading Contract Item of a Settlmt Mgmt Item
SettlmtItemReltdPurgDoc R_SettlmtDocDEX SettlmtItemReltdPurgDoc Related Purchasing Document of a Settlement Management Item
SettlmtItemReltdPurgDocItem R_SettlmtDocDEX SettlmtItemReltdPurgDocItem Related Purchasing Document Item of a Settlmt Mgmt Item
SettlmtItemReltdBillgDoc R_SettlmtDocDEX SettlmtItemReltdBillgDoc Related Billing Document of a Settlement Management Item
SettlmtItemReltdBillgDocItem R_SettlmtDocDEX SettlmtItemReltdBillgDocItem Related Billing Document Item of a Settlmt Mgmt Item
SettlmtDocItemStatus R_SettlmtDocDEX SettlmtDocItemStatus Item Status
SettlmtDocItemCancld R_SettlmtDocDEX SettlmtDocItemCancld Item Was Canceled
SupplierSettlementOrder R_SettlmtDocDEX SupplierSettlementOrder Order for Account Assignment
SupplierItemSettlmtStatus R_SettlmtDocDEX SupplierItemSettlmtStatus Settlement Status - Item - Supplier
CustomerItemSettlmtStatus R_SettlmtDocDEX CustomerItemSettlmtStatus Settlement Status - Item - Customer
SupplierItemSettlmtBlkgReason R_SettlmtDocDEX SupplierItemSettlmtBlkgReason Reason for Supplier Settlement Block at Item
CustomerItemSettlmtBlkgReason R_SettlmtDocDEX CustomerItemSettlmtBlkgReason Reason for Customer Settlement Block at Item
ItemSettlmtRelevance R_SettlmtDocDEX ItemSettlmtRelevance Item Settlement Relevance
ServicesRenderedDate R_SettlmtDocDEX ServicesRenderedDate Date of Services Rendered
GLAccount R_SettlmtDocDEX GLAccount General Ledger
SettlementFiscalYear R_SettlmtDocDEX SettlementFiscalYear Fiscal Year of Settlement
HigherLevelItem R_SettlmtDocDEX HigherLevelItem Higher-Level Item in Bill of Material Structures
LowerLevelItemExists R_SettlmtDocDEX LowerLevelItemExists Subitems Exist
ItemDistributionStatus R_SettlmtDocDEX ItemDistributionStatus Distribution Status of Settlement Item
SettlmtRefDoc R_SettlmtDocDEX SettlmtRefDoc Reference Document for Settlement Management
SettlmtRefDocFiscalYear R_SettlmtDocDEX SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst R_SettlmtDocDEX SettlmtRefDocLogicalSyst Logical System of Reference Document for Smt Mgmt
SettlmtRefDocCompanyCode R_SettlmtDocDEX SettlmtRefDocCompanyCode Company Code of Reference Document for Settlement Management
SettlmtRefDocItem R_SettlmtDocDEX SettlmtRefDocItem Reference Document Item for Settlement Management Document
SettlmtRefDocCat R_SettlmtDocDEX SettlmtRefDocCat Reference Document Category in Settlement Management
ItemIntrastatRelevance R_SettlmtDocDEX ItemIntrastatRelevance Document Item Is Relevant for Intrastat Declarations
CustomerSettlementOrder R_SettlmtDocDEX CustomerSettlementOrder Order for Customer-Related Account Assignment
SuplrSettlmtWBSElmntInternalID R_SettlmtDocDEX SuplrSettlmtWBSElmntInternalID Work Breakdown Structure Element (WBS Element) not converted
CustSettlmtWBSElmntInternalID R_SettlmtDocDEX CustSettlmtWBSElmntInternalID Cust Work Breakdown Struct Elmnt (WBS Element) not converted
SettlmtDocItemCollSts R_SettlmtDocDEX SettlmtDocItemCollSts Status for Collection of Settlement Document Item
CollSettlmtItemBlkgReason R_SettlmtDocDEX CollSettlmtItemBlkgReason Reason for Collective Settlement Item Block
ItmSettlmtDocCollRelevance R_SettlmtDocDEX ItmSettlmtDocCollRelevance Collective Settlement Relevance of Settlement Documents
SettlmtAddlRefDoc R_SettlmtDocDEX SettlmtAddlRefDoc Additional Reference Document for Settlement Management
SettlmtAddlRefDocFiscalYear R_SettlmtDocDEX SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst R_SettlmtDocDEX SettlmtAddlRefDocLogicalSyst Logical System of Additional Reference Document for Smt Mgmt
SettlmtAddlRefDocItem R_SettlmtDocDEX SettlmtAddlRefDocItem Additional Reference Doc Item for Settlement Mgmt. Document
SettlmtAddlRefDocCat R_SettlmtDocDEX SettlmtAddlRefDocCat Additional Reference Document Category
CustomerSettlmtRecipient R_SettlmtDocDEX CustomerSettlmtRecipient Customer Settlement Recipient
SupplierSubrange R_SettlmtDocDEX SupplierSubrange Supplier Subrange
ProductHierarchy R_SettlmtDocDEX ProductHierarchy Product Hierarchy
SalesSpcfcProductGroup1 R_SettlmtDocDEX SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 R_SettlmtDocDEX SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 R_SettlmtDocDEX SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 R_SettlmtDocDEX SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 R_SettlmtDocDEX SalesSpcfcProductGroup5 Sales-Specific Product Group 5
BusVolDocSalesOrganization R_SettlmtDocDEX BusVolDocSalesOrganization Sales Organization In a Business Volume Document
BusVolDocDistributionChannel R_SettlmtDocDEX BusVolDocDistributionChannel Distribution Channel In a Business Volume Document
BusVolDocDivision R_SettlmtDocDEX BusVolDocDivision Division In a Business Volume Document
ProductCommissionGroup R_SettlmtDocDEX ProductCommissionGroup Commission Group
PriceSpecificationProductGroup R_SettlmtDocDEX PriceSpecificationProductGroup Product Pricing Group
SalesVolumeRebateGroup R_SettlmtDocDEX SalesVolumeRebateGroup Sales Volume Rebate Group
_BillToParty R_SettlmtDocDEX _BillToParty
_BillToPartyCompany R_SettlmtDocDEX _BillToPartyCompany
_PayerParty R_SettlmtDocDEX _PayerParty
_PayerPartyCompany R_SettlmtDocDEX _PayerPartyCompany
_InvoicingParty R_SettlmtDocDEX _InvoicingParty
_InvoicingPartyCompany R_SettlmtDocDEX _InvoicingPartyCompany
_PayeeParty R_SettlmtDocDEX _PayeeParty
_PayeePartyCompany R_SettlmtDocDEX _PayeePartyCompany
_AlternativeInvoicingParty R_SettlmtDocDEX _AlternativeInvoicingParty
_AltvInvoicingPartyCompany R_SettlmtDocDEX _AltvInvoicingPartyCompany

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SettlmtDocDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_SettlmtDocDEX AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  SettlmtDocDex.SettlmtDocType AS SettlmtDocType,
  SettlmtDocDex.SettlmtDocCat AS SettlmtDocCat,
  SettlmtDocDex.SettlmtProcessType AS SettlmtProcessType,
  SettlmtDocDex.SettlmtProcessCat AS SettlmtProcessCat,
  SettlmtDocDex.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SettlmtDocDex.SettlmtCat AS SettlmtCat,
  SettlmtDocDex.SupplierPricingProcedure AS SupplierPricingProcedure,
  SettlmtDocDex.CustomerPricingProcedure AS CustomerPricingProcedure,
  SettlmtDocDex.PostingDate AS PostingDate,
  SettlmtDocDex.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
  SettlmtDocDex.InvoicingParty AS InvoicingParty,
  SettlmtDocDex.PayeeParty AS PayeeParty,
  SettlmtDocDex.BillToParty AS BillToParty,
  SettlmtDocDex.PayerParty AS PayerParty,
  SettlmtDocDex.PurchasingOrganization AS PurchasingOrganization,
  SettlmtDocDex.PurchasingGroup AS PurchasingGroup,
  SettlmtDocDex.SalesOrganization AS SalesOrganization,
  SettlmtDocDex.DistributionChannel AS DistributionChannel,
  SettlmtDocDex.Division AS Division,
  SettlmtDocDex.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
  SettlmtDocDex.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
  SettlmtDocDex.CreatedByUser AS CreatedByUser,
  SettlmtDocDex.CreationDate AS CreationDate,
  SettlmtDocDex.CreationTime AS CreationTime,
  SettlmtDocDex.LastChangeDate AS LastChangeDate,
  SettlmtDocDex.DocumentDate AS DocumentDate,
  SettlmtDocDex.DocumentReferenceID AS DocumentReferenceID,
  SettlmtDocDex.AssignmentReference AS AssignmentReference,
  SettlmtDocDex.SettlmtDocCurrency AS SettlmtDocCurrency,
  SettlmtDocDex.ExchangeRate AS ExchangeRate,
  SettlmtDocDex.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SettlmtDocDex.ExchangeRateDate AS ExchangeRateDate,
  SettlmtDocDex.SupplierTotalGrossAmount AS SupplierTotalGrossAmount,
  SettlmtDocDex.SupplierTotalNetAmount AS SupplierTotalNetAmount,
  SettlmtDocDex.CustomerTotalGrossAmount AS CustomerTotalGrossAmount,
  SettlmtDocDex.CustomerTotalNetAmount AS CustomerTotalNetAmount,
  SettlmtDocDex.SupplierPaymentTerms AS SupplierPaymentTerms,
  SettlmtDocDex.SupplierCashDiscount1Days AS SupplierCashDiscount1Days,
  SettlmtDocDex.SupplierCashDiscount2Days AS SupplierCashDiscount2Days,
  SettlmtDocDex.SupplierNetPaymentDays AS SupplierNetPaymentDays,
  SettlmtDocDex.SupplierCashDiscount1Percent AS SupplierCashDiscount1Percent,
  SettlmtDocDex.SupplierCashDiscount2Percent AS SupplierCashDiscount2Percent,
  SettlmtDocDex.SupplierPaymentMethod AS SupplierPaymentMethod,
  SettlmtDocDex.CustomerPaymentTerms AS CustomerPaymentTerms,
  SettlmtDocDex.CustomerCashDiscount1Days AS CustomerCashDiscount1Days,
  SettlmtDocDex.CustomerCashDiscount2Days AS CustomerCashDiscount2Days,
  SettlmtDocDex.CustomerNetPaymentDays AS CustomerNetPaymentDays,
  SettlmtDocDex.CustomerCashDiscount1Percent AS CustomerCashDiscount1Percent,
  SettlmtDocDex.CustomerCashDiscount2Percent AS CustomerCashDiscount2Percent,
  SettlmtDocDex.CustomerPaymentMethod AS CustomerPaymentMethod,
  SettlmtDocDex.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
  SettlmtDocDex.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  SettlmtDocDex.SettlmtDocIsCanceled AS SettlmtDocIsCanceled,
  SettlmtDocDex.CanceledSettlmtDoc AS CanceledSettlmtDoc,
  SettlmtDocDex.SupplierPricingDocument AS SupplierPricingDocument,
  SettlmtDocDex.CustomerPricingDocument AS CustomerPricingDocument,
  SettlmtDocDex.SupplierAdditionalValueDays AS SupplierAdditionalValueDays,
  SettlmtDocDex.SupplierFixedValueDate AS SupplierFixedValueDate,
  SettlmtDocDex.CustomerAdditionalValueDays AS CustomerAdditionalValueDays,
  SettlmtDocDex.CustomerFixedValueDate AS CustomerFixedValueDate,
  SettlmtDocDex.SupplierTotalTaxAmount AS SupplierTotalTaxAmount,
  SettlmtDocDex.CustomerTotalTaxAmount AS CustomerTotalTaxAmount,
  SettlmtDocDex.SupplyingCountry AS SupplyingCountry,
  SettlmtDocDex.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SettlmtDocDex.CreditControlArea AS CreditControlArea,
  SettlmtDocDex.SettlmtDocActivityReason AS SettlmtDocActivityReason,
  SettlmtDocDex.PaymentReference AS PaymentReference,
  SettlmtDocDex.SupplierPaymentCurrency AS SupplierPaymentCurrency,
  SettlmtDocDex.SupplierPaytCurrencyExchRate AS SupplierPaytCurrencyExchRate,
  SettlmtDocDex.CustomerPaymentCurrency AS CustomerPaymentCurrency,
  SettlmtDocDex.CustomerPaytCurrencyExchRate AS CustomerPaytCurrencyExchRate,
  SettlmtDocDex.SettlmtApplSts AS SettlmtApplSts,
  SettlmtDocDex.ExchangeRateType AS ExchangeRateType,
  SettlmtDocDex.SalesOffice AS SalesOffice,
  SettlmtDocDex.SalesGroup AS SalesGroup,
  SettlmtDocDex.OneTimeCustomerAddressID AS OneTimeCustomerAddressID,
  SettlmtDocDex.OneTimeSupplierAddressID AS OneTimeSupplierAddressID,
  SettlmtDocDex.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  SettlmtDocDex.SettlmtReltdTrdgContr AS SettlmtReltdTrdgContr,
  SettlmtDocDex.SettlmtReltdPurgDoc AS SettlmtReltdPurgDoc,
  SettlmtDocDex.SettlmtReltdBillgDoc AS SettlmtReltdBillgDoc,
  SettlmtDocDex.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
  SettlmtDocDex.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  SettlmtDocDex.ReleasedCreditAmount AS ReleasedCreditAmount,
  SettlmtDocDex.SettlmtClassificationCat AS SettlmtClassificationCat,
  SettlmtDocDex.SettlmtPartnerCat AS SettlmtPartnerCat,
  SettlmtDocDex.SupplierSettlmtStatus AS SupplierSettlmtStatus,
  SettlmtDocDex.CustomerSettlmtStatus AS CustomerSettlmtStatus,
  SettlmtDocDex.SupplierSettlmtDocCat AS SupplierSettlmtDocCat,
  SettlmtDocDex.CustomerSettlmtDocCat AS CustomerSettlmtDocCat,
  SettlmtDocDex.SupplierSettlmtBlkgReason AS SupplierSettlmtBlkgReason,
  SettlmtDocDex.CustomerSettlmtBlkgReason AS CustomerSettlmtBlkgReason,
  SettlmtDocDex.FiscalPeriod AS FiscalPeriod,
  SettlmtDocDex.TrdgExpnDocSettled AS TrdgExpnDocSettled,
  SettlmtDocDex.TrdgExpnCurrency AS TrdgExpnCurrency,
  SettlmtDocDex.TrdgExpnAmount AS TrdgExpnAmount,
  SettlmtDocDex.TrdgExpnSupplier AS TrdgExpnSupplier,
  SettlmtDocDex.TrdgExpnCustomer AS TrdgExpnCustomer,
  SettlmtDocDex.CndnContrType AS CndnContrType,
  SettlmtDocDex.SettlmtDateCat AS SettlmtDateCat,
  SettlmtDocDex.ActualSettlmtDate AS ActualSettlmtDate,
  SettlmtDocDex.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  SettlmtDocDex.SettlmtDocIncmpltnsRsn AS SettlmtDocIncmpltnsRsn,
  SettlmtDocDex.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SettlmtDocDex.CombinedSettlmtPostgSts AS CombinedSettlmtPostgSts,
  SettlmtDocDex.TaxDepartureCountry AS TaxDepartureCountry,
  SettlmtDocDex.TaxDestinationCountry AS TaxDestinationCountry,
  SettlmtDocDex.IsEUTriangularDeal AS IsEUTriangularDeal,
  SettlmtDocDex.SupplierVATRegistration AS SupplierVATRegistration,
  SettlmtDocDex.CustomerVATRegistration AS CustomerVATRegistration,
  SettlmtDocDex.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SettlmtDocDex.IncotermsVersion AS IncotermsVersion,
  SettlmtDocDex.IncotermsClassification AS IncotermsClassification,
  SettlmtDocDex.IncotermsTransferLocation AS IncotermsTransferLocation,
  SettlmtDocDex.IncotermsLocation1 AS IncotermsLocation1,
  SettlmtDocDex.IncotermsLocation2 AS IncotermsLocation2,
  SettlmtDocDex.SettlmtDate AS SettlmtDate,
  SettlmtDocDex.SettlmtBusProcVar AS SettlmtBusProcVar,
  SettlmtDocDex.SettlmtDocCollSts AS SettlmtDocCollSts,
  SettlmtDocDex.SettlmtDocIsCollvDoc AS SettlmtDocIsCollvDoc,
  SettlmtDocDex.CollSettlmtBlkgReason AS CollSettlmtBlkgReason,
  SettlmtDocDex.SuplrSettlmtCoCodeTaxCountry AS SuplrSettlmtCoCodeTaxCountry,
  SettlmtDocDex.CustSettlmtCoCodeTaxCountry AS CustSettlmtCoCodeTaxCountry,
  SettlmtDocDex.SettlmtBusProcCat AS SettlmtBusProcCat,
  SettlmtDocDex.SEPAMandate AS SEPAMandate,
  SettlmtDocDex.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  SettlmtDocDex.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  SettlmtDocDex.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  SettlmtDocDex.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  SettlmtDocDex.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  SettlmtDocDex.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  SettlmtDocDex.TotalSettlmtVolume AS TotalSettlmtVolume,
  SettlmtDocDex.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  SettlmtDocDex.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  SettlmtDocDex.PostingPartnerCat AS PostingPartnerCat,
  SettlmtDocDex.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  SettlmtDocDex.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  SettlmtDocDex.CndnContrProcessCategory AS CndnContrProcessCategory,
  SettlmtDocDex.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  SettlmtDocDex.SettlmtDocAuthznCat AS SettlmtDocAuthznCat,
  SettlmtDocDex.Product AS Product,
  SettlmtDocDex.ProductGroup AS ProductGroup,
  SettlmtDocDex.Plant AS Plant,
  SettlmtDocDex.SupplierTaxCode AS SupplierTaxCode,
  SettlmtDocDex.CustomerTaxCode AS CustomerTaxCode,
  SettlmtDocDex.PricingDate AS PricingDate,
  SettlmtDocDex.SettlmtQuantity AS SettlmtQuantity,
  SettlmtDocDex.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  SettlmtDocDex.NetPriceAmount AS NetPriceAmount,
  SettlmtDocDex.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SettlmtDocDex.NetPriceQuantity AS NetPriceQuantity,
  SettlmtDocDex.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  SettlmtDocDex.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  SettlmtDocDex.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  SettlmtDocDex.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  SettlmtDocDex.BaseUnit AS BaseUnit,
  SettlmtDocDex.ItemWeightUnit AS ItemWeightUnit,
  SettlmtDocDex.ItemNetWeight AS ItemNetWeight,
  SettlmtDocDex.ItemGrossWeight AS ItemGrossWeight,
  SettlmtDocDex.ItemVolumeUnit AS ItemVolumeUnit,
  SettlmtDocDex.ItemVolume AS ItemVolume,
  SettlmtDocDex.SupplierItemGrossAmount AS SupplierItemGrossAmount,
  SettlmtDocDex.SupplierItemNetAmount AS SupplierItemNetAmount,
  SettlmtDocDex.SupplierSubtotal1Amount AS SupplierSubtotal1Amount,
  SettlmtDocDex.SupplierSubtotal2Amount AS SupplierSubtotal2Amount,
  SettlmtDocDex.SupplierSubtotal3Amount AS SupplierSubtotal3Amount,
  SettlmtDocDex.SupplierSubtotal4Amount AS SupplierSubtotal4Amount,
  SettlmtDocDex.SupplierSubtotal5Amount AS SupplierSubtotal5Amount,
  SettlmtDocDex.SupplierSubtotal6Amount AS SupplierSubtotal6Amount,
  SettlmtDocDex.SupplierRebateBasisAmount AS SupplierRebateBasisAmount,
  SettlmtDocDex.SupplierEffectiveItemAmount AS SupplierEffectiveItemAmount,
  SettlmtDocDex.SuplrItmEligibleAmtForCshDisc AS SuplrItmEligibleAmtForCshDisc,
  SettlmtDocDex.SupplierItemTaxAmount AS SupplierItemTaxAmount,
  SettlmtDocDex.CustomerItemGrossAmount AS CustomerItemGrossAmount,
  SettlmtDocDex.CustomerItemNetAmount AS CustomerItemNetAmount,
  SettlmtDocDex.CustomerSubtotal1Amount AS CustomerSubtotal1Amount,
  SettlmtDocDex.CustomerSubtotal2Amount AS CustomerSubtotal2Amount,
  SettlmtDocDex.CustomerSubtotal3Amount AS CustomerSubtotal3Amount,
  SettlmtDocDex.CustomerSubtotal4Amount AS CustomerSubtotal4Amount,
  SettlmtDocDex.CustomerSubtotal5Amount AS CustomerSubtotal5Amount,
  SettlmtDocDex.CustomerSubtotal6Amount AS CustomerSubtotal6Amount,
  SettlmtDocDex.CustomerRebateBasisAmount AS CustomerRebateBasisAmount,
  SettlmtDocDex.CustomerEffectiveItemAmount AS CustomerEffectiveItemAmount,
  SettlmtDocDex.CustItmEligibleAmtForCshDisc AS CustItmEligibleAmtForCshDisc,
  SettlmtDocDex.CustomerItemTaxAmount AS CustomerItemTaxAmount,
  SettlmtDocDex.SettlmtItmStatisticalPrpty AS SettlmtItmStatisticalPrpty,
  SettlmtDocDex.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  SettlmtDocDex.SettlmtSourceDoc AS SettlmtSourceDoc,
  SettlmtDocDex.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  SettlmtDocDex.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  SettlmtDocDex.SettlmtSourceDocFiscalYear AS SettlmtSourceDocFiscalYear,
  SettlmtDocDex.SettlmtItemActivityReason AS SettlmtItemActivityReason,
  SettlmtDocDex.SettlmtDocItemText AS SettlmtDocItemText,
  SettlmtDocDex.SupplierProductID AS SupplierProductID,
  SettlmtDocDex.TaxJurisdiction AS TaxJurisdiction,
  SettlmtDocDex.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  SettlmtDocDex.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  SettlmtDocDex.PriorSupplier AS PriorSupplier,
  SettlmtDocDex.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  SettlmtDocDex.InventoryValuationType AS InventoryValuationType,
  SettlmtDocDex.SuplrSettlmtBusinessArea AS SuplrSettlmtBusinessArea,
  SettlmtDocDex.CustSettlmtBusinessArea AS CustSettlmtBusinessArea,
  SettlmtDocDex.SuplrSettlmtControllingArea AS SuplrSettlmtControllingArea,
  SettlmtDocDex.SuplrSettlmtCostCenter AS SuplrSettlmtCostCenter,
  SettlmtDocDex.SuplrSettlmtProfitCenter AS SuplrSettlmtProfitCenter,
  SettlmtDocDex.CustSettlmtControllingArea AS CustSettlmtControllingArea,
  SettlmtDocDex.CustSettlmtCostCenter AS CustSettlmtCostCenter,
  SettlmtDocDex.CustSettlmtProfitCenter AS CustSettlmtProfitCenter,
  SettlmtDocDex.Batch AS Batch,
  SettlmtDocDex.SupplierPrcDetnIsIncmplt AS SupplierPrcDetnIsIncmplt,
  SettlmtDocDex.CustomerPrcDetnIsIncmplt AS CustomerPrcDetnIsIncmplt,
  SettlmtDocDex.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  SettlmtDocDex.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  SettlmtDocDex.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  SettlmtDocDex.SettlmtPrecdgDocFiscalYear AS SettlmtPrecdgDocFiscalYear,
  SettlmtDocDex.SettlmtDocItemCat AS SettlmtDocItemCat,
  SettlmtDocDex.SettlmtItemReltdCndnContr AS SettlmtItemReltdCndnContr,
  SettlmtDocDex.SettlmtItemReltdTrdgContr AS SettlmtItemReltdTrdgContr,
  SettlmtDocDex.SettlmtItemReltdTrdgContrItem AS SettlmtItemReltdTrdgContrItem,
  SettlmtDocDex.SettlmtItemReltdPurgDoc AS SettlmtItemReltdPurgDoc,
  SettlmtDocDex.SettlmtItemReltdPurgDocItem AS SettlmtItemReltdPurgDocItem,
  SettlmtDocDex.SettlmtItemReltdBillgDoc AS SettlmtItemReltdBillgDoc,
  SettlmtDocDex.SettlmtItemReltdBillgDocItem AS SettlmtItemReltdBillgDocItem,
  SettlmtDocDex.SettlmtDocItemStatus AS SettlmtDocItemStatus,
  SettlmtDocDex.SettlmtDocItemCancld AS SettlmtDocItemCancld,
  SettlmtDocDex.SupplierSettlementOrder AS SupplierSettlementOrder,
  SettlmtDocDex.SupplierItemSettlmtStatus AS SupplierItemSettlmtStatus,
  SettlmtDocDex.CustomerItemSettlmtStatus AS CustomerItemSettlmtStatus,
  SettlmtDocDex.SupplierItemSettlmtBlkgReason AS SupplierItemSettlmtBlkgReason,
  SettlmtDocDex.CustomerItemSettlmtBlkgReason AS CustomerItemSettlmtBlkgReason,
  SettlmtDocDex.ItemSettlmtRelevance AS ItemSettlmtRelevance,
  SettlmtDocDex.ServicesRenderedDate AS ServicesRenderedDate,
  SettlmtDocDex.GLAccount AS GLAccount,
  SettlmtDocDex.SettlementFiscalYear AS SettlementFiscalYear,
  SettlmtDocDex.HigherLevelItem AS HigherLevelItem,
  SettlmtDocDex.LowerLevelItemExists AS LowerLevelItemExists,
  SettlmtDocDex.ItemDistributionStatus AS ItemDistributionStatus,
  SettlmtDocDex.SettlmtRefDoc AS SettlmtRefDoc,
  SettlmtDocDex.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  SettlmtDocDex.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  SettlmtDocDex.SettlmtRefDocCompanyCode AS SettlmtRefDocCompanyCode,
  SettlmtDocDex.SettlmtRefDocItem AS SettlmtRefDocItem,
  SettlmtDocDex.SettlmtRefDocCat AS SettlmtRefDocCat,
  SettlmtDocDex.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  SettlmtDocDex.CustomerSettlementOrder AS CustomerSettlementOrder,
  SettlmtDocDex.SuplrSettlmtWBSElmntInternalID AS SuplrSettlmtWBSElmntInternalID,
  SettlmtDocDex.CustSettlmtWBSElmntInternalID AS CustSettlmtWBSElmntInternalID,
  SettlmtDocDex.SettlmtDocItemCollSts AS SettlmtDocItemCollSts,
  SettlmtDocDex.CollSettlmtItemBlkgReason AS CollSettlmtItemBlkgReason,
  SettlmtDocDex.ItmSettlmtDocCollRelevance AS ItmSettlmtDocCollRelevance,
  SettlmtDocDex.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  SettlmtDocDex.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  SettlmtDocDex.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  SettlmtDocDex.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  SettlmtDocDex.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  SettlmtDocDex.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  SettlmtDocDex.SupplierSubrange AS SupplierSubrange,
  SettlmtDocDex.ProductHierarchy AS ProductHierarchy,
  SettlmtDocDex.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  SettlmtDocDex.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  SettlmtDocDex.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  SettlmtDocDex.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  SettlmtDocDex.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  SettlmtDocDex.BusVolDocSalesOrganization AS BusVolDocSalesOrganization,
  SettlmtDocDex.BusVolDocDistributionChannel AS BusVolDocDistributionChannel,
  SettlmtDocDex.BusVolDocDivision AS BusVolDocDivision,
  SettlmtDocDex.ProductCommissionGroup AS ProductCommissionGroup,
  SettlmtDocDex.PriceSpecificationProductGroup AS PriceSpecificationProductGroup,
  SettlmtDocDex.SalesVolumeRebateGroup AS SalesVolumeRebateGroup,
  SettlmtDocDex._BillToParty AS _BillToParty,
  SettlmtDocDex._BillToPartyCompany AS _BillToPartyCompany,
  SettlmtDocDex._PayerParty AS _PayerParty,
  SettlmtDocDex._PayerPartyCompany AS _PayerPartyCompany,
  SettlmtDocDex._InvoicingParty AS _InvoicingParty,
  SettlmtDocDex._InvoicingPartyCompany AS _InvoicingPartyCompany,
  SettlmtDocDex._PayeeParty AS _PayeeParty,
  SettlmtDocDex._PayeePartyCompany AS _PayeePartyCompany,
  SettlmtDocDex._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  SettlmtDocDex._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany
FROM R_SettlmtDocDEX AS SettlmtDocDex
;

Learn More