I_IBaseCharcValue_2

DDL: I_IBASECHARCVALUE_2 SQL: IIBASECSTVAL2 Type: view BASIC
19 Fields 1 Data Sources

Installed Base Characteristic Value

I_IBaseCharcValue_2 is a Basic CDS View that provides data about "Installed Base Characteristic Value" in SAP S/4HANA. It reads from 1 data source (P_IBaseValueCombined) and exposes 19 fields with key fields InstalledBaseComponentRecordNo, VariantConfigurationValueID, CharcInternalID.

Data Sources (1)

SourceAliasJoin Type
P_IBaseValueCombined P_IBaseValueCombined from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IIBASECSTVAL2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private false view
VDM.viewType #BASIC view
EndUserText.label Installed Base Characteristic Value view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InstalledBaseComponentRecordNo InstalledBaseComponentRecordNo
KEY VariantConfigurationValueID Counter Segment
KEY CharcInternalID CharcInternalID Characteristic Internal ID
CharcValue CharcValue Char. Value
CharcFromNumericValue CharcFromNumericValue Value from
CharcToNumericValue CharcToNumericValue Value to
CharcValueIntervalType CharcValueIntervalType Code
VarConfignValueAssignmentType VarConfignValueAssignmentType
CharcFromNumericValueUnit CharacteristicMinimumValueUnit
CharcToNumericValueUnit CharacteristicMaximumValueUnit
CharcFromDate CharcFromDate LowrBndry Date
CharcToDate CharcToDate UprBndry Date
CharcFromTime CharcFromTime LowrBndry Time
CharcToTime CharcToTime UprBndry Time
CharcFromAmount CharcFromAmount LowrBndry Crcy
CharcToAmount CharcToAmount UprBndry Crcy
CharacteristicCurrency CharacteristicCurrency
CharcFromDecimalValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue CharcToDecimalValue UprBndry Nmrc

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_IBaseCharcValue_2.
-- 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: IIBASECSTVAL2

CREATE VIEW I_IBaseCharcValue_2 AS
SELECT
  InstalledBaseComponentRecordNo,
  cast(in_segmcnt as vdm_cbase_value_id) AS VariantConfigurationValueID,
  CharcInternalID,
  CharcValue,
  CharcFromNumericValue,
  CharcToNumericValue,
  CharcValueIntervalType,
  VarConfignValueAssignmentType,
  CharacteristicMinimumValueUnit AS CharcFromNumericValueUnit,
  CharacteristicMaximumValueUnit AS CharcToNumericValueUnit,
  CharcFromDate,
  CharcToDate,
  CharcFromTime,
  CharcToTime,
  CharcFromAmount,
  CharcToAmount,
  CharacteristicCurrency,
  CharcFromDecimalValue,
  CharcToDecimalValue
FROM P_IBaseValueCombined
;

Learn More