October 08, 2009

ABAP Query

Step for create abap query :

There are five steps for creating our own query for searching data based on keyword.

1. Creation of user group.

/NSQ03--- create user group---- write user group name & description.

2. Creation of Infoset.

/NSQ02 --- create Infoset---- write infoset name and description--- Select logical database--- select CKM.

Create field group --- copy required parameters for under field group--- Generate infoset.

3. Assignment of user group with Infoset.

/NSQ03-- - enter user group and infoset--- select user group for assignment--- save.

4. Creation of Query.

/NSQ01--- create query ---- select infoset--- Basic list icon click--- go to MARA General Material --- select check box under column “list fields” & “selection fields” for each parameter selected in logical database set—Execute query--- copy “Repository data “ from system status.

5. Creation of transaction code.

/NSE93--- Create transaction code---- paste copied “Repository data” in program field--- creates the transaction code.

No comments:

Post a Comment