I_VMSVehicleCharacteristic

DDL: I_VMSVEHICLECHARACTERISTIC SQL: IVMSVCHAR Type: view BASIC
16 Fields 8 Data Sources

View for vehicle Characteristics

I_VMSVehicleCharacteristic is a Basic CDS View that provides data about "View for vehicle Characteristics" in SAP S/4HANA. It reads from 8 data sources and exposes 16 fields with key fields ClfnObjectInternalID, ClfnObjectID, InstalledBaseComponent, Characteristic, CharcValue.

Data Sources (8)

SourceAliasJoin Type
I_ClfnClass _ClassHeader inner
I_ClfnCharcBasic _ClfnCharcBasic inner
I_ClfnClassCharcBasic _ClfnClassCharcBasic inner
I_ClfnClassHierarchy _ClfnClassHierarchy inner
I_ClfnInternalIdObjectMapping _ClfnInternalIdObjectMapping from
I_ClfnObjectClassBasic _ClfnObjectClassBasic inner
P_IBaseSymbol _IBaseSymbol inner
P_IBaseValue _IBaseValue inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IVMSVCHAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for vehicle Characteristics view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectInternalID I_ClfnInternalIdObjectMapping ClfnObjectInternalID Object Number
KEY ClfnObjectID I_ClfnInternalIdObjectMapping ClfnObjectID Object
KEY InstalledBaseComponent _IBaseInstance InstalledBaseComponent
KEY Characteristic I_ClfnCharcBasic Characteristic Field Name
KEY CharcValue P_IBaseSymbol CharcValue Char. Value
KEY InstalledBaseComponentRecordNo _IBaseInstance InstalledBaseComponentRecordNo Record number
KEY CharcInternalID P_IBaseSymbol CharcInternalID Characteristic Internal ID
KEY TimeIntervalNumber I_ClfnCharcBasic TimeIntervalNumber Int. counter
KEY CharcFromNumericValue P_IBaseSymbol CharcFromNumericValue Value from
Class I_ClfnClass Class User Group
ClassType I_ClfnClass ClassType X Flag
Currency I_ClfnCharcBasic Currency Valuation Crcy
CharcLength I_ClfnCharcBasic CharcLength Number of Chars
CharcDataType I_ClfnCharcBasic CharcDataType Format
CharcDecimals I_ClfnCharcBasic CharcDecimals Decimal Places
CharcValueUnit I_ClfnCharcBasic CharcValueUnit Internal UoM

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_VMSVehicleCharacteristic.
-- 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: IVMSVCHAR

CREATE VIEW I_VMSVehicleCharacteristic AS
SELECT
  _ClfnInternalIdObjectMapping.ClfnObjectInternalID AS ClfnObjectInternalID,
  _ClfnInternalIdObjectMapping.ClfnObjectID AS ClfnObjectID,
  _IBaseInstance.InstalledBaseComponent AS InstalledBaseComponent,
  _ClfnCharcBasic.Characteristic AS Characteristic,
  _IBaseSymbol.CharcValue AS CharcValue,
  _IBaseInstance.InstalledBaseComponentRecordNo AS InstalledBaseComponentRecordNo,
  _IBaseSymbol.CharcInternalID AS CharcInternalID,
  _ClfnCharcBasic.TimeIntervalNumber AS TimeIntervalNumber,
  _IBaseSymbol.CharcFromNumericValue AS CharcFromNumericValue,
  _ClassHeader.Class AS Class,
  _ClassHeader.ClassType AS ClassType,
  _ClfnCharcBasic.Currency AS Currency,
  _ClfnCharcBasic.CharcLength AS CharcLength,
  _ClfnCharcBasic.CharcDataType AS CharcDataType,
  _ClfnCharcBasic.CharcDecimals AS CharcDecimals,
  _ClfnCharcBasic.CharcValueUnit AS CharcValueUnit
FROM I_ClfnInternalIdObjectMapping AS _ClfnInternalIdObjectMapping
INNER JOIN I_ClfnObjectClassBasic AS _ClfnObjectClassBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnClassHierarchy AS _ClfnClassHierarchy ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnClass AS _ClassHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnClassCharcBasic AS _ClfnClassCharcBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnCharcBasic AS _ClfnCharcBasic ON /* join condition not captured in parsed metadata */
INNER JOIN P_IBaseSymbol AS _IBaseSymbol ON /* join condition not captured in parsed metadata */
INNER JOIN P_IBaseValue AS _IBaseValue ON /* join condition not captured in parsed metadata */
;

Learn More