VLCHISTORY

Transparent Table Application Table
16 Fields 2 CDS Views

VELO : Vehicle History

VLCHISTORY is an SAP database table in S/4HANA. VELO : Vehicle History. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_VMSVehicleHistory view from EXTENSION Vehicle History Extension
I_VMSVehicleHistory view from BASIC View for Vehicle History

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vguid vlc_guid Vehicle GUID
KEY tstmp vlc_ltstamp Time Stamp
actdoctype vlc_actdoctype Action Document Type
cuobj cuobj Int. object no.
vaction vlc_vaction Interlink. Actn
action vlc_action Action
mmctr vlc_cntrl Action Control
mmsta_old vlc_mmstatu Primary Status
mmsta_new vlc_mmstatu Primary Status
sdctr vlc_cntrl Action Control
sdsta_old vlc_mmstatu Primary Status
sdsta_new vlc_mmstatu Primary Status
loctn vlc_loctn Vehicle Location
kunnr vlc_kunnr Customer
ernam ernam Created By

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.

-- VELO : Vehicle History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VLCHISTORY (
    MANDT,       -- Client [mandt]
    VGUID,       -- Vehicle GUID [vlc_guid]
    TSTMP,       -- Time Stamp [vlc_ltstamp]
    ACTDOCTYPE,  -- Action Document Type [vlc_actdoctype]
    CUOBJ,       -- Int. object no. [cuobj]
    VACTION,     -- Interlink. Actn [vlc_vaction]
    ACTION,      -- Action [vlc_action]
    MMCTR,       -- Action Control [vlc_cntrl]
    MMSTA_OLD,   -- Primary Status [vlc_mmstatu]
    MMSTA_NEW,   -- Primary Status [vlc_mmstatu]
    SDCTR,       -- Action Control [vlc_cntrl]
    SDSTA_OLD,   -- Primary Status [vlc_mmstatu]
    SDSTA_NEW,   -- Primary Status [vlc_mmstatu]
    LOCTN,       -- Vehicle Location [vlc_loctn]
    KUNNR,       -- Customer [vlc_kunnr]
    ERNAM,       -- Created By [ernam]
    PRIMARY KEY (MANDT, VGUID, TSTMP)
);

Learn More