C_FrgnCrcyValnRunRsltListItm

DDL: C_FRGNCRCYVALNRUNRSLTLISTITM Type: view_entity CONSUMPTION Package: FINS_FI_CLS_FXV_UI
53 Fields 1 Data Sources 2 Associations 2 OData Services

Financial Closing Run Result Item

C_FrgnCrcyValnRunRsltListItm is a Consumption CDS View that provides data about "Financial Closing Run Result Item" in SAP S/4HANA. It reads from 1 data source (R_FrgnCrcyValnRunRsltListItm) and exposes 53 fields with key fields JrnlPerdEndClsgRunResultUUID, SourceCurrencyRole, TargetCurrencyRole. It has 2 associations to related views. It is exposed through 2 OData services (FINANCIAL_CLOSING_RUN, X_RFCV_UI_GLCLOSINGRUN). Part of development package FINS_FI_CLS_FXV_UI.

Data Sources (1)

SourceAliasJoin Type
R_FrgnCrcyValnRunRsltListItm R_FrgnCrcyValnRunRsltListItm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Financial Closing Run Result Item view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
FINANCIAL_CLOSING_RUN
X_RFCV_UI_GLCLOSINGRUN

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY JrnlPerdEndClsgRunResultUUID JrnlPerdEndClsgRunResultUUID Result List UUID
KEY SourceCurrencyRole SourceCurrencyRole
KEY TargetCurrencyRole TargetCurrencyRole
CompanyCode CompanyCode Receiver Company Code
Ledger Ledger Ledger
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
IsReversed IsReversed Reversed?
GLAccount GLAccount General Ledger
IsOpenItemManaged IsOpenItemManaged Open Item Management
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingDate ClearingDate Clearing Date
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear Predecessor Journal Entry Fiscal Year
PredecessorJournalEntry PredecessorJournalEntry Predecessor Journal Entry
PredecessorJournalEntryItem PredecessorJournalEntryItem Predecessor Journal Entry Item
NetDueDate NetDueDate Net Due Date
FinancialClosingRunUUID FinancialClosingRunUUID Closing Run UUID
FinancialClosingGrouping FinancialClosingGrouping
FinancialClosingValuationRule FinancialClosingValuationRule
FinClosingValuationRuleStep FinClosingValuationRuleStep
OffsettingAccount OffsettingAccount Offsetting Acct
Customer Customer Sold-to Party
Supplier Supplier Supplier
FinClsgRunResultObjectStatus FinClsgRunResultObjectStatus
ChartOfAccounts ChartOfAccounts Node Class
AmountInSourceCurrency AmountInSourceCurrency
SourceCurrency SourceCurrency
EffectiveKeyDateExchangeRate EffectiveKeyDateExchangeRate
ValuatedAmountInTargetCurrency ValuatedAmountInTargetCurrency
PrevPerdsDeltaAmtInTgtCrcy PrevPerdsDeltaAmtInTgtCrcy
RecalculatedAmountInTargetCrcy RecalculatedAmountInTargetCrcy
PostedDeltaAmtInTargetCurrency PostedDeltaAmtInTargetCurrency
CurPerdPostdAmountInTgtCrcy CurPerdPostdAmountInTgtCrcy
CalcdDeltaAmtInTargetCurrency CalcdDeltaAmtInTargetCurrency
TargetCurrency TargetCurrency
_ChartOfAccountsText _ChartOfAccountsText
_GLAccountText _GLAccountText
_SubLedgerAccLineItemTypeT _SubLedgerAccLineItemTypeT
_SourceCurrencyRole _SourceCurrencyRole
_SourceCurrencyRoleText _SourceCurrencyRoleText
_TargetCurrencyRole _TargetCurrencyRole
_TargetCurrencyRoleText _TargetCurrencyRoleText
_FinClsgRunResultObjectStatus _FinClsgRunResultObjectStatus
_FinClsgRunRsltObjStatusText _FinClsgRunRsltObjStatusText
_Supplier _Supplier
_Customer _Customer
_FinClosingRunValuationRule _FinClosingRunValuationRule
_FinClsgRunValuationRuleText _FinClsgRunValuationRuleText
_FrgnCrcyValnRunValnRuleStep _FrgnCrcyValnRunValnRuleStep
_FrgnCrcyValnRunValnRuleStepT _FrgnCrcyValnRunValnRuleStepT

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_FrgnCrcyValnRunRsltListItm.
-- 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_FrgnCrcyValnRunRsltListItm AS
SELECT
  JrnlPerdEndClsgRunResultUUID,
  SourceCurrencyRole,
  TargetCurrencyRole,
  CompanyCode,
  Ledger,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  SubLedgerAcctLineItemType,
  IsReversed,
  GLAccount,
  IsOpenItemManaged,
  ClearingDocFiscalYear,
  ClearingAccountingDocument,
  ClearingDate,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  NetDueDate,
  FinancialClosingRunUUID,
  FinancialClosingGrouping,
  FinancialClosingValuationRule,
  FinClosingValuationRuleStep,
  OffsettingAccount,
  Customer,
  Supplier,
  FinClsgRunResultObjectStatus,
  ChartOfAccounts,
  AmountInSourceCurrency,
  SourceCurrency,
  EffectiveKeyDateExchangeRate,
  ValuatedAmountInTargetCurrency,
  PrevPerdsDeltaAmtInTgtCrcy,
  RecalculatedAmountInTargetCrcy,
  PostedDeltaAmtInTargetCurrency,
  CurPerdPostdAmountInTgtCrcy,
  CalcdDeltaAmtInTargetCurrency,
  TargetCurrency
FROM R_FrgnCrcyValnRunRsltListItm
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More