APS_IAM_RSTR_FLD_UI

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_RSTR_FLD_UI.
-- 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: APS_IAMRSTR_FLD

CREATE VIEW APS_IAM_RSTR_FLD_UI AS
SELECT
  rtype_id,
  field_name,
  sort_order,
  APS_IAM_RSTR_FLD_T_UI.text AS field_text,
  RestrictionField AS whereUsedList
FROM aps_iam_w_rtfld
INNER JOIN APS_IAM_RSTR_UI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_IAM_RSTR_FLD_Names_UI AS RestrictionField ON RestrictionField.field_name = field_name AND RestrictionField.rtype_id = rtype_id association[0..1] to APS_IAM_RSTR_T_UI on APS_IAM_RSTR_T_UI.id = rtype_id AND APS_IAM_RSTR_T_UI.langu = $session.system_language association[0..1] to aps_iam_w_fld as RestrictionFieldDetails on field_name = RestrictionFieldDetails.field_name  -- association [0..1]
;