C_FXExposureTP

DDL: C_FXEXPOSURETP Type: view_entity CONSUMPTION
59 Fields 1 Data Sources 3 Associations

Manage FX Exposures

C_FXExposureTP is a Consumption CDS View that provides data about "Manage FX Exposures" in SAP S/4HANA. It reads from 1 data source (R_FXExposureTP) and exposes 59 fields with key field FXExposureUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_FXExposureTP R_FXExposureTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_FXExposureChgDocItem _FXExpStatusHistChgDoc $projection.ChangeDocObject = _FXExpStatusHistChgDoc.ChangeDocObject
[0..1] I_UserContactCard _UserCreatedBy $projection.FXExposureCreatedBy = _UserCreatedBy.ContactCardID
[0..1] I_UserContactCard _UserChangedBy $projection.FXExposureLastChangedBy = _UserChangedBy.ContactCardID

Annotations (11)

NameValueLevelField
EndUserText.label Manage FX Exposures view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name FXExposure_UI view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY FXExposureUUID FXExposureUUID
ForeignExchangeExposure ForeignExchangeExposure
FXExposureType FXExposureType
FXExposureTypeName _FXExposureTypeText FXExposureTypeName
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCodeText CompanyCodeName Company Name
virtualUICT_HideCompanyCodeabap_boolean
Portfolio Portfolio Portfolio
PortfolioName
virtualUICT_HidePortfolioabap_boolean
CostCenter CostCenter Cost Center
CostCenterName
virtualUICT_HideCostCenterabap_boolean
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
virtualUICT_HideProfitCenterabap_boolean
Country Country Venue: Ctry/Reg
CountryName
virtualUICT_HideCountryabap_boolean
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementName _WBSElementText WBSDescription WBS Element Name
virtualUICT_HideWBSElementabap_boolean
OnBehalfOfCompany OnBehalfOfCompany On Behalf of Company
OnBehalfOfCompanyName _BehalfOfCoCodeText CompanyCodeName On Behalf of Company Name
Segment Segment Segment number
SegmentName
virtualUICT_HideSegmentabap_boolean
virtualUICT_HideDiffCritabap_boolean
FXExposureValidFromDate FXExposureValidFromDate Valid From
FXExposureDueDate FXExposureDueDate
FXExposureAmountInRiskCurrency FXExposureAmountInRiskCurrency
FXExposureRiskCurrency FXExposureRiskCurrency
FXExposureRiskCurrencyName
FXExposureTargetCurrency FXExposureTargetCurrency
FXExposureDirection FXExposureDirection
FXExposureDirectionName _DirectionText FXExposureDirectionName
FXExposureExternalID FXExposureExternalID
FXExposureCreationMode FXExposureCreationMode
FXExposureCreationModeName _CreationModeText FXExposureCreationModeName
FXExposureStatus FXExposureStatus
FXExposureStatusName _StatusText FXExposureStatusName
FXExposureStatusCriticality FXExposureStatusCriticality
FXExposureStsChgReasonText FXExposureStsChgReasonText
ChangeDocObject ChangeDocObject Object Value
FXExposureCreatedBy FXExposureCreatedBy
CreatedByUserDescription _CreatedBy UserDescription Full Name
FXExposureCreatedAtDteTme FXExposureCreatedAtDteTme
FXExposureLastChangedBy FXExposureLastChangedBy
FXExposureLastChangedAtDteTme FXExposureLastChangedAtDteTme
virtualUICT_HideSubmitabap_boolean
virtualUICT_HideReleaseabap_boolean
virtualUICT_HideRejectabap_boolean
virtualUICT_HideObsoleteabap_boolean
virtualUICT_HideSetCreatedabap_boolean
_FXExpStatusHistChgDoc _FXExpStatusHistChgDoc
_UserCreatedBy _UserCreatedBy Created by
_UserChangedBy _UserChangedBy
FXExposureRejectCriticality FXExposureRejectCriticality
FXExposureReleaseCriticality FXExposureReleaseCriticality

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_FXExposureTP.
-- 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 C_FXExposureTP AS
SELECT
  FXExposureUUID,
  ForeignExchangeExposure,
  FXExposureType,
  _FXExposureTypeText.FXExposureTypeName AS FXExposureTypeName,
  CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  virtual UICT_HideCompanyCode : abap_boolean AS virtualUICT_HideCompanyCodeabap_boolean,
  Portfolio,
  _PortfolioText[1:Language=$session.system_language].PortfolioName AS PortfolioName,
  virtual UICT_HidePortfolio : abap_boolean AS virtualUICT_HidePortfolioabap_boolean,
  CostCenter,
  _CostCenterText[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  virtual UICT_HideCostCenter : abap_boolean AS virtualUICT_HideCostCenterabap_boolean,
  ProfitCenter,
  _ProfitCenterText[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  virtual UICT_HideProfitCenter : abap_boolean AS virtualUICT_HideProfitCenterabap_boolean,
  Country,
  _CountryText[1:Language=$session.system_language].CountryName AS CountryName,
  virtual UICT_HideCountry : abap_boolean AS virtualUICT_HideCountryabap_boolean,
  WBSElementExternalID,
  _WBSElementText.WBSDescription AS WBSElementName,
  virtual UICT_HideWBSElement : abap_boolean AS virtualUICT_HideWBSElementabap_boolean,
  OnBehalfOfCompany,
  _BehalfOfCoCodeText.CompanyCodeName AS OnBehalfOfCompanyName,
  Segment,
  _SegmentText[1:Language=$session.system_language].SegmentName AS SegmentName,
  virtual UICT_HideSegment : abap_boolean AS virtualUICT_HideSegmentabap_boolean,
  virtual UICT_HideDiffCrit : abap_boolean AS virtualUICT_HideDiffCritabap_boolean,
  FXExposureValidFromDate,
  FXExposureDueDate,
  FXExposureAmountInRiskCurrency,
  FXExposureRiskCurrency,
  cast(_RiskCurrencyText.CurrencyName as fxem_fx_exposure_risk_crcy_nm preserving type ) AS FXExposureRiskCurrencyName,
  FXExposureTargetCurrency,
  FXExposureDirection,
  _DirectionText.FXExposureDirectionName AS FXExposureDirectionName,
  FXExposureExternalID,
  FXExposureCreationMode,
  _CreationModeText.FXExposureCreationModeName AS FXExposureCreationModeName,
  FXExposureStatus,
  _StatusText.FXExposureStatusName AS FXExposureStatusName,
  FXExposureStatusCriticality,
  FXExposureStsChgReasonText,
  ChangeDocObject,
  FXExposureCreatedBy,
  _CreatedBy.UserDescription AS CreatedByUserDescription,
  FXExposureCreatedAtDteTme,
  FXExposureLastChangedBy,
  FXExposureLastChangedAtDteTme,
  virtual UICT_HideSubmit : abap_boolean AS virtualUICT_HideSubmitabap_boolean,
  virtual UICT_HideRelease : abap_boolean AS virtualUICT_HideReleaseabap_boolean,
  virtual UICT_HideReject : abap_boolean AS virtualUICT_HideRejectabap_boolean,
  virtual UICT_HideObsolete : abap_boolean AS virtualUICT_HideObsoleteabap_boolean,
  virtual UICT_HideSetCreated : abap_boolean AS virtualUICT_HideSetCreatedabap_boolean,
  FXExposureRejectCriticality,
  FXExposureReleaseCriticality
FROM R_FXExposureTP
LEFT OUTER JOIN C_FXExposureChgDocItem AS _FXExpStatusHistChgDoc ON ChangeDocObject = _FXExpStatusHistChgDoc.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _UserCreatedBy ON FXExposureCreatedBy = _UserCreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserChangedBy ON FXExposureLastChangedBy = _UserChangedBy.ContactCardID  -- association [0..1]
;

Learn More