" The role of the update work process is very important since it is responsible for recording the changes in the database. The process performs its functions when the ABAP applications are programmed with the statements in the UPDATE TASK. This type of updating is asynchronously performed, ie. The programs leave update records in a queue to be processed and then continue to the update process. Normally, it runs without any intervention from the SAP R/3 management, still R/3 includes utilities to monitor check and perform management operations on the updation processes. In case any updating error takes place, the system places a message to the user regarding the error and an alert is triggered in the CCMS monitor. For the update functions go to Administration menu bar option --> Monitor option ---> Update option. An initial update screen showing various functions appears. The initial update screen is used to display the system update records with error status or the records which have not yet been processed, activate and deactivate the updating in the whole SAP system. It is also useful to display the update statistics, to display the data on the erroneous update records and reprocess them, either in real or in test mode and to send waiting update records for processing after a deactivation/activations of the updating and delete update records. Many work processes of the type R/3 system update the database. A database interface is included by the dialog and background work processes, which can directly update the database. However, the update work processes ca also be used for updating the physical database in asynchronous way. If it is asynchronous updating, according to which the transactions are programmed in the ABAP business applications, then in the database commit phase, the transactions pass the update records to the update work processes."
"A subset of Standard SQL that is fully integrated in ABAP is Open SQL statements. Their role is to help you by giving permission to access data irrespective of the database system, which the R/3 installation is using. The Data Manipulation Language (DML) part of the Standard SQL is present in the Open SQL. In other words, it gives you the permission to read (SELECT) and change (INSERT, UPDATE, DELETE) data. In the R/3 system, the tasks of the Data Definition Language (DDL) and Data Control Language (DCL) parts of the Standard SQL are performed by the ABAP dictionary and the authorization system."
In SAP goods are moved in different locations. There are transactions that are responsible for carrying out the Goods Movement. For carrying out goods movement the following need to be understood. Goods Receipt, Goods Issue, Stock Transfer, Transfer Posting.
SAP Goods Receipt:
When goods are received from a vendor or from production and a posting is carried out in SAP, then it is known as a Goods Receipt (GR). Once a Goods Receipt is performed the Ware House Stock is increased.
Goods Issue: Goods going out are termed as goods Issue. Basically it can be of the following type.
Material Issue
Material Withdrawal
Material Consumption
Shipment of Goods
Once the posting is carried out in SAP , Goods Issue results in Reduction of Stock.
Stock Transfer:
The movement of goods internally from one place to another is termed as stock transfer. This can be between Storage Location to Storage Location, Warehouse to Warehouse or between Bins, between same plants or between different plant.
Transfer Posting:
Some examples of Transfer Postings are as follows.
Material to Material, Release from Quality Inspection Stock, Transfer of consignment in companies own stock. A transfer posting may or may not carry out a physical movement of goods.
Plnt Sales order Sales order item Project WBS element Material Production/process order, netwo Plnd order Overall prof
CO46
This is a very good report which gives the status of the orders in progress.
2
Production Order Information System
Production order Material Production plant Planning plant Order type MRP controller Production scheduler Sold-to party Sales order Sales order item WBS element Sequence number Priority Selection profile status Sys. status Work center Plant Selection profile Sys. status Component Plant Storage location Selection profile Sys. status Basic start date Basic finish date Scheduled start date Scheduled finish date Scheduled release date Actual start date Actual finish date Actual release date
COOIS
This report gives complete information on Production Orders.
Production Planning
3
Production Order Cost Analysis
Order Cumulated Limited
KKBC_ORD
This report basically gives a report on Target Cost against the Actual Cost
Production Planning
4
Planning Report
Cost Center
KSBL
This report can be used to view cost center plan
Controlling
5
Profitability Report
Operating Concern Report Variant
KE30
This report can give you profitability at the sales order level. However it is necessary to implement PA module
Always specify your conditions in the Where-clause instead of checking
them yourself with check statements. The database system can then use an index
(if possible) and the network load is considerably less.
Always use Pretty Printer and Extended Program Check before releasing the code.
Do not leave unused code in the program. Comment the code thoroughly. Align the comments and the Code. Follow the SAP Standards and SAP Best Practices guidelines. It’s a good practice to take a dump of the code on your local drive.
