P_FI_CLS_FXV_RL

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_FI_CLS_FXV_RL.
-- 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_FI_CLS_FXV_RL AS
SELECT
  rl.Ledger AS Ledger,
  rl.CompanyCode AS CompanyCode,
  rl.FiscalYear AS FiscalYear,
  rl.AccountingDocument AS PrimaryKey1,
  rl.LedgerGLLineItem AS PrimaryKey2,
  rl.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  rl.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  cast ( slalittyt.SubLedgerAcctLineItemTypeName as allowancetype ) AS ALLOWANCETYPE,
  cast( concat( concat(rl.FinancialClosingValuationRule, '/' ) ,rl.FinClosingValuationRuleStep) as cls_val_rule_and_step preserving type ) AS ValuationRuleAndStep,
  StatusText.FinClosingLineItemStatusName AS FinClosingLineItemStatusName,
  rl.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  StatusDetailText.FinClsgLineItmDetailStatusName AS FinClsgLineItmDetailStatusName,
  rl.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  rl.GLAccount AS GLAccount,
  cast( _GLAccountText._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountText,
  rl.ChartOfAccounts AS ChartOfAccounts,
  cast ( rl.FinancialClosingGrouping as cls_run_group_id ) AS GROUPID,
  cast ( rl.FinancialClosingGroupingRule as fins_val_grouping_rule ) AS GROUPRULE,
  cast ( rl.FinClosingGroupingRuleStep as fins_val_grouping_rule_step ) AS GROUPRULESTEP,
  rl.NetDueDate AS NetDueDate,
  rl.OldestOpenItemNetDueDate AS OldestOpenItemNetDueDate,
  cast( rl.PredecessorJournalEntry as cls_val_original_journal_entry preserving type ) AS PredecessorJournalEntry,
  cast( rl.PredecessorJournalEntryItem as cls_val_original_journal_item preserving type ) AS PredecessorJournalEntryItem,
  cast( rl.PrdcssrJournalEntryFiscalYear as cls_val_original_fiscal_year preserving type ) AS PrdcssrJournalEntryFiscalYear,
  cast( rl.ClearingDate as cls_val_clearingdate preserving type ) AS ClearingDate,
  cast( rl.ClearingAccountingDocument as cls_val_clearingdoc preserving type ) AS ClearingAccountingDocument,
  cast( rl.ClearingDocFiscalYear as cls_val_clearingyear preserving type ) AS ClearingDocFiscalYear,
  cast( 0 as fagl_hist_rate ) AS OriginalExchangeRate,
  rl.ExchangeRate AS ValuationExchangeRate,
  cast( rl.FinClsgRunRsltFDCrcy1 as fins_currw preserving type ) AS DocumentCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy1 as valuatedamtintgtcrcy preserving type ) AS AmountInDocumentCurrency,
  cast( rl.FinClsgRunRsltFDCrcy1 as fins_currw ) AS SourceCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy1 as valuatedamtintgtcrcy preserving type ) AS AmountInSourceCurrency,
  cast( rl.FinClsgRunRsltFDCrcy2 as targetcurrency ) AS TargetCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy2 as valuatedamtintgtcrcy preserving type ) AS ValuatedAmountInTargetCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy3 as prevperdsdeltaamtintgtcrcy preserving type ) AS PrevPerdsDeltaAmtInTgtCrcy,
  cast( rl.FinClsgRunRsltAmtInFDCrcy4 as recalculatedamountintargetcrcy preserving type ) AS RecalculatedAmountInTargetCrcy,
  cast( rl.FinClsgRunRsltAmtInFDCrcy6 as curperdfxamtintargetcurrency preserving type ) AS CurPerdFxAmtInTargetCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy7 as calcddeltaamtintargetcurrency preserving type ) AS CalcdDeltaAmtInTargetCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy5 as posteddeltaamtintargetcurrency preserving type ) AS PostedDeltaAmtInTargetCurrency,
  cast( rl.FinClsgRunRsltAmtInFDCrcy8 as historicalamount preserving type ) AS HistoricalAmount,
  rl.FinClsgRunRsltFDCrcy1 AS FinClsgRunRsltFDCrcy1,
  rl.FinClsgRunRsltAmtInFDCrcy1 AS FinClsgRunRsltAmtInFDCrcy1,
  rl.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  rl.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  rl.CompanyCodeCurrency AS CompanyCodeCurrency,
  rl.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  rl.GlobalCurrency AS GlobalCurrency,
  rl.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  rl.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  rl.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  rl.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  rl.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  rl.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  rl.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  rl.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  rl.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  rl.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  rl.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  rl.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  rl.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  rl.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  rl.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  rl.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  rl.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  rl.FinancialTransactionType AS FinancialTransactionType,
  rl.ProfitCenter AS ProfitCenter,
  rl.SalesOrder AS SalesOrder,
  rl.SalesOrderItem AS SalesOrderItem,
  _Supplier.SupplierName AS SupplierName,
  rl.Supplier AS Supplier,
  _Customer.CustomerName AS CustomerName,
  rl.Customer AS Customer,
  rl.HouseBank AS HouseBank,
  rl.HouseBankAccount AS HouseBankAccount,
  rl.CostCtrActivityType AS CostCtrActivityType,
  rl.OrderID AS OrderID,
  rl.WBSElementInternalID AS WBSElementInternalID,
  rl.ProjectNetwork AS ProjectNetwork,
  rl.RelatedNetworkActivity AS RelatedNetworkActivity,
  rl.BusinessProcess AS BusinessProcess,
  rl.CostCenter AS CostCenter,
  rl.FunctionalArea AS FunctionalArea,
  rl.BusinessArea AS BusinessArea,
  rl.ControllingArea AS ControllingArea,
  rl.Segment AS Segment,
  rl.PartnerCostCenter AS PartnerCostCenter,
  rl.PartnerProfitCenter AS PartnerProfitCenter,
  rl.PartnerFunctionalArea AS PartnerFunctionalArea,
  rl.PartnerBusinessArea AS PartnerBusinessArea,
  rl.PartnerCompany AS PartnerCompany,
  rl.CostObject AS CostObject,
  rl.PartnerSegment AS PartnerSegment,
  rl.JointVenture AS JointVenture,
  rl.JointVentureEquityGroup AS JointVentureEquityGroup,
  rl.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  rl.JointVenturePartner AS JointVenturePartner,
  rl.PartnerVenture AS PartnerVenture,
  rl.FinancialValuationObjectType AS FinancialValuationObjectType,
  rl.FinancialValuationObject AS FinancialValuationObject,
  rl.FinancialValuationSubobject AS FinancialValuationSubobject,
  rl.OffsettingAccount AS OffsettingAccount,
  rl.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  rl.PostingDate AS PostingDate,
  rl.AccountingDocumentCategory AS AccountingDocumentCategory,
  rl.FiscalPeriod AS FiscalPeriod,
  rl.InvoiceItemReference AS InvoiceItemReference,
  rl.InvoiceReference AS InvoiceReference,
  rl.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  rl.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  rl.FinClosingEntryCalculationType AS FinClosingEntryCalculationType
FROM P_FIVALUATIONRESULTLIST AS rl
LEFT OUTER JOIN I_FinClsgLineItemDetailStatusT AS StatusDetailText ON rl.FinClosingLineItemDetailStatus = StatusDetailText.FinClosingLineItemDetailStatus AND StatusDetailText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_FinClsgGroupingRule AS _GroupingRule ON GROUPRULE = _GroupingRule.FinancialClosingGroupingRule  -- association [0..1]
LEFT OUTER JOIN I_FinClsgGroupingRuleStep AS _GroupingRuleStep ON GROUPRULESTEP = _GroupingRuleStep.FinClosingGroupingRuleStep AND GROUPRULE = _GroupingRuleStep.FinClosingGroupingRuleStep  -- association [0..*]
;