I_CustomerDunningTP

DDL: I_CUSTOMERDUNNINGTP Type: view_entity TRANSACTIONAL

Customer company code dunning - TP

I_CustomerDunningTP is a Transactional CDS View that provides data about "Customer company code dunning - TP" in SAP S/4HANA. It reads from 1 data source (I_CustomerDunning) and exposes 33 fields with key fields BusinessPartner, CompanyCode, Customer, DunningArea. It has 4 associations to related views.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerDunning CustomerDunning from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CustomerCompanyCodeTP _CustomerCompanyCode $projection.BusinessPartner = _CustomerCompanyCode.BusinessPartner and $projection.Customer = _CustomerCompanyCode.Customer and $projection.CompanyCode = _CustomerCompanyCode.CompanyCode
[1..1] I_Customer_to_BusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer
[1..1] I_BusinessPartnerCustomerTP_2 _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner and $projection.Customer =_BusinessPartnerCustomer.Customer
[1..1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (7)

NameValueLevelField
EndUserText.label Customer company code dunning - TP view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY CompanyCode CompanyCode
KEY Customer Customer
KEY DunningArea DunningArea
BusinessPartnerForEdit
CustomerForEdit Customer
CompanyCodeForEdit CompanyCode
DunningAreaForEdit DunningArea
BusinessPartnerUUID _CustomerToBusinessPartner BusinessPartnerUUID
LastDunnedOn LastDunnedOn
DunningProcedure DunningProcedure
DunningLevel DunningLevel
DunningBlock DunningBlock
DunningRecipient DunningRecipient
LegDunningProcedureOn LegDunningProcedureOn
DunningClerk DunningClerk
CustomerCompanyAuthznGroup _CustomerCompany AuthorizationGroup
AuthorizationGroup _CustomerToBusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted
StandardUsage
_Customer _Customer
_CustomerCompany _CustomerCompany
_DunningArea _DunningArea
_DunningAreaText _DunningAreaText
_DunningBlock _DunningBlock
_DunningBlockText _DunningBlockText
_DunningClerk _DunningClerk
_DunningProcedure _DunningProcedure
_DunningProcedureText _DunningProcedureText
_DunningRecipient _DunningRecipient
_CustomerCompanyCode _CustomerCompanyCode
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner 
@EndUserText.label: 'Customer company code dunning - TP'
@VDM.viewType: #TRANSACTIONAL
@AccessControl: {
   authorizationCheck: #CHECK,
   personalData.blocking: #REQUIRED
}
@ObjectModel:{
 usageType: {
   serviceQuality: #C,
   sizeCategory: #XXL,
   dataClass: #TRANSACTIONAL
  }
}
define view entity I_CustomerDunningTP  
as select from I_CustomerDunning as CustomerDunning
association [1..1] to I_CustomerCompanyCodeTP as _CustomerCompanyCode
                                  on $projection.BusinessPartner = _CustomerCompanyCode.BusinessPartner
                                  and  $projection.Customer   =  _CustomerCompanyCode.Customer
                                  and  $projection.CompanyCode = _CustomerCompanyCode.CompanyCode
               
 association [1..1] to I_Customer_to_BusinessPartner as _CustomerToBusinessPartner on $projection.Customer = _CustomerToBusinessPartner.Customer
 association [1..1] to I_BusinessPartnerCustomerTP_2 as _BusinessPartnerCustomer on  $projection.BusinessPartner  = _BusinessPartnerCustomer.BusinessPartner
                                                                                  and $projection.Customer  =_BusinessPartnerCustomer.Customer   
 association [1..1] to I_BusinessPartnerTP_2 as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner           
{

  key _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartner,
  key CompanyCode,
  key Customer,
  key DunningArea,
  @ObjectModel.editableFieldFor: 'BusinessPartner'
   _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
  @ObjectModel.editableFieldFor: 'Customer'
  Customer    as CustomerForEdit,
  @ObjectModel.editableFieldFor: 'CompanyCode'
  CompanyCode as CompanyCodeForEdit,
  @ObjectModel.editableFieldFor: 'DunningArea'
  DunningArea as DunningAreaForEdit,
  _CustomerToBusinessPartner.BusinessPartnerUUID,
  LastDunnedOn,
  DunningProcedure,
  DunningLevel,
  DunningBlock,
  DunningRecipient,
  LegDunningProcedureOn,
  DunningClerk,
  _CustomerCompany.AuthorizationGroup as CustomerCompanyAuthznGroup,
  _CustomerToBusinessPartner.AuthorizationGroup as AuthorizationGroup,
  _CustomerToBusinessPartner._BusinessPartner.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
  cast(' ' as boole_d)                                        as StandardUsage,
  /* Associations */
  _Customer,
  _CustomerCompany,
  _DunningArea,
  _DunningAreaText,
  _DunningBlock,
  _DunningBlockText,
  _DunningClerk,
  _DunningProcedure,
  _DunningProcedureText,
  _DunningRecipient,
  
  _CustomerCompanyCode,
  _BusinessPartnerCustomer,
  _BusinessPartner
  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERDUNNING",
"I_CUSTOMER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_ACCOUNTINGCLERK",
"I_BUSINESSPARTNERCUSTOMERTP_2",
"I_BUSINESSPARTNERTP_2",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERCOMPANYCODETP",
"I_DUNNINGAREA",
"I_DUNNINGAREATEXT",
"I_DUNNINGBLOCKINGREASONCODE",
"I_DUNNINGBLOCKINGREASONTEXT",
"I_DUNNINGPROCEDURE",
"I_DUNNINGPROCEDURETEXT"
],
"BASE":
[
"I_CUSTOMERDUNNING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More