P_FI_CLS_IMP_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_IMP_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_IMP_RL AS
SELECT
  JrnlPerdEndClsgRunResultUUID,
  rl.Ledger AS Ledger,
  rl.CompanyCode AS CompanyCode,
  rl.FiscalYear AS FiscalYear,
  cast ( _slalittyt.SubLedgerAcctLineItemTypeName as allowancetype ) AS ALLOWANCETYPE,
  JrnlPeriodEndClosingRunLogUUID,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  cast ( FinClsgRunRsltFDCrcy1 as targetcurrency preserving type ) AS Currency,
  FinancialTransactionType,
  ProfitCenter,
  SalesOrder,
  SalesOrderItem,
  _Supplier.SupplierName AS SupplierName,
  rl.Supplier AS Supplier,
  rl.Customer AS Customer,
  _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  cast ( _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner as bpid ) AS BusinessPartnerID,
  cast ( _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName as bpname ) AS BUSINESSPARTNERNAME,
  HouseBank,
  HouseBankAccount,
  CostCtrActivityType,
  OrderID,
  WBSElementInternalID,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  CostObject,
  PartnerSegment,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  PartnerVenture,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  GLAccount,
  OffsettingAccount,
  rl.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  ChartOfAccounts,
  PostingDate,
  AccountingDocumentCategory,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  FiscalPeriod,
  PrdcssrJournalEntryCompanyCode,
  cast( PrdcssrJournalEntryFiscalYear as cls_val_original_fiscal_year preserving type ) AS PrdcssrJournalEntryFiscalYear,
  cast( PredecessorJournalEntry as cls_val_original_journal_entry preserving type ) AS PredecessorJournalEntry,
  cast( PredecessorJournalEntryItem as cls_val_original_journal_item preserving type ) AS PredecessorJournalEntryItem,
  InvoiceItemReference,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  AccountingDocumentItem,
  FinClsgRunRsltFDCrcy1,
  FinClsgRunRsltFDCrcy2,
  ExchangeRate,
  FinClosingRunIsTestExecution,
  FinancialClosingLineItemType,
  FinClosingLineItemDetailStatus,
  cast ( FinancialClosingGrouping as cls_run_group_id preserving type ) AS GROUPID,
  StatusDetailText.FinClsgLineItmDetailStatusName AS FinClsgLineItmDetailStatusName,
  cast ( FinancialClosingGroupingRule as fins_val_grouping_rule preserving type ) AS GROUPRULE,
  rl.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  cast ( FinClosingGroupingRuleStep as fins_val_grouping_rule_step preserving type ) AS GROUPRULESTEP,
  cast( concat( concat(rl.FinancialClosingValuationRule, '/' ) ,rl.FinClosingValuationRuleStep) as cls_val_rule_and_step preserving type ) AS ValuationRuleAndStep,
  FinClosingEntryCalculationType,
  cast( rl.CreditRiskClass as cls_val_risk_class preserving type ) AS CreditRiskClass,
  GeneralLedgerAgingIncrement,
  cast ( GeneralLedgerAgingIncrement as cls_run_valn_agincrmt ) AS AGINGINCREMENT,
  cast ( ' ' as fins_imp_aging ) AS agingscope,
  ExpectedCreditLossPercent,
  cast( ExpectedCreditLossPercent as fins_imp_probability_of_deflt preserving type ) AS ProbabilityOfDefault,
  cast( FinClsgRunRsltAmtInFDCrcy3 as val_amount preserving type ) AS AmountInTargetCurrency,
  cast ( FinClsgRunRsltAmtInFDCrcy2 as cummulatedlossallowance preserving type ) AS CummulatedLossAllowance,
  cast ( FinClsgRunRsltAmtInFDCrcy1 as prepostlossallowance preserving type ) AS PrePostLossAllowance,
  cast ( FinClsgRunRsltAmtInFDCrcy4 as lossallowancetobeposted preserving type ) AS LOSSALLOWANCETOBEPOSTED,
  NetDueDate
FROM P_FIVALUATIONRESULTLIST 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_FinClsgLineItemDetailStatusT AS StatusDetailText ON rl.FinClosingLineItemDetailStatus = StatusDetailText.FinClosingLineItemDetailStatus AND StatusDetailText.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_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..*]
LEFT OUTER JOIN I_LossAllowanceAgingIncrementT AS _AgingIncrement ON agingscope = _AgingIncrement.GeneralLedgerAgingScope AND AGINGINCREMENT = _AgingIncrement.GeneralLedgerAgingIncrement  -- association [0..*]
;