V_ML_FI_CONS

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 V_ML_FI_CONS.
-- 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: V_MLFI_CONS
-- Parameters: iv_bukrs : bukrs, iv_fiscyearper : jahrper

CREATE VIEW V_ML_FI_CONS AS
SELECT
  cast( rldnr as fins_ledger preserving type ) AS rldnr,
  cast( ktosl as ktosl preserving type ) AS ktosl,
  cast( racct as racct preserving type ) AS racct,
  cast( kalnr as ck_kalnr preserving type ) AS kalnr,
  cast( matnr as matnr preserving type ) AS matnr,
  cast( bwkey as bwkey preserving type ) AS bwkey,
  cast( bwtar as bwtar_d preserving type ) AS bwtar,
  cast( prctr as prctr preserving type ) AS prctr,
  cast( hsalk3 as mlhsalk3 preserving type ) AS hsalk3,
  cast( hsalk3_ml as mlhsalk3 preserving type ) AS hsalk3_ml,
  cast( h_diff as mlhsalk3 preserving type ) AS h_diff,
  rhcur,
  cast( ksalk3 as mlksalk3 preserving type ) AS ksalk3,
  cast( ksalk3_ml as mlksalk3 preserving type ) AS ksalk3_ml,
  cast( k_diff as mlksalk3 preserving type ) AS k_diff,
  rkcur,
  cast( osalk3 as mlosalk3 preserving type ) AS osalk3,
  cast( osalk3_ml as mlosalk3 preserving type ) AS osalk3_ml,
  cast( o_diff as mlosalk3 preserving type ) AS o_diff,
  rocur,
  cast( vsalk3 as ml4salk3 preserving type ) AS vsalk3,
  cast( vsalk3_ml as ml4salk3 preserving type ) AS vsalk3_ml,
  cast( v_diff as ml4salk3 preserving type ) AS v_diff,
  rvcur,
  cast( bsalk3 as fins_vbcur12 preserving type ) AS bsalk3,
  cast( bsalk3_ml as fins_vbcur12 preserving type ) AS bsalk3_ml,
  cast( b_diff as fins_vbcur12 preserving type ) AS b_diff,
  rbcur,
  cast( csalk3 as fins_vccur12 preserving type ) AS csalk3,
  cast( csalk3_ml as fins_vccur12 preserving type ) AS csalk3_ml,
  cast( c_diff as fins_vccur12 preserving type ) AS c_diff,
  rccur,
  cast( dsalk3 as fins_vdcur12 preserving type ) AS dsalk3,
  cast( dsalk3_ml as fins_vdcur12 preserving type ) AS dsalk3_ml,
  cast( d_diff as fins_vdcur12 preserving type ) AS d_diff,
  rdcur,
  cast( esalk3 as fins_vecur12 preserving type ) AS esalk3,
  cast( esalk3_ml as fins_vecur12 preserving type ) AS esalk3_ml,
  cast( e_diff as fins_vecur12 preserving type ) AS e_diff,
  recur,
  cast( fsalk3 as fins_vfcur12 preserving type ) AS fsalk3,
  cast( fsalk3_ml as fins_vfcur12 preserving type ) AS fsalk3_ml,
  cast( f_diff as fins_vfcur12 preserving type ) AS f_diff,
  rfcur,
  cast( gsalk3 as fins_vgcur12 preserving type ) AS gsalk3,
  cast( gsalk3_ml as fins_vgcur12 preserving type ) AS gsalk3_ml,
  cast( g_diff as fins_vgcur12 preserving type ) AS g_diff,
  rgcur
FROM TF_ML_FI_CONS
;