CNV_2010C_GL_MAPPING

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 CNV_2010C_GL_MAPPING.
-- 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: CNV_2010C_GLMAPV

CREATE VIEW CNV_2010C_GL_MAPPING AS
SELECT
  cast(mapping_guid as abap.char( 32 )) AS mapping_guid,
  packid,
  mapping_name,
  state.ktopl AS ktopl,
  case mapping_phase when 'MI' then mapping_desc.MI when 'MC' then mapping_desc.MC else mapping_desc.MF end as mapping_status AS MFendasmapping_status,
  ktopl_text.ktplt AS ktopl_desc,
  ktopl_text.spras AS ktopl_lang,
  case when mapping_phase = 'MC' then mapping_desc.MR when packid = '' and spc_activity = 'PR' and spc_status = 'SC' then mapping_desc.SC when packid = '' and spc_activity = 'PR' and spc_status = 'SE' then mapping_desc.SE when packid = '' and spc_activity <> 'PR' then mapping_desc.CN when packid <> '' and conv_state.phase_text is null then mapping_desc.CD when conv_state.error > 0 then mapping_desc.CC when conv_state.abort > 0 then mapping_desc.CC when conv_perc.total_perc = 100.00 then mapping_desc.CF when packid = '' and spc_activity = 'PR' and spc_status = 'SR' then mapping_desc.SR else coalesce ( conv_state.phase_text,mapping_desc.CD ) end as progress_text AS CDendasprogress_text,
  case when mapping_phase = 'MC' then mapping_desc.CN when packid = '' and spc_activity = 'PR' and spc_status = 'SC' then mapping_desc.SC when packid = '' and spc_activity = 'PR' and spc_status = 'SE' then mapping_desc.SE when packid = '' and spc_activity <> 'PR' then mapping_desc.CN when packid <> '' and conv_state.phase_text is null then mapping_desc.CD when conv_state.error > 0 then mapping_desc.CC when conv_state.abort > 0 then mapping_desc.CC when conv_perc.total_perc = 100.00 then mapping_desc.CF when packid = '' and spc_activity = 'PR' and spc_status = 'SR' then mapping_desc.SR else coalesce ( conv_state.phase_text,mapping_desc.CD ) end as progress_text_mapping AS CDendasprogress_text_mapping,
  conv_perc.total_perc AS progress_per,
  useralias AS cruser,
  cast(substring(cast(crtime as abap.char(32)),1,8) as abap.dats) AS created_on,
  cast(substring(cast(cotime as abap.char(32)),1,8) as abap.dats) AS completed_on
FROM cnv_2010c_state AS state
CROSS JOIN CNV_2010C_MAPPING_TEXT AS mapping_desc
LEFT OUTER JOIN CNV_2010C_GL_DESC_MAP AS _gl_mapping ON mapping_guid = _gl_mapping.mapping_guid  -- association [1..*]
LEFT OUTER JOIN CNV_2010C_GL_MAP_ORIG AS _gl_mapping1 ON mapping_guid = _gl_mapping1.mapping_guid  -- association [1..*]
LEFT OUTER JOIN t004t AS ktopl_text ON state.ktopl = ktopl_text.ktopl AND ktopl_text.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN CNV_2010C_PACK_LOG_STATUS AS conv_state ON state.packid = conv_state.packid  -- association [1..1]
LEFT OUTER JOIN CNV_2010C_PROG_PERCENTAGE AS conv_perc ON state.packid = conv_perc.packid  -- association [1..1]
LEFT OUTER JOIN CNV_2010C_Q2P_RELEASE AS check_q2p_rele ON /* condition not available in parsed metadata */  -- association [1..*]
;