C_MaintNotifActivityTP

DDL: C_MAINTNOTIFACTIVITYTP SQL: CNOTIFACTVTP Type: view CONSUMPTION
25 Fields 1 Data Sources 3 Associations

Maintenance Notification Activity

C_MaintNotifActivityTP is a Consumption CDS View that provides data about "Maintenance Notification Activity" in SAP S/4HANA. It reads from 1 data source (I_MaintNotifActivityTP) and exposes 25 fields with key fields MaintNotificationActivity, MaintenanceNotification. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotifActivityTP I_MaintNotifActivityTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_MaintNotificationTP _MaintNotificationTP _MaintNotificationTP.MaintenanceNotification = $projection.MaintenanceNotification
[0..*] I_InspectionCodeText _MaintNotifActivityCodeText $projection.MaintNotificationActivityCode = _MaintNotifActivityCodeText.InspectionCode and $projection.MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeText.InspectionCatalog and $projection.MaintNotifActivityCodeGroup = _MaintNotifActivityCodeText.InspectionCodeGroup
[0..*] I_Inspectioncodegrouptext _MaintNotifActivityCodeGroupT $projection.MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeGroupT.InspectionCatalog and $projection.MaintNotifActivityCodeGroup = _MaintNotifActivityCodeGroupT.InspectionCodeGroup

Annotations (13)

NameValueLevelField
EndUserText.label Maintenance Notification Activity view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CNOTIFACTVTP view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey MaintNotificationActivity view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaintNotificationActivity I_MaintNotifActivityTP MaintNotificationActivity
KEY MaintenanceNotification I_MaintNotifActivityTP MaintenanceNotification Notification
MaintenanceNotificationItem I_MaintNotifActivityTP MaintenanceNotificationItem
MaintNotifActivityForEdit I_MaintNotifActivityTP MaintNotifActivityForEdit
MaintNotifActyTxt I_MaintNotifActivityTP MaintNotifActyTxt
MaintNotifActivityCodeCatalog I_MaintNotifActivityTP MaintNotifActivityCodeCatalog
MaintNotificationActivityCode I_MaintNotifActivityTP MaintNotificationActivityCode
MaintNotifActivityCodeGroup I_MaintNotifActivityTP MaintNotifActivityCodeGroup
IsDeleted I_MaintNotifActivityTP IsDeleted TRUE
CreatedByUser I_MaintNotifActivityTP CreatedByUser User Name
PlannedStartDate I_MaintNotifActivityTP PlannedStartDate Latest Planned Start
PlannedStartTime I_MaintNotifActivityTP PlannedStartTime
MaintNotifActyQtyFactor I_MaintNotifActivityTP MaintNotifActyQtyFactor
PlannedEndDate I_MaintNotifActivityTP PlannedEndDate Ltst Planned Finish
PlannedEndTime I_MaintNotifActivityTP PlannedEndTime
MaintNotifActivitySortNumber I_MaintNotifActivityTP MaintNotifActivitySortNumber
_IsDeleted I_MaintNotifActivityTP _IsDeleted
_MaintenanceNotification I_MaintNotifActivityTP _MaintenanceNotification
_MaintenanceNotificationItem I_MaintNotifActivityTP _MaintenanceNotificationItem
_MaintNotifActivityCodeCatalog I_MaintNotifActivityTP _MaintNotifActivityCodeCatalog
_MaintNotifActivityCodeGroup I_MaintNotifActivityTP _MaintNotifActivityCodeGroup
_MaintNotificationActivityCode I_MaintNotifActivityTP _MaintNotificationActivityCode
_MaintNotificationTP _MaintNotificationTP
_MaintNotifActivityCodeGroupT _MaintNotifActivityCodeGroupT
_MaintNotifActivityCodeText _MaintNotifActivityCodeText

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_MaintNotifActivityTP.
-- 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: CNOTIFACTVTP

CREATE VIEW C_MaintNotifActivityTP AS
SELECT
  I_MaintNotifActivityTP.MaintNotificationActivity AS MaintNotificationActivity,
  I_MaintNotifActivityTP.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotifActivityTP.MaintenanceNotificationItem AS MaintenanceNotificationItem,
  I_MaintNotifActivityTP.MaintNotifActivityForEdit AS MaintNotifActivityForEdit,
  I_MaintNotifActivityTP.MaintNotifActyTxt AS MaintNotifActyTxt,
  I_MaintNotifActivityTP.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  I_MaintNotifActivityTP.MaintNotificationActivityCode AS MaintNotificationActivityCode,
  I_MaintNotifActivityTP.MaintNotifActivityCodeGroup AS MaintNotifActivityCodeGroup,
  I_MaintNotifActivityTP.IsDeleted AS IsDeleted,
  I_MaintNotifActivityTP.CreatedByUser AS CreatedByUser,
  I_MaintNotifActivityTP.PlannedStartDate AS PlannedStartDate,
  I_MaintNotifActivityTP.PlannedStartTime AS PlannedStartTime,
  I_MaintNotifActivityTP.MaintNotifActyQtyFactor AS MaintNotifActyQtyFactor,
  I_MaintNotifActivityTP.PlannedEndDate AS PlannedEndDate,
  I_MaintNotifActivityTP.PlannedEndTime AS PlannedEndTime,
  I_MaintNotifActivityTP.MaintNotifActivitySortNumber AS MaintNotifActivitySortNumber,
  I_MaintNotifActivityTP._IsDeleted AS _IsDeleted,
  I_MaintNotifActivityTP._MaintenanceNotification AS _MaintenanceNotification,
  I_MaintNotifActivityTP._MaintenanceNotificationItem AS _MaintenanceNotificationItem,
  I_MaintNotifActivityTP._MaintNotifActivityCodeCatalog AS _MaintNotifActivityCodeCatalog,
  I_MaintNotifActivityTP._MaintNotifActivityCodeGroup AS _MaintNotifActivityCodeGroup,
  I_MaintNotifActivityTP._MaintNotificationActivityCode AS _MaintNotificationActivityCode
FROM I_MaintNotifActivityTP
LEFT OUTER JOIN C_MaintNotificationTP AS _MaintNotificationTP ON _MaintNotificationTP.MaintenanceNotification = MaintenanceNotification  -- association [1..1]
LEFT OUTER JOIN I_InspectionCodeText AS _MaintNotifActivityCodeText ON MaintNotificationActivityCode = _MaintNotifActivityCodeText.InspectionCode AND MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeText.InspectionCatalog AND MaintNotifActivityCodeGroup = _MaintNotifActivityCodeText.InspectionCodeGroup  -- association [0..*]
LEFT OUTER JOIN I_Inspectioncodegrouptext AS _MaintNotifActivityCodeGroupT ON MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeGroupT.InspectionCatalog AND MaintNotifActivityCodeGroup = _MaintNotifActivityCodeGroupT.InspectionCodeGroup  -- association [0..*]
;

Learn More