I_CmmdtyHdgCnstltnTransOvwUsrT

DDL: I_CMMDTYHDGCNSTLTNTRANSOVWUSRT Type: view_entity COMPOSITE
7 Fields 1 Data Sources 2 Associations

Hedge Constellation Details User - Text

I_CmmdtyHdgCnstltnTransOvwUsrT is a Composite CDS View that provides data about "Hedge Constellation Details User - Text" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgCnstltnTransOvw) and exposes 7 fields with key fields CmmdtyHedgeConstellationUUID, CompanyCode, FinancialTransaction, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgCnstltnTransOvw I_CmmdtyHdgCnstltnTransOvw from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CommodityHedgeFormerMemberT _CommodityHedgeFormerMemberT _CommodityHedgeFormerMemberT.CommodityHedgeFormerMember = 'X' and _CommodityHedgeFormerMemberT.Language = $session.system_language
[0..1] I_User _ChangedByUserText $projection.LastChangedByUser = _ChangedByUserText.UserID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #TEXT view
EndUserText.label Hedge Constellation Details User - Text view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeConstellationUUID CmmdtyHedgeConstellationUUID
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY Language _CommodityHedgeFormerMemberT Language Report Text Language
LastChangedByUser LastChangedByUser User Name
UserIDendasFinTransLastChangedByUserText
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code

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_CmmdtyHdgCnstltnTransOvwUsrT.
-- 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.

CREATE VIEW I_CmmdtyHdgCnstltnTransOvwUsrT AS
SELECT
  CmmdtyHedgeConstellationUUID,
  CompanyCode,
  FinancialTransaction,
  _CommodityHedgeFormerMemberT.Language AS Language,
  LastChangedByUser,
  case when LastChangedByUser is initial then '' when _ChangedByUserText.UserID is null or _ChangedByUserText.UserID = '' then _CommodityHedgeFormerMemberT.CommodityHedgeFormerMemberText else concat( concat( concat( _ChangedByUserText.UserDescription,' (' ) , _ChangedByUserText.UserID ), ')') end as FinTransLastChangedByUserText AS UserIDendasFinTransLastChangedByUserText,
  CmmdtyHdgPlnExpsrCompanyCode
FROM I_CmmdtyHdgCnstltnTransOvw
LEFT OUTER JOIN I_CommodityHedgeFormerMemberT AS _CommodityHedgeFormerMemberT ON _CommodityHedgeFormerMemberT.CommodityHedgeFormerMember = 'X' AND _CommodityHedgeFormerMemberT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUserText ON LastChangedByUser = _ChangedByUserText.UserID  -- association [0..1]
;

Learn More