I_ChgRecordLifecycleStatus_3

DDL: I_CHGRECORDLIFECYCLESTATUS_3 Type: view_entity COMPOSITE Package: VDM_PLMB_CR_RAP

Change Record Lifecycle Status

I_ChgRecordLifecycleStatus_3 is a Composite CDS View that provides data about "Change Record Lifecycle Status" in SAP S/4HANA. It reads from 4 data sources (I_ChgRecdFeatureToggleDisabled, I_ChgRecdFeatureToggleEnabled, I_ChgRecordLifecycleStatus_2, I_ChgRecordLifecycleStatus) and exposes 5 fields with key fields ChangeRecordStatusField2, ChangeRecordLifecycleStatus, ChangeRecordLifeCycleStatus. It has 1 association to related views. Part of development package VDM_PLMB_CR_RAP.

4 data source(s) 5 fields

Data Sources (4)

SourceAliasJoin Type
I_ChgRecdFeatureToggleDisabled _ftg inner
I_ChgRecdFeatureToggleEnabled _ftg inner
I_ChgRecordLifecycleStatus_2 plmlcyclestatus union_all
I_ChgRecordLifecycleStatus status from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChgRecdLifecycleStatusTxt _ChgRecdLifecycleStatusTxt $projection.ChangeRecordLifecycleStatus = _ChgRecdLifecycleStatusTxt.ChangeRecordLifecycleStatus and _ChgRecdLifecycleStatusTxt.Language = $session.system_language

Annotations (7)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordStatusField2 I_ChgRecordLifecycleStatus ABAPDomain
KEY ChangeRecordLifecycleStatus I_ChgRecordLifecycleStatus ChangeRecordLifecycleStatus
ChangeRecordStatusField2
KEY ChangeRecordLifeCycleStatus I_ChgRecordLifecycleStatus_2 ChangeRecordLifeStatus
ChangeRecordLifecycleStatusTxt _ChgRecdLifecycleStatusTxt ChangeRecordStatusDescription 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Lifecycle Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@VDM.viewType:#COMPOSITE
//NOTE: this view 'ftg_enabled' by-passes the kernel API for SFW_SWITCH_STATE, with two drawbacks:

//1) switch states are not frozen per ABAP session,

//2) worse performance.

define view entity I_ChgRecordLifecycleStatus_3
  as select from I_ChgRecordLifecycleStatus as status
  inner join I_ChgRecdFeatureToggleDisabled as _ftg on _ftg.ChangeRecordFeatureToggleID = 'PLM_SAM'
  association [0..1] to I_ChgRecdLifecycleStatusTxt as _ChgRecdLifecycleStatusTxt on  $projection.ChangeRecordLifecycleStatus = _ChgRecdLifecycleStatusTxt.ChangeRecordLifecycleStatus
                                                                                  and _ChgRecdLifecycleStatusTxt.Language     = $session.system_language
{
  key status.ABAPDomain as ChangeRecordStatusField2,
  key status.ChangeRecordLifecycleStatus,
      _ChgRecdLifecycleStatusTxt.ChangeRecordLifecycleStatusTxt
}
union all 
select from I_ChgRecordLifecycleStatus_2 as plmlcyclestatus
inner join I_ChgRecdFeatureToggleEnabled  as _ftg on _ftg.ChangeRecordFeatureToggleID = 'PLM_SAM'
association [0..1] to I_ChangeRecordStatusText_2 as _ChgRecdLifecycleStatusTxt on  plmlcyclestatus.ChangeRecordLifeStatus = _ChgRecdLifecycleStatusTxt.ChangeRecordStatus
                                                                               and _ChgRecdLifecycleStatusTxt.Language         = $session.system_language
{
  key plmlcyclestatus.ChangeRecordStatusField2,
  key plmlcyclestatus.ChangeRecordLifeStatus as ChangeRecordLifeCycleStatus,
      _ChgRecdLifecycleStatusTxt.ChangeRecordStatusDescription as ChangeRecordLifecycleStatusTxt

}

Learn More