C_DunningEntryItem

DDL: C_DUNNINGENTRYITEM SQL: CDUNNINGENTRITM Type: view CONSUMPTION
26 Fields 1 Data Sources

Dunning Entry Item

C_DunningEntryItem is a Consumption CDS View that provides data about "Dunning Entry Item" in SAP S/4HANA. It reads from 1 data source (I_DunningEntryItem) and exposes 26 fields with key fields DunningRunDate, DunningRun, FinancialAccountType, CompanyCode, Customer.

Data Sources (1)

SourceAliasJoin Type
I_DunningEntryItem I_DunningEntryItem from

Annotations (11)

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

Fields (26)

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 Dunning Level
KEY ReferenceDocumentCompanyCode ReferenceDocumentCompanyCode
KEY JournalEntry JournalEntry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY JournalEntryItem JournalEntryItem Journal Entry Item
DunningBlockingReason DunningBlockingReason Set Dunning Block
NetDueDate NetDueDate Net Due Date
DunningLevel DunningLevel Dunning Level
NetDueArrearsDays NetDueArrearsDays
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
OriginalReferenceDocument _JournalEntry OriginalReferenceDocument Reference Key
ReferenceDocumentType _JournalEntry ReferenceDocumentType Reference Document Type
CompanyCodeName _DocumentCompanyCode CompanyCodeName Company Name
DocumentReferenceID DocumentReferenceID Reference
_Customer _Customer
_Supplier _Supplier

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_DunningEntryItem.
-- 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: CDUNNINGENTRITM

CREATE VIEW C_DunningEntryItem AS
SELECT
  DunningRunDate,
  DunningRun,
  FinancialAccountType,
  CompanyCode,
  Customer,
  Supplier,
  OneTimeAcctBankAccount,
  CustomerHeadOffice,
  GroupingDunningArea,
  GroupingDunningLevel,
  ReferenceDocumentCompanyCode,
  JournalEntry,
  FiscalYear,
  JournalEntryItem,
  DunningBlockingReason,
  NetDueDate,
  DunningLevel,
  NetDueArrearsDays,
  AmountInTransactionCurrency,
  TransactionCurrency,
  _JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  _JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  _DocumentCompanyCode.CompanyCodeName AS CompanyCodeName,
  DocumentReferenceID
FROM I_DunningEntryItem
;

Learn More