ARO_DDL_OBL_current_data

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 ARO_DDL_OBL_current_data.
-- 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: V_ARO_OBJACT

CREATE VIEW ARO_DDL_OBL_current_data AS
SELECT
  _ARO_OBJ.obl_guid AS obl_guid,
  _ARO_OBJ.obl_type AS obl_type,
  _ARO_OBJ.comp_code AS comp_code,
  _ARO_OBJ.obl_num AS obl_num,
  _ARO_OBJ.obl_desc AS obl_desc,
  _ARO_OBJ.obl_status AS obl_status,
  _ARO_OBJ.langu AS langu,
  _ARO_OBJ.obl_lock AS obl_lock,
  _ARO_OBJ.obl_mco_desc AS obl_mco_desc,
  _ARO_OBJ.aro_date_beg AS aro_date_beg,
  _ARO_OBJ.aro_date_end AS aro_date_end,
  _ARO_OBJ.inf_rate_key AS inf_rate_key,
  _ARO_OBJ.int_rate_key AS int_rate_key,
  _ARO_OBJ.currency AS currency,
  _assign.bus_area AS bus_area,
  _assign.costcenter AS costcenter,
  _assign.orderid AS orderid,
  _assign.wbs_elem AS wbs_elem,
  _assign.acttype AS acttype,
  _assign.plant AS plant,
  _assign.location AS location,
  _assign.room AS room,
  _assign.func_area AS func_area,
  _assign.segment AS segment,
  _assign.profit_ctr AS profit_ctr,
  _assign.prof_segm AS prof_segm,
  _assign.rl_est_key AS rl_est_key,
  _assign.taxjurcode AS taxjurcode,
  _assign.external_id AS external_id,
  _LAST_TA.entered_by AS last_ta_ENTRY_by,
  _LAST_TA.entry_date AS last_ta_ENTRY_date,
  _LAST_TA.entry_time AS last_ta_ENTRY_time,
  _LAST_CEP.cep_num AS last_CEP_NUM,
  _LAST_CEP.cep_desc AS last_CEP_DESC,
  _LAST_CEP.cep_keydate AS last_CEP_KEYDATE,
  _LAST_CEP.ta_date AS last_cep_TA_DATE,
  _LAST_CEP.infl_key AS last_cep_INFL_KEY,
  _LAST_CEP.infl_meth AS last_cep_INFL_METH,
  _1st_ta_rel_data.released_by AS firstrel_ta_ENTRY_by,
  _1st_ta_rel_data.release_date AS firstrel_ta_ENTRY_date,
  _1st_ta_rel_data.release_time AS firstrel_ta_ENTRY_time,
  _RELE_TA.released_by AS rele_ta_ENTRY_by,
  _RELE_TA.release_date AS rele_ta_ENTRY_date,
  _RELE_TA.release_time AS rele_ta_ENTRY_time,
  _RELE_CEP.cep_num AS rele_CEP_NUM,
  _RELE_CEP.cep_desc AS rele_CEP_DESC,
  _RELE_CEP.cep_keydate AS rele_CEP_KEYDATE,
  _RELE_CEP.ta_date AS rele_cep_TA_DATE,
  _RELE_CEP.infl_key AS rele_cep_INFL_KEY,
  _RELE_CEP.infl_meth AS rele_cep_INFL_METH,
  _uo_hdr.comp_code AS uo_COMP_CODE,
  _uo_hdr.uo_num AS UO_NUM,
  _uo_hdr.uo_type AS UO_TYPE,
  _uo_hdr.uo_desc AS UO_DESC,
  _uo_hdr.adr_city AS uo_adr_city,
  _ARO_OBJ.deleted AS deleted
FROM ARO_DDL_OBL AS _ARO_OBJ
LEFT OUTER JOIN ARO_DDL_latest_Assignment AS _assign_valdito ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_assignments AS _assign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_ta AS _RELE_TA ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_cep_hdr AS _RELE_CEP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_ta AS _LAST_TA ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_cep_hdr AS _LAST_CEP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_uo_hdr AS _uo_hdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARO_DDL_first_TA_REL AS _1st_ta_rel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aro_ta AS _1st_ta_rel_data ON /* join condition not captured in parsed metadata */
;