FAA_CompDrvdAreaPlanVal01

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_CompDrvdAreaPlanVal01.
-- 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: FAAVPDAPV01

CREATE VIEW FAA_CompDrvdAreaPlanVal01 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,
  cast( acdoca.rldnr as fins_technical_ledger preserving type ) AS rldnr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  plan_values.movcat AS s_movcat,
  acdoca.movcat AS t_movcat,
  case when acdoca.rbukrs is null then 'X' when ( plan_values.movcat = '46' and acdoca.movcat <> '06' ) or ( plan_values.movcat = '65' and acdoca.movcat <> '06' ) or ( plan_values.movcat <> '46' and plan_values.movcat <> '65' and plan_values.movcat <> acdoca.movcat ) then 'X' else '' end as movcat_d AS movcatthenXelseendasmovcat_d,
  plan_values.hsl AS s_hsl,
  acdoca.hsl AS t_hsl,
  case when acdoca.rbukrs is null then 'X' when plan_values.hsl <> acdoca.hsl then 'X' else '' end as hsl_d AS hslthenXelseendashsl_d,
  plan_values.ksl AS s_ksl,
  acdoca.ksl AS t_ksl,
  case when acdoca.rbukrs is null then 'X' when plan_values.ksl <> acdoca.ksl then 'X' else '' end as ksl_d AS kslthenXelseendasksl_d,
  plan_values.osl AS s_osl,
  acdoca.osl AS t_osl,
  case when acdoca.rbukrs is null then 'X' when plan_values.osl <> acdoca.osl then 'X' else '' end as osl_d AS oslthenXelseendasosl_d,
  plan_values.rhcur AS s_rhcur,
  acdoca.rhcur AS t_rhcur,
  case when acdoca.rbukrs is null then 'X' when plan_values.rhcur <> acdoca.rhcur then 'X' else '' end as rhcur_d AS rhcurthenXelseendasrhcur_d,
  plan_values.rkcur AS s_rkcur,
  acdoca.rkcur AS t_rkcur,
  case when acdoca.rbukrs is null then 'X' when plan_values.rkcur <> acdoca.rkcur then 'X' else '' end as rkcur_d AS rkcurthenXelseendasrkcur_d,
  plan_values.rocur AS s_rocur,
  acdoca.rocur AS t_rocur,
  case when acdoca.rbukrs is null then 'X' when plan_values.rocur <> acdoca.rocur then 'X' else '' end as rocur_d AS rocurthenXelseendasrocur_d,
  plan_values.anlkl AS s_anlkl,
  acdoca.anlkl AS t_anlkl,
  case when acdoca.rbukrs is null then 'X' when plan_values.anlkl = '' and acdoca.anlkl = '' then 'X' when plan_values.anlkl <> '' and plan_values.anlkl <> acdoca.anlkl then 'X' else '' end as anlkl_d AS anlklthenXelseendasanlkl_d,
  plan_values.ktogr AS s_ktogr,
  acdoca.ktogr AS t_ktogr,
  case when acdoca.rbukrs is null then 'X' when plan_values.ktogr = '' and acdoca.ktogr = '' then 'X' when plan_values.ktogr <> '' and plan_values.ktogr <> acdoca.ktogr then 'X' else '' end as ktogr_d AS ktogrthenXelseendasktogr_d,
  plan_values.mig_source AS s_mig_source,
  acdoca.mig_source AS t_mig_source,
  case when acdoca.rbukrs is null then 'X' when ( plan_values.sdm_status = '20' and acdoca.mig_source <> 'A') or ( plan_values.sdm_status <> '20' and plan_values.mig_source <> acdoca.mig_source ) then 'X' else '' end as mig_source_d AS mig_sourcethenXelseendasmig_source_d,
  plan_values.recid AS s_recid,
  acdoca.recid AS t_recid,
  case when acdoca.rbukrs is null then 'X' when plan_values.recid <> acdoca.recid then 'X' else '' end as recid_d AS recidthenXelseendasrecid_d,
  case when acdoca.rbukrs is null then 'Y' when plan_values.poper <> acdoca.poper then 'X' when ( plan_values.movcat = '46' and acdoca.movcat <> '06' ) or ( plan_values.movcat = '65' and acdoca.movcat <> '06' ) or ( plan_values.movcat <> '46' and plan_values.movcat <> '65' and plan_values.movcat <> acdoca.movcat ) then 'X' when plan_values.hsl <> acdoca.hsl then 'X' when plan_values.ksl <> acdoca.ksl then 'X' when plan_values.osl <> acdoca.osl then 'X' when plan_values.rhcur <> acdoca.rhcur then 'X' when plan_values.rkcur <> acdoca.rkcur then 'X' when plan_values.rocur <> acdoca.rocur then 'X' when ( plan_values.anlkl = '' and acdoca.anlkl = '' ) or ( plan_values.anlkl <> '' and plan_values.anlkl <> acdoca.anlkl ) then 'X' when ( plan_values.ktogr = '' and acdoca.ktogr = '' ) or ( plan_values.ktogr <> '' and plan_values.ktogr <> acdoca.ktogr ) then 'X' when ( plan_values.sdm_status = '20' and acdoca.mig_source <> 'A') or ( plan_values.sdm_status <> '20' and plan_values.mig_source <> acdoca.mig_source ) then 'X' when plan_values.recid <> acdoca.recid then 'X' else '' end as different AS recidthenXelseendasdifferent,
  plan_values.sdm_status AS sdm_status
FROM faagtt_plan_val AS plan_values
LEFT OUTER JOIN acdoca ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAA_CompDrvdAreaSplitNum AS split_number ON /* join condition not captured in parsed metadata */
;