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
  rl.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  rl.Ledger AS Ledger,
  rl.CompanyCode AS CompanyCode,
  rl.FiscalYear AS FiscalYear,
  cast ( _slalittyt.SubLedgerAcctLineItemTypeName as allowancetype ) AS ALLOWANCETYPE,
  rl.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  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,
  cast ( rl.FinClsgRunRsltFDCrcy1 as targetcurrency preserving type ) AS Currency,
  rl.FinancialTransactionType AS FinancialTransactionType,
  rl.ProfitCenter AS ProfitCenter,
  rl.SalesOrder AS SalesOrder,
  rl.SalesOrderItem AS 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,
  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.REBusinessEntity AS REBusinessEntity,
  rl.RealEstateBuilding AS RealEstateBuilding,
  rl.RealEstateProperty AS RealEstateProperty,
  rl.GLAccount AS GLAccount,
  rl.OffsettingAccount AS OffsettingAccount,
  rl.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  rl.ChartOfAccounts AS ChartOfAccounts,
  rl.PostingDate AS PostingDate,
  rl.AccountingDocumentCategory AS AccountingDocumentCategory,
  rl.IsOpenItemManaged AS IsOpenItemManaged,
  rl.ClearingDate AS ClearingDate,
  rl.ClearingAccountingDocument AS ClearingAccountingDocument,
  rl.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  rl.FiscalPeriod AS FiscalPeriod,
  rl.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  cast( rl.PrdcssrJournalEntryFiscalYear as cls_val_original_fiscal_year preserving type ) AS PrdcssrJournalEntryFiscalYear,
  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,
  rl.InvoiceItemReference AS InvoiceItemReference,
  rl.InvoiceReference AS InvoiceReference,
  rl.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  rl.FollowOnDocumentType AS FollowOnDocumentType,
  rl.AccountingDocumentItem AS AccountingDocumentItem,
  rl.FinClsgRunRsltFDCrcy1 AS FinClsgRunRsltFDCrcy1,
  rl.FinClsgRunRsltFDCrcy2 AS FinClsgRunRsltFDCrcy2,
  rl.ExchangeRate AS ExchangeRate,
  rl.FinClosingRunIsTestExecution AS FinClosingRunIsTestExecution,
  rl.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  rl.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  cast ( rl.FinancialClosingGrouping as cls_run_group_id preserving type ) AS GROUPID,
  StatusDetailText.FinClsgLineItmDetailStatusName AS FinClsgLineItmDetailStatusName,
  cast ( rl.FinancialClosingGroupingRule as fins_val_grouping_rule preserving type ) AS GROUPRULE,
  rl.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  cast ( rl.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,
  rl.FinClosingEntryCalculationType AS FinClosingEntryCalculationType,
  cast( rl.CreditRiskClass as cls_val_risk_class preserving type ) AS CreditRiskClass,
  rl.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  cast ( rl.GeneralLedgerAgingScope as fins_imp_aging ) AS agingscope,
  _AgingIncrement.GeneralLedgerAgingIncrmtName AS AGINGINCREMENT,
  rl.ExpectedCreditLossPercent AS ExpectedCreditLossPercent,
  cast( rl.ExpectedCreditLossPercent as fins_imp_probability_of_deflt preserving type ) AS ProbabilityOfDefault,
  cast( rl.FinClsgRunRsltAmtInFDCrcy3 as val_amount preserving type ) AS AmountInTargetCurrency,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy2 as cummulatedlossallowance preserving type ) AS CummulatedLossAllowance,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy1 as prepostlossallowance preserving type ) AS PrePostLossAllowance,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy4 as lossallowancetobeposted preserving type ) AS LOSSALLOWANCETOBEPOSTED,
  rl.NetDueDate AS NetDueDate
FROM P_FIVALUATIONRESULTLIST AS rl
;