R_MaintEventPrioznProfileTP

DDL: R_MAINTEVENTPRIOZNPROFILETP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 5 Associations

Prioritization Profile for Maint Event

R_MaintEventPrioznProfileTP is a Transactional CDS View that provides data about "Prioritization Profile for Maint Event" in SAP S/4HANA. It reads from 1 data source (I_MaintEvtPrioznProfileMapAll) and exposes 18 fields with key fields Plant, NotificationType, MaintEvtPrioritizationProfile, MaintEventConsequenceGroup, MaintEventCnsqncCategoryCode. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintEvtPrioznProfileMapAll I_MaintEvtPrioznProfileMapAll from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_MaintEventPrioznProfileText _MaintEventPrioznProfileText $projection.MaintEvtPrioritizationProfile = _MaintEventPrioznProfileText.MaintEvtPrioritizationProfile
[0..*] I_MaintEventCnsqncCategoryText _MaintEventCnsqncCategoryText $projection.MaintEventCnsqncCategoryCode = _MaintEventCnsqncCategoryText.MaintEventCnsqncCategoryCode
[0..*] I_MaintEventConsequenceText _MaintEventConsequenceText $projection.MaintEventCnsqncCategoryCode = _MaintEventConsequenceText.MaintEventCnsqncCategoryCode and $projection.MaintEventConsequenceCode = _MaintEventConsequenceText.MaintEventConsequenceCode
[0..*] I_MaintEventLikelihoodText _MaintEventLikelihoodText $projection.MaintEventLikelihoodCode = _MaintEventLikelihoodText.MaintEventLikelihoodCode
[0..*] I_GenericPriorityText _GenericPriorityText _GenericPriorityText.PriorityCode = $projection.MaintPriority and _GenericPriorityText.GenericPriorityType = $projection.MaintPriorityType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Prioritization Profile for Maint Event view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name MaintenanceNotification view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY NotificationType NotificationType Notifictn Type
KEY MaintEvtPrioritizationProfile MaintEvtPrioritizationProfile Profile ID
KEY MaintEventConsequenceGroup MaintEventConsequenceGroup Group ID
KEY MaintEventCnsqncCategoryCode MaintEventCnsqncCategoryCode Category ID
KEY MaintEventConsequenceCode MaintEventConsequenceCode Consequence ID
KEY MaintEventLikelihoodCode MaintEventLikelihoodCode Likelihood ID
MaintEvtCnsqncCatPositionValue MaintEvtCnsqncCatPositionValue
MaintEventCnsqncPositionValue MaintEventCnsqncPositionValue
MaintEvtLklihdPositionValue MaintEvtLklihdPositionValue
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
ConfigDeprecationCode ConfigDeprecationCode Validity
_MaintEventPrioznProfileText _MaintEventPrioznProfileText
_MaintEventCnsqncCategoryText _MaintEventCnsqncCategoryText
_MaintEventConsequenceText _MaintEventConsequenceText
_MaintEventLikelihoodText _MaintEventLikelihoodText
_GenericPriorityText _GenericPriorityText

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_MaintEventPrioznProfileTP.
-- 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 R_MaintEventPrioznProfileTP AS
SELECT
  Plant,
  NotificationType,
  MaintEvtPrioritizationProfile,
  MaintEventConsequenceGroup,
  MaintEventCnsqncCategoryCode,
  MaintEventConsequenceCode,
  MaintEventLikelihoodCode,
  MaintEvtCnsqncCatPositionValue,
  MaintEventCnsqncPositionValue,
  MaintEvtLklihdPositionValue,
  MaintPriority,
  MaintPriorityType,
  ConfigDeprecationCode
FROM I_MaintEvtPrioznProfileMapAll
LEFT OUTER JOIN I_MaintEventPrioznProfileText AS _MaintEventPrioznProfileText ON MaintEvtPrioritizationProfile = _MaintEventPrioznProfileText.MaintEvtPrioritizationProfile  -- association [0..*]
LEFT OUTER JOIN I_MaintEventCnsqncCategoryText AS _MaintEventCnsqncCategoryText ON MaintEventCnsqncCategoryCode = _MaintEventCnsqncCategoryText.MaintEventCnsqncCategoryCode  -- association [0..*]
LEFT OUTER JOIN I_MaintEventConsequenceText AS _MaintEventConsequenceText ON MaintEventCnsqncCategoryCode = _MaintEventConsequenceText.MaintEventCnsqncCategoryCode AND MaintEventConsequenceCode = _MaintEventConsequenceText.MaintEventConsequenceCode  -- association [0..*]
LEFT OUTER JOIN I_MaintEventLikelihoodText AS _MaintEventLikelihoodText ON MaintEventLikelihoodCode = _MaintEventLikelihoodText.MaintEventLikelihoodCode  -- association [0..*]
LEFT OUTER JOIN I_GenericPriorityText AS _GenericPriorityText ON _GenericPriorityText.PriorityCode = MaintPriority AND _GenericPriorityText.GenericPriorityType = MaintPriorityType  -- association [0..*]
;

Learn More