I_FXExposureVersion
FX Exposure Version
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.
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
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
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| fxemt_exposure_v | fxemt_exposure_v | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FXExposureVersionUUID | fx_exposure_v_uuid | ||
| ForeignExchangeExposureVersion | fx_exposure_version_nr | |||
| FXExposureUUID | fx_exposure_uuid | |||
| ForeignExchangeExposure | fx_exposure_id | |||
| FXExposureType | fx_exposure_type | |||
| CompanyCode | company_code | Company Code | ||
| Portfolio | portfolio | Portfolio | ||
| CostCenter | cost_center | Posted Cost Center | ||
| ProfitCenter | profit_center | Profit Center | ||
| Country | country | Venue: Ctry/Reg | ||
| WBSElementInternalID | wbs_element | WBS Internal ID | ||
| OnBehalfOfCompany | on_behalf_of_comp_code | On Behalf of CoCode | ||
| Segment | segment | Segment number | ||
| FXExposureValidFromDate | valid_from | Validity Start Time | ||
| FXExposureDueDate | due_date | Net Due Date | ||
| FXExposureAmountInRiskCurrency | amount | Value Amount | ||
| FXExposureRiskCurrency | risk_currency | |||
| FXExposureTargetCurrency | target_currency | |||
| FXExposureDirection | direction | Long/Short Position | ||
| FXExposureStatus | status | Workflow Status | ||
| FXExposureExternalID | external_id | WEBGUI External ID | ||
| FXExposureCreationMode | fx_exposure_creation_mode | |||
| FXExposureCreatedBy | createdby | User Name | ||
| FXExposureCreatedAtDteTme | createdat | Time Stamp | ||
| FXExposureLastChangedBy | lastchangedby | User Name | ||
| FXExposureLastChangedAtDteTme | lastchangedat | Time Stamp | ||
| LocalLastChangeDateTime | local_last_change_datetime | Time Stamp | ||
| ChangeDocObject | changedoc_object_id | Object Value | ||
| FXExposureStsChgReasonText | exp_status_change_reason |
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
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA