NES_I_SWITCH_ITEM

DDL: NES_I_SWITCH_ITEM Type: view_entity Package: SUI_FLP_EXT_NES

Switch Item

NES_I_SWITCH_ITEM is a CDS View that provides data about "Switch Item" in SAP S/4HANA. It reads from 3 data sources (sui_tm_mm_app, sui_tm_mm_app, nes_switchitem) and exposes 8 fields with key fields switch_id, seq_number. Part of development package SUI_FLP_EXT_NES.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
sui_tm_mm_app new_lookup left_outer
sui_tm_mm_app old_lookup left_outer
nes_switchitem switch from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Switch Item view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY switch_id nes_switchitem switch_id
KEY seq_number nes_switchitem seq_number
old_uiad_id nes_switchitem old_uiad_id
old_intent
old_tcode nes_switchitem old_tcode
new_uiad_id nes_switchitem new_uiad_id
new_intent
new_tcode nes_switchitem new_tcode 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Switch Item'

@Metadata.ignorePropagatedAnnotations: true

define view entity NES_I_SWITCH_ITEM
  as select from    nes_switchitem as switch

    left outer join sui_tm_mm_app  as old_lookup on switch.old_uiad_id = old_lookup.app_id
    left outer join sui_tm_mm_app  as new_lookup on switch.new_uiad_id = new_lookup.app_id

  association to parent NES_I_SWITCH_HEADER as _switch_header on $projection.switch_id = _switch_header.switch_id

{
  key switch.switch_id,
  key switch.seq_number,

      switch.old_uiad_id,
      concat(old_lookup.sem_obj, concat('-', old_lookup.sem_act)) as old_intent,
      switch.old_tcode,
      switch.new_uiad_id,
      concat(new_lookup.sem_obj, concat('-', new_lookup.sem_act)) as new_intent,
      switch.new_tcode,
      switch.new_dialog_id,
      switch.old_dialog_id,
      _switch_header
}

Learn More