I_CmmdtyHedgeSpecUserDetails

Commodity Hedge Spec User Details | view: ICMMHDGSPECUSRDT | Extraction: Not supported | Component: Commodity Derivative Risk Management
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
  • Address Number
  • ?
  • ?
  • Client
  • I_CMMDTYHEDGESPECUSERDETAILS.ADDRESSID == ADRC.ADDRNUMBER
  • I_CMMDTYHEDGESPECUSERDETAILS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_CMMDTYHEDGESPECUSERDETAILS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_CMMDTYHEDGESPECUSERDETAILS.MANDT == ADRC.CLIENT
Address number of a user
  • Person Number
  • ?
  • ?
  • Client
  • I_CMMDTYHEDGESPECUSERDETAILS.PERSON == ADRP.PERSNUMBER
  • I_CMMDTYHEDGESPECUSERDETAILS.[column in domain "AD_NATION"] == ADRP.NATION
  • I_CMMDTYHEDGESPECUSERDETAILS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_CMMDTYHEDGESPECUSERDETAILS.MANDT == ADRP.CLIENT
Address key assignment to users
  • User Name in User Master Record
  • Client
  • I_CMMDTYHEDGESPECUSERDETAILS.USERID == USR02.BNAME
  • I_CMMDTYHEDGESPECUSERDETAILS.MANDT == USR02.MANDT