C_BhvrlInsgtsCollStrgy

DDL: C_BHVRLINSGTSCOLLSTRGY SQL: CBEICSPCUS Type: view CONSUMPTION Package: BEI_BASE
14 Fields 1 Data Sources 1 OData Services

Collection Strategy and Step of Customer

C_BhvrlInsgtsCollStrgy is a Consumption CDS View that provides data about "Collection Strategy and Step of Customer" in SAP S/4HANA. It reads from 1 data source (I_BhvrlInsgtsCollStrgy) and exposes 14 fields with key field PredictionRecordID. It is exposed through 1 OData service (UI_RSKCUSTOVW_ANA). Part of development package BEI_BASE.

Data Sources (1)

SourceAliasJoin Type
I_BhvrlInsgtsCollStrgy I_BhvrlInsgtsCollStrgy from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBEICSPCUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Collection Strategy and Step of Customer view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RSKCUSTOVW_ANA UI_RSKCUSTOVW_ANA V2 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PredictionRecordID PredictionRecordID
PredictionScenarioID PredictionScenarioID
PredictionScenarioDate PredictionScenarioDate
BusinessPartner BusinessPartner Issuing Authority
BhvrlInsgtsAccountNumber BhvrlInsgtsAccountNumber
BhvrlInsgtsSubAccountNumber BhvrlInsgtsSubAccountNumber
RiskScoreValue BhvrlInsgtsPredictionValue
DebtAmountInLocalCurrency DebtAmountInLocalCurrency
LocalCurrency LocalCurrency Local Currency
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_BhvrlInsgtsCollStrgy.
-- 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: CBEICSPCUS

CREATE VIEW C_BhvrlInsgtsCollStrgy AS
SELECT
  PredictionRecordID,
  PredictionScenarioID,
  PredictionScenarioDate,
  BusinessPartner,
  BhvrlInsgtsAccountNumber,
  BhvrlInsgtsSubAccountNumber,
  BhvrlInsgtsPredictionValue AS RiskScoreValue,
  DebtAmountInLocalCurrency,
  LocalCurrency,
  CACollectionStrategy,
  CACollectionStep,
  CACollectionStrategyName,
  CACollectionStepName,
  NrOfCustomerPerScenario
FROM I_BhvrlInsgtsCollStrgy
;

Learn More