P_FI_CLS_REC_RL_src_documents

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_REC_RL_src_documents.
-- 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_REC_RL_src_documents AS
SELECT
  rl.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  rl.key1 AS key1,
  rl.key2 AS key2,
  rl.PrdcssrPerdEndClsgRunRsltUUID AS PrdcssrPerdEndClsgRunRsltUUID,
  rl.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  rl.OriginalJournalEntry AS OriginalJournalEntry,
  rl.OriginalJournalEntryItem AS OriginalJournalEntryItem,
  rl.GROUPID AS GROUPID,
  rl.ValuationRuleAndStep AS ValuationRuleAndStep,
  rl.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  StatusDetailText.FinClsgLineItmDetailStatusName AS FinClsgLineItmDetailStatusName,
  cast( rl.GLAccount as fins_rec_target_account preserving type ) AS GLAccount,
  cast( rl.OffsettingAccount as fins_rec_source_account preserving type ) AS OffsettingAccount,
  cast(rl.netduedate as cls_rec_netduedate preserving type ) AS netduedate,
  rl.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  rl.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  rl.AccountType AS AccountType,
  cast ( '' as targetcurrency ) AS Currency,
  cast ( 0 as cls_rec_nominal_value ) AS NominalValue,
  cast ( 0 as cls_rec_adjustments ) AS Adjustment,
  cast ( 0 as cls_rec_valuation_adjustments ) AS ValnAdjmtExcludeImprmt,
  cast ( 0 as cls_rec_impairment_adjustments ) AS ImpairmentAdjustment,
  cast( 0 as cls_rec_remaining_amount ) AS RemainingAmount,
  cast ( _slalittyt.SubLedgerAcctLineItemTypeName as cls_rec_val_line_type_text preserving type ) AS ValuationLineType,
  rl.Supplier AS Supplier,
  rl.Customer AS Customer,
  rl.FinClosingRunIsTestExecution AS FinClosingRunIsTestExecution,
  rl.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  rl.GROUPRULE AS GROUPRULE,
  rl.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  rl.GROUPRULESTEP AS GROUPRULESTEP,
  rl.Ledger AS Ledger,
  rl.CompanyCode AS CompanyCode,
  rl.FiscalYear AS FiscalYear,
  rl.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  rl.ChartOfAccounts AS ChartOfAccounts,
  rl.InvoiceItemReference AS InvoiceItemReference,
  rl.InvoiceReference AS InvoiceReference,
  rl.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear
FROM P_FI_CLS_REC_RL_SRC_doc_base AS rl
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _slalittyt ON rl.SubLedgerAcctLineItemType = _slalittyt.SubLedgerAcctLineItemType AND _slalittyt.Language = $session.system_language  -- association [0..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_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..*]
LEFT OUTER JOIN I_FinClsgLineItemDetailStatusT AS StatusDetailText ON rl.FinClosingLineItemDetailStatus = StatusDetailText.FinClosingLineItemDetailStatus AND StatusDetailText.Language = $session.system_language  -- association [0..1]
;