User Exit for Delivery (STO and SO)

Inorder to customize the behavior of delivery functions we need to write codes in the following modules:

Program name: SAPMV50A
Include File: MV50AFZ1

SAP .NET Connector or SAPLink Logon Problem

Always use SAP logon details such as client, userid, password, and language in all capital letter when using .NET to connect to SAP using .NET Connector or SAPLink.

Tools provided for ABAP Performance Analysis

Courtesy: thespot4sap

Following are the different tools provided by SAP for performance analysis of an ABAP object

1. Run time analysis transaction SE30

This transaction gives all the analysis of an ABAP program with respect to the database and the non-database processing.

2. SQL Trace transaction ST05

The trace list has many lines that are not related to the SELECT statement in the ABAP program. This is because the execution of any ABAP program requires additional administrative SQL calls. To restrict the list output, use the filter introducing the trace list.

The trace list contains different SQL statements simultaneously related to the one SELECT statement in the ABAP program. This is because the R/3 Database Interface - a sophisticated component of the R/3 Application Server - maps every Open SQL statement to one or a series of physical database calls and brings it to execution. This mapping, crucial to R/3s performance, depends on the particular call and database system. For example, the SELECT-ENDSELECT loop on the SPFLI table in our test program is mapped to a sequence PREPARE-OPEN-FETCH of physical calls in an Oracle environment.

The WHERE clause in the trace list's SQL statement is different from the WHERE clause in the ABAP statement. This is because in an R/3 system, a client is a self-contained unit with separate master records and its own set of table data (in commercial, organizational, and technical terms). With ABAP, every Open SQL statement automatically executes within the correct client environment. For this reason, a condition with the actual client code is added to every WHERE clause if a client field is a component of the searched table.

To see a statement's execution plan, just position the cursor on the PREPARE statement and choose Explain SQL. A detailed explanation of the execution plan depends on the database system in use.

Configure Client Characteristics

Transaction Code SCC4

System Message Class Maintenance

Transaction code SE91 - Message Maintenance

Message allow you to communicate with the users from programs.

Material Base Unit of Measure, Order Unit and Issue Unit

If a material base unit of measure is wrongly entered it is difficult to change that when stock exists for that material.

Various alternatives can be:

1) Transfer the stock to make it zero, change the base UOM, make the stock available

2) Block that material and create a new material (TCode MM02, on the "Basic data view" change "x-plant matl status" to "01")

3) Treat various unit of measures as follows:

(i) Create an alternative unit of measure (which the base unit was supposed to be), TCode MM02, on the "Basic data view" click on "Unit of measure" from the toolbar. Create the required unit line with appropriate conversion rate with the base unit.
(ii) Change the "Order unit" on the "Purchasing view" to this alternative unit.
(iii) And change the "Issue unit" on the "Plant/Storage" view to this alternative unit.
(iv) These changes are plant specific so carryout the changes for all the plants.
(v) When entering order, or issuing materials change the default base unit to this alternative unit to reflect the intended quantity.

CLEAR Internal Table: All Entries vs. Header Entry

When CLEAR itab references an internal table itab with a header line, it only resets the sub-fields in the header entry to their initial values. The individual table entries remain unchanged.

To delete the entire internal table together with all its entries, you can use CLEAR itab[] or REFRESH itab.

Maintain Consolidation Transaction Types

IMG path (SPRO):

Enterprise Controlling / Consolidation / Integration: Preparation for Consolidation / Preparation related to all Consolidation Types / Transaction Type Account Assignments / Maintain Trnsaction Types for Consolidation.

Transaction code: OC08

Transfer Material from Block to Unrestricted Stock

Transaction code: MB1B
Movement Type: 343

Maintain Transaction

Use transaction code SE93 to maintain SAP transactions

Validation and Substitution

Validation of Accounting Documents - Transaction OB28
Substitution in Accounting Documents - Transaction OBBH

Cancel Check Payment

Use Transaction code FCH8 to cancel check payment

Block Material in Sales Order and Inventory

To block a material, go to the "Basic data" view of the material,there in the genral data you have "X-plant material status".

Also in "Cost estimate" view of the material you have "Plant Specific Material status". Use the options available to block the material in these two views.

The material will be blocked in sales order and inventory.

Transport Management System to Import your SAP Transport Requests.

Following is a quick guide for importing transport requests into an SAP system:

a) Run transaction STMS from within the target system (you can also run from the source system)
b) Click on "Import Overview" toolbar icon (F5)
c) Select the import queue for the target system
d) Click on Refresh (F5)
e) Go down the list and click on "Adjust"f) Select the transport requests
f) Choose "Import selected transport" (Ctrl+F4)
g) Mention the Client of the target system

And you are done.