ABAP QUERY

1. DEFINE THE USER GROUP (SQ03) - GO TO 'ENVIRONMENT' -QUERY AREA
SELECT (GLOBAL-CROSS CLIENT)
2. GIVE THE NAME - CREATE -SAVE -BACK
3. DEFINE THE FUNCATIONAL AREAS (SQ02) - GIVE THE NAME OF FUN. AREA
4. CREATE - GIVE DESCRIPTION - GIVE THE 'LDB' NAME OR ANY DATA BASE TABLE
5. ENTER - CLICK ON FUNCAL GROUPS - CREATE - GIVE 3 NAMES FOR 3 TABLE OF LDB
6. SELECT THE FIRST FUNCTIONAL GROUP - THEN - GO TO THE FIRST TABLE OF LDB
7. EXPAND THE TABLE COLUMNS AND MAKE THE SELECTION OF COULMNS FOR THAT
FUNCTIONAL GROUP - SAVE.
8. THEN - REPEAT THE SAME OPERATION FOR THE REMAINING TWO FUNC. GROUP
9. SAVE - BACK -IT'LL ASK FOR 'GENERATION' - CLICK - YES - BACK
10. GO TO USERGROUP - CLICK ON 'ASSIGN USER GROUP' - TYPE 'SAPUSER' AND
CLICK ON CHANGE AUTHORIZATION - SAVE - BACK.
11. GO TO FUNCTIONAL AREA - CLICK ON 'ASSIGN FUNC. AREA' - SELECT YOUR USER GROUP
AND SELECT YOUR FUNCATIONAL AREA - SAVE - BACK
12. GO TO QUERY - CREATE - GIVE THE TITLE - SELECT - BASIC LIST - FROM 'DATA FIELDS'
EXPLAND THE TABLE(S) - THEN SELECT - COLUMNS FROM EACH TABLE
13. TAKE THE HEADER AND FOOTER FOR ADDING HEADER AND FOOTER TO THE LIST
14. EXECUTE.