Friday, January 12, 2007

SAP R/3 : Stock Balance Report

I am now using SAP version 3.1 and the ABAP Editor is very crude. Its very different from the latest environment. Its totally different. Stock balance report was one of the report i maintained using this old system.

Added with a slow and unstable dial up connection, the maintenance was so troublesome and disheartening. Each testing and changes made will take half an hour or more. Ok, the report that i maintained today is a report that display a 5 line items.

1. The Opening balance
2. The Requirement
3. The Delivery/PO
4. The Balance
5. The Propose New PO

Each of this line item will display tonnage of stock that is used to monitor their stock level. The opening balance will show the leftover balance of stock including the safety stock. It will be calculated against the balance with item 2 and 3. The report will show the number of tonnage for 15 weeks in a row.

A few things were to take note when developing this report:
1. Less usage of SELECT... ENDSELECT to minimize burden to performance
2. More usage of FOR ALL ENTRIES IN and INNER JOIN.
3. Added and then removed GET_PRINT_PARAMETERS to control printing of blank pages.

is sky the limit... 3.1 is crude

No comments: