APS_BUSR_RAP_USR

Transparent Table Application Table
54 Fields 1 CDS Views

Draft table for entity I_APS_IAM_BUSR_RAP_ROOT

APS_BUSR_RAP_USR is an SAP database table in S/4HANA. Draft table for entity I_APS_IAM_BUSR_RAP_ROOT. It contains 54 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
i_aps_iam_busr_rap_vh_br view_entity from IAM: Business User - Business Roles Value Help

Fields (54)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY userid aps_userid
username usalias Alias
globaluserid suid_globaluid Global User ID
fullname suidtechdesc Description
firstname bu_namep_f First Name
lastname bu_namep_l Last Name
workerid bu_id_number ID Number
personid bu_partner Busn. Partner
emailaddress ad_smtpadr E-Mail Address
phonenumber abap.char
building ad_bldng_p Building code
floor ad_floor Floor
room ad_roomnum Room Number
usergroup xuclass User Group
pricecategorytext aps_iam_text80
validfrom xugltgv Valid from
validto xugltgb Valid to
valid boole_d TRUE
validtext natxt Message Text
validtexthidden boole_d TRUE
locked boole_d TRUE
lockedtext natxt Message Text
lockedtexthidden boole_d TRUE
lockstatus xuuflag User Lock
loggedon boole_d TRUE
loggedontext natxt Message Text
loggedontexthidden boole_d TRUE
decimalformatid abap.char
decimalformat val_text Short Description
dateformatid xudatfm Date format
dateformat val_text Short Description
timezoneid tznzone Time Zone
timezonetext tzndesctzn Time Zone Text
timeformatid xutimefm 12/24 Hours
timeformat val_text Short Description
languageid xulangu Logon Language
language sptxt2 Long Text
businessrolecount abap.int4
applicationjobcount abap.int4
lastlogondatetime timestamp Time Stamp
neverloggedon boole_d TRUE
creationusername aps_userdescription
creationdatetime susr_creation_timestamp
lastchangeusername aps_userdescription
lastchangedatetime timestamp Time Stamp
usergroupcheck xuclass User Group
rolecategory abap.char
workernavhidden boole_d TRUE
workernavworkforcepersonhidden boole_d TRUE
workernavemployeehidden boole_d TRUE
workernavextresourcehidden boole_d TRUE
criticalcodeerror abap.numc
criticalcodesuccess abap.numc

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.

-- Draft table for entity I_APS_IAM_BUSR_RAP_ROOT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APS_BUSR_RAP_USR (
    MANDT,                           -- Client [mandt]
    USERID,                          -- aps_userid
    USERNAME,                        -- Alias [usalias]
    GLOBALUSERID,                    -- Global User ID [suid_globaluid]
    FULLNAME,                        -- Description [suidtechdesc]
    FIRSTNAME,                       -- First Name [bu_namep_f]
    LASTNAME,                        -- Last Name [bu_namep_l]
    WORKERID,                        -- ID Number [bu_id_number]
    PERSONID,                        -- Busn. Partner [bu_partner]
    EMAILADDRESS,                    -- E-Mail Address [ad_smtpadr]
    PHONENUMBER,                     -- abap.char
    BUILDING,                        -- Building code [ad_bldng_p]
    FLOOR,                           -- Floor [ad_floor]
    ROOM,                            -- Room Number [ad_roomnum]
    USERGROUP,                       -- User Group [xuclass]
    PRICECATEGORYTEXT,               -- aps_iam_text80
    VALIDFROM,                       -- Valid from [xugltgv]
    VALIDTO,                         -- Valid to [xugltgb]
    VALID,                           -- TRUE [boole_d]
    VALIDTEXT,                       -- Message Text [natxt]
    VALIDTEXTHIDDEN,                 -- TRUE [boole_d]
    LOCKED,                          -- TRUE [boole_d]
    LOCKEDTEXT,                      -- Message Text [natxt]
    LOCKEDTEXTHIDDEN,                -- TRUE [boole_d]
    LOCKSTATUS,                      -- User Lock [xuuflag]
    LOGGEDON,                        -- TRUE [boole_d]
    LOGGEDONTEXT,                    -- Message Text [natxt]
    LOGGEDONTEXTHIDDEN,              -- TRUE [boole_d]
    DECIMALFORMATID,                 -- abap.char
    DECIMALFORMAT,                   -- Short Description [val_text]
    DATEFORMATID,                    -- Date format [xudatfm]
    DATEFORMAT,                      -- Short Description [val_text]
    TIMEZONEID,                      -- Time Zone [tznzone]
    TIMEZONETEXT,                    -- Time Zone Text [tzndesctzn]
    TIMEFORMATID,                    -- 12/24 Hours [xutimefm]
    TIMEFORMAT,                      -- Short Description [val_text]
    LANGUAGEID,                      -- Logon Language [xulangu]
    LANGUAGE,                        -- Long Text [sptxt2]
    BUSINESSROLECOUNT,               -- abap.int4
    APPLICATIONJOBCOUNT,             -- abap.int4
    LASTLOGONDATETIME,               -- Time Stamp [timestamp]
    NEVERLOGGEDON,                   -- TRUE [boole_d]
    CREATIONUSERNAME,                -- aps_userdescription
    CREATIONDATETIME,                -- susr_creation_timestamp
    LASTCHANGEUSERNAME,              -- aps_userdescription
    LASTCHANGEDATETIME,              -- Time Stamp [timestamp]
    USERGROUPCHECK,                  -- User Group [xuclass]
    ROLECATEGORY,                    -- abap.char
    WORKERNAVHIDDEN,                 -- TRUE [boole_d]
    WORKERNAVWORKFORCEPERSONHIDDEN,  -- TRUE [boole_d]
    WORKERNAVEMPLOYEEHIDDEN,         -- TRUE [boole_d]
    WORKERNAVEXTRESOURCEHIDDEN,      -- TRUE [boole_d]
    CRITICALCODEERROR,               -- abap.numc
    CRITICALCODESUCCESS,             -- abap.numc
    PRIMARY KEY (MANDT, USERID)
);

Learn More