I_CmmdtyHedgeTargetQuotaHeader

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_CmmdtyHedgeTargetQuotaHeader.
-- 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: ICMMHDGTQHEADER

CREATE VIEW I_CmmdtyHedgeTargetQuotaHeader AS
SELECT
  tq.targetquota_uuid AS CmmdtyHedgeTargetQuotaUUID,
  tq.version AS CmmdtyHedgeTargetQuotaVersion,
  tq.company_code AS CompanyCode,
  tq.dcs_id AS DerivativeContrSpecification,
  tq.direction AS CmmdtyHdgTargetQuotaDirection,
  tq.valid_from AS CmmdtyHdgTgtQtaValdFrmDateTime,
  tq.period_class AS CmmdtyHdgTgtQuotaPeriodClass,
  tq.hedge_book AS CmmdtyHdgTgtQuotaHedgeBookID,
  tq.remark AS CommodityHedgeRemarkNote,
  tq.is_active AS IsActive,
  tq.status_id AS CmmdtyHedgeTargetQuotaStatusID,
  tq.log_handle AS CmmdtyHdgTargetQuotaLogHandle,
  tq.is_hedged_fully AS CmmdtyHdgTgtQuotaIsFullyHedged,
  cast( tq.created_by as cmm_hdg_crtd_by ) AS CmmdtyHdgTgtQuotaCreatedByUser,
  tq.created_at AS CmmdtyHdgTgtQtaCrtnDateTime,
  tq.is_obsolete AS CmmdtyHdgTargetQuotaIsObsolete,
  cast( tq.changed_by as cmm_hdg_crtd_by ) AS CmmdtyHdgTgtQuotaChangedByUser,
  tq.changed_at AS CmmdtyHdgTgtQtaChangeDateTime
FROM cmmt_targetquota AS tq
;