C_APS_IAM_BR_APP

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 C_APS_IAM_BR_APP.
-- 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.
-- SQL view name: CAPS_BR_APP

CREATE VIEW C_APS_IAM_BR_APP AS
SELECT
  app.uuid AS uuid,
  app.parent_uuid AS parent_uuid,
  app.AppId AS AppId,
  app.Status AS Status,
  app.ActiveInd AS ActiveInd,
  app.AssignmentType AS AssignmentType,
  '' AS AppAssignmentType,
  cast('' as boole_d) AS IsDeactivatable,
  _text.Description AS Description,
  _tcode.Ttext AS Ttext,
  _tcode.Tcode AS Tcode,
  _Component.ach AS ach,
  _appType.AppTypeText AS AppTypeText,
  _ComScen.CommunicationScenarioId AS CommunicationScenarioId,
  _ComScen.Description AS CommunicationScenarioName,
  _Price.PriceCategoryText AS PriceCategoryText
FROM APS_IAM_BR_APP_TP AS app
LEFT OUTER JOIN aps_iam_c_app AS scope ON scope.app_id = app.AppId  -- association [0..1]
LEFT OUTER JOIN r_aps_iam_app_core_apptype AS _appType ON app.AppId = _appType.AppID  -- association [0..1]
LEFT OUTER JOIN APS_IAM_BR_APPT AS _text ON app.AppId = _text.AppId AND _text.Langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN APS_IAM_BR_APPTCODE AS _tcode ON app.AppId = _tcode.app_id  -- association [0..1]
LEFT OUTER JOIN C_APS_IAM_BR AS _Root ON parent_uuid = _Root.UUID  -- association [1..1]
LEFT OUTER JOIN APS_TADIR AS _Component ON _Component.obj_name = AppId AND _Component.object = 'SIA6' AND _Component.pgmid = 'R3TR'  -- association [0..1]
LEFT OUTER JOIN i_aps_iam_price_cat_app AS _Price ON _Price.AppID = app.AppId  -- association [0..1]
LEFT OUTER JOIN APS_IAM_BR_CS_APS AS _ComScen ON _ComScen.IamAppId = app.AppId  -- association [0..*]
;