APS_IAM_AUTH_FIELD_VAL

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_AUTH_FIELD_VAL.
-- 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_AUTH_FIELD_VAL AS
SELECT
  aps_iam_w_appaui.app_id AS AppId,
  aps_iam_w_appaui.uuid AS Uuid,
  APS_IAM_AUTHOBJ_FIELDS_ACT.Object AS Object,
  APS_IAM_AUTHOBJ_FIELDS_ACT.Field AS Field,
  aps_iam_w_appauv.low_value AS LowValue,
  aps_iam_auth_field_ddl.Fieldname AS Fieldname,
  aps_iam_w_appaui.auth_object AS AuthObject,
  aps_iam_w_appaui.auth_object_inst_id AS AuthObjectInstId,
  aps_iam_w_appaui.status AS AppAuiStatus,
  aps_iam_w_appaui.inactive AS Inactive,
  aps_iam_w_appauv.parent_id AS ParentId,
  aps_iam_w_appauv.field AS AuvField,
  aps_iam_w_appauv.high_value AS HighValue,
  aps_iam_w_appauv.status AS AppAuvStatus,
  APS_IAM_AUTHOBJ_FIELDS_ACT.isActvt AS isActvt,
  aps_iam_auth_field_ddl.ActvtFlag AS ActvtFlag,
  aps_iam_auth_field_ddl.FieldText AS FieldText,
  case aps_iam_auth_field_ddl.Fieldname when 'ACTVT' then tactt.ltext else aps_iam_w_appauv.low_value end as ActivityValue AS low_valueendasActivityValue,
  aps_iam_w_rt_ao.rtype_id AS rtype_id
FROM aps_iam_w_appaui
INNER JOIN APS_IAM_AUTHOBJ_FIELDS_ACT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_auth_field_ddl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appauv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tactt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_rt_ao ON /* join condition not captured in parsed metadata */
;