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