C_DunningEntry

DDL: C_DUNNINGENTRY SQL: CDUNNINGENTRY Type: view CONSUMPTION
31 Fields 1 Data Sources 1 Associations

Dunning Entry

C_DunningEntry is a Consumption CDS View that provides data about "Dunning Entry" in SAP S/4HANA. It reads from 1 data source (I_DunningEntry) and exposes 31 fields with key fields DunningRunDate, DunningRun, FinancialAccountType, CompanyCode, Customer. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DunningEntry I_DunningEntry from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_DunningEntryItem _DunningEntryItem $projection.DunningRunDate = _DunningEntryItem.DunningRunDate and $projection.DunningRun = _DunningEntryItem.DunningRun and $projection.FinancialAccountType = _DunningEntryItem.FinancialAccountType and $projection.CompanyCode = _DunningEntryItem.CompanyCode and $projection.Customer = _DunningEntryItem.Customer and $projection.Supplier = _DunningEntryItem.Supplier and $projection.OneTimeAcctBankAccount = _DunningEntryItem.OneTimeAcctBankAccount and $projection.CustomerHeadOffice = _DunningEntryItem.CustomerHeadOffice and $projection.GroupingDunningArea = _DunningEntryItem.GroupingDunningArea and $projection.GroupingDunningLevel = _DunningEntryItem.GroupingDunningLevel

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CDUNNINGENTRY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Dunning Entry view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY DunningRunDate DunningRunDate
KEY DunningRun DunningRun
KEY FinancialAccountType FinancialAccountType Fin. Account Type
KEY CompanyCode CompanyCode Receiver Company Code
KEY Customer Customer Sold-to Party
KEY Supplier Supplier Supplier
KEY OneTimeAcctBankAccount OneTimeAcctBankAccount
KEY CustomerHeadOffice CustomerHeadOffice Head Office
KEY GroupingDunningArea GroupingDunningArea Dunning Area
KEY GroupingDunningLevel GroupingDunningLevel
KEY DunningClerk DunningClerk Dunning Clerk
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CustomerName _Customer CustomerName Name of Customer
OrganizationBPName1 _Customer OrganizationBPName1 Name 1
OrganizationBPName2 _Customer OrganizationBPName2 Name 2
SupplierName _Supplier SupplierName Supplier Name
Name _Supplier OrganizationBPName1 Name 1
AdditionalName _Supplier OrganizationBPName2 Name 2
DunningPrintDate DunningPrintDate
DunningDate DunningDate Dunning Date
LegDunningProcedureOn LegDunningProcedureOn Leg.Dunn.Proc.
DunningProcedure DunningProcedure Dunn.Procedure
DueLineItemsTotalInDunCrcy DueLineItemsTotalInDunCrcy
DunningCurrency DunningCurrency
NmbrOfPages
DunningLevel DunningLevel Dunning Level
DunningBlockingReason DunningBlockingReason Set Dunning Block
FinancialAccountTypeName
_DunningEntryItem _DunningEntryItem
_Supplier _Supplier
_Customer _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_DunningEntry.
-- 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.
-- SQL view name: CDUNNINGENTRY

CREATE VIEW C_DunningEntry AS
SELECT
  DunningRunDate,
  DunningRun,
  FinancialAccountType,
  CompanyCode,
  Customer,
  Supplier,
  OneTimeAcctBankAccount,
  CustomerHeadOffice,
  GroupingDunningArea,
  GroupingDunningLevel,
  DunningClerk,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Customer.CustomerName AS CustomerName,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.OrganizationBPName1 AS Name,
  _Supplier.OrganizationBPName2 AS AdditionalName,
  DunningPrintDate,
  DunningDate,
  LegDunningProcedureOn,
  DunningProcedure,
  DueLineItemsTotalInDunCrcy,
  DunningCurrency,
  cast( 1 as abap.int4 ) AS NmbrOfPages,
  DunningLevel,
  DunningBlockingReason,
  _FinancialAccountType._Text[1:Language = $session.system_language].FinancialAccountTypeName AS FinancialAccountTypeName
FROM I_DunningEntry
LEFT OUTER JOIN C_DunningEntryItem AS _DunningEntryItem ON DunningRunDate = _DunningEntryItem.DunningRunDate AND DunningRun = _DunningEntryItem.DunningRun AND FinancialAccountType = _DunningEntryItem.FinancialAccountType AND CompanyCode = _DunningEntryItem.CompanyCode AND Customer = _DunningEntryItem.Customer AND Supplier = _DunningEntryItem.Supplier AND OneTimeAcctBankAccount = _DunningEntryItem.OneTimeAcctBankAccount AND CustomerHeadOffice = _DunningEntryItem.CustomerHeadOffice AND GroupingDunningArea = _DunningEntryItem.GroupingDunningArea AND GroupingDunningLevel = _DunningEntryItem.GroupingDunningLevel  -- association [0..*]
;

Learn More