C_VMSVehicleCreditExternalIDVH

DDL: C_VMSVEHICLECREDITEXTERNALIDVH Type: view_entity CONSUMPTION
4 Fields 1 Data Sources

VMSVehicle External ID Search Help

C_VMSVehicleCreditExternalIDVH is a Consumption CDS View that provides data about "VMSVehicle External ID Search Help" in SAP S/4HANA. It reads from 1 data source (I_VMSVehicle) and exposes 4 fields with key field VMSVehicleUUID.

Data Sources (1)

SourceAliasJoin Type
I_VMSVehicle I_VMSVehicle from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey VMSVehicleUUID view
VDM.viewType #CONSUMPTION view
EndUserText.label VMSVehicle External ID Search Help view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID VMSVehicleUUID Vehicle GUID
VMSVehicleExternalID VMSVehicleExternalID Ext.Veh.Number
Material Material Vehicle Model
Plant Plant Valuation Area

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_VMSVehicleCreditExternalIDVH.
-- 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.

CREATE VIEW C_VMSVehicleCreditExternalIDVH AS
SELECT
  VMSVehicleUUID,
  VMSVehicleExternalID,
  Material,
  Plant
FROM I_VMSVehicle
;

Learn More