C_CustSettlmtListEDP

DDL: C_CUSTSETTLMTLISTEDP Type: view_entity CONSUMPTION
64 Fields 1 Data Sources 5 Associations

Customer Settlement List Email Template

C_CustSettlmtListEDP is a Consumption CDS View that provides data about "Customer Settlement List Email Template" in SAP S/4HANA. It reads from 1 data source (R_CustSettlmtList) and exposes 64 fields with key field CustSettlmtList. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CustSettlmtList R_CustSettlmtList from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts $projection.CustSettlmtListAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts
[0..*] I_CustSettlmtListPartner _CustSettlmtListPartner $projection.CustSettlmtList = _CustSettlmtListPartner.CustSettlmtList
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] C_CustSettlmtListOutputForm _RvsdCustSettlmtList $projection.RvsdCustSettlmtList = _RvsdCustSettlmtList.CustSettlmtList
[1..1] E_SettlmtMgmtDoc _Extension $projection.CustSettlmtList = _Extension.SettlmtMgmtDoc

Annotations (11)

NameValueLevelField
EndUserText.label Customer Settlement List Email Template view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey CustSettlmtList 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 (64)

KeyFieldSource TableSource FieldDescription
KEY CustSettlmtList CustSettlmtList
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
LogisticsDataEntryCat LogisticsDataEntryCat Entry Category
PostingDate PostingDate Posting Date for GR
CustSettlmtListAcctgTransfSts CustSettlmtListAcctgTransfSts Posting Status
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
CustSettlmtListCurrency CustSettlmtListCurrency Doc. Currency
ExchangeRate ExchangeRate Exchange rate
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate ExchangeRateDate Translatn Date
CustSettlmtListTotGrossAmount CustSettlmtListTotGrossAmount
CustSettlmtListTotalNetAmount CustSettlmtListTotalNetAmount
CustSettlmtListTotalTaxAmount CustSettlmtListTotalTaxAmount
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
CustTotEligibleAmtForCshDisc CustTotEligibleAmtForCshDisc Cust Cash Disc Bas
CustSettlmtListIsReversed CustSettlmtListIsReversed
RvsdCustSettlmtList RvsdCustSettlmtList
VATRegistration VATRegistration VAT Registration No.
FiscalPeriod FiscalPeriod Tax period
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
_CustSettlmtListPlainLongText _CustSettlmtListPlainLongText
_CustSettlmtListPartner _CustSettlmtListPartner
_CustSettlmtListBankData _CustSettlmtListBankData
_SettlmtDocType _SettlmtDocType
_SettlmtDocCat _SettlmtDocCat
_SettlmtProcessType _SettlmtProcessType
_LogisticsDataEntryCat _LogisticsDataEntryCat
_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts
_BillToParty _BillToParty
_PayerParty _PayerParty
_BillToPartyCompany _BillToPartyCompany
_PayerPartyCompany _PayerPartyCompany
_CompanyCode _CompanyCode
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesArea _SalesArea
_CreatedByUser _CreatedByUser
_ExchangeRateType _ExchangeRateType
_CustSettlmtListCurrency _CustSettlmtListCurrency
_PaymentTerms _PaymentTerms
_RvsdCustSettlmtList _RvsdCustSettlmtList
_SettlmtBusProcCat _SettlmtBusProcCat

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_CustSettlmtListEDP.
-- 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_CustSettlmtListEDP AS
SELECT
  CustSettlmtList,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  PostingDate,
  CustSettlmtListAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  BillToParty,
  PayerParty,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  CustSettlmtListCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  CustSettlmtListTotGrossAmount,
  CustSettlmtListTotalNetAmount,
  CustSettlmtListTotalTaxAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  CustTotEligibleAmtForCshDisc,
  CustSettlmtListIsReversed,
  RvsdCustSettlmtList,
  VATRegistration,
  FiscalPeriod,
  SettlmtBusProcCat
FROM R_CustSettlmtList
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts ON CustSettlmtListAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN I_CustSettlmtListPartner AS _CustSettlmtListPartner ON CustSettlmtList = _CustSettlmtListPartner.CustSettlmtList  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_CustSettlmtListOutputForm AS _RvsdCustSettlmtList ON RvsdCustSettlmtList = _RvsdCustSettlmtList.CustSettlmtList  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON CustSettlmtList = _Extension.SettlmtMgmtDoc  -- association [1..1]
;

Learn More