Regarding Data Maintenance Tool

[Former Member]

Hi ABAPers,

Can any one Explain me what is the use of Data Maintenance Tool. And also let me know where and how to create this tool.

Thanks in Advance.

Regards,

Ramana Prasad. T

[Former Member]

Hi Ramana,

<b>

Mass Maintenance to SAP Data – Current Situation</b>

If only a few tens of records are to be added or updated, entering this data manually into SAP is a reasonable option. However, if several hundred to several thousand records are to be updated, manual data entry is not an ideal choice. Manual data entry can get very expensive and time consuming and is not the best utilization of corporate resources – this is especially wasteful for data that already exists in another digital format, e.g., Excel files. Not only that, manual data entry is very error prone and can lead to severely degraded data quality.

The SAP mass-change transactions are only useful for fairly simple data change scenarios where one or more fields need to be changed to a constant value for all records. Most mass changes scenarios are more complex than that and the second and third options are the ones mostly chosen.

The other tools provided by SAP for automating mass maintenance of data, include tools such as ABAP and LSMW, which are extremely technical in nature and require technical experts in the IT departments to create special-purpose data upload programs. Following the standard change control procedures and industry standard software development practices, writing these special programs ends up being a very time consuming and a very expensive proposition for most companies. Further, many of these programs are throw-away programs written for one-time use only.

<b>

Mass Maintenance to SAP Data– Ideal Scenario</b>

An ideal tool for mass maintenance of SAP data would let the data update projects to be implemented by the end user departments themselves. A few super-users within these end-user departments that supply the data should have the ability to transfer the data themselves without relying on technical experts. Such a tool would significantly cut the time and effort required in SAP data maintenance.

The ideal tool for mass maintenance of SAP data should be easy to learn and should require no programming. Furthermore, such a tool should work across all the different SAP modules and the SAP products, including the different versions of SAP

WE PROPOSE TXSHUTTLE AND TABLEPRO AS THE IDEAL TOOLS FOR ROUTINE SAP DATA MAINTENANCE!

Key Features:

•

TxShuttle runs almost any SAP transaction, simple or complex, and even custom transactions, in any SAP product or module – from outside SAP. While running these transactions, TxShuttle allows easy upload of data between Microsoft Excel or Access and any SAP transaction.

• TablePro allows the easy download of any table or view from SAP into Excel files and even allows the joining of multiple tables.

•

Txshuttle and TablePro are easy-to-use tools intended for SAP end-users and do not require any programming.

•

TxShuttle and TablePro preserves complete SAP role-based security and maintain a complete SAP audit trail.

•

Using TxShuttle and TablePro needs no change to standard SAP – they are desktop software tools that run out of the box

Key Benefits:

•

Save vast amount of time and resources in mass maintenance of SAP data.

•

Make the SAP business-users and functional analysis more self-sufficient by reducing their dependence on valuable IT/IS resources.

•

Save IT resources by significantly reducing custom programming efforts.

•

Use the same tool for many applications. Maximize your return on investment.

Reward if useful.

Thanks

Aneesh.