CUAN_FORM

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 CUAN_FORM.
-- 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 CUAN_FORM AS
SELECT
  DB_KEY,
  ID,
  NAME,
  TYPE,
  COMM_AREA_ID,
  REF_ORG_STRUC,
  LANGUAGE_DEFAULT,
  PREFILL_DATA,
  PROG_PROF_ENABLED,
  PROG_PROF_SHOW_CNT,
  SUPPRESS_PERM_SUBS_DUPLICATES,
  CONTACT_TYPE,
  KEY_HASH,
  STATUS,
  STYLESHEET,
  STYLESHEET_URL,
  SOURCE,
  EXT_ID_ORIGIN,
  EXT_ID,
  CREA_DATE_TIME,
  CREA_UNAME,
  LCHG_DATE_TIME,
  LCHG_UNAME
FROM cuand_cp_root AS Form
LEFT OUTER JOIN CUAN_FORM_RESULT AS _Results ON DB_KEY = _Results.PARENT_KEY  -- association [0..*]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON COMM_AREA_ID = _AuthCommArea.CommunicationArea AND REF_ORG_STRUC = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;