Skip to Content
avatar image
Former Member

I want to extract data from SAP HANA ECC

Hi There,

This is my first question on the community. I'm new to SAP ECC on HANA. I want to pull data about the User-Role assignments from HANA DB by SQL Server. I have installed HANA ODBC driver, and managed to connect the database from SQL Server.

But, I do not know which tables to access in order to get the above mentioned information.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 14, 2016 at 05:23 AM

    Hi ,

    Security related tables for ECC are listed below:

    Before you pull it, do the data browse using tcode SE16, find the relevant tables and then do it.

    Table Description NotesAGR_1016Role
    and ProfileAGR_1016BRole and ProfileAGR_1250Role and
    Authorization dataAGR_1251Role Object,
    Authorization, Field and ValueAGR_1252Organizational
    elements for authorizationsAGR_AGRSRoles in Composite
    RolesAGR_DEFINETo See All Roles
    (Role definition)AGR_HIER2Menu structure
    information – Customer versAGR_HIERTRole menu textsAGR_OBJAssignment of Menu
    Nodes to RoleAGR_PROFProfile name for
    roleAGR_TCDTXTAssignment of roles
    to TcodesAGR_TCODESAssignment of roles
    to TcodesAGR_TEXTSFile Structure for
    Hierarchical Menu – CusAGR_TIMETime Stamp for
    Role: Including profileAGR_USERSAssignment of roles
    to usersDD02LSAP TablesDD02TR/3 DD- SAP table textsDD03LTable FieldsDD04TData element textsTDDATTSTCSAP Transaction CodesTSTCATransaction Code,
    Object, Field and ValueTSTCTTransaction Code TextsUSER_ADDRAddress Data for
    usersUSGRPUser groupsUSGRPTText table for
    USGRPUSH02Change history for
    logon dataUSOBTRelation
    transaction to authorization object (SAP)USOBT_CRelation
    Transaction to Auth. Object (Customer)USOBXCheck table for
    table USOBTUSOBX_CCheck Table for
    Table USOBT_CUSOBXFLAGSTemporary table for
    storing USOBX/T* changUSR01User Master
    (runtime data)USR02Users Data (logon
    data)USR03User address dataUSR04User master
    authorization (one row per user)USR05User Master Parameter IDUSR06Additional Data per UserUSR10Authorisation
    profiles (i.e. &_SAP_ALL)USR11Text for
    authorisation profilesUSR12Authorisation
    valuesUSR13Short text for
    authorisationUSR40Table for illegal
    passwordsUST04User profiles
    (multiple rows per user)UST10CComposit profiles
    (i.e. profile has sub profile)

    Regards

    Raj

    Add comment
    10|10000 characters needed characters exceeded