C_MaintPlanningBucketScopeTP

DDL: C_MAINTPLANNINGBUCKETSCOPETP SQL: CMTPLNGBKTSCPTP Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Maintenance Planning Bucket Scope

C_MaintPlanningBucketScopeTP is a Consumption CDS View that provides data about "Maintenance Planning Bucket Scope" in SAP S/4HANA. It reads from 1 data source (I_MaintPlanningBucketScopeTP) and exposes 19 fields with key field MaintPlanningBucketScopeUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintPlanningBucketScopeTP _MaintPlanningBucketScopeTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_MaintPlanningBucketTP _MaintPlanningBucket _MaintPlanningBucket.MaintPlanningBucketUUID = $projection.MaintPlanningBucketUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMTPLNGBKTSCPTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Planning Bucket Scope view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey MaintPlanningBucketScopeUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketScopeUUID MaintPlanningBucketScopeUUID UUID
MaintPlanningBucketUUID MaintPlanningBucketUUID UUID
MaintPlngBcktScpRangeFieldName MaintPlngBcktScpRangeFieldName Field Name
MaintPlngBucketScopeRgSg MaintPlngBucketScopeRgSg INCL/EXCL
MaintPlngBucketScopeRgOp MaintPlngBucketScopeRgOp Option
MaintPlngBucketScopeRgFr MaintPlngBucketScopeRgFr Field Value
MaintPlngBucketScopeRgTo MaintPlngBucketScopeRgTo Field Value
MaintPlngBcktScopeDescription MaintPlngBcktScopeDescription
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlant MaintenancePlant Maintenance Plant
PlantSection PlantSection Plant Section
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
MainWorkCenter MainWorkCenter Work Center
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintPlanningBucket _MaintPlanningBucket

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MaintPlanningBucketScopeTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMTPLNGBKTSCPTP

CREATE VIEW C_MaintPlanningBucketScopeTP AS
SELECT
  MaintPlanningBucketScopeUUID,
  MaintPlanningBucketUUID,
  MaintPlngBcktScpRangeFieldName,
  MaintPlngBucketScopeRgSg,
  MaintPlngBucketScopeRgOp,
  MaintPlngBucketScopeRgFr,
  MaintPlngBucketScopeRgTo,
  MaintPlngBcktScopeDescription,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenancePlant,
  PlantSection,
  TechnicalObjectLabel,
  MainWorkCenter,
  TechObjIsEquipOrFuncnlLoc,
  WorkCenterInternalID,
  WorkCenterTypeCode
FROM I_MaintPlanningBucketScopeTP AS _MaintPlanningBucketScopeTP
LEFT OUTER JOIN C_MaintPlanningBucketTP AS _MaintPlanningBucket ON _MaintPlanningBucket.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [1..1]
;

Learn More