SAP Data Migration with LSMW

August 29, 2010 by mySAP · Leave a Comment
Filed under: SAP Configuration, SAP Knowledge, SAP Tip, SAP Tutorial 

Legacy System Migration Workbench (LSMW) is a tool recommended by SAP that can be used to transfer data once only or periodically from legacy systems into SAP System.

LSMW is one of the very useful tools available by SAP to upload large amount of data to the SAP system. LSMW tool  is comparable to ecatt or scatt. But the advantage LSMW has over them is the amount of data processed in single session. Moreover, LSMW is easier to learn and execute.

Read more

Viewed 1500 times by 496 viewers

Download Internal Table To Excel Using ABAP GUI_DOWNLOAD

August 21, 2010 by mySAP · Leave a Comment
Filed under: SAP Tip, SAP Tutorial 

To download SAP data from internal SAP table to MS excel using ABAP GUI_DOWNLOAD.

Follow the following steps:

Program description:

In this example, Internal SAP table itab will be populated using data from table PLKO. After that you can specify where you want to save the download file.

Read more

Viewed 3488 times by 920 viewers

SHD0 – Creating Transaction and Screen Variants

How to create Transaction and Screen Variants to change screen layouts. And how to assign those transactions and screens variants to a group of users.

Transaction variants can be used to simplify transaction flow by:

  • Inserting default values for fields
  • Hiding and changing fields to read only
  • Hiding and changing the attributes of tables of control columns
  • Hiding individual menu functions
  • Hiding entire screens

And a transaction variant is made up of a series of screen variants.

Read more

Viewed 7497 times by 1882 viewers

Change Layout of MIRO Screen

For MIRO transaction, OLMRLIST transaction can be used to create screen variant.

Alternative way is, for changing any layout of the screen, “Screen Variant” have to be created or you can change the Standard Screen Variant (Basic Settings, for example)

The steps are:

Read more

Viewed 6938 times by 1548 viewers

Where-Used List Benefits with SAP Table and Other Objects

April 29, 2010 by mySAP · Leave a Comment
Filed under: SAP Tip 

How to find the program which using particular SAP table in the SAP system?

With where-used lists you can determine who used the objects and the dependencies between the objects. For finding the program list which call your SAP table.

The steps are:

Read more

Viewed 17047 times by 3117 viewers

SAP Tip: How to Set Mandatory field for Standard SAP Report

February 2, 2010 by mySAP · Leave a Comment
Filed under: SAP Tip 

The question is whether it’s possible to define a field as mandatory for standard SAP report such as FBL1N, FBL3N, FBL5N transaction. For example you need to define the field “Company code” as mandatory for these SAP transactions.

We can set the mandatory field as you want by creating variant for SAP transactions (such as FBL5N (Customer Line item display) transaction, for example).

Read more

Viewed 5706 times by 2077 viewers

mySAP ERP | SAP Business | SAP Tutorial | SAP Help