BSCL_IBSYMBOL_P

DDL: BSCL_IBSYMBOL_P Type: view_entity
19 Fields 3 Data Sources

Used by generated configurationviews

BSCL_IBSYMBOL_P is a CDS View that provides data about "Used by generated configurationviews" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcValForKeyDateTP, ibsymbol, ibinvalues) and exposes 19 fields with key fields symbol_id, in_recno, in_segmcnt.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcValForKeyDateTP I_ClfnCharcValForKeyDateTP left_outer
ibsymbol IBSY inner
ibinvalues IBVL from

Parameters (2)

NameTypeDefault
P_KeyDate sll_validon
P_Language sylangu

Annotations (5)

NameValueLevelField
EndUserText.label Used by generated configurationviews view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY symbol_id ibsymbol symbol_id Symbol ID
KEY in_recno ibinvalues in_recno Record number
KEY in_segmcnt ibinvalues in_segmcnt Counter Segment
CharacteristicInternalID ibsymbol atinn Internal char.
Characteristic charc Characteristic Field Name
CharcValueUnit charc CharcValueUnit Internal UoM
atwrt ibsymbol atwrt Char. Value
CharcValueDescription
atflv ibsymbol atflv Value from
atflb ibsymbol atflb Value to
atcod ibsymbol atcod Interval limits
TargetUnitOfMeasureMinValue ibinvalues msehi_low Internal UoM
TargetUnitOfMeasureMaxValue ibinvalues msehi_high Internal UoM
dec_value_to ibinvalues dec_value_to UprBndry Nmrc
date_from ibinvalues date_from Validity Start Date
date_to ibinvalues date_to Validity End Date
time_from ibinvalues time_from LowrBndry Time
time_to ibinvalues time_to UprBndry Time
currency ibinvalues currency Valuation Crcy

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 BSCL_IBSYMBOL_P.
-- 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.
-- Parameters: P_KeyDate : sll_validon, P_Language : sylangu

CREATE VIEW BSCL_IBSYMBOL_P AS
SELECT
  IBSY.symbol_id AS symbol_id,
  IBVL.in_recno AS in_recno,
  IBVL.in_segmcnt AS in_segmcnt,
  IBSY.atinn AS CharacteristicInternalID,
  charc.Characteristic AS Characteristic,
  charc.CharcValueUnit AS CharcValueUnit,
  IBSY.atwrt AS atwrt,
  charcval._CharcValueDesc( P_KeyDate: $session.system_date )[1:Language = $parameters.P_Language ].CharcValueDescription AS CharcValueDescription,
  IBSY.atflv AS atflv,
  IBSY.atflb AS atflb,
  IBSY.atcod AS atcod,
  IBVL.msehi_low AS TargetUnitOfMeasureMinValue,
  IBVL.msehi_high AS TargetUnitOfMeasureMaxValue,
  IBVL.dec_value_to AS dec_value_to,
  IBVL.date_from AS date_from,
  IBVL.date_to AS date_to,
  IBVL.time_from AS time_from,
  IBVL.time_to AS time_to,
  IBVL.currency AS currency
FROM ibinvalues AS IBVL
INNER JOIN ibsymbol AS IBSY ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnCharcValForKeyDateTP ON /* join condition not captured in parsed metadata */
;

Learn More