C_CmmdtyHedgeTargetQuotaStatus

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 C_CmmdtyHedgeTargetQuotaStatus.
-- 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: CCMMHDGTQSTS

CREATE VIEW C_CmmdtyHedgeTargetQuotaStatus AS
SELECT
  CmmdtyHdgObjDocumentStatusUUID,
  CmmdtyHedgeObjectDocumentUUID,
  CmmdtyHedgeObjectDocumentType,
  CmmdtyHdgObjDocumentStatusID,
  _StatusText.CmmdtyHdgTargetQuotaStatusText AS CmmdtyHdgTargetQuotaStatusText,
  CmmdtyHdgObjStsDetReasonText,
  CmmdtyHdgObjStsChangeDateTime,
  CmmdtyHdgObjStsChangedByUser,
  case when _ChangedByUser.UserID is null or _ChangedByUser.UserID = '' then _CommodityHedgeFormerMemberT.CommodityHedgeFormerMemberText else concat( concat( concat(_ChangedByUser.UserDescription,' (' ) , _ChangedByUser.UserID ), ')') end as CmmdtyHdgObjStsChgdByUserText AS UserIDendasCmmdtyHdgObjStsChgdByUserText
FROM I_CmmdtyHedgeTargetQuotaStatus
LEFT OUTER JOIN I_CmmdtyHdgTgtQtaStatusObject AS _StatusText ON CmmdtyHdgObjDocumentStatusID = _StatusText.CmmdtyHedgeTargetQuotaStatusID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON CmmdtyHdgObjStsChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CommodityHedgeFormerMemberT AS _CommodityHedgeFormerMemberT ON _CommodityHedgeFormerMemberT.CommodityHedgeFormerMember = 'X' AND _CommodityHedgeFormerMemberT.Language = $session.system_language  -- association [0..*]
;