LAW2D_USMM_PERS

Transparent Table Application Table
26 Fields 2 CDS Views

LAW 2.0 USMM user results

LAW2D_USMM_PERS is an SAP database table in S/4HANA. LAW 2.0 USMM user results. It contains 26 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
LAW3_UI_USMM_PERS_I view from LAW3.0 User results
LAW3_UI_USMM_USER_TYPES_I view inner LAW3.0 User Types

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY datasetguid GUID GUID
KEY systemguid GUID GUID
KEY partid LAW2_PARTID Part ID
KEY uname LAW2_UNAME User Name
cmandt MANDT Client
sysid SYSYSID SAP System ID
creationdate XUERDAT Created On
lastlogin XULDATE Last Logon Date
firstname LAW2_FIRSTNAME First Name
lastname LAW2_LASTNAME Last Name
phonenumber XUTELNR Telephone no.
emailaddr AD_SMTPADR E-Mail Address
accountid XUACCNT Account no.
classtype XFLAG X Flag
licensetype USERTYPEN User Type ID
versurcharge VERSIONZU Special Version ID
surcharge LAW2_PROZ3 Surcharge
uniquelawguid LAW2_UNIQUE_USER_GUID Unique user GUID
externalid LAW2_EXTERNAL_ID External ID
usertypecombination LAW2_USERCOMBINATION Type Comb.
usertypecons LAW2_USERTYPES User Type ID
chargingsysid SYSYSID SAP System ID
chargingclient MANDT Client
charginguser LAW2_UNAME User Name
kostl XUKOSTL Cost center

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 2.0 USMM user results
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW2D_USMM_PERS (
    MANDT,                -- Client [MANDT]
    DATASETGUID,          -- GUID [GUID]
    SYSTEMGUID,           -- GUID [GUID]
    PARTID,               -- Part ID [LAW2_PARTID]
    UNAME,                -- User Name [LAW2_UNAME]
    CMANDT,               -- Client [MANDT]
    SYSID,                -- SAP System ID [SYSYSID]
    CREATIONDATE,         -- Created On [XUERDAT]
    LASTLOGIN,            -- Last Logon Date [XULDATE]
    FIRSTNAME,            -- First Name [LAW2_FIRSTNAME]
    LASTNAME,             -- Last Name [LAW2_LASTNAME]
    PHONENUMBER,          -- Telephone no. [XUTELNR]
    EMAILADDR,            -- E-Mail Address [AD_SMTPADR]
    ACCOUNTID,            -- Account no. [XUACCNT]
    CLASSTYPE,            -- X Flag [XFLAG]
    LICENSETYPE,          -- User Type ID [USERTYPEN]
    VERSURCHARGE,         -- Special Version ID [VERSIONZU]
    SURCHARGE,            -- Surcharge [LAW2_PROZ3]
    UNIQUELAWGUID,        -- Unique user GUID [LAW2_UNIQUE_USER_GUID]
    EXTERNALID,           -- External ID [LAW2_EXTERNAL_ID]
    USERTYPECOMBINATION,  -- Type Comb. [LAW2_USERCOMBINATION]
    USERTYPECONS,         -- User Type ID [LAW2_USERTYPES]
    CHARGINGSYSID,        -- SAP System ID [SYSYSID]
    CHARGINGCLIENT,       -- Client [MANDT]
    CHARGINGUSER,         -- User Name [LAW2_UNAME]
    KOSTL,                -- Cost center [XUKOSTL]
    PRIMARY KEY (MANDT, DATASETGUID, SYSTEMGUID, PARTID, UNAME)
);

Learn More