C_DunningEntryItem

DDL: C_DUNNINGENTRYITEM SQL: CDUNNINGENTRITM Type: view CONSUMPTION

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.

1 data source(s) 26 fields

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
KEY CompanyCode CompanyCode
KEY Customer Customer
KEY Supplier Supplier
KEY OneTimeAcctBankAccount OneTimeAcctBankAccount
KEY CustomerHeadOffice CustomerHeadOffice
KEY GroupingDunningArea GroupingDunningArea
KEY GroupingDunningLevel GroupingDunningLevel
KEY ReferenceDocumentCompanyCode ReferenceDocumentCompanyCode
KEY JournalEntry JournalEntry
KEY FiscalYear FiscalYear
KEY JournalEntryItem JournalEntryItem
DunningBlockingReason DunningBlockingReason
NetDueDate NetDueDate
DunningLevel DunningLevel
NetDueArrearsDays NetDueArrearsDays
AmountInTransactionCurrency AmountInTransactionCurrency
TransactionCurrency TransactionCurrency
OriginalReferenceDocument _JournalEntry OriginalReferenceDocument
ReferenceDocumentType _JournalEntry ReferenceDocumentType
CompanyCodeName _DocumentCompanyCode CompanyCodeName
DocumentReferenceID DocumentReferenceID
_Customer _Customer
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'CDUNNINGENTRITM'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Dunning Entry Item'

@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view C_DunningEntryItem
  as select from I_DunningEntryItem

{
      @UI.hidden: true
  key DunningRunDate, //Run Date

      @UI.hidden: true
  key DunningRun, //Additional Identification

      @UI.hidden: true
  key FinancialAccountType,
      //@UI.hidden: true

      @UI.lineItem.position: 1
      @ObjectModel.text.element: ['CompanyCodeName']
      @UI.textArrangement: #TEXT_LAST
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
  key CompanyCode,
      @Consumption.semanticObject: 'Customer'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_Customer_VH', element: 'Customer' } } ]
  key Customer,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_Supplier_VH', element: 'Supplier' } } ]
      @UI.hidden: true
  key Supplier, 
      @UI.hidden: true
  key OneTimeAcctBankAccount,
      @UI.hidden: true
  key CustomerHeadOffice,
      @UI.hidden: true
  key GroupingDunningArea,
      @UI.hidden: true
  key GroupingDunningLevel,
      //      @UI.lineItem.position: 1

      //      @ObjectModel.text.element: ['CompanyCodeName']

      //      @UI.textArrangement: #TEXT_LAST

      @UI.hidden: true
  key ReferenceDocumentCompanyCode,
      @Search.defaultSearchElement: true
//      @Search.fuzzinessThreshold: 0.8

      @Search.ranking: #HIGH
      @Consumption.semanticObject: 'AccountingDocument'
      @UI.lineItem: [{ position: 2, importance: #HIGH }]    
  key JournalEntry,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @UI.lineItem.position: 4
  key FiscalYear,
      @UI.lineItem.position: 5
  key JournalEntryItem,
      @UI.lineItem: [{ position: 3, importance: #HIGH }]
      DunningBlockingReason,
      @UI.lineItem.position: 6
      NetDueDate,
      @UI.lineItem.position: 7
      DunningLevel,
      @UI.lineItem.position: 8
      NetDueArrearsDays,
      @UI.lineItem: [{ position: 11, importance: #HIGH }]
      AmountInTransactionCurrency,
      TransactionCurrency,
      _JournalEntry.OriginalReferenceDocument,
      _JournalEntry.ReferenceDocumentType,
      //      @UI.lineItem.position: 12

      //      DocumentReferenceID,

      _DocumentCompanyCode.CompanyCodeName,
      @Search.defaultSearchElement: true
//      @Search.fuzzinessThreshold: 0.8

      @Search.ranking: #HIGH
      DocumentReferenceID,
      @UI.hidden: true
      _Customer,
      @UI.hidden: true
      _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_DUNNINGENTRYITEM",
"I_JOURNALENTRY"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_SUPPLIER"
],
"BASE":
[
"I_DUNNINGENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More