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?
Read more…
Viewed 5311 times by 1466 viewers
admin SAP Tip Migration, SAP Tip
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.
Read more…
Viewed 3960 times by 1503 viewers
admin SAP Tip SAP Tip, SAP Tutorials
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.
Read more…
Viewed 5167 times by 2006 viewers
admin SAP Tip SAP Tip, SAP Tutorial
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
Read more…
Viewed 6061 times by 1707 viewers
admin General Ledger Module field status group, SAP Tutorial
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)
Read more…
Viewed 15996 times by 4044 viewers
admin SAP Tip SAP Table, SAP Tips, SAP Tutorial