C_MaintNotificationTechObjTP

DDL: C_MAINTNOTIFICATIONTECHOBJTP SQL: CMAINTNTFTETP Type: view CONSUMPTION
24 Fields 1 Data Sources 2 Associations

Maintenance Notification Tech Object

C_MaintNotificationTechObjTP is a Consumption CDS View that provides data about "Maintenance Notification Tech Object" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationTechObj) and exposes 24 fields with key field MaintenanceNotification. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationTechObj I_MaintNotificationTechObj from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaintNotifDetectionCodeText _MaintNotifDetectCodeTxt $projection.maintnotifdetectioncode = _MaintNotifDetectCodeTxt.MaintNotifDetectionCode
[0..*] I_MaintNotifDetectCodeGroupTxt _MaintNotifDetectCodeGroupTxt _MaintNotifDetectCodeGroupTxt.MaintNotifDetectionCodeGroup = $projection.maintnotifdetectioncodegroup

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTNTFTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Tech Object view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Notification
MaintenanceOrder MaintenanceOrder Order
MaintenanceObjectIsDown MaintenanceObjectIsDown Breakdown
MaintObjDowntimeDurationUnit MaintObjDowntimeDurationUnit Unit
MaintObjectDowntimeDuration MaintObjectDowntimeDuration Breakdown Dur.
TextObjectCategory
TextObjectType
MaintNotifLongTextForEdit
MalfunctionEffect MalfunctionEffect Effect
MalfunctionStartDate MalfunctionStartDate Malfunct. Start
MalfunctionStartTime MalfunctionStartTime Mal. Start (T.)
MalfunctionEndDate MalfunctionEndDate Malfunct. End
MalfunctionEndTime MalfunctionEndTime Malfunction End
MaintNotificationCatalog MaintNotificationCatalog Catalog Type
MaintNotificationCode MaintNotificationCode Coding
MaintNotificationCodeGroup MaintNotificationCodeGroup Code Group
CatalogProfile CatalogProfile Catalog Profile
MaintNotifDetectionCatalog _PMNotifMaintenanceData MaintNotifDetectionCatalog Detection Meth Prfl
MaintNotifDetectionCodeGroup _PMNotifMaintenanceData MaintNotifDetectionCodeGroup Detection Meth Grp
MaintNotifDetectionCode _PMNotifMaintenanceData MaintNotifDetectionCode Detection Meth
_MaintNotifDetectCodeGroupTxt _MaintNotifDetectCodeGroupTxt
_MaintNotifDetectCodeTxt _MaintNotifDetectCodeTxt
_MaintNotificationCode _MaintNotificationCode
_MalfunctionEffect _MalfunctionEffect

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_MaintNotificationTechObjTP.
-- 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: CMAINTNTFTETP

CREATE VIEW C_MaintNotificationTechObjTP AS
SELECT
  MaintenanceNotification,
  MaintenanceOrder,
  MaintenanceObjectIsDown,
  MaintObjDowntimeDurationUnit,
  MaintObjectDowntimeDuration,
  I_MaintNotificationTechObj._MaintNotifLongText.TextObjectCategory AS TextObjectCategory,
  I_MaintNotificationTechObj._MaintNotifLongText.TextObjectType AS TextObjectType,
  I_MaintNotificationTechObj._MaintNotifLongText.MaintNotifLongTextForEdit AS MaintNotifLongTextForEdit,
  MalfunctionEffect,
  MalfunctionStartDate,
  MalfunctionStartTime,
  MalfunctionEndDate,
  MalfunctionEndTime,
  MaintNotificationCatalog,
  MaintNotificationCode,
  MaintNotificationCodeGroup,
  CatalogProfile,
  _PMNotifMaintenanceData.MaintNotifDetectionCatalog AS MaintNotifDetectionCatalog,
  _PMNotifMaintenanceData.MaintNotifDetectionCodeGroup AS MaintNotifDetectionCodeGroup,
  _PMNotifMaintenanceData.MaintNotifDetectionCode AS MaintNotifDetectionCode
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN I_MaintNotifDetectionCodeText AS _MaintNotifDetectCodeTxt ON maintnotifdetectioncode = _MaintNotifDetectCodeTxt.MaintNotifDetectionCode  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifDetectCodeGroupTxt AS _MaintNotifDetectCodeGroupTxt ON _MaintNotifDetectCodeGroupTxt.MaintNotifDetectionCodeGroup = maintnotifdetectioncodegroup  -- association [0..*]
;

Learn More