SAP ABAP

Select,

Insert,

Delete,

Modify,

Update

Asynchronous Update – The program does not wait for the work process to finish the update. Commit Work.

Synchronous Update – The program wait for the work process to finish the update.

Commit Work and Wait.

AT SELECTION-SCREEN.

SELECT * FROM ZREKHA_DEPTT INTO CORRESPONDING FIELDS OF ITAB

WHERE DEPTNO IN DEPTNO.

ENDSELECT.

If SY-DBCNT = 0.

MESSAGE E000 WITH ‘NO RECORDS FOUND’.

ENDIF.

There are three function module in BDC:

1) BDC_OPEN_GROUP

2) BDC_INSERT

3) BDC_CLOSE_GROUP

Steps for execution Session Method:

1) System

2) Service

3) Batch Input

4) Session

5) Choose Session Name

6) Process

7) Asks for Mode (Display All Screen, Display Errors & Background)

8) Process

There are three modes in Call Transaction:

A – Displays All Screen

E – Display Errors

N – Background Processing

There are four types of screen keywords: Module, Loop, Chain and Field.

There are four specials commands of lists: Write, Uline, Skip and New-Page

Each field of cluster table behaves as tables, which contains the number of entries.

SAP Script layout, text element, and some DDIC objects.

In PAI (Write field statement on field you want to validate, if you want to validate group of fields put in chain and End chain statement.)

AT SELECTION-SCREEN ON VALUE-REQUEST FOR MATERIAL.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

to get material and material group for the plant.

Data in IDOC is stored in segments; the output from IDOC is obtained by reading the data stored in its respective segments.

After executing first write statement in start-of-selection event.

In SE11, one option is available above the fields strip i.e. Data element / direct type.

Transaction Code AL21.

Go to transaction SE11. Then there is one option to copy table. Press that button. Enter the name of the standard table and in the Target table enter Z_table name and press enter.

It checks program execution time in microseconds. When you go to SE30. If you give desired program name in performance file. It will take you to below screen. You can get how much fast is your program.

Call transaction is faster then session method. But usually we use session method in real time...because we can transfer large amount of data from internal table to database and if any errors in a session, then process will not complete until session get correct.

ABAP/4 provides some interactive events on lists such as AT LINE-SELECTION (double click) or AT USER-COMMAND (pressing a button). You can use these events to move through layers of information about individual items in a list.

Drill down report is nothing but interactive report...drilldown means above paragraph only.