SUIM_ACGR_SUPO_INFO_X

DDL: SUIM_ACGR_SUPO_INFO_X Type: view_entity
13 Fields 3 Data Sources

SUIM | help view for view entity SUIM_ACHR_SUPO_INFO

SUIM_ACGR_SUPO_INFO_X is a CDS View that provides data about "SUIM | help view for view entity SUIM_ACHR_SUPO_INFO" in SAP S/4HANA. It reads from 3 data sources (agr_1251, agr_define, agr_users) and exposes 13 fields with key field agr_name.

Data Sources (3)

SourceAliasJoin Type
agr_1251 a1251 right_outer
agr_define ad from
agr_users ausr left_outer

Parameters (1)

NameTypeDefault
iv_bool abap.char( 1 )

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM | help view for view entity SUIM_ACHR_SUPO_INFO view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY agr_name agr_define agr_name Role
iv_boolthenXelseendasestatus
agr_title
object agr_1251 object TRFM Object
auth agr_1251 auth Authorization
field agr_1251 field Logical Field
low agr_1251 low Value from
high agr_1251 high Value up to
orgLow a1252 low Value from
orgHigh a1252 high Value up to
ass_user agr_users uname User Name
role_type pfcg role_type Role Type
usr_cnt pfcg usr_cnt

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_ACGR_SUPO_INFO_X.
-- 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.
-- Parameters: iv_bool : abap.char( 1 )

CREATE VIEW SUIM_ACGR_SUPO_INFO_X AS
SELECT
  ad.agr_name AS agr_name,
  case when concat('$', a1251.field) = a1251.low and $parameters.iv_bool = '' then '' when concat('$', a1251.field) != a1251.low and $parameters.iv_bool = '' then '' when concat('$', a1251.field) = a1251.low and $parameters.iv_bool != '' then '' when concat('$', a1251.field) != a1251.low and $parameters.iv_bool != '' then 'X' else '' end as estatus AS iv_boolthenXelseendasestatus,
  coalesce( coalesce( _tx_s.text , _tx_e.text ), _tx_d.text ) AS agr_title,
  a1251.object AS object,
  a1251.auth AS auth,
  a1251.field AS field,
  a1251.low AS low,
  a1251.high AS high,
  a1252.low AS orgLow,
  a1252.high AS orgHigh,
  ausr.uname AS ass_user,
  pfcg.role_type AS role_type,
  pfcg.usr_cnt AS usr_cnt
FROM agr_define AS ad
RIGHT OUTER JOIN agr_1251 AS a1251 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN agr_users AS ausr ON /* join condition not captured in parsed metadata */
;

Learn More