C_EmailDunningEntryData

DDL: C_EMAILDUNNINGENTRYDATA Type: view_entity CONSUMPTION Package: ODATA_MANAGE_DUNNING_PROPOSALS
23 Fields 3 Data Sources

Email Data For Dunning Entry

C_EmailDunningEntryData is a Consumption CDS View that provides data about "Email Data For Dunning Entry" in SAP S/4HANA. It reads from 3 data sources (I_AccountingClerk, I_UserContactCard, I_DunningEntry) and exposes 23 fields with key fields DunningRunDate, DunningRun, FinancialAccountType, CompanyCode, Customer. Part of development package ODATA_MANAGE_DUNNING_PROPOSALS.

Data Sources (3)

SourceAliasJoin Type
I_AccountingClerk _AccountingClerk left_outer
I_UserContactCard _UserData inner
I_DunningEntry Dunning from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Email Data For Dunning Entry view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DunningRunDate I_DunningEntry DunningRunDate
KEY DunningRun I_DunningEntry DunningRun
KEY FinancialAccountType I_DunningEntry FinancialAccountType Fin. Account Type
KEY CompanyCode I_DunningEntry CompanyCode Receiver Company Code
KEY Customer I_DunningEntry Customer Sold-to Party
KEY Supplier I_DunningEntry Supplier Supplier
KEY OneTimeAcctBankAccount I_DunningEntry OneTimeAcctBankAccount
KEY CustomerHeadOffice I_DunningEntry CustomerHeadOffice Head Office
KEY GroupingDunningArea I_DunningEntry GroupingDunningArea Dunning Area
KEY GroupingDunningLevel I_DunningEntry GroupingDunningLevel
KEY DunningClerk I_DunningEntry DunningClerk Dunning Clerk
UserID
CompanyCodeName
FirstName I_UserContactCard FirstName First Name
LastName I_UserContactCard LastName Last Name
FullName I_UserContactCard FullName Name
CustomerName
DunningProcedure
DunningLevel I_DunningEntry DunningLevel Dunning Level
DueLineItemsTotalInDunCrcy
DunningCurrency I_DunningEntry DunningCurrency
PrintIsReal I_DunningEntry DunningNoticeIsToBeSent To Be Sent
_Customer I_DunningEntry _Customer

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_EmailDunningEntryData.
-- 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_EmailDunningEntryData AS
SELECT
  Dunning.DunningRunDate AS DunningRunDate,
  Dunning.DunningRun AS DunningRun,
  Dunning.FinancialAccountType AS FinancialAccountType,
  Dunning.CompanyCode AS CompanyCode,
  Dunning.Customer AS Customer,
  Dunning.Supplier AS Supplier,
  Dunning.OneTimeAcctBankAccount AS OneTimeAcctBankAccount,
  Dunning.CustomerHeadOffice AS CustomerHeadOffice,
  Dunning.GroupingDunningArea AS GroupingDunningArea,
  Dunning.GroupingDunningLevel AS GroupingDunningLevel,
  Dunning.DunningClerk AS DunningClerk,
  cast (_AccountingClerk.UserID as farp_mydunnproposal_userid preserving type) AS UserID,
  Dunning._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _UserData.FirstName AS FirstName,
  _UserData.LastName AS LastName,
  _UserData.FullName AS FullName,
  Dunning._Customer.CustomerName AS CustomerName,
  cast (Dunning.DunningProcedure as farp_mydunningproposal_mahna preserving type) AS DunningProcedure,
  Dunning.DunningLevel AS DunningLevel,
  cast (Dunning.DueLineItemsTotalInDunCrcy as farp_mydunnproposal_faebt preserving type) AS DueLineItemsTotalInDunCrcy,
  Dunning.DunningCurrency AS DunningCurrency,
  Dunning.DunningNoticeIsToBeSent AS PrintIsReal,
  Dunning._Customer AS _Customer
FROM I_DunningEntry AS Dunning
LEFT OUTER JOIN I_AccountingClerk AS _AccountingClerk ON /* join condition not captured in parsed metadata */
INNER JOIN I_UserContactCard AS _UserData ON /* join condition not captured in parsed metadata */
;

Learn More