FPCV_AI_VAL_VAR

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 FPCV_AI_VAL_VAR.
-- 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.

CREATE VIEW FPCV_AI_VAL_VAR AS
SELECT
  tck05.bwvar AS bwvar,
  _CostingValuationVarText.ValuationVariantName AS ValuationVariantName,
  tck05.bwsm1 AS bwsm1,
  tck05.bwsm2 AS bwsm2,
  tck05.bwsm3 AS bwsm3,
  tck05.bwsm4 AS bwsm4,
  tck05.bwsm5 AS bwsm5,
  tck05.prkzg1 AS prkzg1,
  tck05.prkzg2 AS prkzg2,
  tck05.prkzg3 AS prkzg3,
  tck05.prkzg4 AS prkzg4,
  tck05.prkzg5 AS prkzg5,
  tck05.bwse1 AS bwse1,
  tck05.bwse2 AS bwse2,
  tck05.bwse3 AS bwse3,
  tck05.matsubstrat1 AS matsubstrat1,
  tck05.matsubstrat2 AS matsubstrat2,
  tck05.matsubstrat3 AS matsubstrat3,
  tck05.bwma1 AS bwma1,
  tck05.bwma2 AS bwma2,
  tck05.bwma3 AS bwma3,
  tck05.bwma5 AS bwma5,
  tck05.bwma4 AS bwma4,
  tck05.bwsf1 AS bwsf1,
  tck05.bwsf2 AS bwsf2,
  tck05.bwsf3 AS bwsf3,
  tck05.bwsv1 AS bwsv1,
  tck05.bwsv2 AS bwsv2,
  tck05.bwsv3 AS bwsv3,
  tck05.bwsfh AS bwsfh,
  tck05.kalsm AS kalsm,
  tck05.kalsm_raw AS kalsm_raw,
  tck05.zuart AS zuart,
  tck05.plisqut AS plisqut,
  tck05.lobezus AS lobezus,
  tck05.pertarif AS pertarif,
  tck05.versn AS versn,
  tck05.category AS category,
  tck05.con_fin_mpl1 AS con_fin_mpl1,
  tck05.con_fin_mpl2 AS con_fin_mpl2,
  tck05.con_fin_mpl3 AS con_fin_mpl3,
  tck05.con_fin_mpl4 AS con_fin_mpl4,
  tck05.con_fin_mpl5 AS con_fin_mpl5
FROM tck05
LEFT OUTER JOIN I_CostingValuationVarText AS _CostingValuationVarText ON /* join condition not captured in parsed metadata */
;