Archive

Archive for the ‘SAP Tutorial’ Category

How to upload Transactional Data from Legacy to SAP system

January 3rd, 2010

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 ,

SAP Tip: Display SAP Transaction in IMG (SPRO)

December 28th, 2009

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 : How to download data from SAP to Excel

December 24th, 2009

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 Definition : Field Status Group

December 18th, 2009

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 ,

The Kind of SAP Tables

October 30th, 2009

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 , ,