I_ChangeRecordUserStatus_3

DDL: I_CHANGERECORDUSERSTATUS_3 Type: view_entity COMPOSITE Package: VDM_PLMB_CR_RAP

Change Record Status

I_ChangeRecordUserStatus_3 is a Composite CDS View that provides data about "Change Record Status" in SAP S/4HANA. It reads from 4 data sources (I_ChgRecdFeatureToggleEnabled, I_ChgRecdFeatureToggleDisabled, I_ChangeRecordUserStatus_2, I_ChangeRecordUserStatusVH) and exposes 3 fields with key field ChangeRecordStatus. It has 1 association to related views. Part of development package VDM_PLMB_CR_RAP.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_ChgRecdFeatureToggleEnabled _ftg inner
I_ChgRecdFeatureToggleDisabled _ftg inner
I_ChangeRecordUserStatus_2 plmstatus from
I_ChangeRecordUserStatusVH status union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChangeRecordStatusText_2 _ChangeRecordStatusText $projection.ChangeRecordStatus = _ChangeRecordStatusText.ChangeRecordStatus and _ChangeRecordStatusText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Record Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordStatus I_ChangeRecordUserStatus_2 ChangeRecordStatus
ChangeRecordStatus
ChangeRecordStatusDescription I_ChangeRecordUserStatusVH ChangeRecordStatusDescription 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM.viewType: #COMPOSITE

define view entity I_ChangeRecordUserStatus_3 as select from I_ChangeRecordUserStatus_2 as plmstatus 
inner join I_ChgRecdFeatureToggleEnabled as _ftg on _ftg.ChangeRecordFeatureToggleID = 'PLM_SAM'
association [0..1] to I_ChangeRecordStatusText_2 as _ChangeRecordStatusText on  $projection.ChangeRecordStatus   = _ChangeRecordStatusText.ChangeRecordStatus
                                                                            and _ChangeRecordStatusText.Language = $session.system_language
{
  key plmstatus.ChangeRecordStatus ,
 _ChangeRecordStatusText.ChangeRecordStatusDescription
} 
union all select from   I_ChangeRecordUserStatusVH   as status  
inner join I_ChgRecdFeatureToggleDisabled as _ftg on _ftg.ChangeRecordFeatureToggleID = 'PLM_SAM' 
{
 key status.ChangeRecordStatus,
 status.ChangeRecordStatusDescription
}

Learn More