I need to extract the data in given below format:
Composite role --> Child Role--> Transaction code.
I use tcode SQVI to join two tables AGR_AGRS and AGR_1251 to obtain the data but i'm not getting data in desired format.
Idea was: i will join table AGR_AGRS and AGR_1251 and i will use single role from both tables as primary key to join them.
So that i can use repesent data by using fields comp. role (AGR_NAME) , single role(CHILD_AGR) from table AGR_AGRS
and single role(AGR_NAME) and auth. object (OBJECT) = S_TCODE with values (LOW, HIGH).
Problem is : under table AGR_AGRS , composite role represent with field name AGR_NAME and child role (single role) with CHILD_AGR.
Under table AGR_1251, single role reperesnt with field name AGR_NAME. So same child role (single role) field represent with different field name in both type. Tables are getting joined based on AGR_NAME from both tables.
Kindly suggest the tables or method or both so that i can get the data in desired format.