C_MaintNotifItemCauseDP

DDL: C_MAINTNOTIFITEMCAUSEDP Type: view_entity CONSUMPTION Package: VDM_EAM_NTF
17 Fields 1 Data Sources 1 OData Services

Data Provider for Maint Notif Item Cause

C_MaintNotifItemCauseDP is a Consumption CDS View that provides data about "Data Provider for Maint Notif Item Cause" in SAP S/4HANA. It reads from 1 data source (C_MaintNotifItemCauseDEX) and exposes 17 fields with key fields MaintenanceNotification, MaintenanceNotificationItem, MaintenanceNotificationCause. It is exposed through 1 OData service (DP_MAINTENANCENOTIFICATION). Part of development package VDM_EAM_NTF.

Data Sources (1)

SourceAliasJoin Type
C_MaintNotifItemCauseDEX C_MaintNotifItemCauseDEX from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Data Provider for Maint Notif Item Cause view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.sapObjectNodeType.name MaintenanceNotifItemCause view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
DataIntegration.deltaReplication.intended true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_MAINTENANCENOTIFICATION DP_MAINTENANCENOTIFICATION C2 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Notification
KEY MaintenanceNotificationItem MaintenanceNotificationItem
KEY MaintenanceNotificationCause MaintenanceNotificationCause Cause
MaintNotifCauseCodeCatalog MaintNotifCauseCodeCatalog
MaintNotifCauseCodeGroup MaintNotifCauseCodeGroup Cause Code Group
MaintNotificationCauseCode MaintNotificationCauseCode
MaintNotifCauseText MaintNotifCauseText
MaintNotificationRootCause MaintNotificationRootCause
IsDeleted IsDeleted TRUE
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
_MaintenanceNotificationItem _MaintenanceNotificationItem

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_MaintNotifItemCauseDP.
-- 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_MaintNotifItemCauseDP AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationItem,
  MaintenanceNotificationCause,
  MaintNotifCauseCodeCatalog,
  MaintNotifCauseCodeGroup,
  MaintNotificationCauseCode,
  MaintNotifCauseText,
  MaintNotificationRootCause,
  IsDeleted,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime
FROM C_MaintNotifItemCauseDEX
;

Learn More