What is C_CustSettlmtDEX in SAP S/4HANA?

C_CustSettlmtDEX is a consumption CDS view in SAP S/4HANA. Customer Settlement Extraction It contains 182 fields.

Which tables does C_CustSettlmtDEX read from?

C_CustSettlmtDEX reads data from: R_CustSettlmtDEX.

What VDM layer is C_CustSettlmtDEX?

C_CustSettlmtDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CustSettlmtDEX

DDL: C_CUSTSETTLMTDEX Type: view_entity CONSUMPTION Package: WZRE

182 Fields 1 Data Sources

Customer Settlement Extraction

C_CustSettlmtDEX (Consumption)

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

Customer Settlement · Sales

C_CustSettlmtDEX is a Consumption CDS View (Fact) that provides data about "Customer Settlement Extraction" in SAP S/4HANA. It reads from 1 data source (R_CustSettlmtDEX) and exposes 182 fields with key fields CustSettlmt, CustSettlmtItem. Part of development package WZRE.

SAP Help Documentation

Category	Customer Settlement
Data Category	Fact
Status	Released

Purpose
This CDS view supports data extraction to SAP BW/4HANA. It enables the data transfer to SAP BW/4HANA for customer settlements. Providing all relevant customer settlement information, this CDS view also allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which customer settlements 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 In order to use this CDS View as a basis for data extraction, the settlement document types of the corresponding customer settlements must be enabled for SAP BW/4HANA data extraction in Customizing for Settlement Management under Settlement Documents Settlement Document Types . Users must have the following authorization objects assigned: Authorization Object: W_WBRK_FKA Authorization required for Settlement Document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Company Code ( BUKRS ) Sales Organization ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART ) Authorization Object: F_KNA1_BED Authorization group needs to be maintained for the following: Payer Party Payer Party Company Bill-To Party Bill-To Party Company

Structure
Object types This CDS view is built on the following business object: Customer Settlement ( CustomerSettlement ). The key fields are: CustSettlmt CustSettlmtItem Measures and attributes Some important measures and attributes are: Customer settlement number ( CustSettlmt ) Customer settlement item number ( CustSettlmtItem ) Product ( Product ) Plant ( Plant ) Item category ( CustSettlmtItmCat ) Document currency ( CustSettlmtCurrency ) Customer settlement item gross amount ( CustSettlmtItemGrossAmount ) Customer settlement item net amount ( CustSettlmtItemNetAmount ) Customer settlement item tax amount ( CustSettlmtItemTaxAmount ) Settlement quantity ( SettlmtQuantity ) Unit of measure of settlement quantity ( SettlmtQuantityUnit )

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables) Delta (change data capture) Corresponding DataSource (Extractor) 2LIS_45_HDR 2LIS_45_ITM Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

Constraints
This CDS view only displays documents for which the relevant settlement document types were enabled for SAP BW/4HANA data extraction in Customizing. Documents related to other settlement document types will not be displayed. Once data extraction is activated in SAP BW/4HANA and you would like to make any changes in Customizing, for example removing the BW4HANA Extraction flag, please note that your changes will not be included in the next delta extraction. The data that would be affected by your change will not be removed in SAP BW/4HANA. If you want to remove these entries, you must execute a full extraction.

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Sales
Application Component	LO-AB
Capabilities	Data Source for Data Extraction,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Sales for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_CustSettlmtDEX	CustSettlmtDEX	from

Annotations (13)

Name	Value	Level
EndUserText.label	Customer Settlement Extraction	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.compositionRoot	true	view
ObjectModel.modelingPattern	#ANALYTICAL_FACT	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.sapObjectNodeType.name	CustomerSettlement	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	false	view

Fields (182)

Key	Field	Source Table	Source Field	Description
KEY	CustSettlmt		CustSettlmt	Customer Settlement
KEY	CustSettlmtItem		CustSettlmtItem	Document Item
	SettlmtDocType	R_CustSettlmtDEX	SettlmtDocType	Settlement Document Type
	SettlmtDocCat	R_CustSettlmtDEX	SettlmtDocCat	Settlement Document Category
	SettlmtProcessType	R_CustSettlmtDEX	SettlmtProcessType	Settlement Process Type
	LogisticsDataEntryCat	R_CustSettlmtDEX	LogisticsDataEntryCat	Entry Category for Logistics Data
	SettlmtCat	R_CustSettlmtDEX	SettlmtCat	Settlement Category
	PostingDate	R_CustSettlmtDEX	PostingDate	Posting Date for GR
	CustSettlmtAcctgTransfSts	R_CustSettlmtDEX	CustSettlmtAcctgTransfSts	Posting Status for Transfer to Financial Accounting
	DocumentDate	R_CustSettlmtDEX	DocumentDate	Document Date in Settlement Management Document
	DocumentReferenceID	R_CustSettlmtDEX	DocumentReferenceID	Reference Document Number
	AssignmentReference	R_CustSettlmtDEX	AssignmentReference	Assignment Reference
	SettlmtApplSts	R_CustSettlmtDEX	SettlmtApplSts	Application Status for a Settlement Management Document
	SettlmtApplStsGrp	R_CustSettlmtDEX	SettlmtApplStsGrp	Status Group for Settlement Management Documents
	PricingProcedure	R_CustSettlmtDEX	PricingProcedure	Pricing Procedure
	PricingDocument	R_CustSettlmtDEX	PricingDocument	Number of the Document Condition
	BillToParty	R_CustSettlmtDEX	BillToParty	Customer in Settlement Management
	PayerParty	R_CustSettlmtDEX	PayerParty	Payer
	CompanyCode	R_CustSettlmtDEX	CompanyCode	Receiver Company Code
	SalesOrganization	R_CustSettlmtDEX	SalesOrganization	Sales Organization
	DistributionChannel	R_CustSettlmtDEX	DistributionChannel	Distribution Channel
	Division	R_CustSettlmtDEX	Division	Internal Division ID
	SalesOffice	R_CustSettlmtDEX	SalesOffice	Sales Office
	SalesGroup	R_CustSettlmtDEX	SalesGroup	Sales Group
	CreatedByUser	R_CustSettlmtDEX	CreatedByUser	Name of User who Created the Document
	CreationDate	R_CustSettlmtDEX	CreationDate	Date of Document Creation
	CreationTime	R_CustSettlmtDEX	CreationTime	Time of Document Creation
	LastChangeDate	R_CustSettlmtDEX	LastChangeDate	Date of Last Document Change
	CustSettlmtCurrency	R_CustSettlmtDEX	CustSettlmtCurrency	Currency of Settlement Document
	ExchangeRate	R_CustSettlmtDEX	ExchangeRate	Conversion Rate (Not Converted)
	ExchangeRateType	R_CustSettlmtDEX	ExchangeRateType	Exchange Rate Type
	ExchangeRateIsFixed	R_CustSettlmtDEX	ExchangeRateIsFixed	Indicator for Fixed Exchange Rate
	ExchangeRateDate	R_CustSettlmtDEX	ExchangeRateDate	Exchange Rate Date
	CustSettlmtTotalGrossAmount	R_CustSettlmtDEX	CustSettlmtTotalGrossAmount	Gross Settlement Amount in Document Currency
	CustSettlmtTotalNetAmount	R_CustSettlmtDEX	CustSettlmtTotalNetAmount	Net Settlement Amount in Document Currency
	CustSettlmtTotalTaxAmount	R_CustSettlmtDEX	CustSettlmtTotalTaxAmount	Total Tax Amount in Document Currency
	PaymentTerms	R_CustSettlmtDEX	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	R_CustSettlmtDEX	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	R_CustSettlmtDEX	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	R_CustSettlmtDEX	NetPaymentDays	Net Payment Terms Period
	CashDiscount1Percent	R_CustSettlmtDEX	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	R_CustSettlmtDEX	CashDiscount2Percent	Cash Discount Percentage 2
	PaymentMethod	R_CustSettlmtDEX	PaymentMethod	Payment Method
	CustTotEligibleAmtForCshDisc	R_CustSettlmtDEX	CustTotEligibleAmtForCshDisc	Total Amount eligible for cash discount in document currency
	CustSettlmtIsReversed	R_CustSettlmtDEX	CustSettlmtIsReversed	Customer Settlement Is Reversed
	ReversedCustomerSettlement	R_CustSettlmtDEX	ReversedCustomerSettlement	Reversed Document
	AdditionalValueDays	R_CustSettlmtDEX	AdditionalValueDays	Additional Value Days
	FixedValueDate	R_CustSettlmtDEX	FixedValueDate	Fixed Value Date
	TaxDepartureCountry	R_CustSettlmtDEX	TaxDepartureCountry	Tax Departure Country/Region
	TaxDestinationCountry	R_CustSettlmtDEX	TaxDestinationCountry	Tax Destination Country/Region
	IsEUTriangularDeal	R_CustSettlmtDEX	IsEUTriangularDeal	Indicator: Triangular Deal Within the EU
	SettlmtCoCodeTaxCountry	R_CustSettlmtDEX	SettlmtCoCodeTaxCountry	Tax Country/Region Company Code
	VATRegistration	R_CustSettlmtDEX	VATRegistration	VAT Registration Number
	CreditControlArea	R_CustSettlmtDEX	CreditControlArea	Credit Control Area
	CreditControlAreaCurrency	R_CustSettlmtDEX	CreditControlAreaCurrency	Currency of Credit Control Area
	ReleasedCreditAmount	R_CustSettlmtDEX	ReleasedCreditAmount	Released credit amount
	CustSettlmtActivityReason	R_CustSettlmtDEX	CustSettlmtActivityReason	Header Activity Reason for Document Creation
	PaymentReference	R_CustSettlmtDEX	PaymentReference	Payment Reference
	CustSettlmtPaymentCurrency	R_CustSettlmtDEX	CustSettlmtPaymentCurrency	Payment Currency
	CustSettlmtPaytCrcyExchRate	R_CustSettlmtDEX	CustSettlmtPaytCrcyExchRate	Exchange Rate of Payment Currency (not converted)
	OneTimeCustomerAddressID	R_CustSettlmtDEX	OneTimeCustomerAddressID	Address of One-Time Customer
	SettlmtReltdCndnContr	R_CustSettlmtDEX	SettlmtReltdCndnContr	Related Condition Contract in Settlement Management
	CndnContrType	R_CustSettlmtDEX	CndnContrType	Condition Contract Type
	FiscalPeriod	R_CustSettlmtDEX	FiscalPeriod	Fiscal Period
	SettlmtDateCat	R_CustSettlmtDEX	SettlmtDateCat	Rebates: Settlement Date Type
	ActualSettlmtDate	R_CustSettlmtDEX	ActualSettlmtDate	Actual Settlement Date
	SettlmtDateSequentialID	R_CustSettlmtDEX	SettlmtDateSequentialID	Settlement Date - Sequential ID
	SettlmtDate	R_CustSettlmtDEX	SettlmtDate	Rebates: Settlement Date
	CustSettlmtIncmpltnsRsn	R_CustSettlmtDEX	CustSettlmtIncmpltnsRsn	Incompleteness Reason of Settlement Management Document
	DocIntrastatRelevance	R_CustSettlmtDEX	DocIntrastatRelevance	Document is Relevant for Intrastat Declarations
	IntrastatDeclnGdsFlwCat	R_CustSettlmtDEX	IntrastatDeclnGdsFlwCat	Type of Goods Flow for Intrastat Declarations
	IncotermsVersion	R_CustSettlmtDEX	IncotermsVersion	Incoterms Version
	IncotermsClassification	R_CustSettlmtDEX	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	R_CustSettlmtDEX	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	R_CustSettlmtDEX	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	R_CustSettlmtDEX	IncotermsLocation2	Incoterms Location 2
	SettlmtBusProcVar	R_CustSettlmtDEX	SettlmtBusProcVar	Settlement Management Process Category
	SettlmtBusProcCat	R_CustSettlmtDEX	SettlmtBusProcCat	Use Case Type
	SEPAMandate	R_CustSettlmtDEX	SEPAMandate	Unique Reference to Mandate for each Payee
	TotalSettlmtQuantity	R_CustSettlmtDEX	TotalSettlmtQuantity	Total Quantity of the Business Volume in a Settlement Run
	TotalSettlmtQuantityUnit	R_CustSettlmtDEX	TotalSettlmtQuantityUnit	Unit of Measure for Total Quantity
	TotalSettlmtNetWeight	R_CustSettlmtDEX	TotalSettlmtNetWeight	Total Net Weight of the Business Volume in a Settlement Run
	TotalSettlmtGrossWeight	R_CustSettlmtDEX	TotalSettlmtGrossWeight	Total Gross Weight of the Bus Volume in a Settlement Run
	TotalSettlmtWeightUnit	R_CustSettlmtDEX	TotalSettlmtWeightUnit	Unit of Weight for Total Weight
	TotalSettlmtVolume	R_CustSettlmtDEX	TotalSettlmtVolume	Total Volume of the Business Volume in a Settlement Run
	TotalSettlmtVolumeUnit	R_CustSettlmtDEX	TotalSettlmtVolumeUnit	Volume Unit for Total Volume
	TotalSettlmtPointsQty	R_CustSettlmtDEX	TotalSettlmtPointsQty	Total Points of the Business Volume in a Settlement Run
	TotalSettlmtPointsQtyUnit	R_CustSettlmtDEX	TotalSettlmtPointsQtyUnit	Points Unit for Total Points
	SettlmtPeriodStartDate	R_CustSettlmtDEX	SettlmtPeriodStartDate	Start Date of Settlement Period
	SettlmtPeriodEndDate	R_CustSettlmtDEX	SettlmtPeriodEndDate	End Date of Settlement Period
	CndnContrProcessCategory	R_CustSettlmtDEX	CndnContrProcessCategory	Process Category of a Condition Contract
	Product	R_CustSettlmtDEX	Product	Product Sold
	ProductGroup	R_CustSettlmtDEX	ProductGroup	Product Sold Group
	Plant	R_CustSettlmtDEX	Plant	Valuation Area
	InventoryValuationType	R_CustSettlmtDEX	InventoryValuationType	Inventory Valuation Type
	PricingDate	R_CustSettlmtDEX	PricingDate	Date for Pricing and Exchange Rate
	TaxCode	R_CustSettlmtDEX	TaxCode	Tax on Sales/Purchases Code
	TaxCountry	R_CustSettlmtDEX	TaxCountry	Tax Reporting Country/Region
	TaxJurisdiction	R_CustSettlmtDEX	TaxJurisdiction	Tax Jurisdiction
	SettlmtQuantity	R_CustSettlmtDEX	SettlmtQuantity	Quantity of Settlement Management Document Item
	SettlmtQuantityUnit	R_CustSettlmtDEX	SettlmtQuantityUnit	Unit of Measure of Settlement Management Doc Item Quantity
	NetPriceAmount	R_CustSettlmtDEX	NetPriceAmount	Net Price in Document Currency
	NetPriceQuantity	R_CustSettlmtDEX	NetPriceQuantity	Price Unit of Settlement Management Document Item
	NetPriceQuantityUnit	R_CustSettlmtDEX	NetPriceQuantityUnit	Settlement Management Document Item Price Unit
	SettlmtToBaseQuantityNmrtr	R_CustSettlmtDEX	SettlmtToBaseQuantityNmrtr	Numerator Converting Qty in Settlement Document to Base Unit
	SettlmtToBaseQuantityDnmntr	R_CustSettlmtDEX	SettlmtToBaseQuantityDnmntr	Denominator Converting Qty in Settlement Doc. to Base Unit
	SettlmtToNetPriceQtyNmrtr	R_CustSettlmtDEX	SettlmtToNetPriceQtyNmrtr	Numerator for Converting Settl. UoM to Settl. Price UoM
	SettlmtToNetPriceQtyDnmntr	R_CustSettlmtDEX	SettlmtToNetPriceQtyDnmntr	Denominator for Converting Settl. UoM to Settl. Price UoM
	BaseUnit	R_CustSettlmtDEX	BaseUnit	Base Unit of Measure
	ItemNetWeight	R_CustSettlmtDEX	ItemNetWeight	Net Weight
	ItemGrossWeight	R_CustSettlmtDEX	ItemGrossWeight	Gross Weight
	ItemWeightUnit	R_CustSettlmtDEX	ItemWeightUnit	Unit of Weight
	ItemVolume	R_CustSettlmtDEX	ItemVolume	Volume
	ItemVolumeUnit	R_CustSettlmtDEX	ItemVolumeUnit	Volume Unit
	ProductPurchasePointsQtyUnit	R_CustSettlmtDEX	ProductPurchasePointsQtyUnit	Quantity Unit of Purchase Points of a Product
	ProductPurchasePointsQty	R_CustSettlmtDEX	ProductPurchasePointsQty	Purchase Points Quantity of a Product
	CustSettlmtItemGrossAmount	R_CustSettlmtDEX	CustSettlmtItemGrossAmount	Gross Amount of Item in Document Currency
	CustSettlmtItemNetAmount	R_CustSettlmtDEX	CustSettlmtItemNetAmount	Net Amount of Item in Document Currency
	CustSettlmtItemTaxAmount	R_CustSettlmtDEX	CustSettlmtItemTaxAmount	Item Tax Amount in Document Currency
	CustSettlmtSubtotal1Amount	R_CustSettlmtDEX	CustSettlmtSubtotal1Amount	Subtotal 1 Amount
	CustSettlmtSubtotal2Amount	R_CustSettlmtDEX	CustSettlmtSubtotal2Amount	Subtotal 2 Amount
	CustSettlmtSubtotal3Amount	R_CustSettlmtDEX	CustSettlmtSubtotal3Amount	Subtotal 3 Amount
	CustSettlmtSubtotal4Amount	R_CustSettlmtDEX	CustSettlmtSubtotal4Amount	Subtotal 4 Amount
	CustSettlmtSubtotal5Amount	R_CustSettlmtDEX	CustSettlmtSubtotal5Amount	Subtotal 5 Amount
	CustSettlmtSubtotal6Amount	R_CustSettlmtDEX	CustSettlmtSubtotal6Amount	Subtotal 6 Amount
	CustSettlmtRebateBasisAmount	R_CustSettlmtDEX	CustSettlmtRebateBasisAmount	Rebate Basis Amount
	CustSettlmtEffectiveItemAmount	R_CustSettlmtDEX	CustSettlmtEffectiveItemAmount	Effective Amount of Item (Supplier-Side)
	CustItmEligibleAmtForCshDisc	R_CustSettlmtDEX	CustItmEligibleAmtForCshDisc	Amount Eligible for Cash Discount in Document Currency
	NonDeductibleInputTaxAmount	R_CustSettlmtDEX	NonDeductibleInputTaxAmount	Non Deductible Input Tax Amount
	CustSettlmtItmStstclPrpty	R_CustSettlmtDEX	CustSettlmtItmStstclPrpty	Statistical Property of Settlement Management Item
	CashDiscountIsDeductible	R_CustSettlmtDEX	CashDiscountIsDeductible	Cash Discount is Deductible
	SettlmtSourceDoc	R_CustSettlmtDEX	SettlmtSourceDoc	Document Number of the Source Document
	SettlmtSourceDocItem	R_CustSettlmtDEX	SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat	R_CustSettlmtDEX	SettlmtSourceDocCat	Document Category of Source Document
	SettlmtSourceDocFiscalYear	R_CustSettlmtDEX	SettlmtSourceDocFiscalYear	Fiscal Year of a Source Document in Settlement Management
	CustSettlmtItmActivityReason	R_CustSettlmtDEX	CustSettlmtItmActivityReason	Activity Reason for Document Creation
	CustSettlmtItemText	R_CustSettlmtDEX	CustSettlmtItemText	Short Text
	BusinessArea	R_CustSettlmtDEX	BusinessArea	Business Area
	ControllingArea	R_CustSettlmtDEX	ControllingArea	Controlling Area
	CostCenter	R_CustSettlmtDEX	CostCenter	Cost Center
	ProfitCenter	R_CustSettlmtDEX	ProfitCenter	Profit Center
	WBSElementInternalID	R_CustSettlmtDEX	WBSElementInternalID	Work Breakdown Structure Element (WBS Element) not converted
	CustomerSettlementOrder	R_CustSettlmtDEX	CustomerSettlementOrder	Order for Account Assignment in Settlement Management
	Batch	R_CustSettlmtDEX	Batch	Batch Number
	PrcDetnIsIncmplt	R_CustSettlmtDEX	PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc	R_CustSettlmtDEX	SettlmtPrecdgDoc	Preceding Document of the Settlement Management Document
	SettlmtPrecdgDocItem	R_CustSettlmtDEX	SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat	R_CustSettlmtDEX	SettlmtPrecdgDocCat	Document Category of Preceding Document
	SettlmtPrecdgDocFiscalYear	R_CustSettlmtDEX	SettlmtPrecdgDocFiscalYear	Fiscal Year of a Preceding Document in Settlement Management
	CustSettlmtItmCat	R_CustSettlmtDEX	CustSettlmtItmCat	Item Category
	SettlmtItemReltdCndnContr	R_CustSettlmtDEX	SettlmtItemReltdCndnContr	Related Condition Contract of a Settlement Management Item
	CustSettlmtItemStatus	R_CustSettlmtDEX	CustSettlmtItemStatus	Item Status
	CustSettlmtItemReversed	R_CustSettlmtDEX	CustSettlmtItemReversed	Item Was Canceled
	ServicesRenderedDate	R_CustSettlmtDEX	ServicesRenderedDate	Date of Services Rendered
	SettlementFiscalYear	R_CustSettlmtDEX	SettlementFiscalYear	Fiscal Year of Settlement
	HigherLevelItem	R_CustSettlmtDEX	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	LowerLevelItemExists	R_CustSettlmtDEX	LowerLevelItemExists	Subitems Exist
	ItemDistributionStatus	R_CustSettlmtDEX	ItemDistributionStatus	Distribution Status of Settlement Item
	SettlmtRefDocType	R_CustSettlmtDEX	SettlmtRefDocType	Type of Reference Document for Settlement Management
	SettlmtRefDoc	R_CustSettlmtDEX	SettlmtRefDoc	Reference Document for Settlement Management
	SettlmtRefDocFiscalYear	R_CustSettlmtDEX	SettlmtRefDocFiscalYear	Year of Reference Document
	SettlmtRefDocLogicalSyst	R_CustSettlmtDEX	SettlmtRefDocLogicalSyst	Logical System of Reference Document for Smt Mgmt
	SettlmtRefDocItem	R_CustSettlmtDEX	SettlmtRefDocItem	Reference Document Item for Settlement Management Document
	SettlmtRefDocCat	R_CustSettlmtDEX	SettlmtRefDocCat	Reference Document Category in Settlement Management
	ItemIntrastatRelevance	R_CustSettlmtDEX	ItemIntrastatRelevance	Document Item Is Relevant for Intrastat Declarations
	SettlmtAddlRefDocType	R_CustSettlmtDEX	SettlmtAddlRefDocType	Type of Additional Reference Document for Settlmt Mgmt
	SettlmtAddlRefDoc	R_CustSettlmtDEX	SettlmtAddlRefDoc	Additional Reference Document for Settlement Management
	SettlmtAddlRefDocFiscalYear	R_CustSettlmtDEX	SettlmtAddlRefDocFiscalYear	Year of Additional Reference Document
	SettlmtAddlRefDocLogicalSyst	R_CustSettlmtDEX	SettlmtAddlRefDocLogicalSyst	Logical System of Additional Reference Document for Smt Mgmt
	SettlmtAddlRefDocItem	R_CustSettlmtDEX	SettlmtAddlRefDocItem	Additional Reference Doc Item for Settlement Mgmt. Document
	SettlmtAddlRefDocCat	R_CustSettlmtDEX	SettlmtAddlRefDocCat	Additional Reference Document Category
	CustomerSettlmtRecipient	R_CustSettlmtDEX	CustomerSettlmtRecipient	Customer Settlement Recipient
	ProductHierarchy	R_CustSettlmtDEX	ProductHierarchy	Product Hierarchy
	SalesSpcfcProductGroup1	R_CustSettlmtDEX	SalesSpcfcProductGroup1	Sales-Specific Product Group 1
	SalesSpcfcProductGroup2	R_CustSettlmtDEX	SalesSpcfcProductGroup2	Sales-Specific Product Group 2
	SalesSpcfcProductGroup3	R_CustSettlmtDEX	SalesSpcfcProductGroup3	Sales-Specific Product Group 3
	SalesSpcfcProductGroup4	R_CustSettlmtDEX	SalesSpcfcProductGroup4	Sales-Specific Product Group 4
	SalesSpcfcProductGroup5	R_CustSettlmtDEX	SalesSpcfcProductGroup5	Sales-Specific Product Group 5
	_BillToParty	R_CustSettlmtDEX	_BillToParty
	_BillToPartyCompany	R_CustSettlmtDEX	_BillToPartyCompany
	_PayerParty	R_CustSettlmtDEX	_PayerParty
	_PayerPartyCompany	R_CustSettlmtDEX	_PayerPartyCompany

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_CustSettlmtDEX.
-- 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_CustSettlmtDEX AS
SELECT
  CustSettlmt,
  CustSettlmtItem,
  CustSettlmtDEX.SettlmtDocType AS SettlmtDocType,
  CustSettlmtDEX.SettlmtDocCat AS SettlmtDocCat,
  CustSettlmtDEX.SettlmtProcessType AS SettlmtProcessType,
  CustSettlmtDEX.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  CustSettlmtDEX.SettlmtCat AS SettlmtCat,
  CustSettlmtDEX.PostingDate AS PostingDate,
  CustSettlmtDEX.CustSettlmtAcctgTransfSts AS CustSettlmtAcctgTransfSts,
  CustSettlmtDEX.DocumentDate AS DocumentDate,
  CustSettlmtDEX.DocumentReferenceID AS DocumentReferenceID,
  CustSettlmtDEX.AssignmentReference AS AssignmentReference,
  CustSettlmtDEX.SettlmtApplSts AS SettlmtApplSts,
  CustSettlmtDEX.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  CustSettlmtDEX.PricingProcedure AS PricingProcedure,
  CustSettlmtDEX.PricingDocument AS PricingDocument,
  CustSettlmtDEX.BillToParty AS BillToParty,
  CustSettlmtDEX.PayerParty AS PayerParty,
  CustSettlmtDEX.CompanyCode AS CompanyCode,
  CustSettlmtDEX.SalesOrganization AS SalesOrganization,
  CustSettlmtDEX.DistributionChannel AS DistributionChannel,
  CustSettlmtDEX.Division AS Division,
  CustSettlmtDEX.SalesOffice AS SalesOffice,
  CustSettlmtDEX.SalesGroup AS SalesGroup,
  CustSettlmtDEX.CreatedByUser AS CreatedByUser,
  CustSettlmtDEX.CreationDate AS CreationDate,
  CustSettlmtDEX.CreationTime AS CreationTime,
  CustSettlmtDEX.LastChangeDate AS LastChangeDate,
  CustSettlmtDEX.CustSettlmtCurrency AS CustSettlmtCurrency,
  CustSettlmtDEX.ExchangeRate AS ExchangeRate,
  CustSettlmtDEX.ExchangeRateType AS ExchangeRateType,
  CustSettlmtDEX.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  CustSettlmtDEX.ExchangeRateDate AS ExchangeRateDate,
  CustSettlmtDEX.CustSettlmtTotalGrossAmount AS CustSettlmtTotalGrossAmount,
  CustSettlmtDEX.CustSettlmtTotalNetAmount AS CustSettlmtTotalNetAmount,
  CustSettlmtDEX.CustSettlmtTotalTaxAmount AS CustSettlmtTotalTaxAmount,
  CustSettlmtDEX.PaymentTerms AS PaymentTerms,
  CustSettlmtDEX.CashDiscount1Days AS CashDiscount1Days,
  CustSettlmtDEX.CashDiscount2Days AS CashDiscount2Days,
  CustSettlmtDEX.NetPaymentDays AS NetPaymentDays,
  CustSettlmtDEX.CashDiscount1Percent AS CashDiscount1Percent,
  CustSettlmtDEX.CashDiscount2Percent AS CashDiscount2Percent,
  CustSettlmtDEX.PaymentMethod AS PaymentMethod,
  CustSettlmtDEX.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  CustSettlmtDEX.CustSettlmtIsReversed AS CustSettlmtIsReversed,
  CustSettlmtDEX.ReversedCustomerSettlement AS ReversedCustomerSettlement,
  CustSettlmtDEX.AdditionalValueDays AS AdditionalValueDays,
  CustSettlmtDEX.FixedValueDate AS FixedValueDate,
  CustSettlmtDEX.TaxDepartureCountry AS TaxDepartureCountry,
  CustSettlmtDEX.TaxDestinationCountry AS TaxDestinationCountry,
  CustSettlmtDEX.IsEUTriangularDeal AS IsEUTriangularDeal,
  CustSettlmtDEX.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  CustSettlmtDEX.VATRegistration AS VATRegistration,
  CustSettlmtDEX.CreditControlArea AS CreditControlArea,
  CustSettlmtDEX.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  CustSettlmtDEX.ReleasedCreditAmount AS ReleasedCreditAmount,
  CustSettlmtDEX.CustSettlmtActivityReason AS CustSettlmtActivityReason,
  CustSettlmtDEX.PaymentReference AS PaymentReference,
  CustSettlmtDEX.CustSettlmtPaymentCurrency AS CustSettlmtPaymentCurrency,
  CustSettlmtDEX.CustSettlmtPaytCrcyExchRate AS CustSettlmtPaytCrcyExchRate,
  CustSettlmtDEX.OneTimeCustomerAddressID AS OneTimeCustomerAddressID,
  CustSettlmtDEX.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  CustSettlmtDEX.CndnContrType AS CndnContrType,
  CustSettlmtDEX.FiscalPeriod AS FiscalPeriod,
  CustSettlmtDEX.SettlmtDateCat AS SettlmtDateCat,
  CustSettlmtDEX.ActualSettlmtDate AS ActualSettlmtDate,
  CustSettlmtDEX.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  CustSettlmtDEX.SettlmtDate AS SettlmtDate,
  CustSettlmtDEX.CustSettlmtIncmpltnsRsn AS CustSettlmtIncmpltnsRsn,
  CustSettlmtDEX.DocIntrastatRelevance AS DocIntrastatRelevance,
  CustSettlmtDEX.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  CustSettlmtDEX.IncotermsVersion AS IncotermsVersion,
  CustSettlmtDEX.IncotermsClassification AS IncotermsClassification,
  CustSettlmtDEX.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustSettlmtDEX.IncotermsLocation1 AS IncotermsLocation1,
  CustSettlmtDEX.IncotermsLocation2 AS IncotermsLocation2,
  CustSettlmtDEX.SettlmtBusProcVar AS SettlmtBusProcVar,
  CustSettlmtDEX.SettlmtBusProcCat AS SettlmtBusProcCat,
  CustSettlmtDEX.SEPAMandate AS SEPAMandate,
  CustSettlmtDEX.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  CustSettlmtDEX.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  CustSettlmtDEX.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  CustSettlmtDEX.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  CustSettlmtDEX.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  CustSettlmtDEX.TotalSettlmtVolume AS TotalSettlmtVolume,
  CustSettlmtDEX.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  CustSettlmtDEX.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  CustSettlmtDEX.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  CustSettlmtDEX.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  CustSettlmtDEX.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  CustSettlmtDEX.CndnContrProcessCategory AS CndnContrProcessCategory,
  CustSettlmtDEX.Product AS Product,
  CustSettlmtDEX.ProductGroup AS ProductGroup,
  CustSettlmtDEX.Plant AS Plant,
  CustSettlmtDEX.InventoryValuationType AS InventoryValuationType,
  CustSettlmtDEX.PricingDate AS PricingDate,
  CustSettlmtDEX.TaxCode AS TaxCode,
  CustSettlmtDEX.TaxCountry AS TaxCountry,
  CustSettlmtDEX.TaxJurisdiction AS TaxJurisdiction,
  CustSettlmtDEX.SettlmtQuantity AS SettlmtQuantity,
  CustSettlmtDEX.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  CustSettlmtDEX.NetPriceAmount AS NetPriceAmount,
  CustSettlmtDEX.NetPriceQuantity AS NetPriceQuantity,
  CustSettlmtDEX.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  CustSettlmtDEX.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  CustSettlmtDEX.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  CustSettlmtDEX.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  CustSettlmtDEX.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  CustSettlmtDEX.BaseUnit AS BaseUnit,
  CustSettlmtDEX.ItemNetWeight AS ItemNetWeight,
  CustSettlmtDEX.ItemGrossWeight AS ItemGrossWeight,
  CustSettlmtDEX.ItemWeightUnit AS ItemWeightUnit,
  CustSettlmtDEX.ItemVolume AS ItemVolume,
  CustSettlmtDEX.ItemVolumeUnit AS ItemVolumeUnit,
  CustSettlmtDEX.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  CustSettlmtDEX.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  CustSettlmtDEX.CustSettlmtItemGrossAmount AS CustSettlmtItemGrossAmount,
  CustSettlmtDEX.CustSettlmtItemNetAmount AS CustSettlmtItemNetAmount,
  CustSettlmtDEX.CustSettlmtItemTaxAmount AS CustSettlmtItemTaxAmount,
  CustSettlmtDEX.CustSettlmtSubtotal1Amount AS CustSettlmtSubtotal1Amount,
  CustSettlmtDEX.CustSettlmtSubtotal2Amount AS CustSettlmtSubtotal2Amount,
  CustSettlmtDEX.CustSettlmtSubtotal3Amount AS CustSettlmtSubtotal3Amount,
  CustSettlmtDEX.CustSettlmtSubtotal4Amount AS CustSettlmtSubtotal4Amount,
  CustSettlmtDEX.CustSettlmtSubtotal5Amount AS CustSettlmtSubtotal5Amount,
  CustSettlmtDEX.CustSettlmtSubtotal6Amount AS CustSettlmtSubtotal6Amount,
  CustSettlmtDEX.CustSettlmtRebateBasisAmount AS CustSettlmtRebateBasisAmount,
  CustSettlmtDEX.CustSettlmtEffectiveItemAmount AS CustSettlmtEffectiveItemAmount,
  CustSettlmtDEX.CustItmEligibleAmtForCshDisc AS CustItmEligibleAmtForCshDisc,
  CustSettlmtDEX.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  CustSettlmtDEX.CustSettlmtItmStstclPrpty AS CustSettlmtItmStstclPrpty,
  CustSettlmtDEX.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  CustSettlmtDEX.SettlmtSourceDoc AS SettlmtSourceDoc,
  CustSettlmtDEX.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  CustSettlmtDEX.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  CustSettlmtDEX.SettlmtSourceDocFiscalYear AS SettlmtSourceDocFiscalYear,
  CustSettlmtDEX.CustSettlmtItmActivityReason AS CustSettlmtItmActivityReason,
  CustSettlmtDEX.CustSettlmtItemText AS CustSettlmtItemText,
  CustSettlmtDEX.BusinessArea AS BusinessArea,
  CustSettlmtDEX.ControllingArea AS ControllingArea,
  CustSettlmtDEX.CostCenter AS CostCenter,
  CustSettlmtDEX.ProfitCenter AS ProfitCenter,
  CustSettlmtDEX.WBSElementInternalID AS WBSElementInternalID,
  CustSettlmtDEX.CustomerSettlementOrder AS CustomerSettlementOrder,
  CustSettlmtDEX.Batch AS Batch,
  CustSettlmtDEX.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  CustSettlmtDEX.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  CustSettlmtDEX.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  CustSettlmtDEX.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  CustSettlmtDEX.SettlmtPrecdgDocFiscalYear AS SettlmtPrecdgDocFiscalYear,
  CustSettlmtDEX.CustSettlmtItmCat AS CustSettlmtItmCat,
  CustSettlmtDEX.SettlmtItemReltdCndnContr AS SettlmtItemReltdCndnContr,
  CustSettlmtDEX.CustSettlmtItemStatus AS CustSettlmtItemStatus,
  CustSettlmtDEX.CustSettlmtItemReversed AS CustSettlmtItemReversed,
  CustSettlmtDEX.ServicesRenderedDate AS ServicesRenderedDate,
  CustSettlmtDEX.SettlementFiscalYear AS SettlementFiscalYear,
  CustSettlmtDEX.HigherLevelItem AS HigherLevelItem,
  CustSettlmtDEX.LowerLevelItemExists AS LowerLevelItemExists,
  CustSettlmtDEX.ItemDistributionStatus AS ItemDistributionStatus,
  CustSettlmtDEX.SettlmtRefDocType AS SettlmtRefDocType,
  CustSettlmtDEX.SettlmtRefDoc AS SettlmtRefDoc,
  CustSettlmtDEX.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  CustSettlmtDEX.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  CustSettlmtDEX.SettlmtRefDocItem AS SettlmtRefDocItem,
  CustSettlmtDEX.SettlmtRefDocCat AS SettlmtRefDocCat,
  CustSettlmtDEX.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  CustSettlmtDEX.SettlmtAddlRefDocType AS SettlmtAddlRefDocType,
  CustSettlmtDEX.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  CustSettlmtDEX.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  CustSettlmtDEX.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  CustSettlmtDEX.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  CustSettlmtDEX.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  CustSettlmtDEX.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  CustSettlmtDEX.ProductHierarchy AS ProductHierarchy,
  CustSettlmtDEX.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  CustSettlmtDEX.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  CustSettlmtDEX.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  CustSettlmtDEX.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  CustSettlmtDEX.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  CustSettlmtDEX._BillToParty AS _BillToParty,
  CustSettlmtDEX._BillToPartyCompany AS _BillToPartyCompany,
  CustSettlmtDEX._PayerParty AS _PayerParty,
  CustSettlmtDEX._PayerPartyCompany AS _PayerPartyCompany
FROM R_CustSettlmtDEX AS CustSettlmtDEX
;

Depth:

C_CustSettlmtDEX view_entity

R_CustSettlmtDEX view_entity