Swx_Sddl_Address

Workflow Demo: User Address (CDS view) | view: SWX_V_ADDRESS | Extraction: Not supported | Component: SAP Business Workflow
Tables used: USR21
Column Name Description
bname FK User Name in User Master Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
kostl Cost center CHAR8
bpperson Business Partner GUID SYSUUID
organization Business Partner GUID SYSUUID
Master Data Relations Join Conditions
Address number of a user
  • Client
  • ?
  • ?
  • Address Number
  • SWX_SDDL_ADDRESS.MANDT == ADRC.CLIENT
  • SWX_SDDL_ADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • SWX_SDDL_ADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • SWX_SDDL_ADDRESS.ADDRNUMBER == ADRC.ADDRNUMBER
Address key assignment to users
  • User Name in User Master Record
  • Client
  • SWX_SDDL_ADDRESS.BNAME == USR02.BNAME
  • SWX_SDDL_ADDRESS.MANDT == USR02.MANDT
Address number of a user
  • Client
  • ?
  • ?
  • Person Number
  • SWX_SDDL_ADDRESS.MANDT == ADRP.CLIENT
  • SWX_SDDL_ADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • SWX_SDDL_ADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • SWX_SDDL_ADDRESS.PERSNUMBER == ADRP.PERSNUMBER