_USERDETAILS

_USERDETAILS is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
_BusinessPartner _BusinessPartner 3
AuthorizationGroup AuthorizationGroup 3
CompanyCode CompanyCode 2
FullName FullName 3
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 3
Person Person 3
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 3
UserDescription CreatedByUserDescription,ResourceManager,UserDescription 6
UserID UserID 4

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 _USERDETAILS (
    _BUSINESSPARTNER,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    FULLNAME,
    ISBUSINESSPURPOSECOMPLETED,
    PERSON,
    PERSONWORKAGRMTAUTHZNGRPG,
    USERDESCRIPTION,
    USERID
);