_USER

18 Fields

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

Fields (18)

KeyField CDS FieldsUsed in Views
KEY bname ContactCardID,ContactCardSemanticObjectID,UserID 3
KEY ContactCardID ContactCardID,MaterialPriceChangedByUser,MaterialPriceCreatedByUser 4
KEY UserID BusinessUser,UserID 31
class UserGroup 1
Department Department 4
EmailAddress DefaultEmailAddress,EmailAddress 5
FirstName FirstName 11
FullName FullName,IsCurrentUser 15
LastName LastName 11
MobilePhoneNumber MobilePhoneNumber,MobilePhoneNumberExtension 5
name_text name_text 1
NAME_TEXTC CreatedByUserName 1
PersonFullName EmployeeFullName,FullName 15
PhoneNumber PhoneNumber,PhoneNumberExtension 5
smtp_addr smtp_addr 1
techdesc CreatorName,DraftCreatorName 2
user_description changed_by,created_by,user_name 3
UserDescription AccountingDocCreatedByUserName,CollectionSpecialistName,CreatedByUserDescription,CreatedByUserFullName,CreatedByUserName,DisputeCaseProcessorFullName,DsputCaseCoordinatorFullName,FullName,IHBObjectChangedByUserText,LegalTransactionTaskCurUsrName,log_created_by_formatted_name,MaintMobileApplicationUserName,MDQltyBusRuleChangedByUserName,MDQltyBusRuleCreatedByUserName,MDQltyRuleExprtCmpltdByUsrName,MDQltyRuleExprtCrtedByUserName,MDQltyRuleImprtCrtedByUserName,PersonFullName,PurgDocAssgdProcsrFullName,specialist_text,UserDescription,UserFullName,UserName 138

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,
    CLASS,
    DEPARTMENT,
    EMAILADDRESS,
    FIRSTNAME,
    FULLNAME,
    LASTNAME,
    MOBILEPHONENUMBER,
    NAME_TEXT,
    NAME_TEXTC,
    PERSONFULLNAME,
    PHONENUMBER,
    SMTP_ADDR,
    TECHDESC,
    USER_DESCRIPTION,
    USERDESCRIPTION,
    PRIMARY KEY (BNAME, CONTACTCARDID, USERID)
);

Learn More