I_BPCustomerDunningGov

DDL: I_BPCUSTOMERDUNNINGGOV Type: view_entity COMPOSITE

BP Customer Dunning Data Gov

I_BPCustomerDunningGov is a Composite CDS View that provides data about "BP Customer Dunning Data Gov" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerDunningProcess, I_CustomerDunning) and exposes 37 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, CompanyCode. It has 5 associations to related views.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
I_BPCustomerDunningProcess I_BPCustomerDunningProcess from
I_CustomerDunning I_CustomerDunning union_all

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerGov _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[1..1] I_BPCustomerGov _Customer $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject
[1..1] I_BPCustomerCompanyGov _CustomerCompany $projection.MasterDataChangeProcess = _CustomerCompany.MasterDataChangeProcess and $projection.MDChgProcessStep = _CustomerCompany.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _CustomerCompany.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _CustomerCompany.MDChgProcessSrceObject and $projection.CompanyCode = _CustomerCompany.CompanyCode
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
[1..1] I_CustomerToBusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Dunning Data Gov view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY CompanyCode CompanyCode
KEY DunningArea DunningArea
BPAssignmentID BPAssignmentID
Customer Customer
DunningRecipient DunningRecipient
LegDunningProcedureOn LegDunningProcedureOn
LastDunnedOn LastDunnedOn
DunningProcedure DunningProcedure
DunningLevel DunningLevel
DunningBlock DunningBlock
DunningClerk DunningClerk
_BusinessPartner _BusinessPartner
_Customer _Customer
_CustomerCompany _CustomerCompany
KEY MDChgProcessStep
KEY MDChgProcessSrceSystem
KEY MDChgProcessSrceObject
KEY CompanyCode CompanyCode
KEY DunningArea DunningArea
BPAssignmentID
Customer Customer
DunningRecipient DunningRecipient
LegDunningProcedureOn LegDunningProcedureOn
LastDunnedOn LastDunnedOn
DunningProcedure DunningProcedure
DunningLevel DunningLevel
DunningBlock DunningBlock
DunningClerk DunningClerk
MasterDataIsCurrent
_BusinessPartner _BusinessPartner
_Customer _Customer
_CustomerCompany _CustomerCompany
_CustomerToBusinessPartner _CustomerToBusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Dunning Data Gov'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_BPCustomerDunningGov
  as select from I_BPCustomerDunningProcess


  association [1..1] to I_BusinessPartnerGov        as _BusinessPartner           on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [1..1] to I_BPCustomerGov             as _Customer                  on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
  association [1..1] to I_BPCustomerCompanyGov      as _CustomerCompany           on  $projection.MasterDataChangeProcess = _CustomerCompany.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _CustomerCompany.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _CustomerCompany.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _CustomerCompany.MDChgProcessSrceObject
                                                                                  and $projection.CompanyCode             = _CustomerCompany.CompanyCode


  association [0..1] to I_MasterDataChangeProcess   as _MasterDataChangeProcess   on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess

  association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer
{

  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key CompanyCode,
  key DunningArea,
      BPAssignmentID,
      Customer,
      DunningRecipient,
      LegDunningProcedureOn,
      LastDunnedOn,
      DunningProcedure,
      DunningLevel,
      DunningBlock,
      DunningClerk,
      cast(
      case when MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
        MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
      else ' '
      end as abap_boolean preserving type
      ) as MasterDataIsCurrent,

      /* Associations */
      _BusinessPartner,
      _Customer,
      _CustomerCompany,
      _CustomerToBusinessPartner

}
where

  MDChgProcessSourceModified <> 'D'


union all

select from I_CustomerDunning

association [1..1] to I_BusinessPartnerGov        as _BusinessPartner           on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
association [1..1] to I_BPCustomerGov             as _Customer                  on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
association [1..1] to I_BPCustomerCompanyGov      as _CustomerCompany           on  $projection.MasterDataChangeProcess = _CustomerCompany.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _CustomerCompany.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _CustomerCompany.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _CustomerCompany.MDChgProcessSrceObject
                                                                                and $projection.CompanyCode             = _CustomerCompany.CompanyCode

association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer


{


  key  '000000000000'                                              as MasterDataChangeProcess,
  key  '0000'                                                      as MDChgProcessStep,
  key  ''                                                          as MDChgProcessSrceSystem,
  key  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as MDChgProcessSrceObject,
  key  CompanyCode,
  key  DunningArea,
       '000000000002'                                              as BPAssignmentID,
       Customer,
       DunningRecipient,
       LegDunningProcedureOn,
       LastDunnedOn,
       DunningProcedure,
       DunningLevel,
       DunningBlock,
       DunningClerk,
       cast( 'X' as abap_boolean preserving type )                 as MasterDataIsCurrent,

       /* Associations */
       _BusinessPartner,
       _Customer,
       _CustomerCompany,
       _CustomerToBusinessPartner

}

where
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERDUNNINGPROCESS",
"I_BUSINESSPARTNER",
"I_CUSTOMERDUNNING",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_MASTERDATACHANGEPROCESS"
],
"ASSOCIATED":
[
"I_BPCUSTOMERCOMPANYGOV",
"I_BPCUSTOMERGOV",
"I_BUSINESSPARTNERGOV",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More