SAP Queries for beginners

1. Logon to you SAP client
2. Goto Tcode: SQ01 -> Maintain Queries initial screen
3. To turn off the Graphical Query Painter and learn to create easy step-by-step reports by using the
SAP Query tool, select Settings -> Settings and then deselect the Graphical Query Painter check box.

SAP ABAP Custom IMG structure – SPRO

Custome IMG structure: Allows the users to maintain tables in a centralised structure rather than goto SM30 -> table -> view -> TMG.

Step by step procedure to create a Custom IMG Structure:

1. Goto Tcode: SIMGH . This is the tcode where u can edit/create an IMG structure.
2. click on Create. -> Enter name ( Eg: Demo_IMG ) -> Save
You can create an IMG for your entire company/ for each project/ for each application .
3. Click on Insert Node -> create a folder.
4. Click on Activity -> create an activity.
Give some name for the activity: ID : say zdemo_table
Name: some explanation for zdemo_table
5. Document Name: zdemo_table (same as ID / anything)
6. Click enter and Save. Popup comes which will ask to create documentation.
7. Click on create button next to ‘Document Name’
Standard SAP documentation Editor will be opened. Enter the information, save and activate.
8. GoBack to Change img activity: click on Attributes Tab
Enter attribute ID: zdemo_table
Name: some explanation
Give related Business Attributes: (say optional activity, non-critical depending on the req.)
9. Assigned Application Components -> Press F4 -> select relavent
This is nothing but assigning the IMG to something relavent pass code value, say the IMG is related
to finance, select from the options under financial accounting
10.Now click on ‘MaintObjects’ tab.
Give ID and Name same as above.
down in the Assigned objects, we have to put database table names/ views etc.
Under Customizing Obj: enter table/view/ name
select type: T/V/
Transaction: SM30
11. Save