What is I_FXExposureVersion in SAP S/4HANA?

I_FXExposureVersion is a basic CDS view in SAP S/4HANA. FX Exposure Version It contains 29 fields.

Which tables does I_FXExposureVersion read from?

I_FXExposureVersion reads data from: fxemt_exposure_v.

What VDM layer is I_FXExposureVersion?

I_FXExposureVersion is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_FXExposureVersion

DDL: I_FXEXPOSUREVERSION Type: view_entity BASIC Package: FTR_FX_EXPOSURE_MGMT_IMPL

29 Fields 1 Data Sources

FX Exposure Version

I_FXExposureVersion (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FXExposureVersion is a Basic CDS View that provides data about "FX Exposure Version" in SAP S/4HANA. It reads from 1 data source (fxemt_exposure_v) and exposes 29 fields with key field FXExposureVersionUUID. Part of development package FTR_FX_EXPOSURE_MGMT_IMPL.

SAP Help Documentation

Category	CDS Views for Transactional Data

Purpose
This CDS view retrieves the data of the available versions of FX exposures. These FX exposure versions are stored in an internal table when an FX exposure is released, set to obsolete, or rejected. This CDS view provides the data to answer the following business questions: Which FX exposure versions exist? What are the attributes of a specific FX exposure version? Which versions exist for a specific FX exposure? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: F_FXEM (Company Code/FX Exposure Type ID) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Type Label Comment FXExposureVersionUUID X FXEM_FX_EXPOSURE_V_UUID Expos.Vers. Tech. ID FX Exposure Version Technical ID ForeignExchangeExposureVersion FXEM_FX_EXPOSURE_VERSION_NR Exposure Version No. FX Exposure Version Number FXExposureUUID FXEM_FX_EXPOSURE_UUID Exposure Techn. ID FX Exposure Technical ID ForeignExchangeExposure FXEM_FX_EXPOSURE_ID FX Exposure ID FX Exposure ID FXExposureType FXEM_FX_EXPOSURE_TYPE FX Exposure Type FX Exposure Type ID CompanyCode BUKRS Company Code Company Code Portfolio FXEM_FX_EXPOSURE_PORTFOLIO Portfolio Portfolio for FX Exposure CostCenter KOSTL Cost Center Cost Center ProfitCenter PRCTR Profit Center Profit Center Country LAND1 Country/Region Key Country/Region Key WBSElementInternalID FXEM_FX_EXPOSURE_WBS_ELEMENT WBS Element WBS Element for FX Exposure OnBehalfOfCompany TRBA_BEHALF_OF_COMPANY On Behalf of CoCode On Behalf of Company Code Segment FB_SEGMENT Segment Segment for Segmental Reporting FXExposureValidFromDate FXEM_FX_EXPOSURE_VALID_FROM Valid Date From FX Exposure Start Validity Date FXExposureDueDate FXEM_FX_EXPOSURE_DUE_DATE Due Date FX Exposure Due Date FXExposureAmountInRiskCurrency FXEM_FX_EXPOSURE_AMOUNT FX Exposure Amount FX Exposure Amount FXExposureRiskCurrency FXEM_FX_EXPOSURE_RISK_CURRENCY FX Exposure Crcy FX Exposure Currency FXExposureTargetCurrency FXEM_FX_EXPOSURE_TARG_CURRENCY Target Currency Target Currency of FX Exposure FXExposureDirection FXEM_FX_EXPOSURE_DIRECTION Exposure Direction FX Exposure Direction FXExposureStatus FXEM_FX_EXPOSURE_STATUS Exposure Status FX Exposure Status Technical Value Description R Released X Rejected O Obsolete FXExposureExternalID FXEM_FX_EXPOSURE_EXTERNAL_ID External ID FX Exposure External ID FXExposureCreationMode FXEM_FX_EXPOSURE_CREATION_MODE Creation Mode Creation Mode of the FX Exposure FXExposureCreatedBy FXEM_FX_EXPOSURE_CREATED_BY Created By FX Exposure Created By FXExposureCreatedAtDteTme FXEM_FX_EXPOSURE_CREATED_AT Created At FX Exposure Created At FXExposureLastChangedBy FXEM_FX_EXPOSURE_LST_CHANGE_BY Last Changed By FX Exposure Last Changed By FXExposureLastChangedAtDteTme FXEM_FX_EXPOSURE_LST_CHANGE_AT Last Changed At FX Exposure Last Changed At LocalLastChangeDateTime FXEM_FX_EXPOSURE_LST_CHANGE_AT Last Changed At FX Exposure Last Changed At ChangeDocObject CDOBJECTV Object Value Object Value FXExposureStsChgReasonText FXEM_FX_EXPOSURE_STATUS_REASON Status Change Reason Reason for Status Change of FX Exposure

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-TRM-TM-2CL
Capabilities	Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Financial Operations for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view retrieves the data of the available versions of FX exposures. These FX exposure versions are stored in an internal table when an FX exposure is released, set to obsolete, or rejected.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which FX exposure versions exist?</p></li> <li><p>What are the attributes of a specific FX exposure version?</p></li> <li><p>Which versions exist for a specific FX exposure?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
fxemt_exposure_v	fxemt_exposure_v	from

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	FX Exposure Version	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#BASIC	view

Fields (29)

Key	Field	Source Field	Description
KEY	FXExposureVersionUUID	fx_exposure_v_uuid	FX Exposure Version Technical ID
	ForeignExchangeExposureVersion	fx_exposure_version_nr	FX Exposure Version Number
	FXExposureUUID	fx_exposure_uuid	FX Exposure Technical ID
	ForeignExchangeExposure	fx_exposure_id	FX Exposure ID
	FXExposureType	fx_exposure_type	FX Exposure Type ID
	CompanyCode	company_code	Company Code
	Portfolio	portfolio	Portfolio for FX Exposure
	CostCenter	cost_center	Posted Cost Center
	ProfitCenter	profit_center	Profit Center
	Country	country	Country/Region Key
	WBSElementInternalID	wbs_element	WBS Element for FX Exposure
	OnBehalfOfCompany	on_behalf_of_comp_code	On Behalf of Company Code
	Segment	segment	Segment for Segmental Reporting
	FXExposureValidFromDate	valid_from	FX Exposure Start Validity Date
	FXExposureDueDate	due_date	FX Exposure Due Date
	FXExposureAmountInRiskCurrency	amount	FX Exposure Amount
	FXExposureRiskCurrency	risk_currency	FX Exposure Currency
	FXExposureTargetCurrency	target_currency	Target Currency of FX Exposure
	FXExposureDirection	direction	FX Exposure Direction
	FXExposureStatus	status	FX Exposure Status
	FXExposureExternalID	external_id	FX Exposure External ID
	FXExposureCreationMode	fx_exposure_creation_mode	Creation Mode of the FX Exposure
	FXExposureCreatedBy	createdby	FX Exposure Created By
	FXExposureCreatedAtDteTme	createdat	FX Exposure Created At
	FXExposureLastChangedBy	lastchangedby	FX Exposure Last Changed By
	FXExposureLastChangedAtDteTme	lastchangedat	FX Exposure Last Changed At
	LocalLastChangeDateTime	local_last_change_datetime	FX Exposure Last Changed At
	ChangeDocObject	changedoc_object_id	Object Value
	FXExposureStsChgReasonText	exp_status_change_reason	Reason for Status Change of FX Exposure

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_FXExposureVersion.
-- 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_FXExposureVersion AS
SELECT
  fx_exposure_v_uuid AS FXExposureVersionUUID,
  fx_exposure_version_nr AS ForeignExchangeExposureVersion,
  fx_exposure_uuid AS FXExposureUUID,
  fx_exposure_id AS ForeignExchangeExposure,
  fx_exposure_type AS FXExposureType,
  company_code AS CompanyCode,
  Portfolio,
  cost_center AS CostCenter,
  profit_center AS ProfitCenter,
  Country,
  wbs_element AS WBSElementInternalID,
  on_behalf_of_comp_code AS OnBehalfOfCompany,
  Segment,
  valid_from AS FXExposureValidFromDate,
  due_date AS FXExposureDueDate,
  amount AS FXExposureAmountInRiskCurrency,
  risk_currency AS FXExposureRiskCurrency,
  target_currency AS FXExposureTargetCurrency,
  direction AS FXExposureDirection,
  status AS FXExposureStatus,
  external_id AS FXExposureExternalID,
  fx_exposure_creation_mode AS FXExposureCreationMode,
  createdby AS FXExposureCreatedBy,
  createdat AS FXExposureCreatedAtDteTme,
  lastchangedby AS FXExposureLastChangedBy,
  lastchangedat AS FXExposureLastChangedAtDteTme,
  local_last_change_datetime AS LocalLastChangeDateTime,
  changedoc_object_id AS ChangeDocObject,
  exp_status_change_reason AS FXExposureStsChgReasonText
FROM fxemt_exposure_v
;

Depth:

I_FXExposureVersion view_entity

fxemt_exposure_v