I_MaintPlanningBucketScopeTP

DDL: I_MAINTPLANNINGBUCKETSCOPETP Type: view_entity TRANSACTIONAL Package: EAM_PLANNINGBUCKET

Maintenance Planning Bucket Scope TP

I_MaintPlanningBucketScopeTP is a Transactional CDS View that provides data about "Maintenance Planning Bucket Scope TP" in SAP S/4HANA. It reads from 1 data source (I_MaintPlanningBucketScope) and exposes 21 fields with key field MaintPlanningBucketScopeUUID. It has 6 associations to related views. Part of development package EAM_PLANNINGBUCKET.

Data Sources (1)

SourceAliasJoin Type
I_MaintPlanningBucketScope I_MaintPlanningBucketScope from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_MaintPlanningBucketTP _MaintPlanningBucket _MaintPlanningBucket.MaintPlanningBucketUUID = $projection.MaintPlanningBucketUUID
[0..1] I_MaintenancePlannerGroup _MaintenancePlannerGroup _MaintenancePlannerGroup.MaintenancePlannerGroup = $projection.MaintenancePlannerGroup and _MaintenancePlannerGroup.MaintenancePlanningPlant = $projection.maintenanceplanningplant
[0..1] I_TechnicalObject _TechnicalObject _TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
[0..1] I_WorkCenter _MainWorkCenter _MainWorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID and _MainWorkCenter.WorkCenterTypeCode = $projection.WorkCenterTypeCode
[0..1] I_WorkCenter _WorkCenter _WorkCenter.WorkCenterInternalID = $projection.MaintPlngBucketScopeRgFr and _WorkCenter.WorkCenterTypeCode = 'A' and $projection.MaintPlngBcktScpRangeFieldName = 'MainWorkCenterInternalID'
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel _FunctionalLocationLabel.FunctionalLocation = $projection.MaintPlngBucketScopeRgFr and $projection.MaintPlngBcktScpRangeFieldName = 'FunctionalLocation'

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Planning Bucket Scope TP view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence EAM_PLNGBKTSCP_D view
ObjectModel.writeActivePersistence EAM_PLNGBKTSCP view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.representativeKey MaintPlanningBucketScopeUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
Analytics.technicalName IMTPLNGBKTSCPTP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketScopeUUID MaintPlanningBucketScopeUUID
MaintPlanningBucketUUID MaintPlanningBucketUUID
MaintPlngBcktScpRangeFieldName MaintPlngBcktScpRangeFieldName
MaintPlngBucketScopeRgSg MaintPlngBucketScopeRgSg
MaintPlngBucketScopeRgOp MaintPlngBucketScopeRgOp
MaintPlngBucketScopeRgFr MaintPlngBucketScopeRgFr
MaintPlngBucketScopeRgTo MaintPlngBucketScopeRgTo
MaintPlngBcktScopeDescription
NumberOfItems
MaintenancePlanningPlant _MaintPlanningBucket MaintenancePlanningPlant
MaintenancePlannerGroup
MaintenancePlant
PlantSection
TechnicalObject
WorkCenterInternalID
WorkCenterTypeCode
MainWorkCenter
_MaintPlanningBucket _MaintPlanningBucket
_MaintenancePlannerGroup _MaintenancePlannerGroup
_TechnicalObject _TechnicalObject
_MainWorkCenter _MainWorkCenter
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planning Bucket Scope TP'

@ObjectModel: {
  createEnabled:                  true,
  updateEnabled:                  true,
  deleteEnabled:                  true,
  writeDraftPersistence:          'EAM_PLNGBKTSCP_D',
  writeActivePersistence:         'EAM_PLNGBKTSCP',
  modelCategory:                  #BUSINESS_OBJECT,
  representativeKey:              'MaintPlanningBucketScopeUUID',
  semanticKey:                    ['MaintPlanningBucketScopeUUID'],
  usageType: {
    serviceQuality: #C,
    dataClass:      #TRANSACTIONAL,
    sizeCategory:   #L
  }
}
@Analytics.technicalName: 'IMTPLNGBKTSCPTP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view entity I_MaintPlanningBucketScopeTP
  as select from I_MaintPlanningBucketScope
  association [1..1] to I_MaintPlanningBucketTP    as _MaintPlanningBucket         on  _MaintPlanningBucket.MaintPlanningBucketUUID = $projection.MaintPlanningBucketUUID

  association [0..1] to I_MaintenancePlannerGroup  as _MaintenancePlannerGroup     on  _MaintenancePlannerGroup.MaintenancePlannerGroup  = $projection.MaintenancePlannerGroup
                                                                                   and _MaintenancePlannerGroup.MaintenancePlanningPlant = $projection.maintenanceplanningplant

  association [0..1] to I_TechnicalObject          as _TechnicalObject             on  _TechnicalObject.TechnicalObject           = $projection.TechnicalObject
                                                                                   and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc

  association [0..1] to I_WorkCenter               as _MainWorkCenter              on  _MainWorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID
                                                                                   and _MainWorkCenter.WorkCenterTypeCode   = $projection.WorkCenterTypeCode
  association [0..1] to I_WorkCenter               as _WorkCenter                  on  _WorkCenter.WorkCenterInternalID           = $projection.MaintPlngBucketScopeRgFr
                                                                                   and _WorkCenter.WorkCenterTypeCode             = 'A'
                                                                                   and $projection.MaintPlngBcktScpRangeFieldName = 'MainWorkCenterInternalID'
  association [0..1] to I_FunctionalLocationLabel  as _FunctionalLocationLabel     on  _FunctionalLocationLabel.FunctionalLocation = $projection.MaintPlngBucketScopeRgFr
                                                                                   and $projection.MaintPlngBcktScpRangeFieldName  = 'FunctionalLocation'


{
      @UI.hidden
  key MaintPlanningBucketScopeUUID,
      @UI.hidden
      MaintPlanningBucketUUID,

      MaintPlngBcktScpRangeFieldName,
      MaintPlngBucketScopeRgSg,
      MaintPlngBucketScopeRgOp,
      MaintPlngBucketScopeRgFr,
      MaintPlngBucketScopeRgTo,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_CALC_MTPLNGBKTSCPDESC'
      @ObjectModel.readOnly
      cast( '' as ktext40 )                                                                                                                                     as MaintPlngBcktScopeDescription,

      @UI.hidden
      @ObjectModel.readOnly
      cast( 0 as abap.int1 )                                                                                                                                    as NumberOfItems,

      /*** Dummy Fields for Value Helps ***/
      @ObjectModel.readOnly
      _MaintPlanningBucket.MaintenancePlanningPlant,

      @ObjectModel.foreignKey.association: '_MaintenancePlannerGroup'
      @Consumption.valueHelpDefinition: [{ entity : { name: 'C_MaintenancePlannerGroupVH', element: 'MaintenancePlannerGroup' },
                                           additionalBinding: [{ element: 'MaintenancePlanningPlant', localElement: 'MaintenancePlanningPlant' }],useForValidation: true }] 
                                           
      cast( '' as eam_planner_group )                                                                                                                           as MaintenancePlannerGroup,

      @Consumption.valueHelpDefinition: [{ entity : { name: 'I_PlantStdVH', element: 'Plant' } }]
      cast( '' as eams_maintplant )                                                                                                                             as MaintenancePlant,

      @Consumption.valueHelpDefinition: [{ entity : { name: 'I_PlantSectionStdVH', element: 'PlantSection' },
                                           additionalBinding: [{ element: 'Plant', localElement: 'MaintenancePlant' }] }]
      cast( '' as beber )                                                                                                                                       as PlantSection,

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TechnicalObjectStdVH',
                     element: 'TechnicalObject' },
          additionalBinding: [{ localElement: 'TechObjIsEquipOrFuncnlLoc',
                                element: 'TechObjIsEquipOrFuncnlLoc' }]
        }]
      cast( '' as eams_tec_obj )                                                                                                                                as TechnicalObject,

      cast( case MaintPlngBcktScpRangeFieldName when 'Equipment' then 'EAMS_EQUI'
                                                when 'FunctionalLocation' then 'EAMS_FL' end as eams_tec_obj_type )                                             as TechObjIsEquipOrFuncnlLoc,

      @ObjectModel.foreignKey.association: '_MainWorkCenter'
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_WorkCenterStdVh',
               element: 'WorkCenter' },
      additionalBinding: [{ localElement: 'WorkCenterTypeCode',
                          element: 'WorkCenterTypeCode' }]
      }]
      cast( case when MaintPlngBcktScpRangeFieldName = 'MainWorkCenterInternalID' then MaintPlngBucketScopeRgFr end as arbpl )                                  as WorkCenterInternalID,

      cast( 'A' as cr_objty )                                                                                                                                   as WorkCenterTypeCode, // 'A' = Work center


      @Consumption.valueHelpDefinition: [{ entity: { name: 'C_PMWorkCenterVH', element: 'WorkCenter' },
                                          additionalBinding: [{ localElement: 'WorkCenterInternalID',
                                                                element: 'WorkCenterInternalID',
                                                                usage: #RESULT }] }]
      cast( _WorkCenter.WorkCenter as eam_main_work_center preserving type )                                                                                    as MainWorkCenter,

      @Consumption.valueHelpDefinition: [{ entity: { name: 'C_TechnicalObjectLabelVH', element: 'TechnicalObjectLabel' },
                                          additionalBinding: [{ localElement: 'TechnicalObject',
                                                                element: 'TechnicalObject',
                                                                usage: #RESULT },
                                                              { localElement: 'TechObjIsEquipOrFuncnlLoc',
                                                                element: 'TechObjIsEquipOrFuncnlLoc',
                                                                usage: #RESULT }] }]
      cast( case MaintPlngBcktScpRangeFieldName when 'Equipment' then MaintPlngBucketScopeRgFr
                                                when 'FunctionalLocation' then _FunctionalLocationLabel.FunctionalLocationLabelName end as eams_tech_obj_conv ) as TechnicalObjectLabel,


      /*** Dummy Fields for Value Helps ***/



      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _MaintPlanningBucket,
      _MaintenancePlannerGroup,
      _TechnicalObject,
      _MainWorkCenter
}