I_BPCustUnloadingPointGov

DDL: I_BPCUSTUNLOADINGPOINTGOV Type: view_entity COMPOSITE Package: MDC_CUST_GOV_BO

BP Customer Unloading Point Governance

I_BPCustUnloadingPointGov is a Composite CDS View that provides data about "BP Customer Unloading Point Governance" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerUnloadingPointProc, I_CustomerUnloadingPoint) and exposes 79 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, UnloadingPointName. It has 4 associations to related views. Part of development package MDC_CUST_GOV_BO.

2 data source(s) 79 fields

Data Sources (2)

SourceAliasJoin Type
I_BPCustomerUnloadingPointProc I_BPCustomerUnloadingPointProc from
I_CustomerUnloadingPoint I_CustomerUnloadingPoint union_all

Associations (4)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Unloading Point Governance 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 (79)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY UnloadingPointName UnloadingPointName
BPAssignmentID BPAssignmentID
Customer Customer
CustomerFactoryCalenderCode CustomerFactoryCalenderCode
BPGoodsReceivingHoursCode BPGoodsReceivingHoursCode
IsDfltBPUnloadingPoint IsDfltBPUnloadingPoint
MondayMorningOpeningTime MondayMorningOpeningTime
MondayMorningClosingTime MondayMorningClosingTime
MondayAfternoonOpeningTime MondayAfternoonOpeningTime
MondayAfternoonClosingTime MondayAfternoonClosingTime
TuesdayMorningOpeningTime TuesdayMorningOpeningTime
TuesdayMorningClosingTime TuesdayMorningClosingTime
TuesdayAfternoonOpeningTime TuesdayAfternoonOpeningTime
TuesdayAfternoonClosingTime TuesdayAfternoonClosingTime
WednesdayMorningOpeningTime WednesdayMorningOpeningTime
WednesdayMorningClosingTime WednesdayMorningClosingTime
WednesdayAfternoonOpeningTime WednesdayAfternoonOpeningTime
WednesdayAfternoonClosingTime WednesdayAfternoonClosingTime
ThursdayMorningOpeningTime ThursdayMorningOpeningTime
ThursdayMorningClosingTime ThursdayMorningClosingTime
ThursdayAfternoonOpeningTime ThursdayAfternoonOpeningTime
ThursdayAfternoonClosingTime ThursdayAfternoonClosingTime
FridayMorningOpeningTime FridayMorningOpeningTime
FridayMorningClosingTime FridayMorningClosingTime
FridayAfternoonOpeningTime FridayAfternoonOpeningTime
FridayAfternoonClosingTime FridayAfternoonClosingTime
SaturdayMorningOpeningTime SaturdayMorningOpeningTime
SaturdayMorningClosingTime SaturdayMorningClosingTime
SaturdayAfternoonOpeningTime SaturdayAfternoonOpeningTime
SaturdayAfternoonClosingTime SaturdayAfternoonClosingTime
SundayMorningOpeningTime SundayMorningOpeningTime
SundayMorningClosingTime SundayMorningClosingTime
SundayAfternoonOpeningTime SundayAfternoonOpeningTime
SundayAfternoonClosingTime SundayAfternoonClosingTime
_Customer _Customer
KEY MDChgProcessStep
KEY MDChgProcessSrceSystem
KEY MDChgProcessSrceObject
KEY UnloadingPointName UnloadingPointName
BPAssignmentID
Customer Customer
CustomerFactoryCalenderCode CustomerFactoryCalenderCode
BPGoodsReceivingHoursCode BPGoodsReceivingHoursCode
IsDfltBPUnloadingPoint IsDfltBPUnloadingPoint
MondayMorningOpeningTime MondayMorningOpeningTime
MondayMorningClosingTime MondayMorningClosingTime
MondayAfternoonOpeningTime MondayAfternoonOpeningTime
MondayAfternoonClosingTime MondayAfternoonClosingTime
TuesdayMorningOpeningTime TuesdayMorningOpeningTime
TuesdayMorningClosingTime TuesdayMorningClosingTime
TuesdayAfternoonOpeningTime TuesdayAfternoonOpeningTime
TuesdayAfternoonClosingTime TuesdayAfternoonClosingTime
WednesdayMorningOpeningTime WednesdayMorningOpeningTime
WednesdayMorningClosingTime WednesdayMorningClosingTime
WednesdayAfternoonOpeningTime WednesdayAfternoonOpeningTime
WednesdayAfternoonClosingTime WednesdayAfternoonClosingTime
ThursdayMorningOpeningTime ThursdayMorningOpeningTime
ThursdayMorningClosingTime ThursdayMorningClosingTime
ThursdayAfternoonOpeningTime ThursdayAfternoonOpeningTime
ThursdayAfternoonClosingTime ThursdayAfternoonClosingTime
FridayMorningOpeningTime FridayMorningOpeningTime
FridayMorningClosingTime FridayMorningClosingTime
FridayAfternoonOpeningTime FridayAfternoonOpeningTime
FridayAfternoonClosingTime FridayAfternoonClosingTime
SaturdayMorningOpeningTime SaturdayMorningOpeningTime
SaturdayMorningClosingTime SaturdayMorningClosingTime
SaturdayAfternoonOpeningTime SaturdayAfternoonOpeningTime
SaturdayAfternoonClosingTime SaturdayAfternoonClosingTime
SundayMorningOpeningTime SundayMorningOpeningTime
SundayMorningClosingTime SundayMorningClosingTime
SundayAfternoonOpeningTime SundayAfternoonOpeningTime
SundayAfternoonClosingTime SundayAfternoonClosingTime
MasterDataIsCurrent
_Customer _Customer
_BusinessPartnerGov _BusinessPartnerGov 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Unloading Point Governance'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustUnloadingPointGov
  as select from I_BPCustomerUnloadingPointProc

  association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
  association [0..1] to I_BPCustomerGov           as _Customer                on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                              and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                              and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
  association [0..1] to I_BusinessPartnerGov      as _BusinessPartnerGov      on  $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _BusinessPartnerGov.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _BusinessPartnerGov.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _BusinessPartnerGov.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key UnloadingPointName,
      BPAssignmentID,
      Customer,
      CustomerFactoryCalenderCode,
      BPGoodsReceivingHoursCode,
      IsDfltBPUnloadingPoint,
      MondayMorningOpeningTime,
      MondayMorningClosingTime,
      MondayAfternoonOpeningTime,
      MondayAfternoonClosingTime,
      TuesdayMorningOpeningTime,
      TuesdayMorningClosingTime,
      TuesdayAfternoonOpeningTime,
      TuesdayAfternoonClosingTime,
      WednesdayMorningOpeningTime,
      WednesdayMorningClosingTime,
      WednesdayAfternoonOpeningTime,
      WednesdayAfternoonClosingTime,
      ThursdayMorningOpeningTime,
      ThursdayMorningClosingTime,
      ThursdayAfternoonOpeningTime,
      ThursdayAfternoonClosingTime,
      FridayMorningOpeningTime,
      FridayMorningClosingTime,
      FridayAfternoonOpeningTime,
      FridayAfternoonClosingTime,
      SaturdayMorningOpeningTime,
      SaturdayMorningClosingTime,
      SaturdayAfternoonOpeningTime,
      SaturdayAfternoonClosingTime,
      SundayMorningOpeningTime,
      SundayMorningClosingTime,
      SundayAfternoonOpeningTime,
      SundayAfternoonClosingTime,

      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 */
      _Customer,
      _BusinessPartnerGov
}

where
  MDChgProcessSourceModified <> 'D'


union all

select from I_CustomerUnloadingPoint

association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer
association [0..1] to I_BPCustomerGov             as _Customer                  on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
  association [0..1] to I_BusinessPartnerGov      as _BusinessPartnerGov      on  $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _BusinessPartnerGov.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _BusinessPartnerGov.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _BusinessPartnerGov.MDChgProcessSrceObject
{

  key  '000000000000'                                              as MasterDataChangeProcess,
  key  '0000'                                                      as MDChgProcessStep,
  key  ''                                                          as MDChgProcessSrceSystem,
  key  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as MDChgProcessSrceObject,
  key  UnloadingPointName,
       '000000000002'                                              as BPAssignmentID,
       Customer,
       CustomerFactoryCalenderCode,
       BPGoodsReceivingHoursCode,
       IsDfltBPUnloadingPoint,
       MondayMorningOpeningTime,
       MondayMorningClosingTime,
       MondayAfternoonOpeningTime,
       MondayAfternoonClosingTime,
       TuesdayMorningOpeningTime,
       TuesdayMorningClosingTime,
       TuesdayAfternoonOpeningTime,
       TuesdayAfternoonClosingTime,
       WednesdayMorningOpeningTime,
       WednesdayMorningClosingTime,
       WednesdayAfternoonOpeningTime,
       WednesdayAfternoonClosingTime,
       ThursdayMorningOpeningTime,
       ThursdayMorningClosingTime,
       ThursdayAfternoonOpeningTime,
       ThursdayAfternoonClosingTime,
       FridayMorningOpeningTime,
       FridayMorningClosingTime,
       FridayAfternoonOpeningTime,
       FridayAfternoonClosingTime,
       SaturdayMorningOpeningTime,
       SaturdayMorningClosingTime,
       SaturdayAfternoonOpeningTime,
       SaturdayAfternoonClosingTime,
       SundayMorningOpeningTime,
       SundayMorningClosingTime,
       SundayAfternoonOpeningTime,
       SundayAfternoonClosingTime,

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

       /* Associations */
       _Customer,
       _BusinessPartnerGov

}
where
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner is not initial

Learn More