P_Finsskf

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 P_Finsskf.
-- 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 P_Finsskf AS
SELECT
  finsskf.stagr AS stagr,
  finsskf.recid AS recid,
  finsskf.date_from AS date_from,
  finsskf.grtyp AS grtyp,
  finsskf.msl AS msl,
  finsskf.runit AS runit,
  finsskf.timestamp AS timestamp,
  finsskf.rbukrs AS rbukrs,
  finsskf.rrcty AS rrcty,
  finsskf.category AS category,
  finsskf.rcntr AS rcntr,
  finsskf.prctr AS prctr,
  finsskf.rfarea AS rfarea,
  finsskf.rbusa AS rbusa,
  finsskf.kokrs AS kokrs,
  finsskf.segment AS segment,
  finsskf.vorgn AS vorgn,
  finsskf.logsys AS logsys,
  finsskf.objnr AS objnr,
  finsskf.hrkft AS hrkft,
  cast(finsskf.scope as fis_scope_cv_conv_co preserving type) AS scope,
  finsskf.aufnr AS aufnr,
  finsskf.autyp AS autyp,
  cast( finsskf.ps_psp_pnr as fis_wbsint_no_conv preserving type ) AS ps_psp_pnr,
  cast( finsskf.ps_posid as fis_wbs_no_conv preserving type ) AS ps_posid,
  cast( finsskf.ps_prj_pnr as fis_projectint_no_conv preserving type ) AS ps_prj_pnr,
  cast( finsskf.ps_pspid as fis_project_no_conv preserving type ) AS ps_pspid,
  finsskf.nplnr AS nplnr,
  cast( finsskf.nplnr_vorgn as fis_npvrg_no_conv preserving type ) AS nplnr_vorgn,
  finsskf.prznr AS prznr,
  finsskf.kstrg AS kstrg,
  finsskf.rfund AS rfund,
  finsskf.rgrant_nbr AS rgrant_nbr,
  finsskf.rbudget_pd AS rbudget_pd,
  finsskf.kdauf AS kdauf,
  finsskf.kdpos AS kdpos,
  finsskf.lstar AS lstar
FROM finsskf
;