/SCMTMS/D_VSSXRD

Transparent Table Application Table
9 Fields 1 CDS Views

Resource Downtimes - #GENERATED#

/SCMTMS/D_VSSXRD is an SAP database table in S/4HANA. Resource Downtimes - #GENERATED#. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VehSchedgResourceDowntime view_entity from BASIC Vehicle Scheduling Resource Downtime

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
vehicle_guid /SCMTMS/PLN_OPT_GUID_VEHICLE Vehicle
loc_guid /SCMTMS/PLN_OPT_GUID_LOC Location
starttime /SCMTMS/PLN_OPT_TST_STARTTIME Start Time
endtime /SCMTMS/PLN_OPT_TST_ENDTIME End Time
downtime_guid /SCMTMS/PLN_OPT_GUID_DOWNTIME Downtime
downid /SCMTMS/PLN_OPT_CHAR_DOWNID Down Document ID

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.

-- Resource Downtimes - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/D_VSSXRD (
    MANDT,          -- Client [MANDT]
    DB_KEY,         -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,     -- NodeID [/BOBF/CONF_KEY]
    VEHICLE_GUID,   -- Vehicle [/SCMTMS/PLN_OPT_GUID_VEHICLE]
    LOC_GUID,       -- Location [/SCMTMS/PLN_OPT_GUID_LOC]
    STARTTIME,      -- Start Time [/SCMTMS/PLN_OPT_TST_STARTTIME]
    ENDTIME,        -- End Time [/SCMTMS/PLN_OPT_TST_ENDTIME]
    DOWNTIME_GUID,  -- Downtime [/SCMTMS/PLN_OPT_GUID_DOWNTIME]
    DOWNID,         -- Down Document ID [/SCMTMS/PLN_OPT_CHAR_DOWNID]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More