I_MAINTPLANNINGBUCKET

CDS View

Maintenance Planning Bucket

I_MAINTPLANNINGBUCKET is a CDS View in S/4HANA. Maintenance Planning Bucket. It contains 8 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 8 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MaintPlngBucketOverview view_entity from CONSUMPTION Maintenance Planning Bucket Overview
I_MaintenanceEventStdVH view_entity from COMPOSITE Maintenance Event
P_MaintPlanningBucketSequence view from CONSUMPTION Indicator: Preceding/Succeeding Bucket Exists
P_MaintPlanningBucketSequence view left_outer CONSUMPTION Indicator: Preceding/Succeeding Bucket Exists
R_MaintPlanningBucketTP view_entity from BASIC Maintenance Planning Bucket Transactional Processing

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MaintenancePlanningPlant MaintenancePlanningPlant 1
KEY MaintPlanningBucketUUID MaintPlanningBucketUUID 1
_MaintenancePlanningPlant _MaintenancePlanningPlant 1
MaintPlanningBucketDescription MaintPlanningBucketDescription 1
MaintPlanningBucketType MaintPlanningBucketType 1
MaintPlngBucketEndDateTime MaintPlngBucketEndDateTime 1
MaintPlngBucketLabel MaintPlngBucketLabel 1
MaintPlngBucketStartDateTime MaintPlngBucketStartDateTime 1 
@AbapCatalog.sqlViewName: 'IMAINTPLNGBKT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planning Bucket'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    dataClass:      #TRANSACTIONAL,
    sizeCategory:   #L
  }
}

define view I_MaintPlanningBucket
  as select from eam_plngbkt
  association [0..*] to I_MaintPlanningBucketScope as _MaintPlanningBucketScope on _MaintPlanningBucketScope.MaintPlanningBucketUUID = $projection.MaintPlanningBucketUUID

  association [0..1] to I_MaintenancePlanPlant     as _MaintenancePlanningPlant on _MaintenancePlanningPlant.MaintenancePlanningPlant = $projection.MaintenancePlanningPlant

  association [1]    to I_MaintPlanningBucketType  as _MaintPlanningBucketType  on _MaintPlanningBucketType.MaintPlanningBucketType = $projection.MaintPlanningBucketType

{
      @ObjectModel.text.element: ['MaintPlanningBucketDescription']
      @UI.hidden
  key maintplanningbucketuuid        as MaintPlanningBucketUUID,

      @ObjectModel.foreignKey.association: '_MaintPlanningBucketType'
      maintplanningbuckettype        as MaintPlanningBucketType,
      maintenanceplanningplant       as MaintenancePlanningPlant,

      @ObjectModel.text.element: ['MaintPlanningBucketDescription']
      maintplngbucketlabel           as MaintPlngBucketLabel,
      maintplanningbucketdescription as MaintPlanningBucketDescription,
      refmaintplanningbucket         as RefMaintPlanningBucket,
      maintplngbucketlabelpattern    as MaintPlngBucketLabelPattern,
      maintplngbucketrecurrencetype  as MaintPlngBucketRecurrenceType,
      nrofmaintplngbucketsinadvance  as NrOfMaintPlngBucketsInAdvance,
      maintplngbucketstartdatetime   as MaintPlngBucketStartDateTime,
      @Semantics.quantity.unitOfMeasure: 'MaintPlngBucketDurationUnit'
      maintplngbucketduration        as MaintPlngBucketDuration,
      @Semantics.unitOfMeasure
      maintplngbucketdurationunit    as MaintPlngBucketDurationUnit,
      maintplngbucketenddatetime     as MaintPlngBucketEndDateTime,

      @Semantics.systemDateTime.lastChangedAt
      lastchangedatetime             as LastChangeDateTime,
      maintplngbucketgenerationdate  as MaintPlngBucketGenerationDate,
      maintplngbucketsortfield       as MaintPlngBucketSortUUID,
      maintplngbcktrcrrcinterval     as MaintPlngBcktRcrrcInterval,
      maintenanceevent               as MaintenanceEvent,
      maintorderforadministration    as MaintOrderForAdministration,
      _MaintPlanningBucketScope,
      _MaintenancePlanningPlant,
      _MaintPlanningBucketType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAM_PLNGBKT"
],
"ASSOCIATED":
[
"I_MAINTENANCEPLANPLANT",
"I_MAINTPLANNINGBUCKETSCOPE",
"I_MAINTPLANNINGBUCKETTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More