aps_iam_info_br_bc_basic

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 aps_iam_info_br_bc_basic.
-- 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 aps_iam_info_br_bc_basic AS
SELECT
  BusinessRole.uuid AS BusinessRoleUUID,
  BusinessCatalog.catalog_id AS BusinessCatalogID,
  BusinessRole.id AS BusinessRoleID,
  BusinessRoleText.description AS description,
  _PriceTag.PriceCategoryText AS BusinessRolePriceCategory,
  _FieldNameDomain.Description AS LifecycleStatus,
  cast( BusinessRoleText.long_text as abap.char( 1024 ) ) AS LongText,
  BusinessCatalog.text AS BusinessCatalogText,
  BusinessCatalog.PriceCategoryText AS BusinessCatalogPriceCategory,
  _Component.ach AS BusinessCatalogComponent
FROM aps_iam_d_br AS BusinessRole
LEFT OUTER JOIN aps_iam_d_brt AS BusinessRoleText ON /* join condition not captured in parsed metadata */
RIGHT OUTER JOIN C_Aps_Iam_Brbca AS BusinessCatalog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS _FieldNameDomain ON _FieldNameDomain.Name = 'APS_IAM_BROLE_STATUS_LC' AND _FieldNameDomain.Code = BusinessRole.status  -- association [0..*]
LEFT OUTER JOIN i_aps_iam_price_cat_x_br AS _PriceTag ON _PriceTag.BusinessRoleUUID = BusinessRoleUUID  -- association [0..*]
LEFT OUTER JOIN APS_TADIR AS _Component ON _Component.obj_name = BusinessCatalogID AND _Component.object = 'SIA1' AND _Component.pgmid = 'R3TR'  -- association [0..1]
;