Fetching single record from database

Steps.

1. Go to transaction code SE38.  
2. Enter the program name Z or Y<program name>
3. Select attribute type as Executable program.
4. Click on Save.

Source Code

DATA : WA_MAKT TYPE MAKT.

PARAMETERS : P_MATNR TYPE MAKT-MATNR.

SELECT SINGLE * FROM MAKT INTO WA_MAKT WHERE MATNR = P_MATNR.


WRITE : / WA_MAKT-MATNR ,WA_MAKT-SPRAS , WA_MAKT-MAKTX, WA_MAKT-MAKTX.

Input

Output