SATC_AC_XMPT_FND_DDLV

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 SATC_AC_XMPT_FND_DDLV.
-- 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 SATC_AC_XMPT_FND_DDLV AS
SELECT
  fnd.item_id AS item_id,
  xmpt.exemption_id AS exemption_id,
  fnd.langu AS langu,
  fnd.module_ix AS module_ix,
  fnd.message_ix AS message_ix,
  fnd.object_ix AS object_ix,
  fnd.system_ix AS system_ix,
  fnd.test_id AS test_id,
  fnd.message_id AS message_id,
  fnd.obj_name AS obj_name,
  fnd.obj_type AS obj_type,
  fnd.checksum AS checksum,
  fnd.system_id AS system_id,
  fnd.package_name AS package_name,
  fnd.comp_short AS comp_short,
  fnd.dlv_unit AS dlv_unit,
  fnd.dlv_release AS dlv_release,
  fnd.tr_layer AS tr_layer,
  fnd.deleted AS deleted,
  fnd.created_on AS created_on,
  fnd.exc_kind AS exc_kind,
  fnd.exc_validity AS exc_validity,
  fnd.exc_approval AS exc_approval,
  fnd.ui_location AS ui_location,
  concat( concat( fnd.ui_location, fnd.location_path ), fnd.location_fragment ) AS location_url,
  fnd.since AS since,
  fnd.updated_on AS updated_on,
  fnd.processor AS processor,
  fnd.status AS status,
  fnd.title AS title,
  xmpt.category AS category,
  xmpt.check_scope AS check_scope,
  xmpt.chkclass AS chkclass,
  xmpt.chkcode AS chkcode,
  xmpt.object_scope AS object_scope,
  xmpt.objname AS objname,
  xmpt.objtype AS objtype,
  xmpt.subobjname AS subobjname,
  xmpt.subobjtype AS subobjtype,
  xmpt.valid_until AS valid_until,
  xmpt.state AS state,
  xmpt.prev_state AS prev_state,
  xmpt.applicant AS applicant,
  xmpt.appl_last AS appl_last,
  xmpt.reason AS reason,
  xmpt.appl_comment AS appl_comment,
  xmpt.approver AS approver,
  xmpt.appr_last AS appr_last,
  xmpt.appr_comment AS appr_comment,
  xmpt.appr_area AS appr_area,
  xmpt.last_changed AS last_changed,
  xmpt.deleted AS xmpt_deleted
FROM SATC_CI_EXEMPT_U_DDLV AS xmpt
LEFT OUTER JOIN SATC_AC_FND_DDLV AS fnd ON /* join condition not captured in parsed metadata */
;