LAW3_UI_USMM_PERS_I

CDS View

LAW3.0 User results

LAW3_UI_USMM_PERS_I is a CDS View in S/4HANA. LAW3.0 User results. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
LAW3_UI_USMM_USER_CONS_C view from LAW3.0 Information system:User Consolid
LAW3_UI_USMM_USER_I view inner LAW3.0 User

Fields (23)

KeyField CDS FieldsUsed in Views
KEY partid partid 1
KEY systemguid systemguid 1
KEY uname uname 2
accountid accountid 2
chargingclient chargingclient 1
chargingsysid chargingsysid 1
charginguser charginguser 1
classtype classtype 1
cmandt cmandt 1
creationdate creationdate 1
emailaddr emailaddr 2
externalid externalid 1
firstname firstname 2
kostl kostl 1
lastlogin lastlogin 1
lastname lastname 2
licensetype licensetype 2
phonenumber phonenumber 1
surcharge surcharge 1
uniquelawguid uniquelawguid 2
usertypecombination usertypecombination 2
usertypecons usertypecons 2
versurcharge versurcharge 1

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.

-- LAW3.0 User results
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW3_UI_USMM_PERS_I (
    PARTID,
    SYSTEMGUID,
    UNAME,
    ACCOUNTID,
    CHARGINGCLIENT,
    CHARGINGSYSID,
    CHARGINGUSER,
    CLASSTYPE,
    CMANDT,
    CREATIONDATE,
    EMAILADDR,
    EXTERNALID,
    FIRSTNAME,
    KOSTL,
    LASTLOGIN,
    LASTNAME,
    LICENSETYPE,
    PHONENUMBER,
    SURCHARGE,
    UNIQUELAWGUID,
    USERTYPECOMBINATION,
    USERTYPECONS,
    VERSURCHARGE,
    PRIMARY KEY (PARTID, SYSTEMGUID, UNAME)
);