USER

72 Fields

USER is an SAP database table in S/4HANA. It contains 72 fields.

Fields (72)

KeyField CDS FieldsUsed in Views
KEY bname bname,LoggedInUser,UserId 6
KEY consolidationguid ConsolidationId 1
KEY ConsolidationId ConsolidationId 2
KEY datasetguid DatasetId 1
KEY lic_type Classification,lic_type,UserClassificationId 4
KEY licensetype licensetype 1
KEY Store Store 1
KEY UserId CreatedByUser,LastChangedByUser,QueueOMSOwner,UserId 16
ActiveClassificationComb ActiveClassificationComb 2
ActiveClassificationId ActiveClassificationId 2
ActiveClassificationText ActiveClassificationText 2
activeusetype ActiveClassificationId,activeusetype 3
activeusetype_comb ActiveClassificationComb 1
as4date as4date,LastChangedOn 2
AutoLicenseType IsCurrentClassificationAuto 1
autolictype autolictype,IsDefaultLicenseType 2
class class 1
classification classification,classification_user,ClassificationId,ClassificationIdBack 4
classification_comb ClassificationConbination 1
ClassificationConbination ClassificationConbination 2
ClassificationId ClassificationId 2
ClassificationText ClassificationText 2
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
deltaindicator deltaindicator,DeltaIndicatorId 2
deltaindicatorint DeltaIndicatorIdInt,deltaindicatorint 2
FullName FullName 1
gltgb gltgb 1
gltgv gltgv 1
hierarchylevel hierarchylevel 3
isadministrator isadministrator 2
isauthorizeddeveloper isauthorizeddeveloper 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
isclassifieddeveloper isclassifieddeveloper 2
IsDefaultLicenseType IsDefaultLicenseType 1
isdeveloper isdeveloper,wasdeveloper 2
LastDate LastDate 1
lic_type_comb LicTypeCombination 1
LicTypeCombination LicTypeCombination 2
ltime LastTime,ltime 2
MasterProject MasterProject 1
name_first name_first 1
name_last name_last 1
name_text name_text 1
nodeid nodeid 3
parentnodeid parentnodeid 3
PersonNumber PersonNumber 1
profiles profiles 3
roles roles 3
smtp_addr smtp_addr 1
transportcounter transportcounter 2
trdat LastDate,trdat 2
uflag uflag,UserLockStatus 2
uname ApproverName 1
uniquelawguid uniquelawguid 3
User_cons User_cons 2
UserClassificationId UserClassificationId 2
UserClassificationText UserClassificationText 2
UserDescription CreatedByUserName,LastChangedByUserName,UserDescription,UserFullName 10
UserLockStatus UserLockStatus 1
UserType UserType 2
ustyp UserType,ustyp 2
wasdeveloper WasDeveloper 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USER (
    BNAME,
    CONSOLIDATIONGUID,
    CONSOLIDATIONID,
    DATASETGUID,
    LIC_TYPE,
    LICENSETYPE,
    STORE,
    USERID,
    ACTIVECLASSIFICATIONCOMB,
    ACTIVECLASSIFICATIONID,
    ACTIVECLASSIFICATIONTEXT,
    ACTIVEUSETYPE,
    ACTIVEUSETYPE_COMB,
    AS4DATE,
    AUTOLICENSETYPE,
    AUTOLICTYPE,
    CLASS,
    CLASSIFICATION,
    CLASSIFICATION_COMB,
    CLASSIFICATIONCONBINATION,
    CLASSIFICATIONID,
    CLASSIFICATIONTEXT,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELTAINDICATOR,
    DELTAINDICATORINT,
    FULLNAME,
    GLTGB,
    GLTGV,
    HIERARCHYLEVEL,
    ISADMINISTRATOR,
    ISAUTHORIZEDDEVELOPER,
    ISBUSINESSPURPOSECOMPLETED,
    ISCLASSIFIEDDEVELOPER,
    ISDEFAULTLICENSETYPE,
    ISDEVELOPER,
    LASTDATE,
    LIC_TYPE_COMB,
    LICTYPECOMBINATION,
    LTIME,
    MASTERPROJECT,
    NAME_FIRST,
    NAME_LAST,
    NAME_TEXT,
    NODEID,
    PARENTNODEID,
    PERSONNUMBER,
    PROFILES,
    ROLES,
    SMTP_ADDR,
    TRANSPORTCOUNTER,
    TRDAT,
    UFLAG,
    UNAME,
    UNIQUELAWGUID,
    USER_CONS,
    USERCLASSIFICATIONID,
    USERCLASSIFICATIONTEXT,
    USERDESCRIPTION,
    USERLOCKSTATUS,
    USERTYPE,
    USTYP,
    WASDEVELOPER,
    PRIMARY KEY (BNAME, CONSOLIDATIONGUID, CONSOLIDATIONID, DATASETGUID, LIC_TYPE, LICENSETYPE, STORE, USERID)
);

Learn More