FAA_CFG_CMP_LEDGER

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_CFG_CMP_LEDGER.
-- 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: FAAV_CFG_CMP_LD

CREATE VIEW FAA_CFG_CMP_LEDGER AS
SELECT
  aa_cmp_ld.comp_code AS comp_code,
  aa_cmp_ld.ledger AS ledger,
  cast(aa_cmp_ld.ledger as fagl_target_ldgrp) AS ldgrp,
  'X' AS represent,
  aa_cmp_ld.plan_horizon AS plan_horizon,
  #FINS_CUR_POS.'1' AS curposh,
  gl_cmp_ld.curtpk AS curtpk,
  gl_cmp_ld.curposk AS curposk,
  gl_cmp_ld.curtpo AS curtpo,
  gl_cmp_ld.curposo AS curposo,
  gl_cmp_ld.curtpv AS curtpv,
  gl_cmp_ld.curposv AS curposv,
  gl_cmp_ld.curtpb AS curtpb,
  gl_cmp_ld.curposb AS curposb,
  gl_cmp_ld.curtpc AS curtpc,
  gl_cmp_ld.curposc AS curposc,
  gl_cmp_ld.curtpd AS curtpd,
  gl_cmp_ld.curposd AS curposd,
  gl_cmp_ld.curtpe AS curtpe,
  gl_cmp_ld.curpose AS curpose,
  gl_cmp_ld.curtpf AS curtpf,
  gl_cmp_ld.curposf AS curposf,
  gl_cmp_ld.curtpg AS curtpg,
  gl_cmp_ld.curposg AS curposg
FROM faat_cmp_ledger AS aa_cmp_ld
INNER JOIN finsc_ld_cmp AS gl_cmp_ld ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger AS finsc_ld ON /* join condition not captured in parsed metadata */
INNER JOIN tacc_trgt_ldgr AS accpr_ldgrp ON /* join condition not captured in parsed metadata */
INNER JOIN fagl_tldgrp_map AS fagl_tldgrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_ap0 AS ap_generic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_ap0 AS ap_specific ON /* join condition not captured in parsed metadata */
;