A_VMSVehicleToEquipment

DDL: A_VMSVEHICLETOEQUIPMENT SQL: AVMSVEHTOEQ Type: view COMPOSITE Package: ISAUTO_VLC_DB
17 Fields 2 Data Sources 1 OData Services

Vehicle to Equipment Mapping

A_VMSVehicleToEquipment is a Composite CDS View that provides data about "Vehicle to Equipment Mapping" in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, I_VMSVehicleToEquipment) and exposes 17 fields with key fields VMSVehicleEquipmentTemplate, MyObjectID, VMSVehicleAttributeGroup, VMSVehicleAttribute, InstalledBaseComponent. It is exposed through 1 OData service (API_VMSVEHICLE). Part of development package ISAUTO_VLC_DB.

Data Sources (2)

SourceAliasJoin Type
I_SAPClient _SAPClient inner
I_VMSVehicleToEquipment I_VMSVehicleToEquipment from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AVMSVEHTOEQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle to Equipment Mapping view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_VMSVEHICLE API_VMSVEHICLE V2 C2 C1

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleEquipmentTemplate VMSVehicleEquipmentTemplate
KEY MyObjectID MyObjectID UUID 22 char.
KEY VMSVehicleAttributeGroup VMSVehicleAttributeGroup
KEY VMSVehicleAttribute VMSVehicleAttribute
KEY InstalledBaseComponent InstalledBaseComponent
KEY ClfnObjectID
KEY Characteristic Characteristic Field Name
CharcFromNumericValue CharcFromNumericValue Value from
CharcValue CharcValue Char. Value
Currency Currency Valuation Crcy
CharcDecimals CharcDecimals Decimal Places
CharcDataType CharcDataType Format
CharcLength CharcLength Number of Chars
CharcValueUnit CharcValueUnit Internal UoM
Class Class User Group
ClassType ClassType X Flag
LogicalSystem I_SAPClient LogicalSystem Logical System

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 A_VMSVehicleToEquipment.
-- 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: AVMSVEHTOEQ

CREATE VIEW A_VMSVehicleToEquipment AS
SELECT
  VMSVehicleEquipmentTemplate,
  MyObjectID,
  VMSVehicleAttributeGroup,
  VMSVehicleAttribute,
  InstalledBaseComponent,
  cast(ClfnObjectID as abap.char(40)) AS ClfnObjectID,
  Characteristic,
  CharcFromNumericValue,
  CharcValue,
  Currency,
  CharcDecimals,
  CharcDataType,
  CharcLength,
  CharcValueUnit,
  Class,
  ClassType,
  _SAPClient.LogicalSystem AS LogicalSystem
FROM I_VMSVehicleToEquipment
INNER JOIN I_SAPClient AS _SAPClient ON /* join condition not captured in parsed metadata */
;

Learn More