SHSM_VLCVEHICLE2

DDL: SHSM_VLCVEHICLE2 SQL: SHSM_VEHICLE Type: view
41 Fields 1 Data Sources

CDS for search help F4_HELP_VHCLE

SHSM_VLCVEHICLE2 is a CDS View that provides data about "CDS for search help F4_HELP_VHCLE" in SAP S/4HANA. It reads from 1 data source (vlcvehicle2) and exposes 41 fields with key fields mandt, vguid.

Data Sources (1)

SourceAliasJoin Type
vlcvehicle2 vlcvehicle2 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SHSM_VEHICLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS for search help F4_HELP_VHCLE view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY vguid vguid Vehicle GUID
vhcle vhcle Int. Veh. No.
matnr matnr Vehicle Model
lifnr lifnr Vendor no.
charg charg Chargeable Proc.
equnr equnr Equipment
werks werks Receiving Plant
lgort lgort Sublocation
bwtar bwtar Valuation Type
cuobj cuobj Object Number
cuaba cuaba Action Document Type
mmctr mmctr Action Control
mmsta mmsta Primary Status
mmtsp mmtsp Time Stamp
sdctr sdctr Action Control
sdsta sdsta Secondary Status
sdtsp sdtsp Time Stamp
kunnr kunnr Stock customer
endcu endcu End Customer
vhvin vhvin VIN
vhcex vhcex Ext.Veh.Number
avail avail Availability
vblty vblty Visibility
loctn loctn Vehicle Location
gprice gprice Gross List Price
gpricecuky gpricecuky Currency
cdtsp cdtsp Confirmed Date
pstsp pstsp Plnd Delivery Time
pdtsp pdtsp Time of production
ernam ernam User Name
vhusg vhusg Vehicle Usage
cmpgn cmpgn Sales Campaign
pcount pcount Counter reading
pcount_u pcount_u COunter unit
immatdate immatdate Initial Registn.Date
vhsar vhsar Veh.Search Area
vhord vhord Orig. Ord. Pty
shlvl shlvl Sharing Levels
archive_flag archive_flag Archiving
used_vehicle used_vehicle Used Vehicle

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 SHSM_VLCVEHICLE2.
-- 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: SHSM_VEHICLE

CREATE VIEW SHSM_VLCVEHICLE2 AS
SELECT
  mandt,
  vguid,
  vhcle,
  matnr,
  lifnr,
  charg,
  equnr,
  werks,
  lgort,
  bwtar,
  cuobj,
  cuaba,
  mmctr,
  mmsta,
  mmtsp,
  sdctr,
  sdsta,
  sdtsp,
  kunnr,
  endcu,
  vhvin,
  vhcex,
  avail,
  vblty,
  loctn,
  gprice,
  gpricecuky,
  cdtsp,
  pstsp,
  pdtsp,
  ernam,
  vhusg,
  cmpgn,
  pcount,
  pcount_u,
  immatdate,
  vhsar,
  vhord,
  shlvl,
  archive_flag,
  used_vehicle
FROM vlcvehicle2
;

Learn More