_USER

24 Fields

_USER is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY bname ContactCardID,ContactCardSemanticObjectID,UserID 3
KEY ContactCardID ContactCardID,MaterialPriceChangedByUser,MaterialPriceCreatedByUser 5
KEY UserID BusinessUser,UserID 31
KEY Username Username 1
class UserGroup 1
CreatedByUserName FullName 1
Department Department 5
EMail Email 2
EmailAddress DefaultEmailAddress,EmailAddress 5
FirstName FirstName 12
FullName FullName,IsCurrentUser 18
gltgb UserValidTo 1
gltgv UserValidFrom 1
LastName LastName 12
MobilePhoneNumber MobilePhoneNumber,MobilePhoneNumberExtension 6
NAME_TEXTC CreatedByUserName 1
PersonFullName EmployeeFullName,FullName 15
PhoneNumber PhoneNumber,PhoneNumberExtension 6
techdesc CreatorName,DraftCreatorName 2
user_description changed_by,created_by,user_name 3
UserAlias UserAlias 1
UserDescription AccountingDocCreatedByUserName,ApprovedByUserFullName,CollectionSpecialistName,CreatedByUserDescription,CreatedByUserFullName,CreatedByUserName,DisputeCaseProcessorFullName,DsputCaseCoordinatorFullName,FullName,IHBObjectChangedByUserText,LegalTransactionTaskCurUsrName,log_created_by_formatted_name,MaintMobileApplicationUserName,MDQltyBusRuleChangedByUserName,MDQltyBusRuleCreatedByUserName,MDQltyRuleExprtChgdByUserName,MDQltyRuleExprtCmpltdByUsrName,MDQltyRuleExprtCrtedByUserName,MDQltyRuleImprtChgdByUserName,MDQltyRuleImprtCmpltdByUsrName,MDQltyRuleImprtCrtedByUserName,PersonFullName,PurgDocAssgdProcsrFullName,specialist_text,test,UserDescription,UserFullName,UserName 156
UserGroup UserGroup 2
ustyp UserType 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,
    CONTACTCARDID,
    USERID,
    USERNAME,
    CLASS,
    CREATEDBYUSERNAME,
    DEPARTMENT,
    EMAIL,
    EMAILADDRESS,
    FIRSTNAME,
    FULLNAME,
    GLTGB,
    GLTGV,
    LASTNAME,
    MOBILEPHONENUMBER,
    NAME_TEXTC,
    PERSONFULLNAME,
    PHONENUMBER,
    TECHDESC,
    USER_DESCRIPTION,
    USERALIAS,
    USERDESCRIPTION,
    USERGROUP,
    USTYP,
    PRIMARY KEY (BNAME, CONTACTCARDID, USERID, USERNAME)
);

Learn More