I_BPCustPartnerFunctionGov

DDL: I_BPCUSTPARTNERFUNCTIONGOV Type: view_entity COMPOSITE

BP Customer Partner Function Governance

I_BPCustPartnerFunctionGov is a Composite CDS View that provides data about "BP Customer Partner Function Governance" in SAP S/4HANA. It reads from 2 data sources (I_BPCustPartnerFunctionsProc, I_CustSalesPartnerFunc) and exposes 45 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 5 associations to related views.

2 data source(s) 45 fields

Data Sources (2)

SourceAliasJoin Type
I_BPCustPartnerFunctionsProc I_BPCustPartnerFunctionsProc from
I_CustSalesPartnerFunc I_CustSalesPartnerFunc union_all

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
[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_BusinessPartnerGov _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[1..1] I_BPCustomerSalesAreaGov _SalesArea $projection.MasterDataChangeProcess = _SalesArea.MasterDataChangeProcess and $projection.MDChgProcessStep = _SalesArea.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _SalesArea.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _SalesArea.MDChgProcessSrceObject and $projection.SalesOrganization = _SalesArea.SalesOrganization and $projection.DistributionChannel = _SalesArea.DistributionChannel and $projection.Division = _SalesArea.Division
[1..1] I_CustomerToBusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Partner Function Governance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY PartnerFunction PartnerFunction
KEY PartnerCounter PartnerCounter
BPAssignmentID BPAssignmentID
Customer Customer
PartnerFunctionType PartnerFunctionType
BPCustomerNumber BPCustomerNumber
Supplier Supplier
PersonnelNumber PersonnelNumber
ContactPerson ContactPerson
CustomerPartnerDescription CustomerPartnerDescription
DefaultPartner DefaultPartner
AddressID AddressID
_BusinessPartner _BusinessPartner
_Customer _Customer
_SalesArea _SalesArea
KEY MDChgProcessStep
KEY MDChgProcessSrceSystem
KEY MDChgProcessSrceObject
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY PartnerFunction PartnerFunction
KEY PartnerCounter PartnerCounter
BPAssignmentID
Customer Customer
PartnerFunctionType PartnerFunctionType
BPCustomerNumber BPCustomerNumber
Supplier Supplier
PersonnelNumber PersonnelNumber
ContactPerson ContactPerson
CustomerPartnerDescription CustomerPartnerDescription
DefaultPartner DefaultPartner
AddressID AddressID
MasterDataIsCurrent
_BusinessPartner _BusinessPartner
_Customer _Customer
_SalesArea _SalesArea
_CustomerToBusinessPartner _CustomerToBusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Partner Function Governance'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_BPCustPartnerFunctionGov
  as select from I_BPCustPartnerFunctionsProc
  association [0..1] to I_MasterDataChangeProcess   as _MasterDataChangeProcess   on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
  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_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_BPCustomerSalesAreaGov    as _SalesArea                 on  $projection.MasterDataChangeProcess = _SalesArea.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _SalesArea.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _SalesArea.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _SalesArea.MDChgProcessSrceObject
                                                                                  and $projection.SalesOrganization       = _SalesArea.SalesOrganization
                                                                                  and $projection.DistributionChannel     = _SalesArea.DistributionChannel
                                                                                  and $projection.Division                = _SalesArea.Division
  association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer


{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key SalesOrganization,
  key DistributionChannel,
  key Division,
  key PartnerFunction,
  key PartnerCounter,
      BPAssignmentID,
      Customer,
      PartnerFunctionType,
      BPCustomerNumber,
      Supplier,
      PersonnelNumber,
      ContactPerson,
      CustomerPartnerDescription,
      DefaultPartner,
      AddressID,

      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,
      _SalesArea,
      _CustomerToBusinessPartner

}
where
  MDChgProcessSourceModified <> 'D'

union all

select from I_CustSalesPartnerFunc
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_BPCustomerSalesAreaGov    as _SalesArea                 on  $projection.MasterDataChangeProcess = _SalesArea.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _SalesArea.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _SalesArea.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _SalesArea.MDChgProcessSrceObject
                                                                                and $projection.SalesOrganization       = _SalesArea.SalesOrganization
                                                                                and $projection.DistributionChannel     = _SalesArea.DistributionChannel
                                                                                and $projection.Division                = _SalesArea.Division

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  SalesOrganization,
  key  DistributionChannel,
  key  Division,
  key  PartnerFunction,
  key  PartnerCounter,
       '000000000002'                                              as BPAssignmentID,
       Customer,
       PartnerFunctionType,
       BPCustomerNumber,
       Supplier,
       PersonnelNumber,
       ContactPerson,
       CustomerPartnerDescription,
       DefaultPartner,
       AddressID,

       cast( 'X' as abap_boolean preserving type )                 as MasterDataIsCurrent,

       /* Associations */
       _BusinessPartner,
       _Customer,
       _SalesArea,
       _CustomerToBusinessPartner
}
where
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTPARTNERFUNCTIONSPROC",
"I_BUSINESSPARTNER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_CUSTSALESPARTNERFUNC",
"I_MASTERDATACHANGEPROCESS"
],
"ASSOCIATED":
[
"I_BPCUSTOMERGOV",
"I_BPCUSTOMERSALESAREAGOV",
"I_BUSINESSPARTNERGOV",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More