Efficient way of searching Exits by Tx- SMOD & SE11

Step1.  Go to Tx- SMOD.

Step2. To find Enhancement press F4 button. From the POP Up screen, Click on the + button for additional selection . Here U can choose what type of enhancement U r searching.

Step3. Let's choose S - screen enhancement.

\
Step4. All screen enhancements are appeared.

Step5.  Go to Tx: SE11 .All Enhancements provided by SAP stored in the table: MODSAP.

Step6. press F4 against TYP field and from the domain fixed value search option choose- S.

Step7. Execute it.

 
Step8. It shows all Screen enhancements.

----------------------------------------------------------------------------------------------------------------------------------

LDB: Logical data Base(Multiple Node Hierarchy)

Logical database with multilevel hierarchy provides selected filtered records based on the data dependency.

-------------------------------------------------------------------------------------------------------------------------------
Step1. The two tables SCARR & SPFLI are dependent. based on the CARRID value let's get the records from SCARR  table and based on the records from SCARR get all the dependent records from SPFLI table.

Step2. Go To Tx- SE36 or SLDB. Provide a LDB name, select Structure radio button and click on Create button.

Step3. Provide a short text and Create(F5).

Step4. Provide the first NODE name as SCARR &  click on Create button.

Step5. We create the node hierarchy, select the first node SCARR and click on the Create button

Step6. This screen appears.

Step7. Change the value to SPFLI and Hierarchy Under SCARR and Create it.

Step8. We have creates the two level node hierarchy.  Now click on Selections Button.

Step9. YES to continue.

Step10. Select all the check boxes and click on Transfer button.

Step11. The commented code created automatically.

Step12. Change the commented code as per requirement and provide a select-options name S_CARRID . activate it and go back.

Step13. To define the data selection process, click on the Source Code button.

Step14. YES to continue.

Step15. Double click on the second include.

Step16. Click on the include corresponding to node SCARR.(first include)

Step17. Here we find some commented code.

Step18. Change the commented code and activate it. Go back.

Step19. Select the Second Include for the node SPFLI.

Step20. Some commented code appears automatically.

Step21. Change the commented code as per requirement. Activate it and go back.

Step22. Create a report in SE38 and assign the above created LDB to the report.

Step23. Put the below code and execute it.

Step24. click on F8 button. This selection-screen appears from the LDB.

Step25. The below O/P appears:

Step26. Go to the third include in the LDB .

Step27. There is an INIT subroutine which triggers before the selection screen is called. Assign some initial value to the selection-screen element.

Step28. Execute the report program and we find the initial value to the selection-screen element.

----------------------------------------------------------------------------------------------------------------------------------------

LDB: Logical data Base(Single Node)

Logical Data Base(LDB):  Logical data base can be created in Tx- SLDB or SE36 . The advantage of using LDB is that it provides an automatically selection screen and the data selection process when added to a report program. some events that occurs in LDB are INIT, PUT & GET. Once the LDB is created, it can be added to a report program in the Attributes section or inside the program by calling the standard function module 'LDB_PROCESS'. 
-----------------------------------------------------------------------------------------------------------------------------------

Step1. These are the entries present in SCARR table.

Step2. To Create LDB go to TX- SE36 or SLDB.

OR

Step3. Provide a name ans select structure radio button and then click on Create button.

Step4. Provide short text and continue.

Step5. So we need to create an LDB on SCARR table, mention the root node as : SCARR , text and Under Node type SCARR. The root node name and the database table name should be same. At last click on Create button.

Step6. So node SCARR is created. Now lets create a selection screen element. So click on the Selections button.

Step7. YES to continue.

Step8. Select both the check boxes and click on Transfer.

Step9. Here some commented code appears for the Select-option statement based on the primary key of the table. Un-comment the line and provide a select-option name. Here we have provides name as : S_CARRID. Activate it and go back. 

Step10. Node is defined, Selection-screen is defined. For the data selection process based on the selection screen elements, click on the Source code button.

Step11.  YES to continue.

Step12. Some automatically created includes. Double click on the second include.

Step13. For the node SCARR selection process, double click on the first include.

Step14. the below screen appears with some commented code. And also PUT event.

Step15. Un comment the code and put a select and endselect statement. Activate and go back. 

Step16. Go to Tx- SE38 and create a report.

Step17. Under the attributes section, mention the above created LDB name and continue.

Step18. Just write the below code and execute the report. Here we use the GET event. The NODES statement triggers the LDB and The PUT events forwards the data from the LDB progrm to the GET event of the report.

Step19. The selection appears as a result of the LDB. Execute it.

Step20. All the records are transferred from the LDB PUT event to the GET event of the report & the records are displayed.

Step21. Execution with single input.

Step22.O/P.

Step23. Execution with range I/P.

Step24. O/P.

---------------------------------------------------------------------------------------------------------------------------------