R_MaintNotificationPartnerTP

DDL: R_MAINTNOTIFICATIONPARTNERTP SQL: RMAINTNTFPARTTP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources

Maintenance Notification Partner

R_MaintNotificationPartnerTP is a Transactional CDS View that provides data about "Maintenance Notification Partner" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationTechObj) and exposes 11 fields with key fields MaintenanceNotification, PartnerFunction, NotificationPartnerObjectNmbr.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationTechObj I_MaintNotificationTechObj from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Partner view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_MaintNotificationTechObj MaintenanceNotification Notification
KEY PartnerFunction
KEY NotificationPartnerObjectNmbr I_PlantMaintenancePartner MaintenancePartnerObjectNumber Counter
Partner I_PlantMaintenancePartner Partner With Partner
MaintenancePartner I_PlantMaintenancePartner MaintenancePartner Partner
_ContactPerson I_PlantMaintenancePartner _ContactPerson
_Customer I_PlantMaintenancePartner _Customer
_Employee I_PlantMaintenancePartner _Employee
_Supplier I_PlantMaintenancePartner _Supplier
_PartnerFunction I_PlantMaintenancePartner _PartnerFunction
_Notif _Notif

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 R_MaintNotificationPartnerTP.
-- 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: RMAINTNTFPARTTP

CREATE VIEW R_MaintNotificationPartnerTP AS
SELECT
  I_MaintNotificationTechObj.MaintenanceNotification AS MaintenanceNotification,
  cast(I_PlantMaintenancePartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  I_PlantMaintenancePartner.MaintenancePartnerObjectNumber AS NotificationPartnerObjectNmbr,
  I_PlantMaintenancePartner.Partner AS Partner,
  I_PlantMaintenancePartner.MaintenancePartner AS MaintenancePartner,
  I_PlantMaintenancePartner._ContactPerson AS _ContactPerson,
  I_PlantMaintenancePartner._Customer AS _Customer,
  I_PlantMaintenancePartner._Employee AS _Employee,
  I_PlantMaintenancePartner._Supplier AS _Supplier,
  I_PlantMaintenancePartner._PartnerFunction AS _PartnerFunction
FROM I_MaintNotificationTechObj
;

Learn More