fiscds_bal_gl_04

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 fiscds_bal_gl_04.
-- 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: FISV_BAL_GL_04

CREATE VIEW fiscds_bal_gl_04 AS
SELECT
  cast(rldnr as fis_rldnr) AS rldnr,
  cast( rldnr as abap.char(30)) AS rldnr_name,
  ryear,
  cast(rbukrs as fis_bukrs preserving type) AS rbukrs,
  butxt AS rbukrs_name,
  ktopl,
  cast( ktopl as abap.char(50)) AS ktopl_name,
  cast(racct as fis_racct preserving type) AS racct,
  cast( racct as abap.char(20)) AS racct_txt20,
  cast( racct as abap.char(50)) AS racct_txt50,
  prctr,
  cast( prctr as abap.char(40)) AS prctr_name,
  kokrs,
  cast( kokrs as abap.char(25)) AS kokrs_name,
  segment,
  cast( segment as abap.char(50)) AS segment_name,
  rfarea,
  cast( rfarea as abap.char(25)) AS rfarea_name,
  rbusa,
  cast( rbusa as abap.char(30)) AS rbusa_name,
  poper,
  cast( '' as abap.char(1)) AS xnotpostedto,
  koart,
  blart,
  cast(hwaer as fis_hwaer) AS hwaer,
  cast(credit_hsl as fis_cr_hsl) AS credit_hsl,
  cast(debit_hsl as fis_dr_hsl) AS debit_hsl,
  cast(balance_hsl as fis_bal_hsl) AS balance_hsl,
  cast(rkcur as fis_rkcur) AS rkcur,
  cast(credit_ksl as fis_cr_ksl) AS credit_ksl,
  cast(debit_ksl as fis_dr_ksl) AS debit_ksl,
  cast(balance_ksl as fis_bal_ksl) AS balance_ksl,
  cast(rocur as fis_rocur) AS rocur,
  cast(credit_osl as fis_cr_osl) AS credit_osl,
  cast(debit_osl as fis_dr_osl) AS debit_osl,
  cast(balance_osl as fis_bal_osl) AS balance_osl,
  cast(rvcur as fis_rvcur) AS rvcur,
  cast(credit_vsl as fis_cr_vsl) AS credit_vsl,
  cast(debit_vsl as fis_dr_vsl) AS debit_vsl,
  cast(balance_vsl as fis_bal_vsl) AS balance_vsl,
  cast(rbcur as fins_curr3) AS rbcur,
  cast(credit_bsl as fis_cr_bsl) AS credit_bsl,
  cast(debit_bsl as fis_dr_bsl) AS debit_bsl,
  cast(balance_bsl as fis_bal_bsl) AS balance_bsl,
  cast(rccur as fins_curr4) AS rccur,
  cast(credit_csl as fis_cr_csl) AS credit_csl,
  cast(debit_csl as fis_dr_csl) AS debit_csl,
  cast(balance_csl as fis_bal_csl) AS balance_csl,
  cast(rdcur as fins_curr5) AS rdcur,
  cast(credit_dsl as fis_cr_dsl) AS credit_dsl,
  cast(debit_dsl as fis_dr_dsl) AS debit_dsl,
  cast(balance_dsl as fis_bal_dsl) AS balance_dsl,
  cast(recur as fins_curr6) AS recur,
  cast(credit_esl as fis_cr_esl) AS credit_esl,
  cast(debit_esl as fis_dr_esl) AS debit_esl,
  cast(balance_esl as fis_bal_esl) AS balance_esl,
  cast(rfcur as fins_curr7) AS rfcur,
  cast(credit_fsl as fis_cr_fsl) AS credit_fsl,
  cast(debit_fsl as fis_dr_fsl) AS debit_fsl,
  cast(balance_fsl as fis_bal_fsl) AS balance_fsl,
  cast(rgcur as fins_curr8) AS rgcur,
  cast(credit_gsl as fis_cr_gsl) AS credit_gsl,
  cast(debit_gsl as fis_dr_gsl) AS debit_gsl,
  cast(balance_gsl as fis_bal_gsl) AS balance_gsl,
  cast(rfccur as fins_currfc) AS rfccur,
  cast(credit_fcsl as fis_cr_amt_funccrcy) AS credit_fcsl,
  cast(debit_fcsl as fis_dr_amt_funccrcy) AS debit_fcsl,
  cast(balance_fcsl as fis_bal_fcsl) AS balance_fcsl
FROM fiscds_bal_gl_03
;