V_LTR2_RN_INV

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 V_LTR2_RN_INV.
-- 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 V_LTR2_RN_INV AS
SELECT
  R.rn_guid AS rn_guid,
  R.object AS object,
  R.subobject AS subobject,
  R.toyear AS toyear,
  R.nrrangenr AS nrrangenr,
  R.map_mode AS map_mode,
  R.map_built AS map_built,
  R.map_offset AS map_offset,
  R.max_used_val AS max_used_val,
  R.adjust_mode AS adjust_mode,
  R.chk_status AS chk_status,
  R.tol_offset AS tol_offset,
  R.analyzed AS analyzed,
  R.nr_state AS nr_state,
  R.adjust_value AS adjust_value,
  R.auto_create AS auto_create,
  R.prefix AS prefix,
  R.build_ts AS build_ts,
  R.gap_len AS gap_len,
  A.fromnumber AS fromnumber,
  A.tonumber AS tonumber,
  A.nrlevel AS nrlevel,
  A.externind AS externind,
  A.not_in_r AS not_in_r,
  A.fromnumber_r AS fromnumber_r,
  A.tonumber_r AS tonumber_r,
  A.nrlevel_r AS nrlevel_r,
  A.externind_r AS externind_r,
  J.tonumber AS adj_tonumber,
  J.nrlevel AS adjust_num,
  J.adj_type AS adj_type,
  J.adj_action AS adj_action,
  J.msgv1 AS msgv1,
  J.msgv2 AS msgv2,
  J.msgv3 AS msgv3,
  J.msgv4 AS msgv4
FROM ltr2_rn_mapmgr AS R
LEFT OUTER JOIN ltr2_rn_admin AS P ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN V_LTR2_ANA2_INV AS A ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ltr2_rn_adjrslt AS J ON /* join condition not captured in parsed metadata */
;