P_RU_ExchDiff1

DDL: P_RU_EXCHDIFF1 SQL: PRUEXCHDIFF1 Type: view CONSUMPTION Package: GLO_FIN_IS_RU
20 Fields 1 Data Sources 2 Associations

Unrealized exchange differences

P_RU_ExchDiff1 is a Consumption CDS View that provides data about "Unrealized exchange differences" in SAP S/4HANA. It reads from 1 data source (P_ValnHistForDocs) and exposes 20 fields. It has 2 associations to related views. Part of development package GLO_FIN_IS_RU.

Data Sources (1)

SourceAliasJoin Type
P_ValnHistForDocs UnrealizedExchDiff from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_FIDeprArea _DeprArea $projection.ActiveValuationArea = _DeprArea.ActiveValuationArea and $projection.ControllingAreaCurrencyRole = _DeprArea.ControllingAreaCurrencyRole
[1..1] P_RU_ExchDiff0 _Financial $projection.CompanyCode = _Financial.CompanyCode and $projection.AccountingDocument = _Financial.AccountingDocument and $projection.FiscalYear = _Financial.FiscalYear and $projection.AccountingDocumentItem = _Financial.AccountingDocumentItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRUEXCHDIFF1 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED 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

Fields (20)

KeyFieldSource TableSource FieldDescription
CompanyCode P_ValnHistForDocs CompanyCode Receiver Company Code
AccountingDocument P_ValnHistForDocs AccountingDocument Journal Entry
FiscalYear P_ValnHistForDocs FiscalYear G/L Fiscal Year
AccountingDocumentItem P_ValnHistForDocs AccountingDocumentItem Posting View Item
ControllingAreaCurrencyRole P_ValnHistForDocs ControllingAreaCurrencyRole Valuation Area
ActiveValuationArea P_ValnHistForDocs ActiveValuationArea Valuation area
EvaluationKeyDate P_ValnHistForDocs EvaluationKeyDate Valid to
CompanyCodeCurrency _Financial CompanyCodeCurrency Local Currency
FrgnCrcyValnDeltaLogicIsActive _DeprArea FrgnCrcyValnDeltaLogicIsActive
AssignmentReference _Financial AssignmentReference Assignment Reference
Creditor _Financial Creditor Supplier
Debtor _Financial Debtor Debtor
BusinessPartner _Financial Partner With Partner
PostingDate _Financial PostingDate Posting Date for GR
CndnContrType _Financial CndnContrType Contract Type
AuthorizationGroup _Financial AuthorizationGroup AuthorizGroup
CustomerAccountGroup _Financial CustomerAccountGroup Account group
CustomerFinsAuthorizationGrp _Financial CustomerFinsAuthorizationGrp
SupplierAccountGroup _Financial SupplierAccountGroup Account group
SupplierFinsAuthorizationGrp _Financial SupplierFinsAuthorizationGrp

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 P_RU_ExchDiff1.
-- 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: PRUEXCHDIFF1

CREATE VIEW P_RU_ExchDiff1 AS
SELECT
  UnrealizedExchDiff.CompanyCode AS CompanyCode,
  UnrealizedExchDiff.AccountingDocument AS AccountingDocument,
  UnrealizedExchDiff.FiscalYear AS FiscalYear,
  UnrealizedExchDiff.AccountingDocumentItem AS AccountingDocumentItem,
  UnrealizedExchDiff.ControllingAreaCurrencyRole AS ControllingAreaCurrencyRole,
  UnrealizedExchDiff.ActiveValuationArea AS ActiveValuationArea,
  UnrealizedExchDiff.EvaluationKeyDate AS EvaluationKeyDate,
  _Financial.CompanyCodeCurrency AS CompanyCodeCurrency,
  _DeprArea.FrgnCrcyValnDeltaLogicIsActive AS FrgnCrcyValnDeltaLogicIsActive,
  _Financial.AssignmentReference AS AssignmentReference,
  _Financial.Creditor AS Creditor,
  _Financial.Debtor AS Debtor,
  _Financial.Partner AS BusinessPartner,
  _Financial.PostingDate AS PostingDate,
  _Financial.CndnContrType AS CndnContrType,
  _Financial.AuthorizationGroup AS AuthorizationGroup,
  _Financial.CustomerAccountGroup AS CustomerAccountGroup,
  _Financial.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  _Financial.SupplierAccountGroup AS SupplierAccountGroup,
  _Financial.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp
FROM P_ValnHistForDocs AS UnrealizedExchDiff
LEFT OUTER JOIN P_FIDeprArea AS _DeprArea ON ActiveValuationArea = _DeprArea.ActiveValuationArea AND ControllingAreaCurrencyRole = _DeprArea.ControllingAreaCurrencyRole  -- association [0..1]
LEFT OUTER JOIN P_RU_ExchDiff0 AS _Financial ON CompanyCode = _Financial.CompanyCode AND AccountingDocument = _Financial.AccountingDocument AND FiscalYear = _Financial.FiscalYear AND AccountingDocumentItem = _Financial.AccountingDocumentItem  -- association [1..1]
;

Learn More