search help

[Former Member]

hi

1)

i want to know procedure (steps) to create search help plz give a example step by step

2)

what is table maintenance generator plz give one example

3)

step by step procedure to create lock object.

thanks.

deepak

[Former Member]

<b>FOR SEARCH HELP</b>

1)A manual search help can be created in the se11 transaction by clicking on the search help radio button and giving the table and field name for which search help is required.This is done when the field you use in your screen does not already have a search help of its own at the domain level.

2)If the field in the screen is taken from the dictionary,and the the domain of the field already has an existing search help,then in the attributes of the field in the screen,u can check "from dictionary" under the dictionary tab.

3) If the field in the screen is taken from your program (and not dictionary) or if it does not have a search help,then use the following procedure:

In the PAI of the screen, add a module Process on value request.For example:

PROCESS AFTER INPUT.

MODULE USER_COMMAND_100.

PROCESS ON VALUE-REQUEST.

FIELD field_name MODULE value_request_for_field_name.

*field_name is the field for which you require search help.

In the Module value_request_for_field_name call this function 'F4IF_INT_TABLE_VALUE_REQUEST'.

This method has the additional advantage that the table returned by the above FM can be further processed...ie you can filter values to be displayed in your search help based on your requirements.

<b>TABLE MAINTENANCE GENERATOR</b>

Table Maintenance is used to maintain the values of a custom table.Based on your requirements,you may want to change or add/delete the contents of your table.The procedure for table maintenance is:

1)Go to se11 and type the table name in Display or change mode.

2)Using the menu path Utilities -> Table Maintenance Generator .Table maintenance is generated.

3)To be able to maintain your table using a transaction(using a transaction for table maintenance dialog),you need to do the following.

•Create a new transaction of the type “Parameter Transaction” from SE93, specifying SM31 as the transaction.

•The VIEWNAME parameter is set to your table name with the option ‘Skip initial Screen’ set.

•The UPDATE parameter is set to value ‘X’.

<b>LOCK OBJECTS</b>

1)Go to se11 transaction.

2)Click on lock object radio button and give a lock object name starting with 'E'.For example 'ESAMPLE'.Click CREATE.

3)In the TABLE tab, you can give the table name for which you require a lock.In the LOCK PARAMETERS tab,you can give the table fields based on which the table should be locked.

4)Call a function module in your program ENQUEUE_lockobjectname to obtain a lock on the required table.In our example the FM will be ENQUEUE_ESAMPLE.

5)To release the lock on the table,call the function module DEQUEUE_lockobjectname.In our example the FM will be DEQUEUE_ESAMPLE.

Regards,

Beejal

**Reward if the answer is helpful

[former_member201227]

Hi,

Creating Search Help:

Go to SE11. Give a Search help name and create.

Give a description in the next screen.

In the field 'Selection Method' of the Definition tab, give the table name from which you want to fetch the values.

In the table displayed below, under the Search help Parameter, give the field name for which you require the Search help. Give the data element of that field also. Check the boxes IMP and EXP. Give LPos and SPos as 1.

Save and activate.

Table maintenance Generator:

If you want to maintain a table manually, you need to enable this option. Go to Database table, Utilities, Table maintenance generator.

You can maintain the table using SM30.

Hope this helps.

Regards,

Sharmila

[Former Member]

Hi ,

To create a search help , go to se11 , seelct the radiobutton search help and enter the name of search help you want to create , press the create key.

You would get a screen with two tabs Attributes and Definition , in the definition enter the table / view from where you want to get the data in the Selection Method feild and in the parameters table enter the feilds you want to give as input /output in the search help, see the import/export radiobutton.

Regards

Arun

[Former Member]

Hi deepak,

<b>Creating search help</b>

<b>Table maintenance generator</b>

<b>Lock objects</b>

[Former Member]

Hi,

Please refer to the following links:

1. Search Help Creation

http://help.sap.com/saphelp_47x200/helpdata/en/8b/415d363640933fe10000009b38f839/frameset.htm

2. Table Maitenance Generator - suppose if u want to make an entry to a table Manually rather than programatically u can go for table maintenance generator

Manual entries in table can be maintained ( New record can be inserted / existing can be modified )using transaction SM 30, if the table maintenance for the table is generated.

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

3. Lock Objects

http://help.sap.com/saphelp_47x200/helpdata/en/a2/3547360f2ea61fe10000009b38f839/frameset.htm

[Former Member]

Hai Deepak

Go through the following Sample Codes

1)

The Matchcode is replaced by search help from the version 4.6C.

I will tell u how create the search help.

Name of a search help

A search help is an object of the ABAP Dictionary with which input helps

(F4 helps) can be defined.

There are the following types of search helps:

o Elementary search helps implement a search path for determining the

possible entries.

o Collective search helps contain several elementary search helps. A

collective search help therefore provides several alternative search

paths for possible entries.

o Append search helps can be used to enhance collective search helps

delivered by SAP with customer-specific search paths without

requiring a modification.

The three components of the input help process described by a search

help are the outer interface, the online behavior and the method of data

Go to Tcode SE11. Select the search help radio button.

Give name as ztest and click create

There are two types of search help.

Once is elementary search help

& collective search help

Choose one.

Add the data element.

MatchCode is replaced by search helps.

To attach a search help to a field.

Use this code.

at selection-screen on value-request for source.

progname = sy-repid.

dynnum = sy-dynnr.

clear value_tab.

refresh value_tab.

• Filling the Value_tab internal table by itab2 internal table.

*----

---

loop at itab_desc.

write itab_desc-description to value_tab.

append value_tab.

endloop.

*----

---

prog = sy-repid.

no = 1000.

clear tab.

refresh tab.

*----

---

• Building the Structure of the Seach Help.

tab-tabname = 'FMFCTRT'.

tab-fieldname = 'BESCHR'.

collect tab.

• Function Used to provide Search Help.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'BESCHR'

dynpprog = prog

dynpnr = no

dynprofield = 'SOURCE'

window_title = 'Function'

TABLES

value_tab = value_tab

field_tab = tab.

2)

There're several SAP notes about Table maintanance Creation: 339262, 339257, 364647.

1. specially function group.. what is its significance

When we generate table maintenance,

the system , based upon the table fields,

automatically,

generates

PROGRAM CODE, SCREEN FOR ENTERING DATA,

LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA

ETC.

2. All this are BUNCHED under

a FUNCTION GROUP

(if you open that function group in se80, after

creatting table maintenacne,

u will see the program code, screens, gui status etc)

3. Hence, to BUNCH all these various objects,

SAP uses the concept of function group.

*----

---

4. And also why do we need to give two screens there

Its not necessary to have to screens.

5. ONE SCREEN MEANS:

only one screen with table control to enter data

TWO SCREEN means :

first screen : only primary key fields will appear

second screen : rest of the fields will appear to enter data

6. When the table consists of many fields,

its practically more convenient to have two screens,

so that all fields come vertically downwards.

(instead of scrolling horizontally in the table

control, in case of one screen concept)

The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.

yes u need to create a FG and the use it in Table maint. gen.

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

3)

LOCK OBJECTS

1)Go to se11 transaction.

2)Click on lock object radio button and give a lock object name starting with 'E'.For example 'ESAMPLE'.Click CREATE.

3)In the TABLE tab, you can give the table name for which you require a lock.In the LOCK PARAMETERS tab,you can give the table fields based on which the table should be locked.

4)Call a function module in your program ENQUEUE_lockobjectname to obtain a lock on the required table.In our example the FM will be ENQUEUE_ESAMPLE.

5)To release the lock on the table,call the function module DEQUEUE_lockobjectname.In our example the FM will be DEQUEUE_ESAMPLE.

Regards

Sreeni