C_BPCustomerDunning

DDL: C_BPCUSTOMERDUNNING SQL: CBPCUSTDUN Type: view CONSUMPTION

Consumption View for Customer Dunning

C_BPCustomerDunning is a Consumption CDS View that provides data about "Consumption View for Customer Dunning" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerDunningTP) and exposes 21 fields with key fields BusinessPartner, CompanyCode, DunningArea. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerDunningTP CustomerDunning from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerCustCo _BusinessPartnerCustomerCo $projection.BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner and $projection.CompanyCode = _BusinessPartnerCustomerCo.CompanyCode
[1..1] I_Customer_VH _DunningRecipient $projection.DunningRecipient = _DunningRecipient.Customer

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CBPCUSTDUN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption View for Customer Dunning view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Dunning Area view
UI.headerInfo.typeNamePlural Dunning Areas view
UI.headerInfo.title.label Dunning Area Description view
UI.headerInfo.title.value DunningArea view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPCustomerDunningTP BusinessPartner
KEY CompanyCode I_BPCustomerDunningTP CompanyCode
KEY DunningArea I_BPCustomerDunningTP DunningArea
Customer I_BPCustomerDunningTP Customer
BusinessPartnerForEdit I_BPCustomerDunningTP BusinessPartnerForEdit
CompanyCodeForEdit I_BPCustomerDunningTP CompanyCodeForEdit
DunningAreaForEdit I_BPCustomerDunningTP DunningAreaForEdit
DunningRecipient I_BPCustomerDunningTP DunningRecipient
LegDunningProcedureOn I_BPCustomerDunningTP LegDunningProcedureOn
LastDunnedOn I_BPCustomerDunningTP LastDunnedOn
DunningProcedure I_BPCustomerDunningTP DunningProcedure
DunningLevel I_BPCustomerDunningTP DunningLevel
DunningBlock I_BPCustomerDunningTP DunningBlock
DunningClerk I_BPCustomerDunningTP DunningClerk
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomerCo _BusinessPartnerCustomerCo
_DunningAreaText _DunningAreaText
_DunningProcedureText _DunningProcedureText
_DunningBlockText _DunningBlockText
_DunningRecipient _DunningRecipient
@AbapCatalog.sqlViewName: 'CBPCUSTDUN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Consumption View for Customer Dunning'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel: {
   semanticKey: ['BusinessPartner', 'CompanyCode', 'DunningArea'],
   createEnabled,
   updateEnabled,
   deleteEnabled,
   text.control: #ASSOCIATED_TEXT_UI_HIDDEN //texts will be shown together with the Code values. if the Code values are hidden, then texts wont be visible in UI.  no independent visibility for text fields

}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Dunning Area',
  typeNamePlural : 'Dunning Areas',
  title:  { label:'Dunning Area Description', value: 'DunningArea' }
}

@VDM.viewType: #CONSUMPTION
define view C_BPCustomerDunning as select from I_BPCustomerDunningTP as CustomerDunning
  association [1..1] to C_BusinessPartner           as _BusinessPartner           on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to C_BusinessPartnerCustomer   as _BusinessPartnerCustomer   on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  association [1..1] to C_BusinessPartnerCustCo as _BusinessPartnerCustomerCo on  $projection.BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner
                                                                                  and $projection.CompanyCode     = _BusinessPartnerCustomerCo.CompanyCode
  
  association [1..1] to I_Customer_VH as _DunningRecipient on $projection.DunningRecipient = _DunningRecipient.Customer
  
  //association [1..1] to I_AccountingClerkStdVH as _DunningClerk on $projection.CompanyCode = _DunningClerk.CompanyCode   

                                                           //    and $projection.DunningClerk = _DunningClerk.AccountingClerk 

                                                                                  
{
  key CustomerDunning.BusinessPartner,
  key CustomerDunning.CompanyCode,
  key CustomerDunning.DunningArea,
      CustomerDunning.Customer,
      CustomerDunning.BusinessPartnerForEdit,
      CustomerDunning.CompanyCodeForEdit,
      CustomerDunning.DunningAreaForEdit,
      @Consumption.valueHelp: '_DunningRecipient'
      CustomerDunning.DunningRecipient,
      CustomerDunning.LegDunningProcedureOn,
      CustomerDunning.LastDunnedOn,
      CustomerDunning.DunningProcedure,
      CustomerDunning.DunningLevel,
      CustomerDunning.DunningBlock,
     // @Consumption.valueHelp: '_DunningClerk'

      CustomerDunning.DunningClerk,
 
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BusinessPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BusinessPartnerCustomerCo,
      _DunningAreaText,
      _DunningProcedureText,
      _DunningBlockText,
      //_DunningClerk,

      _DunningRecipient
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERDUNNINGTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTCO",
"C_BUSINESSPARTNERCUSTOMER",
"I_CUSTOMER_VH",
"I_DUNNINGAREATEXT",
"I_DUNNINGBLOCKINGREASONTEXT",
"I_DUNNINGPROCEDURETEXT"
],
"BASE":
[
"I_BPCUSTOMERDUNNINGTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/