C_MaintNotifItemTaskTP

DDL: C_MAINTNOTIFITEMTASKTP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources

Maintenance Notification Item Task

C_MaintNotifItemTaskTP is a Consumption CDS View that provides data about "Maintenance Notification Item Task" in SAP S/4HANA. It reads from 1 data source (R_MaintNotificationItemTaskTP) and exposes 14 fields with key fields MaintenanceNotification, MaintenanceNotificationItem, MaintenanceNotificationTask.

Data Sources (1)

SourceAliasJoin Type
R_MaintNotificationItemTaskTP R_MaintNotificationItemTaskTP projection

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Item Task view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Maintenance Notification
KEY MaintenanceNotificationItem MaintenanceNotificationItem Damages Number
KEY MaintenanceNotificationTask MaintenanceNotificationTask Task Number
MaintNotifTaskTxt MaintNotifTaskTxt Task Text
MaintNotifTaskCodeGroup MaintNotifTaskCodeGroup Cause Code Group
MaintNotifTaskCodeGroupName Cause Code Group Text
MaintNotifTaskCode MaintNotifTaskCode Cause Code
MaintNotifTaskCodeName Cause Code Text
MaintNotifTaskCodeCatalog MaintNotifTaskCodeCatalog
PlannedStartDate PlannedStartDate Task Start Date
PlannedStartTime PlannedStartTime Start Time of Task
PlannedEndDate PlannedEndDate Task End Date
PlannedEndTime PlannedEndTime End Time of Task
_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 C_MaintNotifItemTaskTP.
-- 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_MaintNotifItemTaskTP AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationItem,
  MaintenanceNotificationTask,
  MaintNotifTaskTxt,
  MaintNotifTaskCodeGroup,
  _MaintNotifTaskCodeGroup._Text[1:Language=$session.system_language].InspSpecAddlCodeGroupText AS MaintNotifTaskCodeGroupName,
  MaintNotifTaskCode,
  _MaintNotificationTaskCode._Text[1:Language=$session.system_language].InspectionCodeText AS MaintNotifTaskCodeName,
  MaintNotifTaskCodeCatalog,
  PlannedStartDate,
  PlannedStartTime,
  PlannedEndDate,
  PlannedEndTime
FROM R_MaintNotificationItemTaskTP
;

Learn More