What is C_SuplrSettlmtDEX in SAP S/4HANA?

C_SuplrSettlmtDEX is a consumption CDS view in SAP S/4HANA. Supplier Settlement Extraction It contains 188 fields.

Which tables does C_SuplrSettlmtDEX read from?

C_SuplrSettlmtDEX reads data from: R_SuplrSettlmtDEX.

What VDM layer is C_SuplrSettlmtDEX?

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

C_SuplrSettlmtDEX

DDL: C_SUPLRSETTLMTDEX Type: view_entity CONSUMPTION

188 Fields 1 Data Sources

Supplier Settlement Extraction

C_SuplrSettlmtDEX (Consumption)

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

Supplier Settlement · Sales

C_SuplrSettlmtDEX is a Consumption CDS View (Fact) that provides data about "Supplier Settlement Extraction" in SAP S/4HANA. It reads from 1 data source (R_SuplrSettlmtDEX) and exposes 188 fields with key fields SuplrSettlmt, SuplrSettlmtItem.

SAP Help Documentation

Category	Supplier 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 supplier settlements. Providing all relevant supplier 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 supplier 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 supplier 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 folllowing: Company Code ( BUKRS ) Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Authorization Object: F_LFA1_BEK Authorization group needs to be maintained for the following: Invoicing Party Invoicing Party Company Payee Party Payee Party Company Alternative Invoicing Party Alternative Invoicing Party Company

Structure
Object types This CDS view is built on the following business object: Supplier Settlement ( SupplierSettlement ). The key fields are: SuplrSettlmt SuplrSettlmtItem Measures and attributes Some important measures and attributes are: Supplier settlement number ( SuplrSettlmt ) Supplier settlement item number ( SuplrSettlmtItem ) Product ( Product ) Plant ( Plant ) Item category ( SuplrSettlmtItmCat ) Supplier settlement currency ( SuplrSettlmtCurrency ) Supplier settlement item gross amount ( SuplrSettlmtItemGrossAmount ) Supplier settlement item net amount ( SuplrSettlmtItemNetAmount ) Supplier settlement item tax amount ( SuplrSettlmtItemTaxAmount ) 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 supplier settlements. Providing all relevant supplier 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 supplier 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_SuplrSettlmtDEX	SuplrSettlmtDEX	from

Annotations (13)

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

Fields (188)

Key	Field	Source Table	Source Field	Description
KEY	SuplrSettlmt		SuplrSettlmt	Supplier Settlement
KEY	SuplrSettlmtItem		SuplrSettlmtItem	Document Item
	SettlmtDocType	R_SuplrSettlmtDEX	SettlmtDocType	Settlement Document Type
	SettlmtDocCat	R_SuplrSettlmtDEX	SettlmtDocCat	Settlement Document Category
	SettlmtProcessType	R_SuplrSettlmtDEX	SettlmtProcessType	Settlement Process Type
	LogisticsDataEntryCat	R_SuplrSettlmtDEX	LogisticsDataEntryCat	Entry Category for Logistics Data
	SettlmtCat	R_SuplrSettlmtDEX	SettlmtCat	Settlement Category
	PostingDate	R_SuplrSettlmtDEX	PostingDate	Posting Date for GR
	SuplrSettlmtAcctgTransfSts	R_SuplrSettlmtDEX	SuplrSettlmtAcctgTransfSts	Posting Status for Transfer to Financial Accounting
	DocumentDate	R_SuplrSettlmtDEX	DocumentDate	Document Date in Settlement Management Document
	DocumentReferenceID	R_SuplrSettlmtDEX	DocumentReferenceID	Reference Document Number
	AssignmentReference	R_SuplrSettlmtDEX	AssignmentReference	Assignment Reference
	StateCentralBankPaymentReason	R_SuplrSettlmtDEX	StateCentralBankPaymentReason	State Central Bank Indicator
	SettlmtApplSts	R_SuplrSettlmtDEX	SettlmtApplSts	Application Status for a Settlement Management Document
	SettlmtApplStsGrp	R_SuplrSettlmtDEX	SettlmtApplStsGrp	Status Group for Settlement Management Documents
	PricingProcedure	R_SuplrSettlmtDEX	PricingProcedure	Pricing Procedure
	PricingDocument	R_SuplrSettlmtDEX	PricingDocument	Number of the Document Condition
	InvoicingParty	R_SuplrSettlmtDEX	InvoicingParty	Different Invoicing Party
	PayeeParty	R_SuplrSettlmtDEX	PayeeParty	Payee
	AlternativeInvoicingParty	R_SuplrSettlmtDEX	AlternativeInvoicingParty	Alternative Supplier
	CompanyCode	R_SuplrSettlmtDEX	CompanyCode	Receiver Company Code
	PurchasingOrganization	R_SuplrSettlmtDEX	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	R_SuplrSettlmtDEX	PurchasingGroup	Purchasing Group
	CreatedByUser	R_SuplrSettlmtDEX	CreatedByUser	Name of User who Created the Document
	CreationDate	R_SuplrSettlmtDEX	CreationDate	Date of Document Creation
	CreationTime	R_SuplrSettlmtDEX	CreationTime	Time of Document Creation
	LastChangeDate	R_SuplrSettlmtDEX	LastChangeDate	Date of Last Document Change
	SuplrSettlmtCurrency	R_SuplrSettlmtDEX	SuplrSettlmtCurrency	Currency of Settlement Document
	ExchangeRate	R_SuplrSettlmtDEX	ExchangeRate	Conversion Rate (Not Converted)
	ExchangeRateType	R_SuplrSettlmtDEX	ExchangeRateType	Exchange Rate Type
	ExchangeRateIsFixed	R_SuplrSettlmtDEX	ExchangeRateIsFixed	Indicator for Fixed Exchange Rate
	ExchangeRateDate	R_SuplrSettlmtDEX	ExchangeRateDate	Exchange Rate Date
	SuplrSettlmtTotalGrossAmount	R_SuplrSettlmtDEX	SuplrSettlmtTotalGrossAmount	Gross Settlement Amount in Document Currency
	SuplrSettlmtTotalNetAmount	R_SuplrSettlmtDEX	SuplrSettlmtTotalNetAmount	Net Settlement Amount in Document Currency
	SuplrSettlmtTotalTaxAmount	R_SuplrSettlmtDEX	SuplrSettlmtTotalTaxAmount	Total Tax Amount in Document Currency
	PaymentTerms	R_SuplrSettlmtDEX	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	R_SuplrSettlmtDEX	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	R_SuplrSettlmtDEX	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	R_SuplrSettlmtDEX	NetPaymentDays	Net Payment Terms Period
	CashDiscount1Percent	R_SuplrSettlmtDEX	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	R_SuplrSettlmtDEX	CashDiscount2Percent	Cash Discount Percentage 2
	PaymentMethod	R_SuplrSettlmtDEX	PaymentMethod	Payment Method
	SuplrTotEligibleAmtForCshDisc	R_SuplrSettlmtDEX	SuplrTotEligibleAmtForCshDisc	Total Amount eligible for cash discount in document currency
	SuplrSettlmtIsReversed	R_SuplrSettlmtDEX	SuplrSettlmtIsReversed	Supplier Settlement Is Reversed
	ReversedSupplierSettlement	R_SuplrSettlmtDEX	ReversedSupplierSettlement	Reversed Document
	AdditionalValueDays	R_SuplrSettlmtDEX	AdditionalValueDays	Additional Value Days
	FixedValueDate	R_SuplrSettlmtDEX	FixedValueDate	Fixed Value Date
	SupplyingCountry	R_SuplrSettlmtDEX	SupplyingCountry	Supplying Country/Region
	TaxDepartureCountry	R_SuplrSettlmtDEX	TaxDepartureCountry	Tax Departure Country/Region
	TaxDestinationCountry	R_SuplrSettlmtDEX	TaxDestinationCountry	Tax Destination Country/Region
	IsEUTriangularDeal	R_SuplrSettlmtDEX	IsEUTriangularDeal	Indicator: Triangular Deal Within the EU
	SettlmtCoCodeTaxCountry	R_SuplrSettlmtDEX	SettlmtCoCodeTaxCountry	Tax Country/Region Company Code
	VATRegistration	R_SuplrSettlmtDEX	VATRegistration	VAT Registration Number
	CreditControlArea	R_SuplrSettlmtDEX	CreditControlArea	Credit Control Area
	CreditControlAreaCurrency	R_SuplrSettlmtDEX	CreditControlAreaCurrency	Currency of Credit Control Area
	ReleasedCreditAmount	R_SuplrSettlmtDEX	ReleasedCreditAmount	Released credit amount
	SuplrSettlmtActivityReason	R_SuplrSettlmtDEX	SuplrSettlmtActivityReason	Header Activity Reason for Document Creation
	PaymentReference	R_SuplrSettlmtDEX	PaymentReference	Payment Reference
	SuplrSettlmtPaymentCurrency	R_SuplrSettlmtDEX	SuplrSettlmtPaymentCurrency	Payment Currency
	SuplrSettlmtPaytCrcyExchRate	R_SuplrSettlmtDEX	SuplrSettlmtPaytCrcyExchRate	Exchange Rate of Payment Currency (not converted)
	OneTimeSupplierAddressID	R_SuplrSettlmtDEX	OneTimeSupplierAddressID	Address of One-Time Supplier
	SettlmtReltdCndnContr	R_SuplrSettlmtDEX	SettlmtReltdCndnContr	Related Condition Contract in Settlement Management
	CndnContrType	R_SuplrSettlmtDEX	CndnContrType	Condition Contract Type
	FiscalPeriod	R_SuplrSettlmtDEX	FiscalPeriod	Fiscal Period
	SettlmtDateCat	R_SuplrSettlmtDEX	SettlmtDateCat	Rebates: Settlement Date Type
	ActualSettlmtDate	R_SuplrSettlmtDEX	ActualSettlmtDate	Actual Settlement Date
	SettlmtDateSequentialID	R_SuplrSettlmtDEX	SettlmtDateSequentialID	Settlement Date - Sequential ID
	SettlmtDate	R_SuplrSettlmtDEX	SettlmtDate	Rebates: Settlement Date
	SuplrSettlmtIncmpltnsRsn	R_SuplrSettlmtDEX	SuplrSettlmtIncmpltnsRsn	Incompleteness Reason of Settlement Management Document
	DocIntrastatRelevance	R_SuplrSettlmtDEX	DocIntrastatRelevance	Document is Relevant for Intrastat Declarations
	IntrastatDeclnGdsFlwCat	R_SuplrSettlmtDEX	IntrastatDeclnGdsFlwCat	Type of Goods Flow for Intrastat Declarations
	IncotermsVersion	R_SuplrSettlmtDEX	IncotermsVersion	Incoterms Version
	IncotermsClassification	R_SuplrSettlmtDEX	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	R_SuplrSettlmtDEX	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	R_SuplrSettlmtDEX	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	R_SuplrSettlmtDEX	IncotermsLocation2	Incoterms Location 2
	SettlmtBusProcVar	R_SuplrSettlmtDEX	SettlmtBusProcVar	Settlement Management Process Category
	SettlmtBusProcCat	R_SuplrSettlmtDEX	SettlmtBusProcCat	Use Case Type
	SEPAMandate	R_SuplrSettlmtDEX	SEPAMandate	Unique Reference to Mandate for each Payee
	TotalSettlmtQuantity	R_SuplrSettlmtDEX	TotalSettlmtQuantity	Total Quantity of the Business Volume in a Settlement Run
	TotalSettlmtQuantityUnit	R_SuplrSettlmtDEX	TotalSettlmtQuantityUnit	Unit of Measure for Total Quantity
	TotalSettlmtNetWeight	R_SuplrSettlmtDEX	TotalSettlmtNetWeight	Total Net Weight of the Business Volume in a Settlement Run
	TotalSettlmtGrossWeight	R_SuplrSettlmtDEX	TotalSettlmtGrossWeight	Total Gross Weight of the Bus Volume in a Settlement Run
	TotalSettlmtWeightUnit	R_SuplrSettlmtDEX	TotalSettlmtWeightUnit	Unit of Weight for Total Weight
	TotalSettlmtVolume	R_SuplrSettlmtDEX	TotalSettlmtVolume	Total Volume of the Business Volume in a Settlement Run
	TotalSettlmtVolumeUnit	R_SuplrSettlmtDEX	TotalSettlmtVolumeUnit	Volume Unit for Total Volume
	TotalSettlmtPointsQty	R_SuplrSettlmtDEX	TotalSettlmtPointsQty	Total Points of the Business Volume in a Settlement Run
	TotalSettlmtPointsQtyUnit	R_SuplrSettlmtDEX	TotalSettlmtPointsQtyUnit	Points Unit for Total Points
	SettlmtPeriodStartDate	R_SuplrSettlmtDEX	SettlmtPeriodStartDate	Start Date of Settlement Period
	SettlmtPeriodEndDate	R_SuplrSettlmtDEX	SettlmtPeriodEndDate	End Date of Settlement Period
	CndnContrProcessCategory	R_SuplrSettlmtDEX	CndnContrProcessCategory	Process Category of a Condition Contract
	Product	R_SuplrSettlmtDEX	Product	Product Number
	ProductGroup	R_SuplrSettlmtDEX	ProductGroup	Product Sold Group
	Plant	R_SuplrSettlmtDEX	Plant	Valuation Area
	InventoryValuationType	R_SuplrSettlmtDEX	InventoryValuationType	Inventory Valuation Type
	PricingDate	R_SuplrSettlmtDEX	PricingDate	Date for Pricing and Exchange Rate
	TaxCode	R_SuplrSettlmtDEX	TaxCode	Tax on Sales/Purchases Code
	TaxCountry	R_SuplrSettlmtDEX	TaxCountry	Tax Reporting Country/Region
	TaxJurisdiction	R_SuplrSettlmtDEX	TaxJurisdiction	Tax Jurisdiction
	SettlmtQuantity	R_SuplrSettlmtDEX	SettlmtQuantity	Quantity of Settlement Management Document Item
	SettlmtQuantityUnit	R_SuplrSettlmtDEX	SettlmtQuantityUnit	Unit of Measure of Settlement Management Doc Item Quantity
	NetPriceAmount	R_SuplrSettlmtDEX	NetPriceAmount	Net Price in Document Currency
	NetPriceQuantity	R_SuplrSettlmtDEX	NetPriceQuantity	Price Unit of Settlement Management Document Item
	NetPriceQuantityUnit	R_SuplrSettlmtDEX	NetPriceQuantityUnit	Settlement Management Document Item Price Unit
	SettlmtToBaseQuantityNmrtr	R_SuplrSettlmtDEX	SettlmtToBaseQuantityNmrtr	Numerator Converting Qty in Settlement Document to Base Unit
	SettlmtToBaseQuantityDnmntr	R_SuplrSettlmtDEX	SettlmtToBaseQuantityDnmntr	Denominator Converting Qty in Settlement Doc. to Base Unit
	SettlmtToNetPriceQtyNmrtr	R_SuplrSettlmtDEX	SettlmtToNetPriceQtyNmrtr	Numerator for Converting Settl. UoM to Settl. Price UoM
	SettlmtToNetPriceQtyDnmntr	R_SuplrSettlmtDEX	SettlmtToNetPriceQtyDnmntr	Denominator for Converting Settl. UoM to Settl. Price UoM
	BaseUnit	R_SuplrSettlmtDEX	BaseUnit	Base Unit of Measure
	ItemNetWeight	R_SuplrSettlmtDEX	ItemNetWeight	Net Weight
	ItemGrossWeight	R_SuplrSettlmtDEX	ItemGrossWeight	Gross Weight
	ItemWeightUnit	R_SuplrSettlmtDEX	ItemWeightUnit	Unit of Weight
	ItemVolume	R_SuplrSettlmtDEX	ItemVolume	Volume
	ItemVolumeUnit	R_SuplrSettlmtDEX	ItemVolumeUnit	Volume Unit
	ProductPurchasePointsQtyUnit	R_SuplrSettlmtDEX	ProductPurchasePointsQtyUnit	Quantity Unit of Purchase Points of a Product
	ProductPurchasePointsQty	R_SuplrSettlmtDEX	ProductPurchasePointsQty	Purchase Points Quantity of a Product
	SuplrSettlmtItemTaxAmount	R_SuplrSettlmtDEX	SuplrSettlmtItemTaxAmount	Item Tax Amount in Document Currency
	SuplrSettlmtItemGrossAmount	R_SuplrSettlmtDEX	SuplrSettlmtItemGrossAmount	Gross Amount of Item in Document Currency
	SuplrSettlmtItemNetAmount	R_SuplrSettlmtDEX	SuplrSettlmtItemNetAmount	Net Amount of Item in Document Currency
	SuplrSettlmtSubtotal1Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal1Amount	Subtotal 1 Amount
	SuplrSettlmtSubtotal2Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal2Amount	Subtotal 2 Amount
	SuplrSettlmtSubtotal3Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal3Amount	Subtotal 3 Amount
	SuplrSettlmtSubtotal4Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal4Amount	Subtotal 4 Amount
	SuplrSettlmtSubtotal5Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal5Amount	Subtotal 5 Amount
	SuplrSettlmtSubtotal6Amount	R_SuplrSettlmtDEX	SuplrSettlmtSubtotal6Amount	Subtotal 6 Amount
	SuplrSettlmtRebateBasisAmount	R_SuplrSettlmtDEX	SuplrSettlmtRebateBasisAmount	Rebate Basis Amount
	SuplrSettlmtEffctvItemAmount	R_SuplrSettlmtDEX	SuplrSettlmtEffctvItemAmount	Effective Amount of Item
	SuplrItmEligibleAmtForCshDisc	R_SuplrSettlmtDEX	SuplrItmEligibleAmtForCshDisc	Amount Eligible for Cash Discount in Document Currency
	NonDeductibleInputTaxAmount	R_SuplrSettlmtDEX	NonDeductibleInputTaxAmount	Non Deductible Input Tax Amount
	SuplrSettlmtItmStstclPrpty	R_SuplrSettlmtDEX	SuplrSettlmtItmStstclPrpty	Statistical Property of Settlement Management Item
	CashDiscountIsDeductible	R_SuplrSettlmtDEX	CashDiscountIsDeductible	Cash Discount is Deductible
	SettlmtSourceDoc	R_SuplrSettlmtDEX	SettlmtSourceDoc	Document Number of the Source Document
	SettlmtSourceDocItem	R_SuplrSettlmtDEX	SettlmtSourceDocItem	Item of the Source Document
	SettlmtSourceDocCat	R_SuplrSettlmtDEX	SettlmtSourceDocCat	Document Category of Source Document
	SettlmtSourceDocFiscalYear	R_SuplrSettlmtDEX	SettlmtSourceDocFiscalYear	Fiscal Year of a Source Document in Settlement Management
	SuplrSettlmtItmActivityReason	R_SuplrSettlmtDEX	SuplrSettlmtItmActivityReason	Activity Reason for Document Creation
	SuplrSettlmtItemText	R_SuplrSettlmtDEX	SuplrSettlmtItemText	Short Text
	BusinessArea	R_SuplrSettlmtDEX	BusinessArea	Business Area
	ControllingArea	R_SuplrSettlmtDEX	ControllingArea	Controlling Area
	CostCenter	R_SuplrSettlmtDEX	CostCenter	Cost Center
	ProfitCenter	R_SuplrSettlmtDEX	ProfitCenter	Profit Center
	WBSElementInternalID	R_SuplrSettlmtDEX	WBSElementInternalID	Work Breakdown Structure Element (WBS Element) not converted
	SupplierSettlementOrder	R_SuplrSettlmtDEX	SupplierSettlementOrder	Order for Account Assignment in Settlement Management
	Batch	R_SuplrSettlmtDEX	Batch	Batch Number
	PrcDetnIsIncmplt	R_SuplrSettlmtDEX	PrcDetnIsIncmplt	Price Determination Is Incomplete
	SettlmtPrecdgDoc	R_SuplrSettlmtDEX	SettlmtPrecdgDoc	Preceding Document of the Settlement Management Document
	SettlmtPrecdgDocItem	R_SuplrSettlmtDEX	SettlmtPrecdgDocItem	Item of Preceding Document
	SettlmtPrecdgDocCat	R_SuplrSettlmtDEX	SettlmtPrecdgDocCat	Document Category of Preceding Document
	SettlmtPrecdgDocFiscalYear	R_SuplrSettlmtDEX	SettlmtPrecdgDocFiscalYear	Fiscal Year of a Preceding Document in Settlement Management
	SuplrSettlmtItmCat	R_SuplrSettlmtDEX	SuplrSettlmtItmCat	Item Category
	SettlmtItemReltdCndnContr	R_SuplrSettlmtDEX	SettlmtItemReltdCndnContr	Related Condition Contract of a Settlement Management Item
	SuplrSettlmtItemStatus	R_SuplrSettlmtDEX	SuplrSettlmtItemStatus	Item Status
	SuplrSettlmtItemReversed	R_SuplrSettlmtDEX	SuplrSettlmtItemReversed	Item Was Canceled
	ServicesRenderedDate	R_SuplrSettlmtDEX	ServicesRenderedDate	Date of Services Rendered
	SettlementFiscalYear	R_SuplrSettlmtDEX	SettlementFiscalYear	Fiscal Year of Settlement
	HigherLevelItem	R_SuplrSettlmtDEX	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	LowerLevelItemExists	R_SuplrSettlmtDEX	LowerLevelItemExists	Subitems Exist
	ItemDistributionStatus	R_SuplrSettlmtDEX	ItemDistributionStatus	Distribution Status of Settlement Item
	SettlmtRefDocType	R_SuplrSettlmtDEX	SettlmtRefDocType	Type of Reference Document for Settlement Management
	SettlmtRefDoc	R_SuplrSettlmtDEX	SettlmtRefDoc	Reference Document for Settlement Management
	SettlmtRefDocFiscalYear	R_SuplrSettlmtDEX	SettlmtRefDocFiscalYear	Year of Reference Document
	SettlmtRefDocLogicalSyst	R_SuplrSettlmtDEX	SettlmtRefDocLogicalSyst	Logical System of Reference Document for Smt Mgmt
	SettlmtRefDocItem	R_SuplrSettlmtDEX	SettlmtRefDocItem	Reference Document Item for Settlement Management Document
	SettlmtRefDocCat	R_SuplrSettlmtDEX	SettlmtRefDocCat	Reference Document Category in Settlement Management
	ItemIntrastatRelevance	R_SuplrSettlmtDEX	ItemIntrastatRelevance	Document Item Is Relevant for Intrastat Declarations
	SettlmtAddlRefDocType	R_SuplrSettlmtDEX	SettlmtAddlRefDocType	Type of Additional Reference Document for Settlmt Mgmt
	SettlmtAddlRefDoc	R_SuplrSettlmtDEX	SettlmtAddlRefDoc	Additional Reference Document for Settlement Management
	SettlmtAddlRefDocFiscalYear	R_SuplrSettlmtDEX	SettlmtAddlRefDocFiscalYear	Year of Additional Reference Document
	SettlmtAddlRefDocLogicalSyst	R_SuplrSettlmtDEX	SettlmtAddlRefDocLogicalSyst	Logical System of Additional Reference Document for Smt Mgmt
	SettlmtAddlRefDocItem	R_SuplrSettlmtDEX	SettlmtAddlRefDocItem	Additional Reference Doc Item for Settlement Mgmt. Document
	SettlmtAddlRefDocCat	R_SuplrSettlmtDEX	SettlmtAddlRefDocCat	Additional Reference Document Category
	CustomerSettlmtRecipient	R_SuplrSettlmtDEX	CustomerSettlmtRecipient	Customer Settlement Recipient
	ProductHierarchy	R_SuplrSettlmtDEX	ProductHierarchy	Product Hierarchy
	SalesSpcfcProductGroup1	R_SuplrSettlmtDEX	SalesSpcfcProductGroup1	Sales-Specific Product Group 1
	SalesSpcfcProductGroup2	R_SuplrSettlmtDEX	SalesSpcfcProductGroup2	Sales-Specific Product Group 2
	SalesSpcfcProductGroup3	R_SuplrSettlmtDEX	SalesSpcfcProductGroup3	Sales-Specific Product Group 3
	SalesSpcfcProductGroup4	R_SuplrSettlmtDEX	SalesSpcfcProductGroup4	Sales-Specific Product Group 4
	SalesSpcfcProductGroup5	R_SuplrSettlmtDEX	SalesSpcfcProductGroup5	Sales-Specific Product Group 5
	SupplierProductID	R_SuplrSettlmtDEX	SupplierProductID	Material Number Used by Supplier
	PriorSupplier	R_SuplrSettlmtDEX	PriorSupplier	Prior Supplier
	GLAccount	R_SuplrSettlmtDEX	GLAccount	General Ledger
	SupplierSubrange	R_SuplrSettlmtDEX	SupplierSubrange	Supplier Subrange
	_AlternativeInvoicingParty	R_SuplrSettlmtDEX	_AlternativeInvoicingParty
	_AltvInvoicingPartyCompany	R_SuplrSettlmtDEX	_AltvInvoicingPartyCompany
	_InvoicingParty	R_SuplrSettlmtDEX	_InvoicingParty
	_InvoicingPartyCompany	R_SuplrSettlmtDEX	_InvoicingPartyCompany
	_PayeeParty	R_SuplrSettlmtDEX	_PayeeParty
	_PayeePartyCompany	R_SuplrSettlmtDEX	_PayeePartyCompany

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_SuplrSettlmtDEX.
-- 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_SuplrSettlmtDEX AS
SELECT
  SuplrSettlmt,
  SuplrSettlmtItem,
  SuplrSettlmtDEX.SettlmtDocType AS SettlmtDocType,
  SuplrSettlmtDEX.SettlmtDocCat AS SettlmtDocCat,
  SuplrSettlmtDEX.SettlmtProcessType AS SettlmtProcessType,
  SuplrSettlmtDEX.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SuplrSettlmtDEX.SettlmtCat AS SettlmtCat,
  SuplrSettlmtDEX.PostingDate AS PostingDate,
  SuplrSettlmtDEX.SuplrSettlmtAcctgTransfSts AS SuplrSettlmtAcctgTransfSts,
  SuplrSettlmtDEX.DocumentDate AS DocumentDate,
  SuplrSettlmtDEX.DocumentReferenceID AS DocumentReferenceID,
  SuplrSettlmtDEX.AssignmentReference AS AssignmentReference,
  SuplrSettlmtDEX.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SuplrSettlmtDEX.SettlmtApplSts AS SettlmtApplSts,
  SuplrSettlmtDEX.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  SuplrSettlmtDEX.PricingProcedure AS PricingProcedure,
  SuplrSettlmtDEX.PricingDocument AS PricingDocument,
  SuplrSettlmtDEX.InvoicingParty AS InvoicingParty,
  SuplrSettlmtDEX.PayeeParty AS PayeeParty,
  SuplrSettlmtDEX.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SuplrSettlmtDEX.CompanyCode AS CompanyCode,
  SuplrSettlmtDEX.PurchasingOrganization AS PurchasingOrganization,
  SuplrSettlmtDEX.PurchasingGroup AS PurchasingGroup,
  SuplrSettlmtDEX.CreatedByUser AS CreatedByUser,
  SuplrSettlmtDEX.CreationDate AS CreationDate,
  SuplrSettlmtDEX.CreationTime AS CreationTime,
  SuplrSettlmtDEX.LastChangeDate AS LastChangeDate,
  SuplrSettlmtDEX.SuplrSettlmtCurrency AS SuplrSettlmtCurrency,
  SuplrSettlmtDEX.ExchangeRate AS ExchangeRate,
  SuplrSettlmtDEX.ExchangeRateType AS ExchangeRateType,
  SuplrSettlmtDEX.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SuplrSettlmtDEX.ExchangeRateDate AS ExchangeRateDate,
  SuplrSettlmtDEX.SuplrSettlmtTotalGrossAmount AS SuplrSettlmtTotalGrossAmount,
  SuplrSettlmtDEX.SuplrSettlmtTotalNetAmount AS SuplrSettlmtTotalNetAmount,
  SuplrSettlmtDEX.SuplrSettlmtTotalTaxAmount AS SuplrSettlmtTotalTaxAmount,
  SuplrSettlmtDEX.PaymentTerms AS PaymentTerms,
  SuplrSettlmtDEX.CashDiscount1Days AS CashDiscount1Days,
  SuplrSettlmtDEX.CashDiscount2Days AS CashDiscount2Days,
  SuplrSettlmtDEX.NetPaymentDays AS NetPaymentDays,
  SuplrSettlmtDEX.CashDiscount1Percent AS CashDiscount1Percent,
  SuplrSettlmtDEX.CashDiscount2Percent AS CashDiscount2Percent,
  SuplrSettlmtDEX.PaymentMethod AS PaymentMethod,
  SuplrSettlmtDEX.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
  SuplrSettlmtDEX.SuplrSettlmtIsReversed AS SuplrSettlmtIsReversed,
  SuplrSettlmtDEX.ReversedSupplierSettlement AS ReversedSupplierSettlement,
  SuplrSettlmtDEX.AdditionalValueDays AS AdditionalValueDays,
  SuplrSettlmtDEX.FixedValueDate AS FixedValueDate,
  SuplrSettlmtDEX.SupplyingCountry AS SupplyingCountry,
  SuplrSettlmtDEX.TaxDepartureCountry AS TaxDepartureCountry,
  SuplrSettlmtDEX.TaxDestinationCountry AS TaxDestinationCountry,
  SuplrSettlmtDEX.IsEUTriangularDeal AS IsEUTriangularDeal,
  SuplrSettlmtDEX.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  SuplrSettlmtDEX.VATRegistration AS VATRegistration,
  SuplrSettlmtDEX.CreditControlArea AS CreditControlArea,
  SuplrSettlmtDEX.CreditControlAreaCurrency AS CreditControlAreaCurrency,
  SuplrSettlmtDEX.ReleasedCreditAmount AS ReleasedCreditAmount,
  SuplrSettlmtDEX.SuplrSettlmtActivityReason AS SuplrSettlmtActivityReason,
  SuplrSettlmtDEX.PaymentReference AS PaymentReference,
  SuplrSettlmtDEX.SuplrSettlmtPaymentCurrency AS SuplrSettlmtPaymentCurrency,
  SuplrSettlmtDEX.SuplrSettlmtPaytCrcyExchRate AS SuplrSettlmtPaytCrcyExchRate,
  SuplrSettlmtDEX.OneTimeSupplierAddressID AS OneTimeSupplierAddressID,
  SuplrSettlmtDEX.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
  SuplrSettlmtDEX.CndnContrType AS CndnContrType,
  SuplrSettlmtDEX.FiscalPeriod AS FiscalPeriod,
  SuplrSettlmtDEX.SettlmtDateCat AS SettlmtDateCat,
  SuplrSettlmtDEX.ActualSettlmtDate AS ActualSettlmtDate,
  SuplrSettlmtDEX.SettlmtDateSequentialID AS SettlmtDateSequentialID,
  SuplrSettlmtDEX.SettlmtDate AS SettlmtDate,
  SuplrSettlmtDEX.SuplrSettlmtIncmpltnsRsn AS SuplrSettlmtIncmpltnsRsn,
  SuplrSettlmtDEX.DocIntrastatRelevance AS DocIntrastatRelevance,
  SuplrSettlmtDEX.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SuplrSettlmtDEX.IncotermsVersion AS IncotermsVersion,
  SuplrSettlmtDEX.IncotermsClassification AS IncotermsClassification,
  SuplrSettlmtDEX.IncotermsTransferLocation AS IncotermsTransferLocation,
  SuplrSettlmtDEX.IncotermsLocation1 AS IncotermsLocation1,
  SuplrSettlmtDEX.IncotermsLocation2 AS IncotermsLocation2,
  SuplrSettlmtDEX.SettlmtBusProcVar AS SettlmtBusProcVar,
  SuplrSettlmtDEX.SettlmtBusProcCat AS SettlmtBusProcCat,
  SuplrSettlmtDEX.SEPAMandate AS SEPAMandate,
  SuplrSettlmtDEX.TotalSettlmtQuantity AS TotalSettlmtQuantity,
  SuplrSettlmtDEX.TotalSettlmtQuantityUnit AS TotalSettlmtQuantityUnit,
  SuplrSettlmtDEX.TotalSettlmtNetWeight AS TotalSettlmtNetWeight,
  SuplrSettlmtDEX.TotalSettlmtGrossWeight AS TotalSettlmtGrossWeight,
  SuplrSettlmtDEX.TotalSettlmtWeightUnit AS TotalSettlmtWeightUnit,
  SuplrSettlmtDEX.TotalSettlmtVolume AS TotalSettlmtVolume,
  SuplrSettlmtDEX.TotalSettlmtVolumeUnit AS TotalSettlmtVolumeUnit,
  SuplrSettlmtDEX.TotalSettlmtPointsQty AS TotalSettlmtPointsQty,
  SuplrSettlmtDEX.TotalSettlmtPointsQtyUnit AS TotalSettlmtPointsQtyUnit,
  SuplrSettlmtDEX.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
  SuplrSettlmtDEX.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
  SuplrSettlmtDEX.CndnContrProcessCategory AS CndnContrProcessCategory,
  SuplrSettlmtDEX.Product AS Product,
  SuplrSettlmtDEX.ProductGroup AS ProductGroup,
  SuplrSettlmtDEX.Plant AS Plant,
  SuplrSettlmtDEX.InventoryValuationType AS InventoryValuationType,
  SuplrSettlmtDEX.PricingDate AS PricingDate,
  SuplrSettlmtDEX.TaxCode AS TaxCode,
  SuplrSettlmtDEX.TaxCountry AS TaxCountry,
  SuplrSettlmtDEX.TaxJurisdiction AS TaxJurisdiction,
  SuplrSettlmtDEX.SettlmtQuantity AS SettlmtQuantity,
  SuplrSettlmtDEX.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  SuplrSettlmtDEX.NetPriceAmount AS NetPriceAmount,
  SuplrSettlmtDEX.NetPriceQuantity AS NetPriceQuantity,
  SuplrSettlmtDEX.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SuplrSettlmtDEX.SettlmtToBaseQuantityNmrtr AS SettlmtToBaseQuantityNmrtr,
  SuplrSettlmtDEX.SettlmtToBaseQuantityDnmntr AS SettlmtToBaseQuantityDnmntr,
  SuplrSettlmtDEX.SettlmtToNetPriceQtyNmrtr AS SettlmtToNetPriceQtyNmrtr,
  SuplrSettlmtDEX.SettlmtToNetPriceQtyDnmntr AS SettlmtToNetPriceQtyDnmntr,
  SuplrSettlmtDEX.BaseUnit AS BaseUnit,
  SuplrSettlmtDEX.ItemNetWeight AS ItemNetWeight,
  SuplrSettlmtDEX.ItemGrossWeight AS ItemGrossWeight,
  SuplrSettlmtDEX.ItemWeightUnit AS ItemWeightUnit,
  SuplrSettlmtDEX.ItemVolume AS ItemVolume,
  SuplrSettlmtDEX.ItemVolumeUnit AS ItemVolumeUnit,
  SuplrSettlmtDEX.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  SuplrSettlmtDEX.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  SuplrSettlmtDEX.SuplrSettlmtItemTaxAmount AS SuplrSettlmtItemTaxAmount,
  SuplrSettlmtDEX.SuplrSettlmtItemGrossAmount AS SuplrSettlmtItemGrossAmount,
  SuplrSettlmtDEX.SuplrSettlmtItemNetAmount AS SuplrSettlmtItemNetAmount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal1Amount AS SuplrSettlmtSubtotal1Amount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal2Amount AS SuplrSettlmtSubtotal2Amount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal3Amount AS SuplrSettlmtSubtotal3Amount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal4Amount AS SuplrSettlmtSubtotal4Amount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal5Amount AS SuplrSettlmtSubtotal5Amount,
  SuplrSettlmtDEX.SuplrSettlmtSubtotal6Amount AS SuplrSettlmtSubtotal6Amount,
  SuplrSettlmtDEX.SuplrSettlmtRebateBasisAmount AS SuplrSettlmtRebateBasisAmount,
  SuplrSettlmtDEX.SuplrSettlmtEffctvItemAmount AS SuplrSettlmtEffctvItemAmount,
  SuplrSettlmtDEX.SuplrItmEligibleAmtForCshDisc AS SuplrItmEligibleAmtForCshDisc,
  SuplrSettlmtDEX.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  SuplrSettlmtDEX.SuplrSettlmtItmStstclPrpty AS SuplrSettlmtItmStstclPrpty,
  SuplrSettlmtDEX.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  SuplrSettlmtDEX.SettlmtSourceDoc AS SettlmtSourceDoc,
  SuplrSettlmtDEX.SettlmtSourceDocItem AS SettlmtSourceDocItem,
  SuplrSettlmtDEX.SettlmtSourceDocCat AS SettlmtSourceDocCat,
  SuplrSettlmtDEX.SettlmtSourceDocFiscalYear AS SettlmtSourceDocFiscalYear,
  SuplrSettlmtDEX.SuplrSettlmtItmActivityReason AS SuplrSettlmtItmActivityReason,
  SuplrSettlmtDEX.SuplrSettlmtItemText AS SuplrSettlmtItemText,
  SuplrSettlmtDEX.BusinessArea AS BusinessArea,
  SuplrSettlmtDEX.ControllingArea AS ControllingArea,
  SuplrSettlmtDEX.CostCenter AS CostCenter,
  SuplrSettlmtDEX.ProfitCenter AS ProfitCenter,
  SuplrSettlmtDEX.WBSElementInternalID AS WBSElementInternalID,
  SuplrSettlmtDEX.SupplierSettlementOrder AS SupplierSettlementOrder,
  SuplrSettlmtDEX.Batch AS Batch,
  SuplrSettlmtDEX.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  SuplrSettlmtDEX.SettlmtPrecdgDoc AS SettlmtPrecdgDoc,
  SuplrSettlmtDEX.SettlmtPrecdgDocItem AS SettlmtPrecdgDocItem,
  SuplrSettlmtDEX.SettlmtPrecdgDocCat AS SettlmtPrecdgDocCat,
  SuplrSettlmtDEX.SettlmtPrecdgDocFiscalYear AS SettlmtPrecdgDocFiscalYear,
  SuplrSettlmtDEX.SuplrSettlmtItmCat AS SuplrSettlmtItmCat,
  SuplrSettlmtDEX.SettlmtItemReltdCndnContr AS SettlmtItemReltdCndnContr,
  SuplrSettlmtDEX.SuplrSettlmtItemStatus AS SuplrSettlmtItemStatus,
  SuplrSettlmtDEX.SuplrSettlmtItemReversed AS SuplrSettlmtItemReversed,
  SuplrSettlmtDEX.ServicesRenderedDate AS ServicesRenderedDate,
  SuplrSettlmtDEX.SettlementFiscalYear AS SettlementFiscalYear,
  SuplrSettlmtDEX.HigherLevelItem AS HigherLevelItem,
  SuplrSettlmtDEX.LowerLevelItemExists AS LowerLevelItemExists,
  SuplrSettlmtDEX.ItemDistributionStatus AS ItemDistributionStatus,
  SuplrSettlmtDEX.SettlmtRefDocType AS SettlmtRefDocType,
  SuplrSettlmtDEX.SettlmtRefDoc AS SettlmtRefDoc,
  SuplrSettlmtDEX.SettlmtRefDocFiscalYear AS SettlmtRefDocFiscalYear,
  SuplrSettlmtDEX.SettlmtRefDocLogicalSyst AS SettlmtRefDocLogicalSyst,
  SuplrSettlmtDEX.SettlmtRefDocItem AS SettlmtRefDocItem,
  SuplrSettlmtDEX.SettlmtRefDocCat AS SettlmtRefDocCat,
  SuplrSettlmtDEX.ItemIntrastatRelevance AS ItemIntrastatRelevance,
  SuplrSettlmtDEX.SettlmtAddlRefDocType AS SettlmtAddlRefDocType,
  SuplrSettlmtDEX.SettlmtAddlRefDoc AS SettlmtAddlRefDoc,
  SuplrSettlmtDEX.SettlmtAddlRefDocFiscalYear AS SettlmtAddlRefDocFiscalYear,
  SuplrSettlmtDEX.SettlmtAddlRefDocLogicalSyst AS SettlmtAddlRefDocLogicalSyst,
  SuplrSettlmtDEX.SettlmtAddlRefDocItem AS SettlmtAddlRefDocItem,
  SuplrSettlmtDEX.SettlmtAddlRefDocCat AS SettlmtAddlRefDocCat,
  SuplrSettlmtDEX.CustomerSettlmtRecipient AS CustomerSettlmtRecipient,
  SuplrSettlmtDEX.ProductHierarchy AS ProductHierarchy,
  SuplrSettlmtDEX.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  SuplrSettlmtDEX.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  SuplrSettlmtDEX.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  SuplrSettlmtDEX.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  SuplrSettlmtDEX.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  SuplrSettlmtDEX.SupplierProductID AS SupplierProductID,
  SuplrSettlmtDEX.PriorSupplier AS PriorSupplier,
  SuplrSettlmtDEX.GLAccount AS GLAccount,
  SuplrSettlmtDEX.SupplierSubrange AS SupplierSubrange,
  SuplrSettlmtDEX._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  SuplrSettlmtDEX._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany,
  SuplrSettlmtDEX._InvoicingParty AS _InvoicingParty,
  SuplrSettlmtDEX._InvoicingPartyCompany AS _InvoicingPartyCompany,
  SuplrSettlmtDEX._PayeeParty AS _PayeeParty,
  SuplrSettlmtDEX._PayeePartyCompany AS _PayeePartyCompany
FROM R_SuplrSettlmtDEX AS SuplrSettlmtDEX
;

Depth:

C_SuplrSettlmtDEX view_entity

R_SuplrSettlmtDEX view