LAW3D_USMM_SYST

Transparent Table Application Table
21 Fields 1 CDS Views

LAW 3.0 USMM result systems

LAW3D_USMM_SYST is an SAP database table in S/4HANA. LAW 3.0 USMM result systems. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
LAW3_UI_USMM_SYSTEMS_I view inner LAW3.0 Systems

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY datasetguid GUID GUID
KEY systemguid GUID GUID
systemno LAW2_SYSTEMNO System Number
sysid SYSYSID SAP System ID
instno LAW2_INSTNUMBER Inst. Number
hwkey LAW2_HWKEY Hardware Key
useddatabase SYDBSYS Database system
saprelease LAW2_SYSTEM_RELEASE SAP Release
pricelist LAW2_PRICELIST Pricelist
resultdate LAW2_DATE Date
status LAW2_USMM_MEAS_STATUS Measurment Status
sysstatus LAW2_MEASPLAN_SYSSTAT_XML System Status
measstatus LAW2_STATUS_VALUE Status
measuser LAW2_MEASUSER Measured By
measdate LAW2_MEASDATE Measurement Date
meastime LAW2_MEASTIME Measurement Time
measno RSUVM_MNO Measurement No.
extsystemflag LAW2_EXTERNAL_SYSTEM_FLAG External System
extsystemid LAW2_EXTERNAL_SYSTEM_ID Ext. Syst. ID
hanasystemflag LAW3_HANA_SYSTEM_FLAG External System

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.

-- LAW 3.0 USMM result systems
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW3D_USMM_SYST (
    MANDT,           -- Client [MANDT]
    DATASETGUID,     -- GUID [GUID]
    SYSTEMGUID,      -- GUID [GUID]
    SYSTEMNO,        -- System Number [LAW2_SYSTEMNO]
    SYSID,           -- SAP System ID [SYSYSID]
    INSTNO,          -- Inst. Number [LAW2_INSTNUMBER]
    HWKEY,           -- Hardware Key [LAW2_HWKEY]
    USEDDATABASE,    -- Database system [SYDBSYS]
    SAPRELEASE,      -- SAP Release [LAW2_SYSTEM_RELEASE]
    PRICELIST,       -- Pricelist [LAW2_PRICELIST]
    RESULTDATE,      -- Date [LAW2_DATE]
    STATUS,          -- Measurment Status [LAW2_USMM_MEAS_STATUS]
    SYSSTATUS,       -- System Status [LAW2_MEASPLAN_SYSSTAT_XML]
    MEASSTATUS,      -- Status [LAW2_STATUS_VALUE]
    MEASUSER,        -- Measured By [LAW2_MEASUSER]
    MEASDATE,        -- Measurement Date [LAW2_MEASDATE]
    MEASTIME,        -- Measurement Time [LAW2_MEASTIME]
    MEASNO,          -- Measurement No. [RSUVM_MNO]
    EXTSYSTEMFLAG,   -- External System [LAW2_EXTERNAL_SYSTEM_FLAG]
    EXTSYSTEMID,     -- Ext. Syst. ID [LAW2_EXTERNAL_SYSTEM_ID]
    HANASYSTEMFLAG,  -- External System [LAW3_HANA_SYSTEM_FLAG]
    PRIMARY KEY (MANDT, DATASETGUID, SYSTEMGUID)
);

Learn More