Step-by-Step Procedure to create the logical data base(LDB):
- Enter the transaction code SE36.
- Enter the LDB name starting with Y or Z and click on create.
- Enter the short description click on “Create”
- Enter the package name and click on “Save”.
- Enter the root table name and short description and click on create. NOTE:: Node name and DB table name must be same.
- Then you will see the following screen layout. To insert other nodes select the node first and right click then select “Insert node”.
- Provide the DB table name, short text and then click on “Create New Node”. Then click on “Save”.
- You will see the following screen. From the application tool bar click on “Selections”.
- Then it will ask whether the LDB is generated from the structure? Click “Yes”.
- Then again it will ask whether you want to define the “search help”? click “no”. then you will see the following screen. Select the database tables for which free selections are to be generated. Click on “Transfer”.
- Un comment the select-options and replace “?” with the suitable database table name. Then Save and activate. Then click on “back”(F3).
- Click on “ Source code” button from the application tool bar
- Then you will see the following screen
- Double click on TOP include. Save and active and then come back(F3).
- Double click on next include. Then you will see the following screen.
- if you are created the LDB using n number of database tables then you will get n number of includes(DB<p_name>N001, DB<p_name>N002 ,…….. DB<p_name>N00n).
- Double Click the first node. And insert the following code before the PUT statement .
Select * from zsemp where eno in eno.
Put zsemp.
Endselect.
Then Save and activate.
- Then double click on second node and enter the following code before the put statement.
Select * from zsdept where edept = zsdept-edept and edept in edept.
Put zsdept.
Endselect.
- That’s completes the creation of Logical Data Base.
- Now using this LDB we have to write the program.
- For that create any program of Type 1/E (Report Program).
- Enter the transaction code SE38. Provide the program name and then click on “Create”. Then Enter the short description, select the type of the program, Logical database table name and then click on “Save”.
- Enter the following code.
nodes: zsemp, zsdept.
get: zsemp, zsdept.
write: / zsemp-eno, zsemp-ename, zsemp-esal, zsemp-edept, zsdept-edes,
zsdept-epf.
- Save, Check, activate and execute the program.
