I_CmmdtyHdgPlnExposureUserText

DDL: I_CMMDTYHDGPLNEXPOSUREUSERTEXT Type: view_entity COMPOSITE
10 Fields 1 Data Sources 3 Associations

Commodity Plan Exposure User - Text

I_CmmdtyHdgPlnExposureUserText is a Composite CDS View that provides data about "Commodity Plan Exposure User - Text" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgPlanExpsrComposite) and exposes 10 fields with key fields CommodityHedgePlanExposureUUID, Language. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgPlanExpsrComposite I_CmmdtyHdgPlanExpsrComposite from

Associations (3)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Commodity Plan Exposure User - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #TEXT view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID UUID
KEY Language _CommodityHedgeFormerMemberT Language Report Text Language
CmmdtyHdgPlnExpsrCreatedByUser CmmdtyHdgPlnExpsrCreatedByUser User Name
CmmdtyHdgPlnExpsrLastChgdByUsr CmmdtyHdgPlnExpsrLastChgdByUsr User Name
UserIDendasCmmdtyHdgExpsrCrtedByUserText
UserIDendasCmmdtyHdgExpsrChgdByUserText
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode Company Code
CmmdtyHdgBookAuthznGroup CmmdtyHdgBookAuthznGroup
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID DCS ID
PhysicalCommodity PhysicalCommodity

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_CmmdtyHdgPlnExposureUserText.
-- 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_CmmdtyHdgPlnExposureUserText AS
SELECT
  CommodityHedgePlanExposureUUID,
  _CommodityHedgeFormerMemberT.Language AS Language,
  CmmdtyHdgPlnExpsrCreatedByUser,
  CmmdtyHdgPlnExpsrLastChgdByUsr,
  case when CmmdtyHdgPlnExpsrCreatedByUser is initial then '' when _CreatedByUserText.UserID is null or _CreatedByUserText.UserID = '' then _CommodityHedgeFormerMemberT.CommodityHedgeFormerMemberText else concat( concat( concat( _CreatedByUserText.UserDescription,' (' ) , _CreatedByUserText.UserID ), ')') end as CmmdtyHdgExpsrCrtedByUserText AS UserIDendasCmmdtyHdgExpsrCrtedByUserText,
  case when CmmdtyHdgPlnExpsrLastChgdByUsr is initial then '' when _ChangedByUserText.UserID is null or _ChangedByUserText.UserID = '' then _CommodityHedgeFormerMemberT.CommodityHedgeFormerMemberText else concat( concat( concat( _ChangedByUserText.UserDescription,' (' ) , _ChangedByUserText.UserID ), ')') end as CmmdtyHdgExpsrChgdByUserText AS UserIDendasCmmdtyHdgExpsrChgdByUserText,
  CmmdtyHdgPlnExpsrCompanyCode,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHedgePlanExposureDCSID,
  PhysicalCommodity
FROM I_CmmdtyHdgPlanExpsrComposite
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 _CreatedByUserText ON CmmdtyHdgPlnExpsrCreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUserText ON CmmdtyHdgPlnExpsrLastChgdByUsr = _ChangedByUserText.UserID  -- association [0..1]
;

Learn More