SAP Tip: How to set default layout for SAP Report
To set your own default layout for some SAP report. You can maintain your own user profile via the SAP menu path:
System > User profile > own data
or execute SU3 transaction directly.
So You are now on the “Maintain User Profile” screen. Select Parameter Tab then.
Enter value FIT_ALV_GL in Parameter ID filed. Specify your layout value in Parameter Value field. Then save transaction.
Viewed 7353 times by 2450 viewers
How to upload Transactional Data from Legacy to SAP system
How to migrate huge volume of Sales Orders (1,000), Purchase Orders (2,000), Production Orders (500) to the new SAP system?
What I know is to have the open orders be created to the new SAP system, however if these are too many, how can I maintain in the new system?
Viewed 6773 times by 2133 viewers
SAP Tip: Display SAP Transaction in IMG (SPRO)
How to find / display SAP transaction code name in IMG transaction (SPRO)?
Mostly the transaction code always shows as SPRO. There are many ways to get the SAP transaction code.
Viewed 6450 times by 2810 viewers
SAP Tip : How to download data from SAP to Excel
How to download data from SAP report to Excel
- Mostly, SAP standard reports have direct download function to Excel already that can be search for the menu option or the button.
- SAP Query and SAP QuickViewer are excellent tools for Downloading.
- SE16N transaction also allows you to access any SAP table and download result to Excel. SAP RFC functions can be called directly from Excel / VBA (requires special authorization).
- Use querySHUTTLE from Winshuttle product that extracts data from one or many SAP tables, and enforces security rules.
- Process Runner also offers an easy way to find tables joins via Data Dictionary SOX compliant searchable XML look up of over 80K SAP tables and views. You can even use Excel data as a filter to limit your downloads.
Use BAPI transaction in SAP to find your business object and study the function.
Viewed 6979 times by 2868 viewers
SAP Definition : Field Status Group
Enter the field status group in the master record of a G/L account in SAP system. When entering a document in SAP system, the definitions which were stored will be effectived.
Field Status Group in SAP determines the screen layout for document entry in SAP system.
The fields can have the following statuses:
- Optional Entry – Data can be entered in the field
- Mandatory Entry – Data must be entered in the field
- Suppressed – The field will not appear on the SAP screen
Viewed 7921 times by 2639 viewers
The Kind of SAP Tables
T**** Tables are Transparent Tables
Has a Physical definition and gets created in the database.
V_ Tables are View Tables
View tables are basically LOGICAL VIEW of one or more tables. For example a view is not actually physically stored, instead it is derived from one or more other tables… if you look at the View Table Structure.. you will see that they are basically JOINS of other tables and the fields are derived by varied tables…
Checking SAP Tables via SM30 transaction. eg:
- T512W_D (Definition/Has Physical Storage)
- V_512W_D (Table with Joins/doesnt have physical storage)
Viewed 17785 times by 4721 viewers


















