C_BhvrlInsgtsOverviewFilter

DDL: C_BHVRLINSGTSOVERVIEWFILTER SQL: CBEIOVPFIL Type: view CONSUMPTION

Overview Page Filter

C_BhvrlInsgtsOverviewFilter is a Consumption CDS View that provides data about "Overview Page Filter" in SAP S/4HANA. It reads from 1 data source (I_BhvrlInsgtsOverviewFilter) and exposes 21 fields with key field BhvrlInsgtsRecordID. It is exposed through 1 OData service (UI_RSKCUSTOVW_ANA). It is used in 1 Fiori application: At-Risk Customers Overview.

Data Sources (1)

SourceAliasJoin Type
I_BhvrlInsgtsOverviewFilter I_BhvrlInsgtsOverviewFilter from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBEIOVPFIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
EndUserText.label Overview Page Filter view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RSKCUSTOVW_ANA UI_RSKCUSTOVW_ANA V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6601 At-Risk Customers Overview Analytical An app that provides an overview of the predicted risk scores, different collection strategies and overview of ML-generated customer groups.

At-Risk Customers Overview

Business Role: Accounts Receivable Manager - Public Sector

In SAP S/4HANA for behavioral insights (abbreviated to: Behavioral Insights), you can use the SAP Fiori app, At-risk Customers Overview, to analyze scenario trends, collections success, and intelligent clusters of customers. Multiple filters and analytic cards can be used to see details about Behavioral Insights" machine learning scenarios, risk scores, and risk reasons for various groupings of business partners including the following: Scenario analytics showing trends and explanations within each ML scenario Success tracking showing success of collections strategies and steps Clustering or intelligent grouping of customers based on risk and reasons You can drill down from any analytic card to the SAP Fiori app, Explore At-Risk Customers, for further analysis.For more information, see At-Risk Customers Overview.

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BhvrlInsgtsRecordID BhvrlInsgtsRecordID
PredictionScenarioID PredictionScenarioID
ScenarioName ScenarioName
BusinessPartner BusinessPartner Issuing Authority
BhvrlInsgtsAccountNumber BhvrlInsgtsAccountNumber
BhvrlInsgtsSubAccountNumber BhvrlInsgtsSubAccountNumber
DebtAmountInLocalCurrency DebtAmountInLocalCurrency
LocalCurrency LocalCurrency Local Currency
DebtAmountCategory DebtAmountCategory
DebtAmountCategoryText DebtAmountCategoryText
RiskScoreValue RiskScoreValue
RiskTrendValue RiskTrendValue
RiskScoreCategory RiskScoreCategory
RiskScoreCategoryText RiskScoreCategoryText
PredictionScenarioDate PredictionScenarioDate
BhvrlInsgtsReasonCodeName BhvrlInsgtsReasonCodeName
CACollectionStrategy CACollectionStrategy Coll. Strategy
CACollectionStep CACollectionStep
CACollectionStrategyName CACollectionStrategyName
CACollectionStepName CACollectionStepName
NrOfCustomerPerScenario NrOfCustomerPerScenario

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 C_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: CBEIOVPFIL

CREATE VIEW C_BhvrlInsgtsOverviewFilter AS
SELECT
  BhvrlInsgtsRecordID,
  PredictionScenarioID,
  ScenarioName,
  BusinessPartner,
  BhvrlInsgtsAccountNumber,
  BhvrlInsgtsSubAccountNumber,
  DebtAmountInLocalCurrency,
  LocalCurrency,
  DebtAmountCategory,
  DebtAmountCategoryText,
  RiskScoreValue,
  RiskTrendValue,
  RiskScoreCategory,
  RiskScoreCategoryText,
  PredictionScenarioDate,
  BhvrlInsgtsReasonCodeName,
  CACollectionStrategy,
  CACollectionStep,
  CACollectionStrategyName,
  CACollectionStepName,
  NrOfCustomerPerScenario
FROM I_BhvrlInsgtsOverviewFilter
;