What is C_ExpnSettlmtDEX in SAP S/4HANA?

C_ExpnSettlmtDEX is a consumption CDS view in SAP S/4HANA. Expense Settlement Extraction It contains 180 fields.

Which tables does C_ExpnSettlmtDEX read from?

C_ExpnSettlmtDEX reads data from: R_ExpnSettlmtDEX.

What VDM layer is C_ExpnSettlmtDEX?

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

C_ExpnSettlmtDEX

DDL: C_EXPNSETTLMTDEX Type: view_entity CONSUMPTION

180 Fields 1 Data Sources

Expense Settlement Extraction

C_ExpnSettlmtDEX (Consumption)

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

Expense Settlement · Sales

C_ExpnSettlmtDEX is a Consumption CDS View (Fact) that provides data about "Expense Settlement Extraction" in SAP S/4HANA. It reads from 1 data source (R_ExpnSettlmtDEX) and exposes 180 fields with key fields ExpnSettlmt, ExpnSettlmtItem.

SAP Help Documentation

Category	Expense 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 expense settlements. Providing all relevant expense 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 expense 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 expense 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: Bill-To Party Bill-To Party Company Payer Party Payer Party Company

Structure
Object types This CDS view is built on the following business object: Expense Settlement ( ExpenseSettlement ). The key fields are: ExpnSettlmt ExpnSettlmtItem Measures and attributes Some important measures and attributes are: Expense settlement number ( ExpnSettlmt ) Expense settlement item number ( ExpnSettlmtItem ) Product ( Product ) Plant ( Plant ) Item category ( ExpnSettlmtItmCat ) Expense settlement currency ( ExpnSettlmtCurrency ) Expense settlement item gross amount ( ExpnSettlmtItemGrossAmount ) Expense settlement item net amount ( ExpenseSettlementItemNetAmount ) Expense settlement item tax amount ( ExpenseSettlementItemTaxAmount ) Item quantity ( SettlmtQuantity ) Unit of measure of item 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

State	C1
Line of Business	Sales
Application Component	LO-AB
Capabilities	Data Source for Defining CDS Entities, Data Source for Data Extraction, Data Source in SQL Select
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view supports data extraction to SAP BW/4HANA. It enables the data transfer to SAP BW/4HANA for expense settlements. Providing all relevant expense settlement 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 expense settlements 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

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

Data Sources (1)

Source	Alias	Join Type
R_ExpnSettlmtDEX	ExpnSettlmtDEX	from

Annotations (13)

Name	Value	Level
EndUserText.label	Expense 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	ExpenseSettlement	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	false	view

Fields (180)

Key	Field	Source Table	Source Field	Description
KEY	ExpnSettlmt		ExpnSettlmt	Document Number of Expense Settlement
KEY	ExpnSettlmtItem		ExpnSettlmtItem	Document Item
	SettlmtDocType	R_ExpnSettlmtDEX	SettlmtDocType	Settlement Document Type
	SettlmtDocCat	R_ExpnSettlmtDEX	SettlmtDocCat	Settlement Document Category
	SettlmtProcessType	R_ExpnSettlmtDEX	SettlmtProcessType	Settlement Process Type
	LogisticsDataEntryCat	R_ExpnSettlmtDEX	LogisticsDataEntryCat	Entry Category for Logistics Data
	SettlmtCat	R_ExpnSettlmtDEX	SettlmtCat	Settlement Category
	PostingDate	R_ExpnSettlmtDEX	PostingDate	Posting Date for GR
	ExpnSettlmtAcctgTransfSts	R_ExpnSettlmtDEX	ExpnSettlmtAcctgTransfSts	Posting Status for Transfer to Financial Accounting
	DocumentDate	R_ExpnSettlmtDEX	DocumentDate	Document Date in Settlement Management Document
	DocumentReferenceID	R_ExpnSettlmtDEX	DocumentReferenceID	Reference Document Number
	AssignmentReference	R_ExpnSettlmtDEX	AssignmentReference	Assignment Reference
	SettlmtApplSts	R_ExpnSettlmtDEX	SettlmtApplSts	Application Status for a Settlement Management Document
	SettlmtApplStsGrp	R_ExpnSettlmtDEX	SettlmtApplStsGrp	Status Group for Settlement Management Documents
	PricingProcedure	R_ExpnSettlmtDEX	PricingProcedure	Pricing Procedure
	PricingDocument	R_ExpnSettlmtDEX	PricingDocument	Number of the Document Condition
	BillToParty	R_ExpnSettlmtDEX	BillToParty	Inv. Recipient
	PayerParty	R_ExpnSettlmtDEX	PayerParty	Payer
	CompanyCode	R_ExpnSettlmtDEX	CompanyCode	Receiver Company Code
	SalesOrganization	R_ExpnSettlmtDEX	SalesOrganization	Sales Organization
	DistributionChannel	R_ExpnSettlmtDEX	DistributionChannel	Distribution Channel
	Division	R_ExpnSettlmtDEX	Division	Internal Division ID
	SalesOffice	R_ExpnSettlmtDEX	SalesOffice	Sales Office
	SalesGroup	R_ExpnSettlmtDEX	SalesGroup	Sales Group
	CreatedByUser	R_ExpnSettlmtDEX	CreatedByUser	Name of User who Created the Document
	CreationDate	R_ExpnSettlmtDEX	CreationDate	Date of Document Creation
	CreationTime	R_ExpnSettlmtDEX	CreationTime	Time of Document Creation
	LastChangeDate	R_ExpnSettlmtDEX	LastChangeDate	Date of Last Document Change
	ExpnSettlmtCurrency	R_ExpnSettlmtDEX	ExpnSettlmtCurrency	Currency of Settlement Document
	ExchangeRate	R_ExpnSettlmtDEX	ExchangeRate	Conversion Rate (Not Converted)
	ExchangeRateType	R_ExpnSettlmtDEX	ExchangeRateType	Exchange Rate Type
	ExchangeRateIsFixed	R_ExpnSettlmtDEX	ExchangeRateIsFixed	Indicator for Fixed Exchange Rate
	ExchangeRateDate	R_ExpnSettlmtDEX	ExchangeRateDate	Exchange Rate Date
	ExpnSettlmtTotalGrossAmount	R_ExpnSettlmtDEX	ExpnSettlmtTotalGrossAmount	Gross Settlement Amount in Document Currency
	ExpnSettlmtTotalNetAmount	R_ExpnSettlmtDEX	ExpnSettlmtTotalNetAmount	Net Settlement Amount in Document Currency
	ExpnSettlmtTotalTaxAmount	R_ExpnSettlmtDEX	ExpnSettlmtTotalTaxAmount	Total Tax Amount in Document Currency
	PaymentTerms	R_ExpnSettlmtDEX	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	R_ExpnSettlmtDEX	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	R_ExpnSettlmtDEX	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	R_ExpnSettlmtDEX	NetPaymentDays	Net Payment Terms Period
	CashDiscount1Percent	R_ExpnSettlmtDEX	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	R_ExpnSettlmtDEX	CashDiscount2Percent	Cash Discount Percentage 2
	PaymentMethod	R_ExpnSettlmtDEX	PaymentMethod	Payment Method
	CustTotEligibleAmtForCshDisc	R_ExpnSettlmtDEX	CustTotEligibleAmtForCshDisc	Total Amount eligible for cash discount in document currency
	ExpenseSettlementIsReversed	R_ExpnSettlmtDEX	ExpenseSettlementIsReversed	Expense Settlement Is Reversed
	ReversedExpenseSettlement	R_ExpnSettlmtDEX	ReversedExpenseSettlement	Reversed Document
	AdditionalValueDays	R_ExpnSettlmtDEX	AdditionalValueDays	Additional Value Days
	FixedValueDate	R_ExpnSettlmtDEX	FixedValueDate	Fixed Value Date
	TaxDepartureCountry	R_ExpnSettlmtDEX	TaxDepartureCountry	Tax Departure Country/Region
	TaxDestinationCountry	R_ExpnSettlmtDEX	TaxDestinationCountry	Tax Destination Country/Region
	IsEUTriangularDeal	R_ExpnSettlmtDEX	IsEUTriangularDeal	Indicator: Triangular Deal Within the EU
	SettlmtCoCodeTaxCountry	R_ExpnSettlmtDEX	SettlmtCoCodeTaxCountry	Tax Country/Region Company Code
	VATRegistration	R_ExpnSettlmtDEX	VATRegistration	VAT Registration Number
	CreditControlArea	R_ExpnSettlmtDEX	CreditControlArea	Credit Control Area
	ExpnSettlmtActivityReason	R_ExpnSettlmtDEX	ExpnSettlmtActivityReason	Header Activity Reason for Document Creation
	PaymentReference	R_ExpnSettlmtDEX	PaymentReference	Payment Reference
	ExpnSettlmtPaymentCurrency	R_ExpnSettlmtDEX	ExpnSettlmtPaymentCurrency	Payment Currency
	ExpnSettlmtPaytCrcyExchRate	R_ExpnSettlmtDEX	ExpnSettlmtPaytCrcyExchRate	Exchange Rate of Payment Currency (not converted)
	OneTimeCustomerAddressID	R_ExpnSettlmtDEX	OneTimeCustomerAddressID	Address of One-Time Customer
	SettlmtReltdTrdgContr	R_ExpnSettlmtDEX	SettlmtReltdTrdgContr	Related Trading Contract in Settlement Management
	FiscalPeriod	R_ExpnSettlmtDEX	FiscalPeriod	Fiscal Period
	SettlmtDate	R_ExpnSettlmtDEX	SettlmtDate	Rebates: Settlement Date
	ExpnSettlmtIncmpltnsRsn	R_ExpnSettlmtDEX	ExpnSettlmtIncmpltnsRsn	Incompleteness Reason of Settlement Management Document
	TrdgExpnSettlmtDoc	R_ExpnSettlmtDEX	TrdgExpnSettlmtDoc	Settlement Document of planned Trading Expenses
	SettlmtDocSmmrznCat	R_ExpnSettlmtDEX	SettlmtDocSmmrznCat	Document Summarization Category
	TrdgExpnDocSettled	R_ExpnSettlmtDEX	TrdgExpnDocSettled	Trading Expense Document Settled Indicator
	TrdgExpnCurrency	R_ExpnSettlmtDEX	TrdgExpnCurrency	Ref. Field for Trading Expenses Ref. Value (Crcy, %, Unit)
	TrdgExpnAmount	R_ExpnSettlmtDEX	TrdgExpnAmount	Reference Value for Trading Expenses
	TrdgExpnCustomer	R_ExpnSettlmtDEX	TrdgExpnCustomer	Trading Expense Customer
	DocIntrastatRelevance	R_ExpnSettlmtDEX	DocIntrastatRelevance	Document is Relevant for Intrastat Declarations
	IntrastatDeclnGdsFlwCat	R_ExpnSettlmtDEX	IntrastatDeclnGdsFlwCat	Type of Goods Flow for Intrastat Declarations
	IncotermsVersion	R_ExpnSettlmtDEX	IncotermsVersion	Incoterms Version
	IncotermsClassification	R_ExpnSettlmtDEX	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	R_ExpnSettlmtDEX	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	R_ExpnSettlmtDEX	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	R_ExpnSettlmtDEX	IncotermsLocation2	Incoterms Location 2
	SettlmtBusProcVar	R_ExpnSettlmtDEX	SettlmtBusProcVar	Settlement Management Process Category
	SettlmtBusProcCat	R_ExpnSettlmtDEX	SettlmtBusProcCat	Use Case Type
	SEPAMandate	R_ExpnSettlmtDEX	SEPAMandate	Unique Reference to Mandate for each Payee
	TotalSettlmtQuantity	R_ExpnSettlmtDEX	TotalSettlmtQuantity	Total Quantity of the Business Volume in a Settlement Run
	TotalSettlmtQuantityUnit	R_ExpnSettlmtDEX	TotalSettlmtQuantityUnit	Unit of Measure for Total Quantity
	TotalSettlmtNetWeight	R_ExpnSettlmtDEX	TotalSettlmtNetWeight	Total Net Weight of the Business Volume in a Settlement Run
	TotalSettlmtGrossWeight	R_ExpnSettlmtDEX	TotalSettlmtGrossWeight	Total Gross Weight of the Bus Volume in a Settlement Run
	TotalSettlmtWeightUnit	R_ExpnSettlmtDEX	TotalSettlmtWeightUnit	Unit of Weight for Total Weight
	TotalSettlmtVolume	R_ExpnSettlmtDEX	TotalSettlmtVolume	Total Volume of the Business Volume in a Settlement Run
	TotalSettlmtVolumeUnit	R_ExpnSettlmtDEX	TotalSettlmtVolumeUnit	Volume Unit for Total Volume
	TotalSettlmtPointsQty	R_ExpnSettlmtDEX	TotalSettlmtPointsQty	Total Points of the Business Volume in a Settlement Run
	TotalSettlmtPointsQtyUnit	R_ExpnSettlmtDEX	TotalSettlmtPointsQtyUnit	Points Unit for Total Points
	Product	R_ExpnSettlmtDEX	Product	Product Number
	ProductGroup	R_ExpnSettlmtDEX	ProductGroup	Product Sold Group
	Plant	R_ExpnSettlmtDEX	Plant	Valuation Area
	InventoryValuationType	R_ExpnSettlmtDEX	InventoryValuationType	Inventory Valuation Type
	PricingDate	R_ExpnSettlmtDEX	PricingDate	Date for Pricing and Exchange Rate
	TaxCode	R_ExpnSettlmtDEX	TaxCode	Tax on Sales/Purchases Code
	TaxCountry	R_ExpnSettlmtDEX	TaxCountry	Tax Reporting Country/Region
	TaxJurisdiction	R_ExpnSettlmtDEX	TaxJurisdiction	Tax Jurisdiction
	SettlmtQuantity	R_ExpnSettlmtDEX	SettlmtQuantity	Quantity of Settlement Management Document Item
	SettlmtQuantityUnit	R_ExpnSettlmtDEX	SettlmtQuantityUnit	Unit of Measure of Settlement Management Doc Item Quantity
	NetPriceAmount	R_ExpnSettlmtDEX	NetPriceAmount	Net Price in Document Currency
	NetPriceQuantity	R_ExpnSettlmtDEX	NetPriceQuantity	Price Unit of Settlement Management Document Item
	NetPriceQuantityUnit	R_ExpnSettlmtDEX	NetPriceQuantityUnit	Settlement Management Document Item Price Unit
	SettlmtToBaseQuantityNmrtr	R_ExpnSettlmtDEX	SettlmtToBaseQuantityNmrtr	Numerator Converting Qty in Settlement Document to Base Unit
	SettlmtToBaseQuantityDnmntr	R_ExpnSettlmtDEX	SettlmtToBaseQuantityDnmntr	Denominator Converting Qty in Settlement Doc. to Base Unit
	SettlmtToNetPriceQtyNmrtr	R_ExpnSettlmtDEX	SettlmtToNetPriceQtyNmrtr	Numerator for Converting Settl. UoM to Settl. Price UoM
	SettlmtToNetPriceQtyDnmntr	R_ExpnSettlmtDEX	SettlmtToNetPriceQtyDnmntr	Denominator for Converting Settl. UoM to Settl. Price UoM
	BaseUnit	R_ExpnSettlmtDEX	BaseUnit	Base Unit of Measure
	ItemNetWeight	R_ExpnSettlmtDEX	ItemNetWeight	Net Weight
	ItemGrossWeight	R_ExpnSettlmtDEX	ItemGrossWeight	Gross Weight
	ItemWeightUnit	R_ExpnSettlmtDEX	ItemWeightUnit	Unit of Weight
	ItemVolume	R_ExpnSettlmtDEX	ItemVolume	Volume
	ItemVolumeUnit	R_ExpnSettlmtDEX	ItemVolumeUnit	Volume Unit
	ProductPurchasePointsQtyUnit	R_ExpnSettlmtDEX	ProductPurchasePointsQtyUnit	Quantity Unit of Purchase Points of a Product
	ProductPurchasePointsQty	R_ExpnSettlmtDEX	ProductPurchasePointsQty	Purchase Points Quantity of a Product
	ExpenseSettlementItemTaxAmount	R_ExpnSettlmtDEX	ExpenseSettlementItemTaxAmount	Item Tax Amount in Document Currency
	ExpnSettlmtItemGrossAmount	R_ExpnSettlmtDEX	ExpnSettlmtItemGrossAmount	Gross Amount of Item in Document Currency
	ExpenseSettlementItemNetAmount	R_ExpnSettlmtDEX	ExpenseSettlementItemNetAmount	Net Amount of Item in Document Currency
	ExpnSettlmtSubtotal1Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal1Amount	Subtotal 1 Amount
	ExpnSettlmtSubtotal2Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal2Amount	Subtotal 2 Amount
	ExpnSettlmtSubtotal3Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal3Amount	Subtotal 3 Amount
	ExpnSettlmtSubtotal4Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal4Amount	Subtotal 4 Amount
	ExpnSettlmtSubtotal5Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal5Amount	Subtotal 5 Amount
	ExpnSettlmtSubtotal6Amount	R_ExpnSettlmtDEX	ExpnSettlmtSubtotal6Amount	Subtotal 6 Amount
	ExpnSettlmtRebateBasisAmount	R_ExpnSettlmtDEX	ExpnSettlmtRebateBasisAmount	Rebate Basis Amount
	ExpnSettlmtEffectiveItemAmount	R_ExpnSettlmtDEX	ExpnSettlmtEffectiveItemAmount	Effective Amount of Item
	CustItmEligibleAmtForCshDisc	R_ExpnSettlmtDEX	CustItmEligibleAmtForCshDisc	Amount Eligible for Cash Discount in Document Currency
	NonDeductibleInputTaxAmount	R_ExpnSettlmtDEX	NonDeductibleInputTaxAmount	Non Deductible Input Tax Amount
	ExpnSettlmtItmStstclPrpty	R_ExpnSettlmtDEX	ExpnSettlmtItmStstclPrpty	Statistical Property of Settlement Management Item
	CashDiscountIsDeductible	R_ExpnSettlmtDEX	CashDiscountIsDeductible	Cash Discount is Deductible
	SettlmtSourceDoc	R_ExpnSettlmtDEX	SettlmtSourceDoc	Document Number of the Source Document
	SettlmtSourceDocItem	R_ExpnSettlmtDEX	SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat	R_ExpnSettlmtDEX	SettlmtSourceDocCat	Document Category of Source Document
	SettlmtSourceDocFiscalYear	R_ExpnSettlmtDEX	SettlmtSourceDocFiscalYear	Fiscal Year of a Source Document in Settlement Management
	ExpnSettlmtItemActivityReason	R_ExpnSettlmtDEX	ExpnSettlmtItemActivityReason	Activity Reason for Document Creation
	ExpnSettlmtItemText	R_ExpnSettlmtDEX	ExpnSettlmtItemText	Short Text
	BusinessArea	R_ExpnSettlmtDEX	BusinessArea	Business Area
	ControllingArea	R_ExpnSettlmtDEX	ControllingArea	Controlling Area
	CostCenter	R_ExpnSettlmtDEX	CostCenter	Cost Center
	ProfitCenter	R_ExpnSettlmtDEX	ProfitCenter	Profit Center
	WBSElementInternalID	R_ExpnSettlmtDEX	WBSElementInternalID	Work Breakdown Structure Element (WBS Element) not converted
	ExpenseSettlementOrder	R_ExpnSettlmtDEX	ExpenseSettlementOrder	Order for Account Assignment in Settlement Management
	Batch	R_ExpnSettlmtDEX	Batch	Batch Number
	PrcDetnIsIncmplt	R_ExpnSettlmtDEX	PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc	R_ExpnSettlmtDEX	SettlmtPrecdgDoc	Preceding Document of the Settlement Management Document
	SettlmtPrecdgDocItem	R_ExpnSettlmtDEX	SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat	R_ExpnSettlmtDEX	SettlmtPrecdgDocCat	Document Category of Preceding Document
	SettlmtPrecdgDocFiscalYear	R_ExpnSettlmtDEX	SettlmtPrecdgDocFiscalYear	Fiscal Year of a Preceding Document in Settlement Management
	ExpnSettlmtItmCat	R_ExpnSettlmtDEX	ExpnSettlmtItmCat	Item Category
	SettlmtItemReltdTrdgContr	R_ExpnSettlmtDEX	SettlmtItemReltdTrdgContr	Related Trading Contract of a Settlement Management Item
	SettlmtItemReltdTrdgContrItem	R_ExpnSettlmtDEX	SettlmtItemReltdTrdgContrItem	Related Trading Contract Item of a Settlmt Mgmt Item
	ExpnSettlmtItemStatus	R_ExpnSettlmtDEX	ExpnSettlmtItemStatus	Item Status
	ExpenseSettlementItemReversed	R_ExpnSettlmtDEX	ExpenseSettlementItemReversed	Item Was Canceled
	ServicesRenderedDate	R_ExpnSettlmtDEX	ServicesRenderedDate	Date of Services Rendered
	SettlementFiscalYear	R_ExpnSettlmtDEX	SettlementFiscalYear	Fiscal Year of Settlement
	HigherLevelItem	R_ExpnSettlmtDEX	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	LowerLevelItemExists	R_ExpnSettlmtDEX	LowerLevelItemExists	Subitems Exist
	ItemDistributionStatus	R_ExpnSettlmtDEX	ItemDistributionStatus	Distribution Status of Settlement Item
	SettlmtRefDocType	R_ExpnSettlmtDEX	SettlmtRefDocType	Type of Reference Document for Settlement Management
	SettlmtRefDoc	R_ExpnSettlmtDEX	SettlmtRefDoc	Reference Document for Settlement Management
	SettlmtRefDocFiscalYear	R_ExpnSettlmtDEX	SettlmtRefDocFiscalYear	Year of Reference Document
	SettlmtRefDocLogicalSyst	R_ExpnSettlmtDEX	SettlmtRefDocLogicalSyst	Logical System of Reference Document for Smt Mgmt
	SettlmtRefDocItem	R_ExpnSettlmtDEX	SettlmtRefDocItem	Reference Document Item for Settlement Management Document
	SettlmtRefDocCat	R_ExpnSettlmtDEX	SettlmtRefDocCat	Reference Document Category in Settlement Management
	ItemIntrastatRelevance	R_ExpnSettlmtDEX	ItemIntrastatRelevance	Document Item Is Relevant for Intrastat Declarations
	SettlmtAddlRefDocType	R_ExpnSettlmtDEX	SettlmtAddlRefDocType	Type of Additional Reference Document for Settlmt Mgmt
	SettlmtAddlRefDoc	R_ExpnSettlmtDEX	SettlmtAddlRefDoc	Additional Reference Document for Settlement Management
	SettlmtAddlRefDocFiscalYear	R_ExpnSettlmtDEX	SettlmtAddlRefDocFiscalYear	Year of Additional Reference Document
	SettlmtAddlRefDocLogicalSyst	R_ExpnSettlmtDEX	SettlmtAddlRefDocLogicalSyst	Logical System of Additional Reference Document for Smt Mgmt
	SettlmtAddlRefDocItem	R_ExpnSettlmtDEX	SettlmtAddlRefDocItem	Additional Reference Doc Item for Settlement Mgmt. Document
	SettlmtAddlRefDocCat	R_ExpnSettlmtDEX	SettlmtAddlRefDocCat	Additional Reference Document Category
	CustomerSettlmtRecipient	R_ExpnSettlmtDEX	CustomerSettlmtRecipient	Customer Settlement Recipient
	ProductHierarchy	R_ExpnSettlmtDEX	ProductHierarchy	Product Hierarchy
	SalesSpcfcProductGroup1	R_ExpnSettlmtDEX	SalesSpcfcProductGroup1	Sales-Specific Product Group 1
	SalesSpcfcProductGroup2	R_ExpnSettlmtDEX	SalesSpcfcProductGroup2	Sales-Specific Product Group 2
	SalesSpcfcProductGroup3	R_ExpnSettlmtDEX	SalesSpcfcProductGroup3	Sales-Specific Product Group 3
	SalesSpcfcProductGroup4	R_ExpnSettlmtDEX	SalesSpcfcProductGroup4	Sales-Specific Product Group 4
	SalesSpcfcProductGroup5	R_ExpnSettlmtDEX	SalesSpcfcProductGroup5	Sales-Specific Product Group 5
	_BillToParty	R_ExpnSettlmtDEX	_BillToParty
	_BillToPartyCompany	R_ExpnSettlmtDEX	_BillToPartyCompany
	_PayerParty	R_ExpnSettlmtDEX	_PayerParty
	_PayerPartyCompany	R_ExpnSettlmtDEX	_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_ExpnSettlmtDEX.
-- 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_ExpnSettlmtDEX AS
SELECT
  ExpnSettlmt,
  ExpnSettlmtItem,
  ExpnSettlmtDEX.SettlmtDocType AS SettlmtDocType,
  ExpnSettlmtDEX.SettlmtDocCat AS SettlmtDocCat,
  ExpnSettlmtDEX.SettlmtProcessType AS SettlmtProcessType,
  ExpnSettlmtDEX.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  ExpnSettlmtDEX.SettlmtCat AS SettlmtCat,
  ExpnSettlmtDEX.PostingDate AS PostingDate,
  ExpnSettlmtDEX.ExpnSettlmtAcctgTransfSts AS ExpnSettlmtAcctgTransfSts,
  ExpnSettlmtDEX.DocumentDate AS DocumentDate,
  ExpnSettlmtDEX.DocumentReferenceID AS DocumentReferenceID,
  ExpnSettlmtDEX.AssignmentReference AS AssignmentReference,
  ExpnSettlmtDEX.SettlmtApplSts AS SettlmtApplSts,
  ExpnSettlmtDEX.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  ExpnSettlmtDEX.PricingProcedure AS PricingProcedure,
  ExpnSettlmtDEX.PricingDocument AS PricingDocument,
  ExpnSettlmtDEX.BillToParty AS BillToParty,
  ExpnSettlmtDEX.PayerParty AS PayerParty,
  ExpnSettlmtDEX.CompanyCode AS CompanyCode,
  ExpnSettlmtDEX.SalesOrganization AS SalesOrganization,
  ExpnSettlmtDEX.DistributionChannel AS DistributionChannel,
  ExpnSettlmtDEX.Division AS Division,
  ExpnSettlmtDEX.SalesOffice AS SalesOffice,
  ExpnSettlmtDEX.SalesGroup AS SalesGroup,
  ExpnSettlmtDEX.CreatedByUser AS CreatedByUser,
  ExpnSettlmtDEX.CreationDate AS CreationDate,
  ExpnSettlmtDEX.CreationTime AS CreationTime,
  ExpnSettlmtDEX.LastChangeDate AS LastChangeDate,
  ExpnSettlmtDEX.ExpnSettlmtCurrency AS ExpnSettlmtCurrency,
  ExpnSettlmtDEX.ExchangeRate AS ExchangeRate,
  ExpnSettlmtDEX.ExchangeRateType AS ExchangeRateType,
  ExpnSettlmtDEX.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  ExpnSettlmtDEX.ExchangeRateDate AS ExchangeRateDate,
  ExpnSettlmtDEX.ExpnSettlmtTotalGrossAmount AS ExpnSettlmtTotalGrossAmount,
  ExpnSettlmtDEX.ExpnSettlmtTotalNetAmount AS ExpnSettlmtTotalNetAmount,
  ExpnSettlmtDEX.ExpnSettlmtTotalTaxAmount AS ExpnSettlmtTotalTaxAmount,
  ExpnSettlmtDEX.PaymentTerms AS PaymentTerms,
  ExpnSettlmtDEX.CashDiscount1Days AS CashDiscount1Days,
  ExpnSettlmtDEX.CashDiscount2Days AS CashDiscount2Days,
  ExpnSettlmtDEX.NetPaymentDays AS NetPaymentDays,
  ExpnSettlmtDEX.CashDiscount1Percent AS CashDiscount1Percent,
  ExpnSettlmtDEX.CashDiscount2Percent AS CashDiscount2Percent,
  ExpnSettlmtDEX.PaymentMethod AS PaymentMethod,
  ExpnSettlmtDEX.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  ExpnSettlmtDEX.ExpenseSettlementIsReversed AS ExpenseSettlementIsReversed,
  ExpnSettlmtDEX.ReversedExpenseSettlement AS ReversedExpenseSettlement,
  ExpnSettlmtDEX.AdditionalValueDays AS AdditionalValueDays,
  ExpnSettlmtDEX.FixedValueDate AS FixedValueDate,
  ExpnSettlmtDEX.TaxDepartureCountry AS TaxDepartureCountry,
  ExpnSettlmtDEX.TaxDestinationCountry AS TaxDestinationCountry,
  ExpnSettlmtDEX.IsEUTriangularDeal AS IsEUTriangularDeal,
  ExpnSettlmtDEX.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  ExpnSettlmtDEX.VATRegistration AS VATRegistration,
  ExpnSettlmtDEX.CreditControlArea AS CreditControlArea,
  ExpnSettlmtDEX.ExpnSettlmtActivityReason AS ExpnSettlmtActivityReason,
  ExpnSettlmtDEX.PaymentReference AS PaymentReference,
  ExpnSettlmtDEX.ExpnSettlmtPaymentCurrency AS ExpnSettlmtPaymentCurrency,
  ExpnSettlmtDEX.ExpnSettlmtPaytCrcyExchRate AS ExpnSettlmtPaytCrcyExchRate,
  ExpnSettlmtDEX.OneTimeCustomerAddressID AS OneTimeCustomerAddressID,
  ExpnSettlmtDEX.SettlmtReltdTrdgContr AS SettlmtReltdTrdgContr,
  ExpnSettlmtDEX.FiscalPeriod AS FiscalPeriod,
  ExpnSettlmtDEX.SettlmtDate AS SettlmtDate,
  ExpnSettlmtDEX.ExpnSettlmtIncmpltnsRsn AS ExpnSettlmtIncmpltnsRsn,
  ExpnSettlmtDEX.TrdgExpnSettlmtDoc AS TrdgExpnSettlmtDoc,
  ExpnSettlmtDEX.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
  ExpnSettlmtDEX.TrdgExpnDocSettled AS TrdgExpnDocSettled,
  ExpnSettlmtDEX.TrdgExpnCurrency AS TrdgExpnCurrency,
  ExpnSettlmtDEX.TrdgExpnAmount AS TrdgExpnAmount,
  ExpnSettlmtDEX.TrdgExpnCustomer AS TrdgExpnCustomer,
  ExpnSettlmtDEX.DocIntrastatRelevance AS DocIntrastatRelevance,
  ExpnSettlmtDEX.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  ExpnSettlmtDEX.IncotermsVersion AS IncotermsVersion,
  ExpnSettlmtDEX.IncotermsClassification AS IncotermsClassification,
  ExpnSettlmtDEX.IncotermsTransferLocation AS IncotermsTransferLocation,
  ExpnSettlmtDEX.IncotermsLocation1 AS IncotermsLocation1,
  ExpnSettlmtDEX.IncotermsLocation2 AS IncotermsLocation2,
  ExpnSettlmtDEX.SettlmtBusProcVar AS SettlmtBusProcVar,
  ExpnSettlmtDEX.SettlmtBusProcCat AS SettlmtBusProcCat,
  ExpnSettlmtDEX.SEPAMandate AS SEPAMandate,
  ExpnSettlmtDEX.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  ExpnSettlmtDEX.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  ExpnSettlmtDEX.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  ExpnSettlmtDEX.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  ExpnSettlmtDEX.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  ExpnSettlmtDEX.TotalSettlmtVolume AS TotalSettlmtVolume,
  ExpnSettlmtDEX.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  ExpnSettlmtDEX.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  ExpnSettlmtDEX.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  ExpnSettlmtDEX.Product AS Product,
  ExpnSettlmtDEX.ProductGroup AS ProductGroup,
  ExpnSettlmtDEX.Plant AS Plant,
  ExpnSettlmtDEX.InventoryValuationType AS InventoryValuationType,
  ExpnSettlmtDEX.PricingDate AS PricingDate,
  ExpnSettlmtDEX.TaxCode AS TaxCode,
  ExpnSettlmtDEX.TaxCountry AS TaxCountry,
  ExpnSettlmtDEX.TaxJurisdiction AS TaxJurisdiction,
  ExpnSettlmtDEX.SettlmtQuantity AS SettlmtQuantity,
  ExpnSettlmtDEX.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  ExpnSettlmtDEX.NetPriceAmount AS NetPriceAmount,
  ExpnSettlmtDEX.NetPriceQuantity AS NetPriceQuantity,
  ExpnSettlmtDEX.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  ExpnSettlmtDEX.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  ExpnSettlmtDEX.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  ExpnSettlmtDEX.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  ExpnSettlmtDEX.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  ExpnSettlmtDEX.BaseUnit AS BaseUnit,
  ExpnSettlmtDEX.ItemNetWeight AS ItemNetWeight,
  ExpnSettlmtDEX.ItemGrossWeight AS ItemGrossWeight,
  ExpnSettlmtDEX.ItemWeightUnit AS ItemWeightUnit,
  ExpnSettlmtDEX.ItemVolume AS ItemVolume,
  ExpnSettlmtDEX.ItemVolumeUnit AS ItemVolumeUnit,
  ExpnSettlmtDEX.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  ExpnSettlmtDEX.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  ExpnSettlmtDEX.ExpenseSettlementItemTaxAmount AS ExpenseSettlementItemTaxAmount,
  ExpnSettlmtDEX.ExpnSettlmtItemGrossAmount AS ExpnSettlmtItemGrossAmount,
  ExpnSettlmtDEX.ExpenseSettlementItemNetAmount AS ExpenseSettlementItemNetAmount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal1Amount AS ExpnSettlmtSubtotal1Amount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal2Amount AS ExpnSettlmtSubtotal2Amount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal3Amount AS ExpnSettlmtSubtotal3Amount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal4Amount AS ExpnSettlmtSubtotal4Amount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal5Amount AS ExpnSettlmtSubtotal5Amount,
  ExpnSettlmtDEX.ExpnSettlmtSubtotal6Amount AS ExpnSettlmtSubtotal6Amount,
  ExpnSettlmtDEX.ExpnSettlmtRebateBasisAmount AS ExpnSettlmtRebateBasisAmount,
  ExpnSettlmtDEX.ExpnSettlmtEffectiveItemAmount AS ExpnSettlmtEffectiveItemAmount,
  ExpnSettlmtDEX.CustItmEligibleAmtForCshDisc AS CustItmEligibleAmtForCshDisc,
  ExpnSettlmtDEX.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  ExpnSettlmtDEX.ExpnSettlmtItmStstclPrpty AS ExpnSettlmtItmStstclPrpty,
  ExpnSettlmtDEX.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  ExpnSettlmtDEX.SettlmtSourceDoc AS SettlmtSourceDoc,
  ExpnSettlmtDEX.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  ExpnSettlmtDEX.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  ExpnSettlmtDEX.SettlmtSourceDocFiscalYear AS SettlmtSourceDocFiscalYear,
  ExpnSettlmtDEX.ExpnSettlmtItemActivityReason AS ExpnSettlmtItemActivityReason,
  ExpnSettlmtDEX.ExpnSettlmtItemText AS ExpnSettlmtItemText,
  ExpnSettlmtDEX.BusinessArea AS BusinessArea,
  ExpnSettlmtDEX.ControllingArea AS ControllingArea,
  ExpnSettlmtDEX.CostCenter AS CostCenter,
  ExpnSettlmtDEX.ProfitCenter AS ProfitCenter,
  ExpnSettlmtDEX.WBSElementInternalID AS WBSElementInternalID,
  ExpnSettlmtDEX.ExpenseSettlementOrder AS ExpenseSettlementOrder,
  ExpnSettlmtDEX.Batch AS Batch,
  ExpnSettlmtDEX.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  ExpnSettlmtDEX.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  ExpnSettlmtDEX.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  ExpnSettlmtDEX.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  ExpnSettlmtDEX.SettlmtPrecdgDocFiscalYear AS SettlmtPrecdgDocFiscalYear,
  ExpnSettlmtDEX.ExpnSettlmtItmCat AS ExpnSettlmtItmCat,
  ExpnSettlmtDEX.SettlmtItemReltdTrdgContr AS SettlmtItemReltdTrdgContr,
  ExpnSettlmtDEX.SettlmtItemReltdTrdgContrItem AS SettlmtItemReltdTrdgContrItem,
  ExpnSettlmtDEX.ExpnSettlmtItemStatus AS ExpnSettlmtItemStatus,
  ExpnSettlmtDEX.ExpenseSettlementItemReversed AS ExpenseSettlementItemReversed,
  ExpnSettlmtDEX.ServicesRenderedDate AS ServicesRenderedDate,
  ExpnSettlmtDEX.SettlementFiscalYear AS SettlementFiscalYear,
  ExpnSettlmtDEX.HigherLevelItem AS HigherLevelItem,
  ExpnSettlmtDEX.LowerLevelItemExists AS LowerLevelItemExists,
  ExpnSettlmtDEX.ItemDistributionStatus AS ItemDistributionStatus,
  ExpnSettlmtDEX.SettlmtRefDocType AS SettlmtRefDocType,
  ExpnSettlmtDEX.SettlmtRefDoc AS SettlmtRefDoc,
  ExpnSettlmtDEX.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  ExpnSettlmtDEX.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  ExpnSettlmtDEX.SettlmtRefDocItem AS SettlmtRefDocItem,
  ExpnSettlmtDEX.SettlmtRefDocCat AS SettlmtRefDocCat,
  ExpnSettlmtDEX.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  ExpnSettlmtDEX.SettlmtAddlRefDocType AS SettlmtAddlRefDocType,
  ExpnSettlmtDEX.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  ExpnSettlmtDEX.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  ExpnSettlmtDEX.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  ExpnSettlmtDEX.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  ExpnSettlmtDEX.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  ExpnSettlmtDEX.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  ExpnSettlmtDEX.ProductHierarchy AS ProductHierarchy,
  ExpnSettlmtDEX.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  ExpnSettlmtDEX.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  ExpnSettlmtDEX.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  ExpnSettlmtDEX.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  ExpnSettlmtDEX.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  ExpnSettlmtDEX._BillToParty AS _BillToParty,
  ExpnSettlmtDEX._BillToPartyCompany AS _BillToPartyCompany,
  ExpnSettlmtDEX._PayerParty AS _PayerParty,
  ExpnSettlmtDEX._PayerPartyCompany AS _PayerPartyCompany
FROM R_ExpnSettlmtDEX AS ExpnSettlmtDEX
;

Depth:

C_ExpnSettlmtDEX view_entity

R_ExpnSettlmtDEX view