I_CmHdgOffstgFXHdgReqUserText

DDL: I_CMHDGOFFSTGFXHDGREQUSERTEXT Type: view_entity COMPOSITE
5 Fields 1 Data Sources 3 Associations

Offsetting FX Hedge Request User - Text

I_CmHdgOffstgFXHdgReqUserText is a Composite CDS View that provides data about "Offsetting FX Hedge Request User - Text" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgOffstgFXHdgReqCmpst) and exposes 5 fields with key fields CmmdtyHdgOffstgFXHdgReqGrpUUID, HedgeRequestIdentifier, Language. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgOffstgFXHdgReqCmpst I_CmmdtyHdgOffstgFXHdgReqCmpst from

Associations (3)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Offsetting FX Hedge Request 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 (5)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgOffstgFXHdgReqGrpUUID CmmdtyHdgOffstgFXHdgReqGrpUUID
KEY HedgeRequestIdentifier HedgeRequestIdentifier
KEY Language _CommodityHedgeFormerMemberT Language Report Text Language
CmmdtyHdgFXHdgReqCreatedByUser CmmdtyHdgFXHdgReqCreatedByUser
CmmdtyHdgFXHdgReqLastChgdByUsr CmmdtyHdgFXHdgReqLastChgdByUsr

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_CmHdgOffstgFXHdgReqUserText.
-- 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_CmHdgOffstgFXHdgReqUserText AS
SELECT
  CmmdtyHdgOffstgFXHdgReqGrpUUID,
  HedgeRequestIdentifier,
  _CommodityHedgeFormerMemberT.Language AS Language,
  CmmdtyHdgFXHdgReqCreatedByUser,
  CmmdtyHdgFXHdgReqLastChgdByUsr
FROM I_CmmdtyHdgOffstgFXHdgReqCmpst
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 CmmdtyHdgFXHdgReqCreatedByUser = _CreatedByUserText.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUserText ON CmmdtyHdgFXHdgReqLastChgdByUsr = _ChangedByUserText.UserID  -- association [0..1]
;

Learn More