P_ProcessedImpairmentLineItem

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_ProcessedImpairmentLineItem.
-- 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.
-- SQL view name: PPRCIMPLI
-- Parameters: P_Ledger : fis_rldnr, P_CompanyCode : fis_bukrs, P_CurrencyRole : fis_curtp, P_LossAllowanceLayout : fins_key_figure_layout, P_FiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW P_ProcessedImpairmentLineItem AS
SELECT
  LineItems.Ledger AS Ledger,
  LineItems.CompanyCode AS CompanyCode,
  FiscalYear,
  FiscalPeriod,
  Country,
  CreditRiskClass,
  GeneralLedgerAgingIncrement,
  CompanyCodeCurrencyRole,
  GlobalCurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role,
  GLAccount,
  BusinessPartner,
  Customer,
  LossAllowanceSortSequenceValue,
  LossAllowanceKeyFigure,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  SubLedgerAcctLineItemType,
  case when CompanyCodeCurrencyRole = :P_CurrencyRole then cast(AmountInCompanyCodeCurrency as farp_amount_display_crcy preserving type) when GlobalCurrencyRole = :P_CurrencyRole then cast(AmountInGlobalCurrency as farp_amount_display_crcy preserving type) when FreeDefinedCurrency1Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency1 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency2Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency2 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency3Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency3 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency4Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency4 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency5Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency5 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency6Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency6 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency7Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency7 as farp_amount_display_crcy preserving type) when FreeDefinedCurrency8Role = :P_CurrencyRole then cast(AmountInFreeDefinedCurrency8 as farp_amount_display_crcy preserving type) else cast('0' as farp_amount_display_crcy) end as AmountInDisplayCurrency AS P_LedgerasLedger,
  cast(' ' as vdm_v_display_currency) AS DisplayCurrency,
  cast(0 as farp_amount_display_crcy) AS AmountInDisplayCurrency
FROM P_GLACCImpairmentLineItem
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS CurrencyRoles ON /* join condition not captured in parsed metadata */
;