ERP Database - The Unofficial ERP Knowledge Base

Facebook Twitter del.icio.us Digg it
ERP Database contains a huge collection of articles related to ERP System and Software. Many of the articles are specifically related to SAP. All these ERP/SAP articles are freely available to everyone.

If you would like to submit an article or share any document related to ERP or any specific ERP software. Please mail it to support@erpdb.info. Please make sure that the documents are not copyrighted.
Social Bookmarks:

Archive for January, 2008

SAP Tips: Change Database tables directly

Print This Post Email This Post Written by admin on Jan 31st, 2008 | Filed under: ABAP

SAP being a very robust system has some flaws.. maybe they kept it intentionally so that we can play with it. Anyways, As far as i know there are two ways in which the table data can be changed directly incase if you do not have a SM30 view or there is no interface written to handle the database tables.

One easy way of handling it the use of ‘&SAP_EDIT ‘. Just go to SE16n and give the table name and in the command windows key in ‘&SAP_EDIT’(without quotes) and execute. You will have all the values editable. Ofcourse not the primary keys…! If you want to change the primary keys.. then just delete it and create a new entry in SE16n.

the other way is below.. need a very little debugging experience.

Continue Reading …


SAP News: SAP Growth Rate Increase but Profits Drop

Print This Post Email This Post Written by admin on Jan 31st, 2008 | Filed under: SAP News

SAP AG got the 4th Quarter revenue of $3.65 billion from software and software related services. This was a total of around 13 Percent rise from the last year. But it’s net profit decline by 6 percent year over year to $1.12 billion due to it’s launch of Business ByDesign.

“We expect new innovations like SAP Business ByDesign to help us capture tremendous opportunities in untapped segments in the midmarket,” said Chief Executive Henning Kagermann. “In addition, the recent acquisition of Business Objects makes us the clear leader in business performance optimization products, which will help us further penetrate the fast-growing business user segment and will be another driver of growth as we move ahead.”


ABAP Programs: Transferring data to a file

Print This Post Email This Post Written by admin on Jan 31st, 2008 | Filed under: ABAP Programs

Here is a little program, which will teach you to transfer the data to a file.

REPORT ZSOURCE2601.
* Data declarations for later use
PARAMETERS FILENAME(128) DEFAULT '/usr/tmp/testfile.dat'
                         LOWER CASE.
TABLES CUSTOMERS.
DATA MSG_TEXT(50).
* Get data for file transfer
DATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100
                   WITH HEADER LINE.
 Continue Reading ...

EXIT : ABAP Keyword a day

Print This Post Email This Post Written by admin on Jan 31st, 2008 | Filed under: ABAP Keywords

EXIT

Basic forms

1. EXIT.
2. EXIT FROM STEP-LOOP.
3. EXIT FROM SQL.
Continue Reading …


SAP’s Strategic Plan of ByDesign for India

Print This Post Email This Post Written by admin on Jan 30th, 2008 | Filed under: SAP News

Before the end of the current year, SAP Aims to have around 1000 Customers for it’s hosted Midmarket ERP service – Business ByDesign.

“We will go after the biggest markets first,” said deputy CEO Leo Apotheker. “India is a very important market for a product like Business ByDesign,” he said.

SAP Launches these services each year and it’s supposed to happen in the second quarter.

SAP’s ByDesign is not only the first product to target small and mid size companies but it has may other products like Business All-in-one or Business One.