Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

customer exits

Former Member
0 Kudos
346

hi experts,

can u give me sm information regarding...customer exits...??

thanx and regards

kanika

1 ACCEPTED SOLUTION

Former Member
0 Kudos
133

hi,

SAP has developed its various modules with standards, which are broadly practiced all over. But yet the requirement of customers differs from place to place. In this scenario it becomes imperative to modify SAP objects to suit the customer needs.

Hence SAP allows you to add your own functionality to SAPu2019s standard business applications without having to modify the original applications. This can be done in four ways :

Customizing

Enhancement

Modification

Custom Development

Customer Exits

The R/3 enhancement concept allows you to add your own functionality to SAPu2019s

standard business applications without having to modify the original applications.

SAP creates customer exits for specific programs, screens, and menus within

standard R/3 applications. These exits do not contain any functionality. Instead,

the customer exits act as hooks. You can hang your own add-on functionality onto

these hooks.

Main Program

Call Customer-Function u2018XXXu2019.

Include Program

Advantages

They do not impact SAP support to standard SAP source code.

They are not affected by SAP upgrades.

Disadvantages

Customer exits are not available for all programs and screens found in the SAP System. You can only use customer exits if they already exist in the SAP System.

Types of Customer Exits

There are three types of customer exits:

Menu Exit:Menu exits add items to the pull down menus in standard SAP applications. you can use these menu items to call up our own screens or to trigger entire add-on applications.

Screen Exit:Screen exits add fields to screens in R/3 applications. SAP creates screen exits by placing special sub screen areas on a standard R/3 screen and calling a customer sub screen from the standard screenu2019s flow logic.

Function Module Exit:Function module exits add functions to R/3 applications. Function module exits play a role in both menu and screen exits.SAP application calls function module exits by writing calls to customer functions into the source code of standard R/3 programs. These calls have the following syntax:

CALL CUSTOMER-FUNCTION u2018001u2019.

Find out Enhancement - SMOD

Go to transaction SMOD

From top menu select Utilities-->Find

Enter the selection text such as u201Corder confirmationu201D and execute.

It will list down all related exits .

Go to SE93

Enter the transaction name

Note down the package name

Go to SMODUtilitiesFind (Same screen will appear as given in last slide)

Enter the package name and it will list down all related enhancements.

Go to transaction SE84

Select Enhancement  customer exits  Enhancements

Now you can search the exits as explained using SMOD .

5 REPLIES 5

Former Member
0 Kudos
133

Main points to be noted are,

1) Customer exits are always implemented using FM and not subroutines

2) The Transactions

Projects - CMOD

Enhancement - SMOD

3) The beauty of CMOD is - you can deactivate the entire Project ( including multiple customer exits ) just by clicking deactivate button.

These are my understanding on Customer exits. Otherwise all the points for user exits applies to customer exits also

Cheers

Kothand

Former Member
0 Kudos
134

hi,

SAP has developed its various modules with standards, which are broadly practiced all over. But yet the requirement of customers differs from place to place. In this scenario it becomes imperative to modify SAP objects to suit the customer needs.

Hence SAP allows you to add your own functionality to SAPu2019s standard business applications without having to modify the original applications. This can be done in four ways :

Customizing

Enhancement

Modification

Custom Development

Customer Exits

The R/3 enhancement concept allows you to add your own functionality to SAPu2019s

standard business applications without having to modify the original applications.

SAP creates customer exits for specific programs, screens, and menus within

standard R/3 applications. These exits do not contain any functionality. Instead,

the customer exits act as hooks. You can hang your own add-on functionality onto

these hooks.

Main Program

Call Customer-Function u2018XXXu2019.

Include Program

Advantages

They do not impact SAP support to standard SAP source code.

They are not affected by SAP upgrades.

Disadvantages

Customer exits are not available for all programs and screens found in the SAP System. You can only use customer exits if they already exist in the SAP System.

Types of Customer Exits

There are three types of customer exits:

Menu Exit:Menu exits add items to the pull down menus in standard SAP applications. you can use these menu items to call up our own screens or to trigger entire add-on applications.

Screen Exit:Screen exits add fields to screens in R/3 applications. SAP creates screen exits by placing special sub screen areas on a standard R/3 screen and calling a customer sub screen from the standard screenu2019s flow logic.

Function Module Exit:Function module exits add functions to R/3 applications. Function module exits play a role in both menu and screen exits.SAP application calls function module exits by writing calls to customer functions into the source code of standard R/3 programs. These calls have the following syntax:

CALL CUSTOMER-FUNCTION u2018001u2019.

Find out Enhancement - SMOD

Go to transaction SMOD

From top menu select Utilities-->Find

Enter the selection text such as u201Corder confirmationu201D and execute.

It will list down all related exits .

Go to SE93

Enter the transaction name

Note down the package name

Go to SMODUtilitiesFind (Same screen will appear as given in last slide)

Enter the package name and it will list down all related enhancements.

Go to transaction SE84

Select Enhancement  customer exits  Enhancements

Now you can search the exits as explained using SMOD .

Former Member
0 Kudos
133

Hi,

SAP has developed its various modules with standards, which are broadly practiced all over. But yet the requirement of customers differs from place to place. In this scenario it becomes imperative to modify SAP objects to suit the customer needs.

Hence SAP allows you to add your own functionality to SAPu2019s standard business applications without having to modify the original applications. This can be done in four ways :

Customizing

Enhancement

Modification

Custom Development.

coutomer exits are:

The R/3 enhancement concept allows you to add your own functionality to SAPu2019s

standard business applications without having to modify the original applications.

SAP creates customer exits for specific programs, screens, and menus within

standard R/3 applications. These exits do not contain any functionality. Instead,

the customer exits act as hooks. You can hang your own add-on functionality onto

these hooks.

type of customee exits:

1. menu exit

2. screen exit

3. Function Module Exit

transaction used to create and implement customer exits:

SE81

SE84

SMOD

and SE30 for run time analysis.

Thanks & Regards.

Rajesh Kumar

Former Member
0 Kudos
133

Hi Chopra,

Check below links. It gives detailed explanation.

http://help.sap.com/erp2005_ehp_03/helpdata/EN/c8/1975e643b111d1896f0000e8322d00/frameset.htm

http://help.sap.com/erp2005_ehp_03/helpdata/EN/c8/1975cc43b111d1896f0000e8322d00/frameset.htm

http://help.sap.com/erp2005_ehp_03/helpdata/EN/4a/5b75387be80518e10000009b38f889/frameset.htm

Point to Remember: Any exit functionality is to midify SAP provided functinality to suit the business needs.

eg: User exits - To implement custom checks, Messages etc.

Menu exits - To add New menu items

Screen exits - To modify standard screens.

User exit: A user exit is a three character code that instructs the system to access a program during system processing.

SXX: S is for standard exits that are delivered by SAP. XX represents the 2-digit exit number.

UXX: U is for user exits that are defined by the user. XX represents the 2-digit exit number

Customer exit: The R/3 enhancement concept allows you to add your own functionality to SAPu2019s standard business applications without having to modify the original applications. SAP creates customer exits for specific programs, screens, and menus within standard R/3 applications. These exits do not contain any functionality. Instead, the customer exits act as hooks. You can hang your own add-on functionality onto these hooks.

1. Previously there were only user-exits.

2. Then came the concept of customer-exits.

3. user exits were nothing but subroutines

FORM/PERFORM

called from standard programs.

4. The FORM defintion was placed inside

an empty include file.

5. So It was called EVERYTIME.

and we need to MODIFY/REPAIR the

standard include .

6. Then it came with concept of customer-exit

7. It consists of calling a FUNCTION MODULE,

which is called only if

the user-exit is ACTIVATED (other wise not called)

In this case, the code in put inside

a pre-defined Z include.

8. Functionality of both is same, howerver

we can note the following important differences

a) Customer exit is called only if activated.

(hence, it does not waste resources)

b) in customer exit, REPAIR does not happen

to the standard include.

Exits are basically the hooks whcih SAP has provided to add your own code.

please can anyone give me exact user/customer exits, which will be called after saving the document...

document is saved after the below routine..

SAPMV45A>MV45AF0C_CHANGE_DOCUMENT_CREAT>CALL FUNCTION 'SD_XVBLB_CHANGES'

Transaction Code - VA02 Change Sales Order

Exit Name Description

SDTRM001 Reschedule schedule lines without a new ATP check

V45A0001 Determine alternative materials for product selection

V45A0002 Predefine sold-to party in sales document

V45A0003 Collector for customer function modulpool MV45A

V45A0004 Copy packing proposal

V45E0001 Update the purchase order from the sales order

V45E0002 Data transfer in procurement elements (PRreq., assembly)

V45L0001 SD component supplier processing (customer enhancements)

V45P0001 SD customer function for cross-company code sales

V45S0001 Update sales document from configuration

V45S0003 MRP-relevance for incomplete configuration

V45S0004 Effectivity type in sales order

V45W0001 SD Service Management: Forward Contract Data to Item

V46H0001 SD Customer functions for resource-related billing

V60F0001 SD Billing plan (customer enhancement) diff. to billing plan

No of Exits: 15

These r the main differences between user exits and customer exits

1) user exits r subroutines where as customer exits r function modules

2) user exits r not upgraded where as customer exits r will upgrade

3) customer exits r used for creating and additional fields or menu items to stadard tcode where as user exits r used for enabling or disabling the fields on the standrd screen or concatenating the key fields,it is not used adding an additional componenats to stadard tcode

4) customer exits r reusable where as user exits r not reusable.

1. Userexits --> implemented in subroutines -


> modifications --> fails in upgrades.

2. Customer exits --> implemente using func modules --> enhancement --> doesnot fail in upgrades

Customer exits: *

Implemented as Function Modules within z includes. Anybody can change it and no access key is required.

User Exit:

Implemented as subroutines within includes (any include except y or z includes). You need access for the specific include and then you can any subroutine (user exit) within that Include.

BADIs are the enhanced version of user exits where the same logic is implemented via classes and object (OOP)

Enchancement point is the latest once introduces with ECC6.0 . Not very sure about that but you can change it without any access key.

Step by step procedure for creating Field Exits

There are eight steps to creating a field exit:

Step 1: Determine Data Element

Step 2: Go To Field Exit Transaction

Step 3: Create Field Exit

Step 4: Create Function Module

Step 5: Code Function Module

Step 6: Activate Function Module

Step 7: Assign Program/Screen

Step 8: Activate Field Exit

Step 1: Determine Data Element

u2022 Before you can begin adding the functionality for a field exit, you must know the corresponding data element.

u2022 An easy way to determine the data element associated to a particular screen field is to:

Go the appropriate screen.

Position the cursor in the appropriate field.

Press u2018F1u2019 for field-level help.

Click on the u2018Technical infou2019 pushbutton (or press u2018F9u2019) on the help dialog box.

On this Technical Information dialog box, the data element will be specified if the field is 'painted' from the ABAP/4 Dictionary.

Step 2: Go To Field Exit Transaction

u2022 The transaction to create field exits is CMOD.

u2022 You can use the menu path Tools -> ABAP/4 Workbench -> Utilities -> Enhancements -> Project management.

u2022 From the initial screen of transaction CMOD, choose the Text enhancements -> Field exits menu path.

u2022 After choosing this menu path, you will be taken to the field exits screen. From here, you can create a field exit.

NOTE : Even though you use transaction CMOD to maintain field exits, you do not need to create a project to activate field exits.

Step 3: Create Field Exit

u2022 From the field exit screen of transaction CMOD, choose the Field exit -> Create menu path.

u2022 After choosing this menu path, a dialog box will prompt you for the appropriate data element .

u2022 Enter the data element name and click the u2018Continueu2019 pushbutton.

u2022 Now, you will be able to create the function module associated to the data elementu2019s field exit.

Step 4: Create Function Module

u2022 You will automatically be taken to the Function Library (SE37) after entering a data element name and clicking the u2018Continueu2019 pushbutton.

u2022 In the u2018Function moduleu2019 field, a function module name will be defaulted by the system based on the data element specified. This name will have the following convention:

FIELD_EXIT_

u2022 You can add an identifier (an underscore followed by a single character ).

u2022 The first function module for a data elementu2019s field exit must be created without an identifier.

u2022 To create the function module, click on the u2018Createu2019 pushbutton, choose menu path Function module -> Create, or press u2018F5u2019.

u2022 After choosing to create the function module, you will get the warning: "Function module name is reserved for SAP". This message is just a warning so a developer does not accidentally create a function module in the field exit name range. By pressing u2018Enteru2019, you will be able to go ahead and create the function module.

u2022 Before coding the function module, you will have to specify the function modules attributes -- function group, application, and short text.

Step 5: Code Function Module

u2022 From the function moduleu2019s attributes screen, click on the u2018Source codeu2019 pushbutton or choose the Goto -> Function module menu path to the code of the function module.

u2022 Here you will add your desired functionality for the field exit.

u2022 Remember that field exitu2019s function module will have two parameters -- one importing parameter called "INPUT" and one exporting parameter called "OUTPUT". These parameters will be set up automatically by the system.

u2022 You must remember to assign a value to the OUTPUT field. Even if the value does not change, it must be moved from the INPUT field to the OUTPUT field.

Step 6: Activate Function Module

u2022 After coding the function module, you must remember to activate it.

u2022 Use the Function module -> Activate menu path to activate the function module.

u2022 At this point, you can return to the field exit transaction.

u2022 You should be able to 'green arrow' back to this transaction.

u2022 When you return to the field exit transaction, you will see an entry for the newly created field exit.

u2022 At this point, the field exit is global. That is, it applies to all screens that use a particular data element. On any screen that uses the data element, the corresponding field exit function module will be triggered, once it is active.

u2022 Also, the field exit will not be triggered yet because it is inactive.

Step 7: Assign Program/Screen

u2022 This step is only needed if you want to make a field exit local.

u2022 To make a field exit local, select the field exit and click on the u2018Assign prog./screenu2019 pushbutton.

u2022 In the dialog box , indicate the appropriate program name and screen number.

This information indicates that the field exit is local to the specified screen in the specified program.

u2022 In the dialog box, you determine which function module gets executed for the field exit by specifying the identifier in the u2018Fld. Exitu2019 field.

u2022 If this field is left blank, the function module triggered will be 'FIELD_EXIT_'.

u2022 If a single-character identifier is entered into the field, the function module triggered will be 'FIELD_EXIT__'.

Step 8: Activate Field Exit

u2022 The field exit must be active for it to be triggered by the system.

u2022 Activate the field exit by choosing the Field exit -> Activate menu path.

u2022 After assigning the field exit to a change request, its status will change to u2018Activeu2019 and it will be triggered automatically on the appropriate screen(s).

NOTE : In order to activate the field exit the profile parameter abap/fieldexit = YES must be set on all application servers

Step by step procdure for creating Menu Exits

PART A: Search for the menu exit.

1. A menu exit is a way to add a menu item and corresponding functionality to the menu bar of an SAP transaction. The first step is to navigate to the screen where you want to attach menu exit.

2. Go to the menu painter of that screen through system -> status and look for function codes in the menu bar that start with a plus sign. These are the menu's which can be enhanced.

PART B: Attaching your own menu.

3. Run transaction YSMD (available in 3.1G) to identify the Enhancement and the Component which contains that exit or search it through transaction SMOD.

Note : All menu exits will have the function code name with the plus sign as the last four characters of the component.

4. Include the Enhancement in your own project through transaction CMOD.

5. Go to Enhancement Components a

And double click on the component name to give your own text to the menu item.

6. Activate the project.

At this point the menu item will appear, but it will have no functionality.

PART C: Adding functionality to the menu item.

The new menu item can have functionality in four ways:

predefined functionality by SAP programmer

transaction code

program exit

area menu'

7. You do not have control over the first method of functionality to a menu exit. In some cases, SAP programmers will have predefined code that is executed once you activate the menu exit.

8. If the menu exit function code is a type u201CTu201D function code, you will need to create a transaction code to add functionality to the new menu item. (To find the type of the function code, just double click on the function code in the GUI screen) The transaction code should have the same name as the function code (remember: it will start with a plus sign). The transaction code you create can either call an online (module pool) program or a report. You can create a transaction code from the object browser.

9. If the functionality for a menu exit is to be placed in a program exit, the menu exit and corresponding program exit will belong to the same enhancement.

Examining the enhancement that contains the menu exit can give you an initial indication that a program exit is needed to add functionality. You can code the program exit by double clicking on the component in your project or examining the SAP code to find the corresponding check of the function code triggered. For the appropriate function code, you will see a u201CCALL CUSTOMER-FUNCTIONu201D statement.

10. The last way of adding functionality is through area menuu2019s. An area menu is a transaction that serves as a collection point for several other transactions. Unlike other dialog transactions, area menus do not have underlying programs, hence, you cannot append your own functions to them.

No screens accompany an area menu. An area menu has only one title and status, both of which are assigned by the system. Area menus allow you to create menus containing functions that are customized for a particular function in your company. Creating an area menu is similar to creating a standard menu. However, instead of specifying functions for menu options you specify transaction codes.

To navigate to area menuu2019s choose Development -> Other tools -> Area menus. The name of the area menu should be same as that of the function code of the menu exit.

Step by step procedure for creating Screen Exits

PART A: Search for the screen exit.

1. A screen exit is a way to add a sub-screen and corresponding functionality to an SAP transaction. The first step is to navigate to the screen where you want to attach menu exit.

2. Go to the field list of that screen through system -> status or F1 -> Technical details and look for fields that have subscreen as the field type for that particular screen. These are the area's on the main screen which can be enhanced.

PART B: Creating your own subscreen.

3. Identify the enhancement and its component that has the provision for creating the screen exit for that particular screen.

Note A: To know more about how to identify the enhancement, refer to the document on Locating User Exits.

Note B: All SAP provided subscreenu2019s may not have the scope for enhancement. There are a limited number of transactions which has scope for screen exit. Refer to Annexure A for details.

4. Include the Enhancement in your own project through transaction CMOD.

5. Go to Enhancement Components and double click on the component name.

6. It will take you to the screen attributes for that particular subscreen.

u2022 The screen type should be subscreen.

u2022 Maintain the size of the subscreen through Lines/Columns attribute. This should correspond to the size of the subscreen mentioned in the main SAP screen.

u2022 The development class for the subscreen should be the development class for the project.

7. Create the subscreen using the fullscreen editor.

8. You can add your own modules in the subscreenu2019s flow logic. However, one has to be careful regarding data transfer between the main screen and the subscreen. For more details refer to R/3 On-line Help.

9. Generate the screen.

PART C: Activating the project

10. Use the back button to navigate back to the project enhancement main screen.

11. Activate the project.

Locating User Exits

Before you can add functionality to a SAP system, you need to be able to locate the appropriate user exits. SAP has provided around 2000 user exits.

Searching from transaction CMOD

Searching from the Application Hierarchy

Making your own customized search

Keep in mind that you must first search for an enhancement. Once you find an enhancement, you can display its components -- the actual user exits. Then you need to include the enhancement containing the required user exit as a component in your own project.

Method #1: Using Transaction CMOD

u2022 Transaction CMOD contains search functionality to help locate enhancements.

u2022 Selecting the "Utilities -> SAP enhancements" menu path in transaction CMOD will take you to an enhancement selection screen .

u2022 You can limit the search for enhancements based on:

Enhancement name

Development class

u2022 After clicking on the u2018Executeu2019 pushbutton (or u2018F8u2019) on the selection screen, the system will display a listing of the development classes that contain enhancements (see graphic above).

u2022 From this listing, you can double-click a development class to display its enhancements.

u2022 If you have clicked on the u2018Display componentsu2019 pushbutton on the selection screen (see graphic on previous page), the components of each enhancement will automatically be displayed.

Remark: To use this search method one must either know the part of the enhancement name or the development class. But if one looks at SAPu2019s naming convention for user exits (see note below), the screen numbers/program names/ function codes/etc are contained in the components name and there is no scope for that in selection options. Also one cannot restrict the search to only one type of exit.

Method #2: Using SAP Application Hierarchy

u2022 Selecting the "Overview -> Applic. hierarchy -> SAP" menu path in the ABAP/4 Development Workbench will take you to a listing of all standard SAP applications and components .

u2022 To locate a user exit for a particular application, follow these steps

from the SAP Application Hierarchy:

u2022 Select the appropriate application by single clicking on it.

u2022 Choose the "Edit Sel./desel. subtree" menu path.

u2022 Click on the u2018Repository Infosys.u2019 pushbutton.

u2022 This will take you to the ABAP/4 Repository Information System.

u2022 Double click on the u2018Environmentu2019 branch.

u2022 Double click on the u2018Customer enhancementu2019 branch.

u2022 Double-click on the u2018Customer exitu2019 branch.

u2022 This will take you to the customer exit (or enhancement) selection screen with the appropriate development class for the application selecting on the Application Hierarchy.

u2022 Click on the u2018Executeu2019 pushbutton.

u2022 This will take you to a listing of all enhancements that meet the selection criteria.

From this listing, you can display the components of each enhancement and the documentation. You will be taken automatically to transaction SMOD from the ABAP/4 Repository Information System.

Remark: To use this one must have knowledge about the application hierarchy to which that particular enhancement belongs. Also one has to explode individual enhancements to identify weather the component is contained in that enhancement.

Like previous method, there is no scope for selection option on the components name.

Method #3: Writing a small report program

The details about projects, enhancements and components are contained in two SAP tables:

MODSAP: containing enhancement name, type of exit and component

MODACT: containing project name and enhancements

Thus by writing a report program to retrieve data from these two tables, you can customize your search requirements. Code for one such sample program is attached in annexure A and the corresponding transaction code to execute this program is YSMD .

Using this you can list all components that match a particular string like the program name or the function code as well as search for only one type of exit.

NOTE: SAPu2019s naming convention for user exits-

u2022 Program/Function exits : EXIT_AAAAAAAA_nnn where

AAAAAAAA stands for the program name which contains the exit and

nnn is a SAP assigned number starting from 001

u2022 Menu exits : AAAAAAAA+XXX where

AAAAAAAA stands for the program name which contains the exit and

+XXX is the name of the function code contained in the menu item

u2022 Screen Exits : AAAAAAAA_nnnn_BBBBBBBB_CCCCCCCC_mmmm where

AAAAAAAA : calling program name

nnnn : calling screen number

BBBBBBBB : area

CCCCCCCC : called program name

mmmm : called screen number

Source Code to find User Exits 1

************************************************************************

u2022 REPORT YSMOD2

*

u2022 SELECTION TEXTS : INPUT1 -


> Enter search term for Trxn.

u2022 INPUT2 -


> Enter type of exit

************************************************************************

REPORT YSMOD2 .

TABLES: MODSAP, MODACT, TSTC.

PARAMETERS: INPUT1 LIKE TSTC-TCODE DEFAULT ' ',

INPUT2 LIKE MODSAP-TYP DEFAULT ' '.

DATA: SEARCH1(6),

SEARCH2(3),

SEARCH3 LIKE MODSAP-MEMBER.

DATA : FIRST_ROW VALUE 'Y'.

CONCATENATE: '%' INPUT1 '%' INTO SEARCH1,

'%' INPUT2 INTO SEARCH2.

SELECT * FROM TSTC WHERE TCODE LIKE SEARCH1.

FIRST_ROW = 'Y'.

CHECK TSTC-PGMNA NE SPACE.

CONCATENATE '%' TSTC-PGMNA '%' INTO SEARCH3.

SELECT * FROM MODSAP WHERE TYP LIKE SEARCH2

AND MEMBER LIKE SEARCH3.

SELECT SINGLE * FROM MODACT WHERE MEMBER = MODSAP-NAME.

IF FIRST_ROW EQ 'Y'.

WRITE: /0 TSTC-TCODE, 6 TSTC-PGMNA, 16 MODSAP-NAME, 32 MODSAP-TYP,

45 MODSAP-MEMBER, 70 MODACT-NAME.

FIRST_ROW = 'N'.

ELSE.

WRITE: /16 MODSAP-NAME, 32 MODSAP-TYP, 45 MODSAP-MEMBER, 70 MODACT-NAME.

ENDIF.

CLEAR : MODSAP, MODACT.

ENDSELECT.

IF SY-SUBRC NE 0.

WRITE : /0 TSTC-TCODE, 6 TSTC-PGMNA, 30 'No exits found'.

ENDIF.

CLEAR TSTC.

ENDSELECT.

END-OF-SELECTION.

CLEAR: SEARCH1, SEARCH2, SEARCH3.

Source Code to Locate User Exits

************************************************************************

u2022 REPORT YSMOD

*

u2022 SELECTION TEXTS : INPUT1 -


> Enter search term for Enhancmn

u2022 INPUT2 -


> Enter type of exit

u2022 INPUT3 -


> Enter search term for componen

************************************************************************

REPORT YSMOD .

TABLES: MODSAP, MODACT.

PARAMETERS: INPUT1 LIKE MODSAP-NAME DEFAULT ' ',

INPUT2 LIKE MODSAP-TYP DEFAULT ' ',

INPUT3 LIKE MODSAP-MEMBER DEFAULT ' '.

DATA: SEARCH1 LIKE MODSAP-NAME,

SEARCH2(3), " like modsap-typ,

SEARCH3 LIKE MODSAP-MEMBER.

CONCATENATE: '%' INPUT1 '%' INTO SEARCH1,

'%' INPUT2 INTO SEARCH2,

'%' INPUT3 '%' INTO SEARCH3.

SELECT * FROM MODSAP WHERE NAME LIKE SEARCH1

AND TYP LIKE SEARCH2

AND MEMBER LIKE SEARCH3.

SELECT SINGLE * FROM MODACT WHERE MEMBER = MODSAP-NAME.

WRITE: /10 MODSAP-NAME, 30 MODSAP-TYP, 45 MODSAP-MEMBER, 70 MODACT-NAME.

CLEAR : MODSAP, MODACT.

ENDSELECT.

IF SY-SUBRC NE 0.

WRITE : /'Not found'.

ENDIF.

END-OF-SELECTION.

CLEAR: SEARCH1, SEARCH2, SEARCH3.

Easiest way is to create a subscreen and embed this in your dynpro.

report ztest_0001 .

tables: mara.

Custom Selection Screen 1010

selection-screen begin of screen 1010 as subscreen.

selection-screen begin of block b1 with frame title text-001.

parameters: p_rad1 radiobutton group grp1 default 'X',

p_rad2 radiobutton group grp1,

p_rad3 radiobutton group grp1.

select-options: s_matnr for mara-matnr,

s_matkl for mara-matkl,

s_mtart for mara-mtart.

selection-screen end of block b1.

selection-screen end of screen 1010.

start-of-selection.

call screen 100.

&----


*& Module STATUS_0100 OUTPUT

&----


module status_0100 output.

SET PF-STATUS 'xxxxxxxx'.

SET TITLEBAR 'xxx'.

endmodule.

&----


*& Module USER_COMMAND_0100 INPUT

&----


module user_command_0100 input.

endmodule.

Screen screen 100 with a subscreen area called "subscreen_1010"

Screen Flow Logic follows

*process before output.

*

module status_0100.

*

call subscreen subscreen_1010 including sy-repid '1010'.

*

*process after input.

*

call subscreen subscreen_1010 .

*

module user_command_0100.

Checkout the FM`S in SE37

/BKC/RFC_GET_TABLE_SIZE

/SDF/INF_TOP_TABLES

/SDF/MSS_TEXT_IMAGE_FIELDS

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_DB6

MSS_GET_DB_SIZE_DETAILS

MSS_GET_SCHEMA_SIZE_INFO

MSS_GET_TABLE_SIZE_INFO

SFMSS_SIZE

GET_TABLE_SIZE_MSS

When you look into se16 you just get the number of rows for this client, while db02 shows the table size over all clients. Therefore the tables size didn't match my calculations.

If Found Help Full Do Reward.

Regards.

Eshwar.