Go on link..

link us with ...

Showing posts with label ABAP QUERY. Show all posts
Showing posts with label ABAP QUERY. Show all posts

Friday, December 31, 2010

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.

link us...

For Visitors

if you want to publish or Add something on ERP, SAP , SAP FUNCTIONAL, SAP ABAP then mail us along with your email-id. contain must be yours

email-id :- avinashkr_raj@yahoo.com(any email)

email-id :- avinaskr_raj.abap@blogger.com ( use only gmail)