LAW3_UI_USMM_PARTS_I

CDS View
62 Fields 7 CDS Views

LAW3.0 Clients

LAW3_UI_USMM_PARTS_I is a CDS View in S/4HANA. LAW3.0 Clients. It contains 62 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
LAW3_UI_USMM_CLIENT_LIST_C view from LAW3.0 Infromation system: Client List
LAW3_UI_USMM_ENGINES_I view from LAW3.0 Engines
LAW3_UI_USMM_ENGINES_I view union LAW3.0 Engines
LAW3_UI_USMM_ENGINES_OLD_I view from LAW3.0 Engines from LAW2.0
LAW3_UI_USMM_PERS_OBJECTS_I view from LAW3.0 Personalization objects
LAW3_UI_USMM_USER_I view from LAW3.0 User
LAW3_UI_USMM_USER_TYPES_I view from LAW3.0 User Types

Fields (62)

KeyField CDS FieldsUsed in Views
KEY datasetguid datasetguid 5
KEY instno instno 5
KEY partid partid 4
KEY sapclient sapclient 4
KEY sysid sysid 5
KEY systemguid systemguid 5
KEY systemno systemno 5
chdate chdate 1
chname chname 1
chtime chtime 1
crdate crdate 1
crname crname 1
crtime crtime 1
datasetid datasetid 4
defutype defutype 1
description description 1
emailsender emailsender 1
emptygroupingattrusers emptygroupingattrusers 1
excluded excluded 1
executor executor 1
extattrstatus extattrstatus 1
extgroupingattribute extgroupingattribute 1
extresultcounter extresultcounter 1
extsystemflag extsystemflag 1
extsystemid extsystemid 1
genericid genericid 1
hanasystemflag hanasystemflag 1
hwkey hwkey 1
measdate measdate 1
measno measno 1
measstatus measstatus 1
meastime meastime 1
measuser measuser 1
name name 1
nmpcomment nmpcomment 1
part_resultdate part_resultdate 1
part_status part_status 1
part_systemno part_systemno 1
pc_auto_flag pc_auto_flag 1
pc_timestamp pc_timestamp 1
persobjgrouping persobjgrouping 1
persobjgrouping2 persobjgrouping2 1
pricelist pricelist 1
productive productive 1
resultdate resultdate 1
saprelease saprelease 1
sdccn_instno sdccn_instno 1
sdccn_reqsid sdccn_reqsid 1
sdccn_sessionnr sdccn_sessionnr 1
sendcomment sendcomment 1
status status 3
sysstatus sysstatus 1
system_status system_status 1
transferdate transferdate 1
transferstatus_sdccn transferstatus_sdccn 1
transfertime transfertime 1
transfertype transfertype 1
useddatabase useddatabase 1
usergroupingfield usergroupingfield 1
usergroupingfield2 usergroupingfield2 1
usersaftergrouping usersaftergrouping 1
usersbeforegrouping usersbeforegrouping 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 Clients
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LAW3_UI_USMM_PARTS_I (
    DATASETGUID,
    INSTNO,
    PARTID,
    SAPCLIENT,
    SYSID,
    SYSTEMGUID,
    SYSTEMNO,
    CHDATE,
    CHNAME,
    CHTIME,
    CRDATE,
    CRNAME,
    CRTIME,
    DATASETID,
    DEFUTYPE,
    DESCRIPTION,
    EMAILSENDER,
    EMPTYGROUPINGATTRUSERS,
    EXCLUDED,
    EXECUTOR,
    EXTATTRSTATUS,
    EXTGROUPINGATTRIBUTE,
    EXTRESULTCOUNTER,
    EXTSYSTEMFLAG,
    EXTSYSTEMID,
    GENERICID,
    HANASYSTEMFLAG,
    HWKEY,
    MEASDATE,
    MEASNO,
    MEASSTATUS,
    MEASTIME,
    MEASUSER,
    NAME,
    NMPCOMMENT,
    PART_RESULTDATE,
    PART_STATUS,
    PART_SYSTEMNO,
    PC_AUTO_FLAG,
    PC_TIMESTAMP,
    PERSOBJGROUPING,
    PERSOBJGROUPING2,
    PRICELIST,
    PRODUCTIVE,
    RESULTDATE,
    SAPRELEASE,
    SDCCN_INSTNO,
    SDCCN_REQSID,
    SDCCN_SESSIONNR,
    SENDCOMMENT,
    STATUS,
    SYSSTATUS,
    SYSTEM_STATUS,
    TRANSFERDATE,
    TRANSFERSTATUS_SDCCN,
    TRANSFERTIME,
    TRANSFERTYPE,
    USEDDATABASE,
    USERGROUPINGFIELD,
    USERGROUPINGFIELD2,
    USERSAFTERGROUPING,
    USERSBEFOREGROUPING,
    PRIMARY KEY (DATASETGUID, INSTNO, PARTID, SAPCLIENT, SYSID, SYSTEMGUID, SYSTEMNO)
);

Learn More