I_BhvrlInsgtsOverviewFilter

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 I_BhvrlInsgtsOverviewFilter.
-- 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: IBEIOVPFIL

CREATE VIEW I_BhvrlInsgtsOverviewFilter AS
SELECT
  PredRes.PredictionRecordID AS BhvrlInsgtsRecordID,
  LstPrd.PredictionScenarioID AS PredictionScenarioID,
  LstPrd.ScenarioName AS ScenarioName,
  Cust.BusinessPartner AS BusinessPartner,
  PredRes.BhvrlInsgtsAccountNumber AS BhvrlInsgtsAccountNumber,
  PredRes.BhvrlInsgtsSubAccountNumber AS BhvrlInsgtsSubAccountNumber,
  PredRes.DebtAmountInLocalCurrency AS DebtAmountInLocalCurrency,
  PredRes.LocalCurrency AS LocalCurrency,
  PredRes.DebtAmountCategory AS DebtAmountCategory,
  DbtRngeCfgT.RangeCategoryText AS DebtAmountCategoryText,
  PredRes.BhvrlInsgtsPredictionValue AS RiskScoreValue,
  PredRes.RiskTrendValue AS RiskTrendValue,
  PredRes.RiskScoreCategory AS RiskScoreCategory,
  RskRngeCfgT.RangeCategoryText AS RiskScoreCategoryText,
  cast(cast(PredRes.PredictionScenarioDateTime as abap.char(50)) as abap.dats) AS PredictionScenarioDate,
  '' AS BhvrlInsgtsReasonCodeName,
  PredRes.CACollectionStrategy AS CACollectionStrategy,
  PredRes.CACollectionStep AS CACollectionStep,
  case when PredRes.CACollectionStrategy is initial then MsgT.SystemMessageText else CollStgT.CACollectionStrategyName end AS CACollectionStrategyName,
  CollStpT.CACollectionStepName AS CACollectionStepName,
  cast(1 as abap.int4) AS NrOfCustomerPerScenario
FROM I_BhvrlInsgtsPrdtnResult AS PredRes
INNER JOIN I_BhvrlInsgtsLtstPrdtnTime AS LstPrd ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerMasterData AS Cust ON /* join condition not captured in parsed metadata */
;