I_CmmdtyHdgTargetQuotaPosition

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 I_CmmdtyHdgTargetQuotaPosition.
-- 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: ICMMHDGTGTQTAPOS

CREATE VIEW I_CmmdtyHdgTargetQuotaPosition AS
SELECT
  tq_pos_uuid AS CmmdtyHdgTgtQuotaPositionUUID,
  targetquota_uuid AS CmmdtyHedgeTargetQuotaUUID,
  position_year AS CmmdtyHdgTgtQuotaPositionYear,
  position_valid_from AS CmmdtyHdgTgtQtaPosValdDateTime,
  tstmp_to_dats( position_valid_from, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CmmdtyHdgTgtQtaPosValdDate AS clientNULLasCmmdtyHdgTgtQtaPosValdDate,
  period_number AS CmmdtyHdgTgtQuotaPeriodNumber,
  cast(hedge_management_quota as abap.fltp) AS CmmdtyHdgTgtQtaUprLmtInPercent,
  cast(hedge_accounting_quota as abap.fltp) AS CmmdtyHdgAcctgUprLmtInPercent,
  remark AS CommodityHedgeRemarkNote,
  is_active AS IsActive,
  period_class AS CmmdtyHdgTgtQuotaPeriodClass,
  cast( created_by as cmm_hdg_crtd_by ) AS CmmdtyHdgTgtQtaPosCrtedByUser,
  created_at AS CmmdtyHdgTgtQtaPosCrtnDateTime,
  cast( changed_by as cmm_hdg_crtd_by ) AS CmmdtyHdgTgtQtaPosChgdByUser,
  changed_at AS CmmdtyHdgTgtQtaPosChgDateTime,
  cast( '%' as meins ) AS CommodityHedgePercentageUnit
FROM cmmt_tq_position
;