FAA_UPA_MIG_DA_PLANV_CMPR

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 FAA_UPA_MIG_DA_PLANV_CMPR.
-- 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 FAA_UPA_MIG_DA_PLANV_CMPR AS
SELECT
  plan_values.bukrs AS bukrs,
  plan_values.anln1 AS anln1,
  plan_values.anln2 AS anln2,
  plan_values.gjahr AS gjahr,
  plan_values.afabe AS afabe,
  plan_values.poper AS poper,
  plan_values.slalittype AS slalittype,
  plan_values.rldnr AS rldnr,
  plan_values.belnr AS belnr,
  plan_values.docln AS docln,
  plan_values.is_null AS is_null,
  case when plan_values.movcat_d = 'X' then 'X' when plan_values.hsl_d = 'X' then 'X' when plan_values.ksl_d = 'X' then 'X' when plan_values.osl_d = 'X' then 'X' when plan_values.vsl_d = 'X' then 'X' when plan_values.bsl_d = 'X' then 'X' when plan_values.csl_d = 'X' then 'X' when plan_values.dsl_d = 'X' then 'X' when plan_values.esl_d = 'X' then 'X' when plan_values.fsl_d = 'X' then 'X' when plan_values.gsl_d = 'X' then 'X' when plan_values.rhcur_d = 'X' then 'X' when plan_values.rkcur_d = 'X' then 'X' when plan_values.rocur_d = 'X' then 'X' when plan_values.rvcur_d = 'X' then 'X' when plan_values.rbcur_d = 'X' then 'X' when plan_values.rccur_d = 'X' then 'X' when plan_values.rdcur_d = 'X' then 'X' when plan_values.recur_d = 'X' then 'X' when plan_values.rfcur_d = 'X' then 'X' when plan_values.rgcur_d = 'X' then 'X' when plan_values.anlkl_d = 'X' then 'X' when plan_values.ktogr_d = 'X' then 'X' when plan_values.mig_source_d = 'X' then 'X' when plan_values.recid_d = 'X' then 'X' else '' end as has_error AS recid_dXthenXelseendashas_error,
  plan_values.movcat_d AS movcat_d,
  plan_values.hsl_d AS hsl_d,
  plan_values.ksl_d AS ksl_d,
  plan_values.osl_d AS osl_d,
  plan_values.vsl_d AS vsl_d,
  plan_values.bsl_d AS bsl_d,
  plan_values.csl_d AS csl_d,
  plan_values.dsl_d AS dsl_d,
  plan_values.esl_d AS esl_d,
  plan_values.fsl_d AS fsl_d,
  plan_values.gsl_d AS gsl_d,
  plan_values.rhcur_d AS rhcur_d,
  plan_values.rkcur_d AS rkcur_d,
  plan_values.rocur_d AS rocur_d,
  plan_values.rvcur_d AS rvcur_d,
  plan_values.rbcur_d AS rbcur_d,
  plan_values.rccur_d AS rccur_d,
  plan_values.rdcur_d AS rdcur_d,
  plan_values.recur_d AS recur_d,
  plan_values.rfcur_d AS rfcur_d,
  plan_values.rgcur_d AS rgcur_d,
  plan_values.anlkl_d AS anlkl_d,
  plan_values.ktogr_d AS ktogr_d,
  plan_values.mig_source_d AS mig_source_d,
  plan_values.recid_d AS recid_d,
  plan_values.s_movcat AS s_movcat,
  plan_values.t_movcat AS t_movcat,
  plan_values.s_hsl AS s_hsl,
  plan_values.t_hsl AS t_hsl,
  plan_values.s_ksl AS s_ksl,
  plan_values.t_ksl AS t_ksl,
  plan_values.s_osl AS s_osl,
  plan_values.t_osl AS t_osl,
  plan_values.s_vsl AS s_vsl,
  plan_values.t_vsl AS t_vsl,
  plan_values.s_bsl AS s_bsl,
  plan_values.t_bsl AS t_bsl,
  plan_values.s_csl AS s_csl,
  plan_values.t_csl AS t_csl,
  plan_values.s_dsl AS s_dsl,
  plan_values.t_dsl AS t_dsl,
  plan_values.s_esl AS s_esl,
  plan_values.t_esl AS t_esl,
  plan_values.s_fsl AS s_fsl,
  plan_values.t_fsl AS t_fsl,
  plan_values.s_gsl AS s_gsl,
  plan_values.t_gsl AS t_gsl,
  plan_values.s_rhcur AS s_rhcur,
  plan_values.t_rhcur AS t_rhcur,
  plan_values.s_rkcur AS s_rkcur,
  plan_values.t_rkcur AS t_rkcur,
  plan_values.s_rocur AS s_rocur,
  plan_values.t_rocur AS t_rocur,
  plan_values.s_rvcur AS s_rvcur,
  plan_values.t_rvcur AS t_rvcur,
  plan_values.s_rbcur AS s_rbcur,
  plan_values.t_rbcur AS t_rbcur,
  plan_values.s_rccur AS s_rccur,
  plan_values.t_rccur AS t_rccur,
  plan_values.s_rdcur AS s_rdcur,
  plan_values.t_rdcur AS t_rdcur,
  plan_values.s_recur AS s_recur,
  plan_values.t_recur AS t_recur,
  plan_values.s_rfcur AS s_rfcur,
  plan_values.t_rfcur AS t_rfcur,
  plan_values.s_rgcur AS s_rgcur,
  plan_values.t_rgcur AS t_rgcur,
  plan_values.s_anlkl AS s_anlkl,
  plan_values.t_anlkl AS t_anlkl,
  plan_values.s_ktogr AS s_ktogr,
  plan_values.t_ktogr AS t_ktogr,
  plan_values.s_mig_source AS s_mig_source,
  plan_values.t_mig_source AS t_mig_source,
  plan_values.s_recid AS s_recid,
  plan_values.t_recid AS t_recid,
  plan_values.sdm_status AS sdm_status
FROM FAA_UPA_MIG_DA_PLANV_CMPR01 AS plan_values
;