P_FXRUNNOTFROM00

DDL: P_FXRUNNOTFROM00 Type: view_entity COMPOSITE
24 Fields 3 Data Sources

P_FXRUNNOTFROM00 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_JrnlPerdEndClsgRunLogResult, R_FinClsgRunResultListAmount, R_FinClsgRunResultListAmount) and exposes 24 fields with key fields JrnlPerdEndClsgRunResultUUID, SourceCurrencyRole, TargetCurrencyRole.

Data Sources (3)

SourceAliasJoin Type
I_JrnlPerdEndClsgRunLogResult resultlist from
R_FinClsgRunResultListAmount SourceCurrency inner
R_FinClsgRunResultListAmount TargetCurrency inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY JrnlPerdEndClsgRunResultUUID I_JrnlPerdEndClsgRunLogResult JrnlPerdEndClsgRunResultUUID Result List UUID
KEY SourceCurrencyRole currencysetting SourceCurrencyRole
KEY TargetCurrencyRole currencysetting TargetCurrencyRole
JrnlPeriodEndClosingRunLogUUID I_JrnlPerdEndClsgRunLogResult JrnlPeriodEndClosingRunLogUUID Closing Run UUID
Ledger I_JrnlPerdEndClsgRunLogResult Ledger Ledger
CompanyCode I_JrnlPerdEndClsgRunLogResult CompanyCode Receiver Company Code
FiscalYear I_JrnlPerdEndClsgRunLogResult FiscalYear G/L Fiscal Year
AccountingDocument I_JrnlPerdEndClsgRunLogResult AccountingDocument Journal Entry
LedgerGLLineItem I_JrnlPerdEndClsgRunLogResult LedgerGLLineItem Journal Entry Item
FinancialClosingLineItemStatus I_JrnlPerdEndClsgRunLogResult FinancialClosingLineItemStatus Status
FinClosingRunIsTestExecution I_JrnlPerdEndClsgRunLogResult FinClosingRunIsTestExecution Test Run
FinancialClosingLineItemType I_JrnlPerdEndClsgRunLogResult FinancialClosingLineItemType Line Item Type
SubLedgerAcctLineItemType I_JrnlPerdEndClsgRunLogResult SubLedgerAcctLineItemType SLALineItemType
FinClosingEntryCalculationType I_JrnlPerdEndClsgRunLogResult FinClosingEntryCalculationType Calc. Line Type
NetDueDate I_JrnlPerdEndClsgRunLogResult NetDueDate Net Due Date
OldestOpenItemNetDueDate I_JrnlPerdEndClsgRunLogResult OldestOpenItemNetDueDate Group Net Due Date
FinancialClosingGroupingRule I_JrnlPerdEndClsgRunLogResult FinancialClosingGroupingRule Obsolete
FinClosingGroupingRuleStep I_JrnlPerdEndClsgRunLogResult FinClosingGroupingRuleStep Step of Grpng Rule
FinancialClosingGrouping I_JrnlPerdEndClsgRunLogResult FinancialClosingGrouping UUID
FinClosingLineItemDetailStatus I_JrnlPerdEndClsgRunLogResult FinClosingLineItemDetailStatus Status Detail
FinancialClosingValuationRule I_JrnlPerdEndClsgRunLogResult FinancialClosingValuationRule Rule
FinClosingValuationRuleStep I_JrnlPerdEndClsgRunLogResult FinClosingValuationRuleStep Rule Step
PrdcssrPerdEndClsgRunRsltUUID I_JrnlPerdEndClsgRunLogResult PrdcssrPerdEndClsgRunRsltUUID Predecessor Result List UUID
EffectiveKeyDateExchangeRate R_FinClsgRunResultListAmount EffectiveKeyDateExchangeRate

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_FXRUNNOTFROM00.
-- 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 P_FXRUNNOTFROM00 AS
SELECT
  resultlist.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  currencysetting.SourceCurrencyRole AS SourceCurrencyRole,
  currencysetting.TargetCurrencyRole AS TargetCurrencyRole,
  resultlist.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  resultlist.Ledger AS Ledger,
  resultlist.CompanyCode AS CompanyCode,
  resultlist.FiscalYear AS FiscalYear,
  resultlist.AccountingDocument AS AccountingDocument,
  resultlist.LedgerGLLineItem AS LedgerGLLineItem,
  resultlist.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  resultlist.FinClosingRunIsTestExecution AS FinClosingRunIsTestExecution,
  resultlist.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  resultlist.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  resultlist.FinClosingEntryCalculationType AS FinClosingEntryCalculationType,
  resultlist.NetDueDate AS NetDueDate,
  resultlist.OldestOpenItemNetDueDate AS OldestOpenItemNetDueDate,
  resultlist.FinancialClosingGroupingRule AS FinancialClosingGroupingRule,
  resultlist.FinClosingGroupingRuleStep AS FinClosingGroupingRuleStep,
  resultlist.FinancialClosingGrouping AS FinancialClosingGrouping,
  resultlist.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  resultlist.FinancialClosingValuationRule AS FinancialClosingValuationRule,
  resultlist.FinClosingValuationRuleStep AS FinClosingValuationRuleStep,
  resultlist.PrdcssrPerdEndClsgRunRsltUUID AS PrdcssrPerdEndClsgRunRsltUUID,
  TargetCurrency.EffectiveKeyDateExchangeRate AS EffectiveKeyDateExchangeRate
FROM I_JrnlPerdEndClsgRunLogResult AS resultlist
INNER JOIN R_FinClsgRunResultListAmount AS SourceCurrency ON /* join condition not captured in parsed metadata */
INNER JOIN R_FinClsgRunResultListAmount AS TargetCurrency ON /* join condition not captured in parsed metadata */
;

Learn More