I_DunningEntryForOutpDetn

DDL: I_DUNNINGENTRYFOROUTPDETN Type: view_entity COMPOSITE

Determine Output Parameter for Dunning

I_DunningEntryForOutpDetn is a Composite CDS View that provides data about "Determine Output Parameter for Dunning" in SAP S/4HANA. It reads from 1 data source (I_DunningEntry) and exposes 30 fields with key fields DunningRunDate, DunningRun, FinancialAccountType, CompanyCode, Customer. It has 2 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_DunningEntry dataview from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserData _UserData.ContactCardID = $session.user
[1..1] I_CustomerCompany _CustomerCompany _CustomerCompany.Customer = $projection.Customer and _CustomerCompany.CompanyCode = $projection.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Determine Output Parameter for Dunning view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY DunningRunDate DunningRunDate
KEY DunningRun DunningRun
KEY FinancialAccountType FinancialAccountType
KEY CompanyCode CompanyCode
KEY Customer Customer
KEY Supplier Supplier
KEY OneTimeAcctBankAccount
KEY CustomerHeadOffice CustomerHeadOffice
KEY GroupingDunningArea GroupingDunningArea
KEY GroupingDunningLevel GroupingDunningLevel
KEY DunningClerk DunningClerk
UserID
EmailAddress _UserData EmailAddress
CompanyCodeCountry
AddressIndependentEmailAddress
DefaultEmailAddress
AccountingClerkInternetAddress _CustomerCompany AccountingClerkInternetAddress
Country
Language
DunningPrintDate DunningPrintDate
DunningDate DunningDate
LegDunningProcedureOn LegDunningProcedureOn
DunningProcedure DunningProcedure
DunningLevel DunningLevel
DunningBlockingReason DunningBlockingReason
_UserData _UserData
_AccountingClerk _AccountingClerk
_Customer _Customer
_CompanyCode _CompanyCode
_CustomerCompany _CustomerCompany 
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Determine Output Parameter for Dunning'


@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #COMPOSITE

define view entity I_DunningEntryForOutpDetn
  as select from I_DunningEntry as dataview
  association [0..1] to I_UserContactCard as _UserData        on  _UserData.ContactCardID = $session.user
  association [1..1] to I_CustomerCompany as _CustomerCompany on  _CustomerCompany.Customer    = $projection.Customer
                                                              and _CustomerCompany.CompanyCode = $projection.CompanyCode
{
  key DunningRunDate,
  key DunningRun,
  key FinancialAccountType,
  key CompanyCode,
  key Customer,
  key Supplier,
  key cast (OneTimeAcctBankAccount as cpdky)                                                                                       as OneTimeAcctBankAccount,
  key CustomerHeadOffice,
  key GroupingDunningArea,
  key GroupingDunningLevel,
  key DunningClerk,

      //data of accounting clerk

      cast (dataview._AccountingClerk.UserID as farp_mydunnproposal_userid)                                                        as UserID,
      _UserData.EmailAddress,
      dataview._CompanyCode.Country                                                                                                as CompanyCodeCountry,

      //data of customer

      _Customer._CustomerToBusinessPartner._BusinessPartner._BPAddressIndependentEmail[1:IsDefaultEmailAddress = 'X'].EmailAddress as AddressIndependentEmailAddress,
      dataview._Customer._CustomerToBusinessPartner._BusinessPartner._DefaultAddress._Address._DefaultEmailAddress.EmailAddress    as DefaultEmailAddress,
      _CustomerCompany.AccountingClerkInternetAddress,
      dataview._Customer.Country,
      dataview._Customer.Language,

      DunningPrintDate,
      DunningDate,
      LegDunningProcedureOn,
      DunningProcedure,
      DunningLevel,
      DunningBlockingReason,

      //associations

      _UserData,
      _AccountingClerk,
      _Customer,
      _CompanyCode,
      _CustomerCompany
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGCLERK",
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_BPADDRESSINDEPENDENTEMAIL",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERDEFAULTADDR",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_DUNNINGENTRY",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_ACCOUNTINGCLERK",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_DUNNINGENTRY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More