HRFPM_CDS_FPM_POS

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 HRFPM_CDS_FPM_POS.
-- 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: HRFPMCDSFPMPOS

CREATE VIEW HRFPM_CDS_FPM_POS AS
SELECT
  pos.plvar AS plvar,
  pos.otype AS otype,
  pos.objid AS objid,
  pos.enc_type AS enc_type,
  pos.datbi AS datbi,
  pos.endda_key AS endda_key,
  pos.fpm_posnr AS fpm_posnr,
  pos.plvar_dp AS plvar_dp,
  pos.otype_dp AS otype_dp,
  pos.objid_dp AS objid_dp,
  pos.enc_type_dp AS enc_type_dp,
  pos.datbi_dp AS datbi_dp,
  pos.endda_key_dp AS endda_key_dp,
  pos.fpm_posnr_dp AS fpm_posnr_dp,
  pos.enc_type_mp AS enc_type_mp,
  pos.belnr_mp AS belnr_mp,
  pos.fpm_posnr_mp AS fpm_posnr_mp,
  pos.begda AS begda,
  pos.endda AS endda,
  pos.betrg AS betrg,
  pos.waers AS waers,
  pos.erlkz AS erlkz,
  pos.due_date AS due_date,
  pos.perio AS perio,
  pos.saknr AS saknr,
  pos.bukrs AS bukrs,
  pos.kokrs AS kokrs,
  pos.kostl AS kostl,
  pos.aufnr AS aufnr,
  pos.posnr AS posnr,
  pos.nplnr AS nplnr,
  pos.vornr AS vornr,
  pos.grant_nbr AS grant_nbr,
  pos.geber AS geber,
  pos.budget_pd AS budget_pd,
  pos.fkber AS fkber,
  pos.fistl AS fistl,
  pos.fipex AS fipex,
  pos.gsber AS gsber,
  pos.segmt AS segmt,
  pos.payarea AS payarea,
  pos.flexdim AS flexdim,
  pos.status AS status,
  pos.delta_amount AS delta_amount,
  pos.currency AS currency,
  pos.db_action AS db_action,
  pos.request_id AS request_id,
  pos.closed AS closed,
  pos.costitem AS costitem,
  pos.begdafor AS begdafor,
  pos.enddafor AS enddafor,
  doc.aedtm AS aedtm
FROM hrfpm_fpm_pos AS pos
LEFT OUTER JOIN hrfpm_fpm_doc AS doc ON /* join condition not captured in parsed metadata */
;