LAW3D_SYSTEM

Transparent Table Application Table
33 Fields 1 CDS Views

LAW 3.0 system table

LAW3D_SYSTEM is an SAP database table in S/4HANA. LAW 3.0 system table. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
LAW3_UI_SYSTEM_I view from LAW3.0 System

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY systemguid GUID GUID
systemno LAW2_SYSTEMNO System Number
custno LAW2_CUSTNUMBER Customer Number
sysid SYSYSID SAP System ID
instno LAW2_INSTNUMBER Inst. Number
uisystemid LAW2_SYSTEM_ID LAW System ID
description LAW2_DESCRIPTION Description
language LANGU Language
useddatabase LAW2_USEDDATABASE Database Sys.
saprelease LAW2_SYSTEM_RELEASE SAP Release
sysstatus LAW2_MEASPLAN_SYSSTAT_XML System Status
systemprod LAW2_SYS_PRODUCT System Product
systempvers LAW2_SYS_PRODUCT_VERSION Product Version
rfcdestination RFCDEST Destination
rslawplugin PROGRAMM Program Name
systemcdate LAW2_SYS_CREATION_DATE Created On
measurestatus LAW3_MEASURESTATUS_VALUE Measure Status
nomeasurereason LAW2_NOMEASURE_REASON_VALUE Non-Meas. Reas.
nomeasureremark LAW2_NOMEASURE_REASON_REMARK Comment Not Meas.
contractnumber LAW2_VBELN Contract Number
instlocation LAW2_CITY Location
instcontact LAW2_CONTACTPERSON Contact Person
localsystem LAW2_LOCAL_SYSTEM_FLAG
extsystemflag LAW2_EXTERNAL_SYSTEM_FLAG External System
extsystemid LAW2_EXTERNAL_SYSTEM_ID Ext. Syst. ID
hanasystemflag LAW3_HANA_SYSTEM_FLAG External System
crname LAW2_CREATE_USERNAME Created By
crdate LAW2_CREATE_DATE Created On
crtime LAW2_CREATE_TIME Creation Time
chname LAW2_CHANGE_USERNAME Changed by
chdate LAW2_CHANGE_DATE Changed On
chtime LAW2_CHANGE_TIME Changed At

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 system table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW3D_SYSTEM (
    MANDT,            -- Client [MANDT]
    SYSTEMGUID,       -- GUID [GUID]
    SYSTEMNO,         -- System Number [LAW2_SYSTEMNO]
    CUSTNO,           -- Customer Number [LAW2_CUSTNUMBER]
    SYSID,            -- SAP System ID [SYSYSID]
    INSTNO,           -- Inst. Number [LAW2_INSTNUMBER]
    UISYSTEMID,       -- LAW System ID [LAW2_SYSTEM_ID]
    DESCRIPTION,      -- Description [LAW2_DESCRIPTION]
    LANGUAGE,         -- Language [LANGU]
    USEDDATABASE,     -- Database Sys. [LAW2_USEDDATABASE]
    SAPRELEASE,       -- SAP Release [LAW2_SYSTEM_RELEASE]
    SYSSTATUS,        -- System Status [LAW2_MEASPLAN_SYSSTAT_XML]
    SYSTEMPROD,       -- System Product [LAW2_SYS_PRODUCT]
    SYSTEMPVERS,      -- Product Version [LAW2_SYS_PRODUCT_VERSION]
    RFCDESTINATION,   -- Destination [RFCDEST]
    RSLAWPLUGIN,      -- Program Name [PROGRAMM]
    SYSTEMCDATE,      -- Created On [LAW2_SYS_CREATION_DATE]
    MEASURESTATUS,    -- Measure Status [LAW3_MEASURESTATUS_VALUE]
    NOMEASUREREASON,  -- Non-Meas. Reas. [LAW2_NOMEASURE_REASON_VALUE]
    NOMEASUREREMARK,  -- Comment Not Meas. [LAW2_NOMEASURE_REASON_REMARK]
    CONTRACTNUMBER,   -- Contract Number [LAW2_VBELN]
    INSTLOCATION,     -- Location [LAW2_CITY]
    INSTCONTACT,      -- Contact Person [LAW2_CONTACTPERSON]
    LOCALSYSTEM,      -- LAW2_LOCAL_SYSTEM_FLAG
    EXTSYSTEMFLAG,    -- External System [LAW2_EXTERNAL_SYSTEM_FLAG]
    EXTSYSTEMID,      -- Ext. Syst. ID [LAW2_EXTERNAL_SYSTEM_ID]
    HANASYSTEMFLAG,   -- External System [LAW3_HANA_SYSTEM_FLAG]
    CRNAME,           -- Created By [LAW2_CREATE_USERNAME]
    CRDATE,           -- Created On [LAW2_CREATE_DATE]
    CRTIME,           -- Creation Time [LAW2_CREATE_TIME]
    CHNAME,           -- Changed by [LAW2_CHANGE_USERNAME]
    CHDATE,           -- Changed On [LAW2_CHANGE_DATE]
    CHTIME,           -- Changed At [LAW2_CHANGE_TIME]
    PRIMARY KEY (MANDT, SYSTEMGUID)
);

Learn More