What is C_RU_ExchDiff in SAP S/4HANA?

C_RU_ExchDiff is a consumption CDS view in SAP S/4HANA. FI RU Unrealized exchanged differences It contains 61 fields.

Which tables does C_RU_ExchDiff read from?

C_RU_ExchDiff reads data from: P_RU_ExchDiff1, P_RU_ExchDiff1.

What VDM layer is C_RU_ExchDiff?

C_RU_ExchDiff is classified as a Consumption view optimized for specific business scenarios and reporting.

C_RU_ExchDiff

DDL: C_RU_EXCHDIFF SQL: CRUEXCHDIFF Type: view CONSUMPTION Package: GLO_FIN_IS_RU

61 Fields 2 Data Sources

FI RU Unrealized exchanged differences

C_RU_ExchDiff (Consumption)

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

Country or Region-Specific Functions for Finance

C_RU_ExchDiff is a Consumption CDS View that provides data about "FI RU Unrealized exchanged differences" in SAP S/4HANA. It reads from 2 data sources (P_RU_ExchDiff1, P_RU_ExchDiff1) and exposes 61 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, ControllingAreaCurrencyRole. Part of development package GLO_FIN_IS_RU.

SAP Help Documentation

Category	Finance

Purpose
This CDS view is designed to analyze and report on exchange rate differences that occur during financial transactions. This CDS view provides the data to answer the following business questions: What are the exchange rate differences for specific business partner reconciliation items within a given period? 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: BEGRU_KNA1 (Authorization Group for Customers) BEGRU_LFA1 (Authorization Group for Suppliers) B_BUP_DCPD (Accounting Document: Authorization for Company Codes) BEGRU_BUPA_GRP (Customer: Account Authorization) BUKRS (Company Code) These restriction types are edited in the Maintain Business Roles app.

Structure
Parameters The parameters of the CDS view are as follows: P_FromPostingDate : This parameter is used as the lower limit of the reporting time frame. P_ToPostingDate : This parameter is used as the upper limit of the reporting time frame. Important Fields Important fields in this view include the following: Field Name Description FISCALYEAR Fiscal Year ACCOUNTINGDOCUMENT Document Number ACCOUNTINGDOCUMENTITEM Item COMPANYCODE Company Code CONTROLLINGAREACURRENCYROLE Curr./Val. Type ACTIVEVALUATIONAREA Valuation Area

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Country or Region-Specific Functions for Finance
Application Component	FI-LOC-FI-RU
Capabilities	Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Country/Region-Specific Functions for Finance for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view is designed to analyze and report on exchange rate differences that occur during financial transactions.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the exchange rate differences for specific business partner reconciliation items within a given period?</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 (2)

Source	Alias	Join Type
P_RU_ExchDiff1	_Sum	from
P_RU_ExchDiff1	_Sum	union

Parameters (2)

Name	Type	Default
P_FromPostingDate	firu_posting_date_from
P_ToPostingDate	firu_posting_date_to

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CRUEXCHDIFF	view
VDM.viewType	#CONSUMPTION	view
AccessControl.personalData.blocking	#REQUIRED	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	FI RU Unrealized exchanged differences	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_RU_ExchDiff1	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_RU_ExchDiff1	AccountingDocument	Document Number of an Accounting Document
KEY	FiscalYear	P_RU_ExchDiff1	FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem	P_RU_ExchDiff1	AccountingDocumentItem	Number of Line Item Within Accounting Document
KEY	ControllingAreaCurrencyRole	P_RU_ExchDiff1	ControllingAreaCurrencyRole	Currency Type
KEY	ActiveValuationArea	P_RU_ExchDiff1	ActiveValuationArea	Valuation Area for FI Year-End Closing
	EndingBalanceAmtInCoCodeCrcy		0
	CompanyCodeCurrency	P_RU_ExchDiff1	CompanyCodeCurrency	Company Code Currency
	FrgnCrcyValnDeltaLogicIsActive	P_RU_ExchDiff1	FrgnCrcyValnDeltaLogicIsActive	Delta Logic of Foreign Currency Valuation
	AssignmentReference	P_RU_ExchDiff1	AssignmentReference	Assignment Reference
	Creditor	P_RU_ExchDiff1	Creditor	Supplier
	Debtor	P_RU_ExchDiff1	Debtor	Customer
	BusinessPartner	P_RU_ExchDiff1	BusinessPartner	Issuing Authority
	PostingDate	P_RU_ExchDiff1	PostingDate	Posting Date for GR
	CndnContrType	P_RU_ExchDiff1	CndnContrType	Contract Type
	AuthorizationGroup	P_RU_ExchDiff1	AuthorizationGroup	AuthorizGroup
	SupplierFinsAuthorizationGrp	P_RU_ExchDiff1	SupplierFinsAuthorizationGrp	Authorization Group
	CustomerFinsAuthorizationGrp	P_RU_ExchDiff1	CustomerFinsAuthorizationGrp	Authorization Group
	SupplierCompanyAuthznGroup	SupplierCompany	AuthorizationGroup	Authorization Group
	CustomerCompanyAuthznGroup	CustomerCompany	AuthorizationGroup	Authorization Group
	DataControllerSet	BusinessPartner	DataControllerSet	BP: Data Controller Set Flag
	DataController1	BusinessPartner	DataController1	BP: Data Controller (Internal Use Only)
	DataController2	BusinessPartner	DataController2	BP: Data Controller (Internal Use Only)
	DataController3	BusinessPartner	DataController3	BP: Data Controller (Internal Use Only)
	DataController4	BusinessPartner	DataController4	BP: Data Controller (Internal Use Only)
	DataController5	BusinessPartner	DataController5	BP: Data Controller (Internal Use Only)
	DataController6	BusinessPartner	DataController6	BP: Data Controller (Internal Use Only)
	DataController7	BusinessPartner	DataController7	BP: Data Controller (Internal Use Only)
	DataController8	BusinessPartner	DataController8	BP: Data Controller (Internal Use Only)
	DataController9	BusinessPartner	DataController9	BP: Data Controller (Internal Use Only)
	CompanyCode			Receiver Company Code
KEY	AccountingDocument	P_RU_ExchDiff1	AccountingDocument	Document Number of an Accounting Document
KEY	FiscalYear	P_RU_ExchDiff1	FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem	P_RU_ExchDiff1	AccountingDocumentItem	Number of Line Item Within Accounting Document
KEY	ControllingAreaCurrencyRole	P_RU_ExchDiff1	ControllingAreaCurrencyRole	Currency Type
KEY	ActiveValuationArea	P_RU_ExchDiff1	ActiveValuationArea	Valuation Area for FI Year-End Closing
	StartingBalanceAmtInCoCodeCrcy		0
	CompanyCodeCurrency	P_RU_ExchDiff1	CompanyCodeCurrency	Company Code Currency
	FrgnCrcyValnDeltaLogicIsActive	P_RU_ExchDiff1	FrgnCrcyValnDeltaLogicIsActive	Delta Logic of Foreign Currency Valuation
	AssignmentReference	P_RU_ExchDiff1	AssignmentReference	Assignment Reference
	Creditor	P_RU_ExchDiff1	Creditor	Supplier
	Debtor	P_RU_ExchDiff1	Debtor	Customer
	BusinessPartner	P_RU_ExchDiff1	BusinessPartner	Issuing Authority
	PostingDate	P_RU_ExchDiff1	PostingDate	Posting Date for GR
	CndnContrType	P_RU_ExchDiff1	CndnContrType	Contract Type
	AuthorizationGroup	P_RU_ExchDiff1	AuthorizationGroup	AuthorizGroup
	SupplierFinsAuthorizationGrp	P_RU_ExchDiff1	SupplierFinsAuthorizationGrp	Authorization Group
	CustomerFinsAuthorizationGrp	P_RU_ExchDiff1	CustomerFinsAuthorizationGrp	Authorization Group
	SupplierCompanyAuthznGroup	SupplierCompany	AuthorizationGroup	Authorization Group
	CustomerCompanyAuthznGroup	CustomerCompany	AuthorizationGroup	Authorization Group
	DataControllerSet	BusinessPartner	DataControllerSet	BP: Data Controller Set Flag
	DataController1	BusinessPartner	DataController1	BP: Data Controller (Internal Use Only)
	DataController2	BusinessPartner	DataController2	BP: Data Controller (Internal Use Only)
	DataController3	BusinessPartner	DataController3	BP: Data Controller (Internal Use Only)
	DataController4	BusinessPartner	DataController4	BP: Data Controller (Internal Use Only)
	DataController5	BusinessPartner	DataController5	BP: Data Controller (Internal Use Only)
	DataController6	BusinessPartner	DataController6	BP: Data Controller (Internal Use Only)
	DataController7	BusinessPartner	DataController7	BP: Data Controller (Internal Use Only)
	DataController8	BusinessPartner	DataController8	BP: Data Controller (Internal Use Only)
	DataController9	BusinessPartner	DataController9	BP: Data Controller (Internal Use Only)
	DataController10	BusinessPartner	DataController10	BP: Data Controller (Internal Use Only)

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_RU_ExchDiff.
-- 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.
-- SQL view name: CRUEXCHDIFF
-- Parameters: P_FromPostingDate : firu_posting_date_from, P_ToPostingDate : firu_posting_date_to

CREATE VIEW C_RU_ExchDiff AS
SELECT
  _Sum.CompanyCode AS CompanyCode,
  _Sum.AccountingDocument AS AccountingDocument,
  _Sum.FiscalYear AS FiscalYear,
  _Sum.AccountingDocumentItem AS AccountingDocumentItem,
  _Sum.ControllingAreaCurrencyRole AS ControllingAreaCurrencyRole,
  _Sum.ActiveValuationArea AS ActiveValuationArea,
  0.0 AS EndingBalanceAmtInCoCodeCrcy,
  _Sum.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Sum.FrgnCrcyValnDeltaLogicIsActive AS FrgnCrcyValnDeltaLogicIsActive,
  _Sum.AssignmentReference AS AssignmentReference,
  _Sum.Creditor AS Creditor,
  _Sum.Debtor AS Debtor,
  _Sum.BusinessPartner AS BusinessPartner,
  _Sum.PostingDate AS PostingDate,
  _Sum.CndnContrType AS CndnContrType,
  _Sum.AuthorizationGroup AS AuthorizationGroup,
  _Sum.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  _Sum.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  CustomerCompany.AuthorizationGroup AS CustomerCompanyAuthznGroup,
  BusinessPartner.DataControllerSet AS DataControllerSet,
  BusinessPartner.DataController1 AS DataController1,
  BusinessPartner.DataController2 AS DataController2,
  BusinessPartner.DataController3 AS DataController3,
  BusinessPartner.DataController4 AS DataController4,
  BusinessPartner.DataController5 AS DataController5,
  BusinessPartner.DataController6 AS DataController6,
  BusinessPartner.DataController7 AS DataController7,
  BusinessPartner.DataController8 AS DataController8,
  BusinessPartner.DataController9 AS DataController9,
  0.0 AS StartingBalanceAmtInCoCodeCrcy,
  BusinessPartner.DataController10 AS DataController10
FROM P_RU_ExchDiff1 AS _Sum
-- UNION with additional select branch(es): P_RU_ExchDiff1
;

Depth:

C_RU_ExchDiff view

P_RU_ExchDiff1 view
P_RU_ExchDiff1 view