I_MaintNotifActivityTechObj

DDL: I_MAINTNOTIFACTIVITYTECHOBJ SQL: INOTIFACTVTECOBJ Type: view COMPOSITE
27 Fields 1 Data Sources 1 Associations

Maint. Notif. Activity /w Tech. Obj.

I_MaintNotifActivityTechObj is a Composite CDS View (Dimension) that provides data about "Maint. Notif. Activity /w Tech. Obj." in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationActivity) and exposes 27 fields with key fields MaintNotificationActivity, MaintenanceNotification. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationActivity I_MaintNotificationActivity from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintNotificationTechObj _MaintNotificationTechObj $projection.MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName INOTIFACTVTECOBJ view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maint. Notif. Activity /w Tech. Obj. view
ObjectModel.representativeKey MaintNotificationActivity view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaintNotificationActivity I_MaintNotificationActivity MaintNotificationActivity Task
KEY MaintenanceNotification I_MaintNotificationActivity MaintenanceNotification Notification
MaintenanceNotificationItem I_MaintNotificationActivity MaintenanceNotificationItem Number of days
MaintNotifActyTxt I_MaintNotificationActivity MaintNotifActyTxt Task Text
MaintNotifActivitySortNumber I_MaintNotificationActivity MaintNotifActivitySortNumber Sort Number
MaintNotifActivityCodeCatalog I_MaintNotificationActivity MaintNotifActivityCodeCatalog
MaintNotificationActivityCode I_MaintNotificationActivity MaintNotificationActivityCode
MaintNotifActivityCodeGroup I_MaintNotificationActivity MaintNotifActivityCodeGroup
IsDeleted I_MaintNotificationActivity IsDeleted TRUE
CreatedByUser I_MaintNotificationActivity CreatedByUser User Name
PlannedStartDate I_MaintNotificationActivity PlannedStartDate Latest Planned Start
PlannedStartTime I_MaintNotificationActivity PlannedStartTime
MaintNotifActyQtyFactor I_MaintNotificationActivity MaintNotifActyQtyFactor Quantity Factor
PlannedEndDate I_MaintNotificationActivity PlannedEndDate Ltst Planned Finish
PlannedEndTime I_MaintNotificationActivity PlannedEndTime
LastChangeDateTime I_MaintNotificationActivity LastChangeDateTime Timestamp
CreationDate I_MaintNotificationActivity CreationDate Time Stamp
CreationTime I_MaintNotificationActivity CreationTime Time of Change
LastChangeDate I_MaintNotificationActivity LastChangeDate Time Stamp
LastChangeTime I_MaintNotificationActivity LastChangeTime Time changed
_MaintNotificationTechObj _MaintNotificationTechObj
_IsDeleted I_MaintNotificationActivity _IsDeleted
_MaintenanceNotification I_MaintNotificationActivity _MaintenanceNotification
_MaintenanceNotificationItem I_MaintNotificationActivity _MaintenanceNotificationItem
_MaintNotifActivityCodeCatalog I_MaintNotificationActivity _MaintNotifActivityCodeCatalog
_MaintNotifActivityCodeGroup I_MaintNotificationActivity _MaintNotifActivityCodeGroup
_MaintNotificationActivityCode I_MaintNotificationActivity _MaintNotificationActivityCode

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 I_MaintNotifActivityTechObj.
-- 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: INOTIFACTVTECOBJ

CREATE VIEW I_MaintNotifActivityTechObj AS
SELECT
  I_MaintNotificationActivity.MaintNotificationActivity AS MaintNotificationActivity,
  I_MaintNotificationActivity.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationActivity.MaintenanceNotificationItem AS MaintenanceNotificationItem,
  I_MaintNotificationActivity.MaintNotifActyTxt AS MaintNotifActyTxt,
  I_MaintNotificationActivity.MaintNotifActivitySortNumber AS MaintNotifActivitySortNumber,
  I_MaintNotificationActivity.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  I_MaintNotificationActivity.MaintNotificationActivityCode AS MaintNotificationActivityCode,
  I_MaintNotificationActivity.MaintNotifActivityCodeGroup AS MaintNotifActivityCodeGroup,
  I_MaintNotificationActivity.IsDeleted AS IsDeleted,
  I_MaintNotificationActivity.CreatedByUser AS CreatedByUser,
  I_MaintNotificationActivity.PlannedStartDate AS PlannedStartDate,
  I_MaintNotificationActivity.PlannedStartTime AS PlannedStartTime,
  I_MaintNotificationActivity.MaintNotifActyQtyFactor AS MaintNotifActyQtyFactor,
  I_MaintNotificationActivity.PlannedEndDate AS PlannedEndDate,
  I_MaintNotificationActivity.PlannedEndTime AS PlannedEndTime,
  I_MaintNotificationActivity.LastChangeDateTime AS LastChangeDateTime,
  I_MaintNotificationActivity.CreationDate AS CreationDate,
  I_MaintNotificationActivity.CreationTime AS CreationTime,
  I_MaintNotificationActivity.LastChangeDate AS LastChangeDate,
  I_MaintNotificationActivity.LastChangeTime AS LastChangeTime,
  I_MaintNotificationActivity._IsDeleted AS _IsDeleted,
  I_MaintNotificationActivity._MaintenanceNotification AS _MaintenanceNotification,
  I_MaintNotificationActivity._MaintenanceNotificationItem AS _MaintenanceNotificationItem,
  I_MaintNotificationActivity._MaintNotifActivityCodeCatalog AS _MaintNotifActivityCodeCatalog,
  I_MaintNotificationActivity._MaintNotifActivityCodeGroup AS _MaintNotifActivityCodeGroup,
  I_MaintNotificationActivity._MaintNotificationActivityCode AS _MaintNotificationActivityCode
FROM I_MaintNotificationActivity
LEFT OUTER JOIN I_MaintNotificationTechObj AS _MaintNotificationTechObj ON MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification  -- association [1..1]
;

Learn More