C_FXRunConfigurationRuleStep

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_FXRunConfigurationRuleStep.
-- 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_FXRunConfigurationRuleStep AS
SELECT
  FinancialClosingRunUUID,
  FinClosingValuationRuleStep,
  BusinessTransactionType,
  AccountingDocumentType,
  ExchangeRateType,
  FinClosingValuationMethod,
  FinancialClosingGroupingRule,
  ForeignCrcyRlzdGainGLAccount,
  ForeignCrcyRlzdLossGLAccount,
  ForeignCrcyUnrlzdGainGLAccount,
  ForeignCrcyUnrlzdLossGLAccount
FROM R_FXRunConfigurationRuleStep
LEFT OUTER JOIN R_FrgnCrcyValnRunRsltListItm AS _FinClosingRunResultListItem ON FinancialClosingRunUUID = _FinClosingRunResultListItem.JrnlPerdEndClsgRunResultUUID  -- association [1..*]
LEFT OUTER JOIN R_FrgnCrcyValnRunValnRuleStep AS _FrgnCrcyValnRunValnRuleStep ON FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStep.FinClosingValuationRuleStep  -- association [1..*]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusTransactionTypeText ON BusinessTransactionType = _BusTransactionTypeText.BusinessTransactionType  -- association [1..*]
LEFT OUTER JOIN I_ExchangeRateTypeText AS _ExchangeRateTypeText ON ExchangeRateType = _ExchangeRateTypeText.ExchangeRateType  -- association [1..*]
LEFT OUTER JOIN C_FinClosingRunValuatedAccount AS _FinClosingRunValuatedAccount ON FinancialClosingRunUUID = _FinClosingRunValuatedAccount.FinancialClosingRunUUID AND FinClosingValuationRuleStep = _FinClosingRunValuatedAccount.FinClosingValuationRuleStep  -- association [1..*]
LEFT OUTER JOIN R_FrgnCrcyValnRunValnRuleStepT AS _FrgnCrcyValnRunValnRuleStepT ON FinClosingValuationRuleStep = _FrgnCrcyValnRunValnRuleStepT.FinClosingValuationRuleStep  -- association [1..*]
LEFT OUTER JOIN I_FinClsgGroupingRuleText AS _FinClsgGroupingRuleText ON FinancialClosingGroupingRule = _FinClsgGroupingRuleText.FinancialClosingGroupingRule  -- association [1..*]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [1..*]
LEFT OUTER JOIN R_FinClosingValuationMethodT AS _FinClosingValuationMethodT ON FinClosingValuationMethod = _FinClosingValuationMethodT.FinClosingValuationMethod  -- association [1..*]
;