FAA_SDM_DOCIT_CP22

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_SDM_DOCIT_CP22.
-- 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: FAAVDOCITCP22

CREATE VIEW FAA_SDM_DOCIT_CP22 AS
SELECT
  acdoca.rbukrs AS bukrs,
  acdoca.anln1 AS anln1,
  acdoca.anln2 AS anln2,
  acdoca.gjahr AS gjahr,
  acdoca.afabe AS afabe,
  acdoca.depr_period AS poper,
  acdoca.slalittype AS slalittype,
  cast( acdoca.rldnr as fins_technical_ledger preserving type ) AS rldnr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  case when plan_values.bukrs is null then 'X' when ledger_p.tech_ledger <> acdoca.rldnr then 'X' else '' end as tech_ledger_d AS rldnrthenXelseendastech_ledger_d,
  acdoca.poper AS t_poper,
  case when plan_values.bukrs is null then 'X' when ( ( plan_values.poper_shifted = '000' and plan_values.poper <> acdoca.poper ) or ( plan_values.poper_shifted <> '000' and plan_values.poper_shifted <> acdoca.poper ) ) then 'X' else '' end as poper_d AS poperthenXelseendaspoper_d,
  plan_values.movcat AS s_movcat,
  acdoca.movcat AS t_movcat,
  case when plan_values.bukrs 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 plan_values.bukrs 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,
  '' AS ksl_d,
  plan_values.osl AS s_osl,
  acdoca.osl AS t_osl,
  '' AS osl_d,
  plan_values.vsl AS s_vsl,
  acdoca.vsl AS t_vsl,
  '' AS vsl_d,
  plan_values.rhcur AS s_rhcur,
  acdoca.rhcur AS t_rhcur,
  case when plan_values.bukrs 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,
  '' AS rkcur_d,
  plan_values.rocur AS s_rocur,
  acdoca.rocur AS t_rocur,
  '' AS rocur_d,
  plan_values.rvcur AS s_rvcur,
  acdoca.rvcur AS t_rvcur,
  '' AS rvcur_d,
  plan_values.anlkl AS s_anlkl,
  acdoca.anlkl AS t_anlkl,
  case when plan_values.bukrs 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 plan_values.bukrs 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,
  '' AS mig_source_d,
  plan_values.recid AS s_recid,
  acdoca.recid AS t_recid,
  case when plan_values.bukrs is null then 'X' when plan_values.recid <> acdoca.recid then 'X' else '' end as recid_d AS recidthenXelseendasrecid_d,
  case when plan_values.bukrs is null then 'X' when ledger_p.tech_ledger <> acdoca.rldnr then 'X' when ( ( plan_values.poper_shifted = '000' and plan_values.poper <> acdoca.poper ) or ( plan_values.poper_shifted <> '000' and plan_values.poper_shifted <> 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.rhcur <> acdoca.rhcur 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.recid <> acdoca.recid then 'X' else '' end as different AS recidthenXelseendasdifferent,
  cast( '-' as char01 preserving type ) AS direction,
  acdoca.anlkl AS anlkl,
  acdoca.movcat AS movcat
FROM acdoca
INNER JOIN fins_tech_ledger AS ledger_a ON /* join condition not captured in parsed metadata */
INNER JOIN FAA_CFG_DEPR_AREA AS cfg_depr_area ON /* join condition not captured in parsed metadata */
INNER JOIN fins_tech_ledger AS ledger_p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAA_SDM_DOCIT_CP02 AS split_number ON /* join condition not captured in parsed metadata */
;