I_CmmdtyDrvtvOrderUserDetails

Basic View for User Details | view: ICMMDTYUSRDET | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: ADCPADR2ADR6ADRPUSR21
Column Name Description
UserID FK User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
FirstName First name TEXT40
LastName Last name TEXT40
FullName Full Name of Person TEXT80
PhoneNumber Contact Card Phone Number
MobilePhoneNumber Contact Card Mobile Phone Number
EmailAddress Contact Card E-Mail Address
Department Department TEXT40
Master Data Relations Join Conditions
Address number of a user
  • Client
  • ?
  • ?
  • Address Number
  • I_CMMDTYDRVTVORDERUSERDETAILS.MANDT == ADRC.CLIENT
  • I_CMMDTYDRVTVORDERUSERDETAILS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_CMMDTYDRVTVORDERUSERDETAILS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_CMMDTYDRVTVORDERUSERDETAILS.ADDRESSID == ADRC.ADDRNUMBER
Address number of a user
  • Client
  • Person Number
  • ?
  • ?
  • I_CMMDTYDRVTVORDERUSERDETAILS.MANDT == ADRP.CLIENT
  • I_CMMDTYDRVTVORDERUSERDETAILS.PERSON == ADRP.PERSNUMBER
  • I_CMMDTYDRVTVORDERUSERDETAILS.[column in domain "AD_NATION"] == ADRP.NATION
  • I_CMMDTYDRVTVORDERUSERDETAILS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
Address key assignment to users
  • Client
  • User Name in User Master Record
  • I_CMMDTYDRVTVORDERUSERDETAILS.MANDT == USR02.MANDT
  • I_CMMDTYDRVTVORDERUSERDETAILS.USERID == USR02.BNAME