I_Userdetails

Basic CDS for User Details | view: IUSERDETAILS | Extraction: Not supported | Component: Purchase Requisitions
Tables used: BUT0IDBUT000USR21
Column Name Description
UserID FK User ID
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate null
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
FullName Full Name TEXT80
Employee Identification Number CHAR60
PersonWorkAgreement Personnel Number PERSNO
CompanyCode Company Code BUKRS
Person Business Partner Number BU_PARTNER
PersonWorkAgrmtAuthznGrpg Organizational Key VDSK1
Master Data Relations Join Conditions
Authorization Group
  • Authorization Group
  • Client
  • ?
  • I_USERDETAILS.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_USERDETAILS.MANDT == TB037.CLIENT
  • I_USERDETAILS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Address key assignment to users
  • User ID
  • Client
  • I_USERDETAILS.USERID == USR02.BNAME
  • I_USERDETAILS.MANDT == USR02.MANDT