SUIM_AGR_MNU

DDL: SUIM_AGR_MNU Type: view_entity Package: SUIM_IS_ROLES

SUIM | Startable Nodes in Role Menu

SUIM_AGR_MNU is a CDS View that provides data about "SUIM | Startable Nodes in Role Menu" in SAP S/4HANA. It reads from 3 data sources (SUIM_AGR_MNU_OTH, SUIM_AGR_MNU_PROV, SUIM_AGR_MNU_TRAN) and exposes 34 fields with key fields agr_name, object_id, object_id, object_id. Part of development package SUIM_IS_ROLES.

Data Sources (3)

SourceAliasJoin Type
SUIM_AGR_MNU_OTH oth union
SUIM_AGR_MNU_PROV prov union
SUIM_AGR_MNU_TRAN tcd from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM | Startable Nodes in Role Menu view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY agr_name SUIM_AGR_MNU_TRAN agr_name Role
KEY object_id SUIM_AGR_MNU_TRAN object_id Transaction ID
type_icon SUIM_AGR_MNU_TRAN type_icon
object SUIM_AGR_MNU_TRAN object TRFM Object
appl_name Application Name
appl_tx
node_type Type
node_type_tx SUIM_AGR_MNU_TRAN node_type_tx WSS Profile
ident
ident_tx SUIM_AGR_MNU_TRAN ident_tx WSS Profile
su2x_name SUIM_AGR_MNU_TRAN su2x_name Report Name
agr_name Role
KEY object_id SUIM_AGR_MNU_PROV object_id Transaction ID
type_icon SUIM_AGR_MNU_PROV type_icon
object TRFM Object
appl_name SUIM_AGR_MNU_PROV appl_name Application Name
appl_tx
node_type SUIM_AGR_MNU_PROV node_type Type
node_type_tx SUIM_AGR_MNU_PROV node_type_tx WSS Profile
ident
ident_tx WSS Profile
su2x_name Report Name
agr_name Role
KEY object_id SUIM_AGR_MNU_OTH object_id Transaction ID
type_icon SUIM_AGR_MNU_OTH type_icon
object TRFM Object
appl_name SUIM_AGR_MNU_OTH appl_name Application Name
appl_tx
node_type SUIM_AGR_MNU_OTH node_type Type
node_type_tx SUIM_AGR_MNU_OTH node_type_tx WSS Profile
ident
ident_tx WSS Profile
su2x_name Report Name
su2x_type

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 SUIM_AGR_MNU.
-- 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 SUIM_AGR_MNU AS
SELECT
  tcd.agr_name AS agr_name,
  tcd.object_id AS object_id,
  tcd.type_icon AS type_icon,
  tcd.object AS object,
  cast(tcd.appl_name as abap.char(1332) ) AS appl_name,
  cast(tcd.appl_tx as abap.char(255) ) AS appl_tx,
  cast(tcd.node_type as extdreport ) AS node_type,
  tcd.node_type_tx AS node_type_tx,
  cast( tcd.ident as suim_2x_ident) AS ident,
  tcd.ident_tx AS ident_tx,
  tcd.su2x_name AS su2x_name,
  ' ' AS su2x_type
FROM SUIM_AGR_MNU_TRAN AS tcd
-- UNION with additional select branch(es): SUIM_AGR_MNU_PROV, SUIM_AGR_MNU_OTH
;