C_CmmdtyHdgTargetQuotaVersion

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_CmmdtyHdgTargetQuotaVersion.
-- 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: CMMHDGTQVER

CREATE VIEW C_CmmdtyHdgTargetQuotaVersion AS
SELECT
  CmmdtyHedgeTargetQuotaUUID,
  CmmdtyHedgeTargetQuotaVersion,
  CompanyCode,
  _CCText.CompanyCodeName AS CompanyCodeName,
  DerivativeContrSpecification,
  _DCSText.DerivativeContrSpecName AS DerivativeContrSpecName,
  CmmdtyHdgTargetQuotaDirection,
  _DircText.CmmdtyHdgTgtQuotaDirectionText AS CmmdtyHdgTgtQuotaDirectionText,
  CmmdtyHdgTgtQtaValdFrmDateTime,
  CmmdtyHdgTgtQuotaPeriodClass,
  _PrdClassText.CmmdtyHdgTgtQtaPerdLengthText AS CmmdtyHdgTgtQtaPerdLengthText,
  CmmdtyHdgTgtQuotaHedgeBookID,
  _HdgBookText.CmmdtyHedgeBookDescription AS CmmdtyHedgeBookDescription,
  CommodityHedgeRemarkNote,
  CmmdtyHdgTargetQuotaLogHandle,
  IsActive,
  CmmdtyHedgeTargetQuotaStatusID,
  _StatusText.CmmdtyHdgTargetQuotaStatusText AS CmmdtyHdgTargetQuotaStatusText,
  CmmdtyHdgTgtQuotaCreatedByUser,
  CmmdtyHdgTgtQtaCrtnDateTime,
  CmmdtyHdgTgtQuotaChangedByUser,
  CmmdtyHdgTgtQtaChangeDateTime,
  case when _ChangedByUser.UserID is null or _ChangedByUser.UserID = '' then _CommodityHedgeFormerMemberT.CommodityHedgeFormerMemberText else concat( concat( concat(_ChangedByUser.UserDescription,' (' ) , _ChangedByUser.UserID ), ')') end as CmmdtyHdgTgtQtaChgdByUserText AS UserIDendasCmmdtyHdgTgtQtaChgdByUserText
FROM I_CmmdtyHedgeTargetQuotaHeader
LEFT OUTER JOIN C_CmmdtyHdgTgtQtaPosVersion AS _TargetQuotaPosYear ON CmmdtyHedgeTargetQuotaUUID = _TargetQuotaPosYear.CmmdtyHedgeTargetQuotaUUID AND CmmdtyHdgTgtQuotaPeriodClass = _TargetQuotaPosYear.CmmdtyHdgTgtQuotaPeriodClass  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyHedgeTargetQuotaStatus AS _TQStatus ON CmmdtyHedgeTargetQuotaUUID = _TQStatus.CmmdtyHedgeObjectDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgTgtQtaStatusObject AS _StatusText ON CmmdtyHedgeTargetQuotaStatusID = _StatusText.CmmdtyHedgeTargetQuotaStatusID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgTgtQtaPerdClassText AS _PrdClassText ON CmmdtyHdgTgtQuotaPeriodClass = _PrdClassText.CmmdtyHdgTgtQuotaPeriodClass  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgBookDescriptionText AS _HdgBookText ON CmmdtyHdgTgtQuotaHedgeBookID = _HdgBookText.CommodityHedgeBookIdentifier AND _HdgBookText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DCSText ON DerivativeContrSpecification = _DCSText.DerivativeContrSpecification AND _DCSText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CCText ON CompanyCode = _CCText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgTgtQuotaDirection AS _DircText ON CmmdtyHdgTargetQuotaDirection = _DircText.CmmdtyHdgTargetQuotaDirection  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CmmdtyHdgTgtQuotaCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON CmmdtyHdgTgtQuotaChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CommodityHedgeFormerMemberT AS _CommodityHedgeFormerMemberT ON _CommodityHedgeFormerMemberT.CommodityHedgeFormerMember = 'X' AND _CommodityHedgeFormerMemberT.Language = $session.system_language  -- association [0..*]
;