R_MaintenanceEventTP

DDL: R_MAINTENANCEEVENTTP Type: view_entity TRANSACTIONAL
22 Fields 1 Data Sources

Maintenance Event - TP

R_MaintenanceEventTP is a Transactional CDS View that provides data about "Maintenance Event - TP" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceEvent) and exposes 22 fields with key fields MaintenancePlanningPlant, MaintenanceEvent.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceEvent I_MaintenanceEvent from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Event - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name MaintenanceEvent view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
KEY MaintenanceEvent MaintenanceEvent Revision
MaintenanceEventDescription MaintenanceEventDescription RevDescription
MaintenanceEventStartDate MaintenanceEventStartDate Start date
MaintenanceEventStartTime MaintenanceEventStartTime RevStrtTime
MaintenanceEventEndDate MaintenanceEventEndDate End date
MaintenanceEventEndTime MaintenanceEventEndTime RevEndTime
MaintenanceEventIsCompleted MaintenanceEventIsCompleted RevCompleted
MainWorkCenterTypeCode MainWorkCenterTypeCode Object Type
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
MaintObjectInternalID MaintObjectInternalID Object number
MaintenanceEventType MaintenanceEventType Revision Type
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter

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 R_MaintenanceEventTP.
-- 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 R_MaintenanceEventTP AS
SELECT
  MaintenancePlanningPlant,
  MaintenanceEvent,
  MaintenanceEventDescription,
  MaintenanceEventStartDate,
  MaintenanceEventStartTime,
  MaintenanceEventEndDate,
  MaintenanceEventEndTime,
  MaintenanceEventIsCompleted,
  MainWorkCenterTypeCode,
  Equipment,
  FunctionalLocation,
  WBSElementInternalID,
  LastChangedByUser,
  LastChangeDate,
  CreatedByUser,
  CreationDate,
  LastChangeDateTime,
  MaintObjectInternalID,
  MaintenanceEventType,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant
FROM I_MaintenanceEvent
;

Learn More