I_VMSVEHICLE

CDS View
12 Fields 11 CDS Views

Vehicle Details

I_VMSVEHICLE is a CDS View in S/4HANA. Vehicle Details. It contains 12 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
A_VMSVehicle view from COMPOSITE Vehicle Details
C_VMSVehicleCreditExternalIDVH view_entity from CONSUMPTION VMSVehicle External ID Search Help
C_VMSVehicleCreditInternalIDVH view_entity from CONSUMPTION VMSVehicle Internal ID Search Help
I_DigitalVehicleConfiguration view_entity from COMPOSITE Digital Vehicle Configuration
I_DigitalVehiclePurOrderItem view_entity from COMPOSITE Vehicle Purchase Order
I_VMSVehicleB2CSalesOrdAssign view_entity inner BASIC VMS Sales Order Assigned details
I_VMSVehicleIncomingInvoice view inner BASIC View for vehicle incoming Invoice
I_VMSVehicleInvoiceBasic view inner BASIC Vehicle Invoice
I_VMSVehicleModVarAvaily view_entity from COMPOSITE Availability of Vehicle model Variant
R_DigitalVehicleTP view_entity from TRANSACTIONAL Digital Vehicle
R_VMSVehicleTP view_entity from TRANSACTIONAL VMS Vehicle Root Details

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ConfigurationNumber ConfigurationNumber 3
KEY VMSVehicleUUID VMSVehicleUUID 4
DigitalVehicleReferenceID DigitalVehicleReferenceID 2
Material Material,VMSVehicleModel 2
Plant Plant 1
StorageLocation StorageLocation 1
VehicleIdentificationNumber VehicleIdentificationNumber 2
VMSVehicleBatch VMSVehicleBatch 5
VMSVehicleInternalID VMSVehicleInternalID 2
VMSVehicleModelVariant VMSVehicleModelVariant 2
VMSVehiclePrimaryStatus VMSVehiclePrimaryStatus 1
VMSVehicleSecondaryStatus VMSVehicleSecondaryStatus 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Vehicle Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_VMSVEHICLE (
    CONFIGURATIONNUMBER,
    VMSVEHICLEUUID,
    DIGITALVEHICLEREFERENCEID,
    MATERIAL,
    PLANT,
    STORAGELOCATION,
    VEHICLEIDENTIFICATIONNUMBER,
    VMSVEHICLEBATCH,
    VMSVEHICLEINTERNALID,
    VMSVEHICLEMODELVARIANT,
    VMSVEHICLEPRIMARYSTATUS,
    VMSVEHICLESECONDARYSTATUS,
    PRIMARY KEY (CONFIGURATIONNUMBER, VMSVEHICLEUUID)
);

Learn More