A_MaintNotificationTask

DDL: A_MAINTNOTIFICATIONTASK Type: view_entity COMPOSITE
19 Fields 1 Data Sources

Maintenance Notification Task

A_MaintNotificationTask is a Composite CDS View that provides data about "Maintenance Notification Task" in SAP S/4HANA. It reads from 1 data source (R_MaintNotificationTaskTP) and exposes 19 fields with key fields MaintenanceNotification, MaintenanceNotificationTask.

Data Sources (1)

SourceAliasJoin Type
R_MaintNotificationTaskTP R_MaintNotificationTaskTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Maintenance Notification Task view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
OData.entityType.name MaintenanceNotificationTask_Type view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Notification
KEY MaintenanceNotificationTask MaintenanceNotificationTask
MaintenanceNotificationItem MaintenanceNotificationItem
MaintNotifTaskTxt MaintNotifTaskTxt
MaintNotifTaskCodeGroup MaintNotifTaskCodeGroup
MaintNotifTaskCodeGroupName
MaintNotifTaskCode MaintNotifTaskCode
MaintNotifTaskCodeName
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedStartTime PlannedStartTime
PlannedEndDate PlannedEndDate Ltst Planned Finish
PlannedEndTime PlannedEndTime
CompletedByUser CompletedByUser
CompletionDate CompletionDate Completion Date
CompletionTime CompletionTime Completion Time
ResponsiblePersonFunctionCode ResponsiblePersonFunctionCode
MaintNotifPersonResponsible MaintNotifPersonResponsible Processor
IsDeleted IsDeleted TRUE
_MaintenanceNotification _MaintenanceNotification

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 A_MaintNotificationTask.
-- 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 A_MaintNotificationTask AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationTask,
  MaintenanceNotificationItem,
  MaintNotifTaskTxt,
  MaintNotifTaskCodeGroup,
  _MaintNotifTaskCodeGroup._Text[1:Language=$session.system_language].InspSpecAddlCodeGroupText AS MaintNotifTaskCodeGroupName,
  MaintNotifTaskCode,
  _MaintNotificationTaskCode._Text[1:Language=$session.system_language].InspectionCodeText AS MaintNotifTaskCodeName,
  PlannedStartDate,
  PlannedStartTime,
  PlannedEndDate,
  PlannedEndTime,
  CompletedByUser,
  CompletionDate,
  CompletionTime,
  ResponsiblePersonFunctionCode,
  MaintNotifPersonResponsible,
  IsDeleted
FROM R_MaintNotificationTaskTP
;

Learn More