LAW3_UI_USMM_SYSTEMS_I

CDS View
50 Fields 3 CDS Views

LAW3.0 Systems

LAW3_UI_USMM_SYSTEMS_I is a CDS View in S/4HANA. LAW3.0 Systems. It contains 50 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
LAW3_UI_USMM_COMPONENTS_I view from LAW3.0 Components
LAW3_UI_USMM_PARTS_I view from LAW3.0 Clients
LAW3_UI_USMM_SYSTEM_LIST_C view from LAW3.0 Infromation system: System List

Fields (50)

KeyField CDS FieldsUsed in Views
KEY datasetguid datasetguid 2
KEY systemguid systemguid 2
KEY systemno systemno 3
chdate chdate 2
chname chname 2
chtime chtime 2
crdate crdate 2
crname crname 2
crtime crtime 2
datasetid datasetid 2
description description 2
emailsender emailsender 2
emptygroupingattrusers emptygroupingattrusers 2
extattrstatus extattrstatus 2
extgroupingattribute extgroupingattribute 2
extresultcounter extresultcounter 2
extsystemflag extsystemflag 3
extsystemid extsystemid 3
hanasystemflag hanasystemflag 3
hwkey hwkey 2
instno instno 3
measdate measdate 3
measstatus measstatus 3
meastime meastime 3
measuser measuser 3
nmpcomment nmpcomment 2
pc_auto_flag pc_auto_flag 2
pc_timestamp pc_timestamp 2
persobjgrouping persobjgrouping 2
persobjgrouping2 persobjgrouping2 2
pricelist pricelist 3
resultdate resultdate 3
saprelease saprelease 3
sdccn_instno sdccn_instno 2
sdccn_reqsid sdccn_reqsid 2
sdccn_sessionnr sdccn_sessionnr 2
sendcomment sendcomment 2
status status 3
sysid sysid 3
sysstatus sysstatus 3
system_status system_status 2
transferdate transferdate 2
transferstatus_sdccn transferstatus_sdccn 2
transfertime transfertime 2
transfertype transfertype 2
useddatabase useddatabase 3
usergroupingfield usergroupingfield 2
usergroupingfield2 usergroupingfield2 2
usersaftergrouping usersaftergrouping 2
usersbeforegrouping usersbeforegrouping 2

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 Systems
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW3_UI_USMM_SYSTEMS_I (
    DATASETGUID,
    SYSTEMGUID,
    SYSTEMNO,
    CHDATE,
    CHNAME,
    CHTIME,
    CRDATE,
    CRNAME,
    CRTIME,
    DATASETID,
    DESCRIPTION,
    EMAILSENDER,
    EMPTYGROUPINGATTRUSERS,
    EXTATTRSTATUS,
    EXTGROUPINGATTRIBUTE,
    EXTRESULTCOUNTER,
    EXTSYSTEMFLAG,
    EXTSYSTEMID,
    HANASYSTEMFLAG,
    HWKEY,
    INSTNO,
    MEASDATE,
    MEASSTATUS,
    MEASTIME,
    MEASUSER,
    NMPCOMMENT,
    PC_AUTO_FLAG,
    PC_TIMESTAMP,
    PERSOBJGROUPING,
    PERSOBJGROUPING2,
    PRICELIST,
    RESULTDATE,
    SAPRELEASE,
    SDCCN_INSTNO,
    SDCCN_REQSID,
    SDCCN_SESSIONNR,
    SENDCOMMENT,
    STATUS,
    SYSID,
    SYSSTATUS,
    SYSTEM_STATUS,
    TRANSFERDATE,
    TRANSFERSTATUS_SDCCN,
    TRANSFERTIME,
    TRANSFERTYPE,
    USEDDATABASE,
    USERGROUPINGFIELD,
    USERGROUPINGFIELD2,
    USERSAFTERGROUPING,
    USERSBEFOREGROUPING,
    PRIMARY KEY (DATASETGUID, SYSTEMGUID, SYSTEMNO)
);

Learn More