Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report Requirement

Hi Experts

I am new to BI Extraction as i worked a lot earlier on Front End (BEX)

I have a requirement like this can you help me out in generating a report from scratch..

Users want a Bex report (So that they can see/drilldonw the data in different angles)

Role name should be the key and he needs the following information in the report

System

Role name

Role Description

Parent Role

Tcodes in role

Orgn level details for a role

Users assigned to a role (user id , Full name, User group - TERM - USR02)

Orgn level field description/text

And from the below tables (Role Name is the key max. of these tables) we can get the above information....

AGR_1016

AGR_TEXTS

AGR_DEFINE

AGR_TCODES

AGR_1252

AGR_USERS

AGR_TEXTS

AGR_DEFINE

AGR_TCODES

AGR_1252

USER_ADDR

USER_ADDR

USR02

We have several systems like R/3, CRM, SRM, BI etc... in all the sytems the role related information is stored in the above tables. And i need to extract the data from all the systems mentioned above to DSO or Cube.

Now can you help me through which extraction mode i have to go and how i have to design my DSO or Cube to meet the above requirement.

I am thinking we can go through Generic extraction through Function Module... (if so can you provide me the Steps and also the design of DSO or Cube...)

If any body had similar requirement please help....

Appreciate your help.....

Former Member
Not what you were looking for? View more on this topic or Ask a question