C_RSHPlngBucketAndEventDetails

DDL: C_RSHPLNGBUCKETANDEVENTDETAILS Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 2 Associations

Maintenance Event and Planning bucket

C_RSHPlngBucketAndEventDetails is a Consumption CDS View that provides data about "Maintenance Event and Planning bucket" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceRevision) and exposes 12 fields with key fields MaintenancePlanningPlant, MaintenanceEvent. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceRevision I_MaintenanceRevision from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintPlngBucketWithRespyData _PlanningBucket _PlanningBucket.MaintenanceEvent = $projection.MaintenanceEvent
[0..1] I_MaintenanceEventTypeText _MaintEventTypeText _MaintEventTypeText.MaintenanceEventType = $projection.MaintenanceEventType

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Maintenance Event and Planning bucket view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant I_MaintenanceRevision MaintenancePlanningPlant Planning Plant
KEY MaintenanceEvent I_MaintenanceRevision MaintenanceRevision Revision
MaintenanceEventText I_MaintenanceRevision MaintenanceRevisionDesc RevDescription
MaintenanceEventType I_MaintenanceRevision MaintenanceEventType Revision Type
MaintEventTypeDescription
MaintPlanningBucketUUID _PlanningBucket MaintPlanningBucketUUID UUID
MaintPlngBucketLabel _PlanningBucket MaintPlngBucketLabel Label
MaintPlanningBucketDescription _PlanningBucket MaintPlanningBucketDescription Description
MaintPlanningBucketPersonResp _PlanningBucket MaintPlanningBucketPersonResp Person Responsible
PersonResponsibleName
MaintPlanningBucketType _PlanningBucket MaintPlanningBucketType Type
_PersonWorkAgreement _PlanningBucket _PersonWorkAgreement

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_RSHPlngBucketAndEventDetails.
-- 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.

CREATE VIEW C_RSHPlngBucketAndEventDetails AS
SELECT
  I_MaintenanceRevision.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintenanceRevision.MaintenanceRevision AS MaintenanceEvent,
  I_MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceEventText,
  I_MaintenanceRevision.MaintenanceEventType AS MaintenanceEventType,
  _MaintEventTypeText[ 1: Language = $session.system_language ].MaintEventTypeDescription AS MaintEventTypeDescription,
  _PlanningBucket.MaintPlanningBucketUUID AS MaintPlanningBucketUUID,
  _PlanningBucket.MaintPlngBucketLabel AS MaintPlngBucketLabel,
  _PlanningBucket.MaintPlanningBucketDescription AS MaintPlanningBucketDescription,
  _PlanningBucket.MaintPlanningBucketPersonResp AS MaintPlanningBucketPersonResp,
  _PlanningBucket._PersonWorkAgreement.PersonFullName AS PersonResponsibleName,
  _PlanningBucket.MaintPlanningBucketType AS MaintPlanningBucketType,
  _PlanningBucket._PersonWorkAgreement AS _PersonWorkAgreement
FROM I_MaintenanceRevision
LEFT OUTER JOIN I_MaintPlngBucketWithRespyData AS _PlanningBucket ON _PlanningBucket.MaintenanceEvent = MaintenanceEvent  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceEventTypeText AS _MaintEventTypeText ON _MaintEventTypeText.MaintenanceEventType = MaintenanceEventType  -- association [0..1]
;

Learn More