What is C_CustSettlmtEDP in SAP S/4HANA?

C_CustSettlmtEDP is a consumption CDS view in SAP S/4HANA. Customer Settlement Email Data Provider It contains 71 fields.

Which tables does C_CustSettlmtEDP read from?

C_CustSettlmtEDP reads data from: R_CustSettlmt.

What VDM layer is C_CustSettlmtEDP?

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

C_CustSettlmtEDP

DDL: C_CUSTSETTLMTEDP Type: view_entity CONSUMPTION

71 Fields 1 Data Sources 7 Associations

Customer Settlement Email Data Provider

C_CustSettlmtEDP (Consumption)

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

Sales

C_CustSettlmtEDP is a Consumption CDS View that provides data about "Customer Settlement Email Data Provider" in SAP S/4HANA. It reads from 1 data source (R_CustSettlmt) and exposes 71 fields with key field CustSettlmt. It has 7 associations to related views.

SAP API Hub

State	C1
Line of Business	Sales
Application Component	LO-AB
Capabilities	Output: Email Data Provider
Package	Sales for SAP S/4HANA Cloud Private Edition

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_CustSettlmt	R_CustSettlmt	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_CustSettlmtPlainLongText	_CustSettlmtPlainLongText	`$projection.CustSettlmt = _CustSettlmtPlainLongText.CustSettlmt`
[0..*]	I_CustSettlmtPartner	_CustSettlmtPartner	`$projection.CustSettlmt = _CustSettlmtPartner.CustSettlmt`
[0..*]	I_CustSettlmtBankData	_CustSettlmtBankData	`$projection.CustSettlmt = _CustSettlmtBankData.CustSettlmt`
[0..*]	I_CustSettlmtPrcgElmnt	_CustSettlmtPrcgElmnt	`$projection.CustSettlmt = _CustSettlmtPrcgElmnt.CustSettlmt`
[0..1]	I_PaymentTerms	_CustomerPaymentTerms	`$projection.PaymentTerms = _CustomerPaymentTerms.PaymentTerms`
[0..1]	C_CustSettlmtEDP	_ReversedCustomerSettlement	`$projection.ReversedCustomerSettlement = _ReversedCustomerSettlement.CustSettlmt`
[1..1]	E_SettlmtMgmtDoc	_Extension	`$projection.CustSettlmt = _Extension.SettlmtMgmtDoc`

Annotations (11)

Name	Value	Level
EndUserText.label	Customer Settlement Email Data Provider	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	CustSettlmt	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.modelingPattern	#OUTPUT_EMAIL_DATA_PROVIDER	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	false	view

Fields (71)

Key	Field	Source Field	Description
KEY	CustSettlmt	CustSettlmt	Customer Settlement
	SettlmtDocType	SettlmtDocType	Settlement Document Type
	SettlmtDocCat	SettlmtDocCat	Settlement Document Category
	SettlmtProcessType	SettlmtProcessType	Settlement Process Type
	LogisticsDataEntryCat	LogisticsDataEntryCat	Entry Category for Logistics Data
	SettlmtCat	SettlmtCat	Settlement Category
	PostingDate	PostingDate	Posting Date for GR
	CustSettlmtAcctgTransfSts	CustSettlmtAcctgTransfSts	Posting Status for Transfer to Financial Accounting
	DocumentDate	DocumentDate	Document Date in Settlement Management Document
	DocumentReferenceID	DocumentReferenceID	Reference Document Number
	AssignmentReference	AssignmentReference	Assignment Reference
	BillToParty	BillToParty	Inv. Recipient
	PayerParty	PayerParty	Payer
	CompanyCode	CompanyCode	Receiver Company Code
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	Division	Division	Internal Division ID
	SalesOffice	SalesOffice	Sales Office
	SalesGroup	SalesGroup	Sales Group
	CreatedByUser	CreatedByUser	Name of User who Created the Document
	CreationDate	CreationDate	Date of Document Creation
	CreationTime	CreationTime	Time of Document Creation
	LastChangeDate	LastChangeDate	Date of Last Document Change
	CustSettlmtCurrency	CustSettlmtCurrency	Currency of Settlement Document
	ExchangeRate	ExchangeRate	Conversion Rate (Not Converted)
	ExchangeRateType	ExchangeRateType	Exchange Rate Type
	ExchangeRateIsFixed	ExchangeRateIsFixed	Indicator for Fixed Exchange Rate
	ExchangeRateDate	ExchangeRateDate	Exchange Rate Date
	CustSettlmtTotalGrossAmount	CustSettlmtTotalGrossAmount	Gross Settlement Amount in Document Currency
	CustSettlmtTotalNetAmount	CustSettlmtTotalNetAmount	Net Settlement Amount in Document Currency
	CustSettlmtTotalTaxAmount	CustSettlmtTotalTaxAmount	Total Tax Amount in Document Currency
	PaymentTerms	PaymentTerms	Terms of Payment Key
	CashDiscount1Days	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	NetPaymentDays	Net Payment Terms Period
	CashDiscount1Percent	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	CashDiscount2Percent	Cash Discount Percentage 2
	PaymentMethod	PaymentMethod	Payment Method
	CustTotEligibleAmtForCshDisc	CustTotEligibleAmtForCshDisc	Total Amount eligible for cash discount in document currency
	CustSettlmtIsReversed	CustSettlmtIsReversed	Customer Settlement Is Reversed
	ReversedCustomerSettlement	ReversedCustomerSettlement	Reversed Document
	VATRegistration	VATRegistration	VAT Registration Number
	FiscalPeriod	FiscalPeriod	Fiscal Period
	SettlmtBusProcCat	SettlmtBusProcCat	Use Case Type
	_CustSettlmtPlainLongText	_CustSettlmtPlainLongText
	_CustSettlmtPartner	_CustSettlmtPartner
	_CustSettlmtBankData	_CustSettlmtBankData
	_CustSettlmtPrcgElmnt	_CustSettlmtPrcgElmnt
	_SettlmtDocType	_SettlmtDocType
	_SettlmtDocCat	_SettlmtDocCat
	_SettlmtProcessType	_SettlmtProcessType
	_LogisticsDataEntryCat	_LogisticsDataEntryCat
	_SettlmtCat	_SettlmtCat
	_CustSettlmtAcctgTransfSts	_CustSettlmtAcctgTransfSts
	_BillToParty	_BillToParty
	_PayerParty	_PayerParty
	_BillToPartyCompany	_BillToPartyCompany
	_PayerPartyCompany	_PayerPartyCompany
	_SalesOrganization	_SalesOrganization
	_DistributionChannel	_DistributionChannel
	_Division	_Division
	_SalesOffice	_SalesOffice
	_SalesGroup	_SalesGroup
	_SalesArea	_SalesArea
	_CreatedByUser	_CreatedByUser
	_CustSettlmtCurrency	_CustSettlmtCurrency
	_ExchangeRateType	_ExchangeRateType
	_CustomerPaymentTerms	_CustomerPaymentTerms
	_ReversedCustomerSettlement	_ReversedCustomerSettlement
	_SettlmtBusProcCat	_SettlmtBusProcCat
	_CompanyCode	_CompanyCode

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_CustSettlmtEDP.
-- 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_CustSettlmtEDP AS
SELECT
  CustSettlmt,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  CustSettlmtAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  BillToParty,
  PayerParty,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  CustSettlmtCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  CustSettlmtTotalGrossAmount,
  CustSettlmtTotalNetAmount,
  CustSettlmtTotalTaxAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  CustTotEligibleAmtForCshDisc,
  CustSettlmtIsReversed,
  ReversedCustomerSettlement,
  VATRegistration,
  FiscalPeriod,
  SettlmtBusProcCat
FROM R_CustSettlmt
LEFT OUTER JOIN I_CustSettlmtPlainLongText AS _CustSettlmtPlainLongText ON CustSettlmt = _CustSettlmtPlainLongText.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtPartner AS _CustSettlmtPartner ON CustSettlmt = _CustSettlmtPartner.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtBankData AS _CustSettlmtBankData ON CustSettlmt = _CustSettlmtBankData.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtPrcgElmnt AS _CustSettlmtPrcgElmnt ON CustSettlmt = _CustSettlmtPrcgElmnt.CustSettlmt  -- association [0..*]
LEFT OUTER JOIN I_PaymentTerms AS _CustomerPaymentTerms ON PaymentTerms = _CustomerPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_CustSettlmtEDP AS _ReversedCustomerSettlement ON ReversedCustomerSettlement = _ReversedCustomerSettlement.CustSettlmt  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON CustSettlmt = _Extension.SettlmtMgmtDoc  -- association [1..1]
;

Depth:

C_CustSettlmtEDP view_entity

R_CustSettlmt view