Search Help of The key fileds In DB Table ????

[sagar_ranasingh]

hello Helping Minds..

I have some doubts Abt SEARCH HELP.

As i know , in a DB field. For each Primary key fields ,Search help Already created.

So whr u will Use Primary field of a table , its search help is populated automatically,

so when we use a Particular Primary key field in a Screen of Modulepool or REPORT -(selection screen ),Its Search Help will be displayed Automatically...

Ex- When BUKRS field from - - T001 table is used in Modulepool Screen, its Search help is populated Automatically, we don need to create any search help for that.

But BUKRS field does nt have any search help associated with it. as i checked in T001 table>select BUKRS filed->SRCH HLP .....Then Message is --NoSearch Help Associated.....

So whts d Fundaa... Pls Answer In details...

Thnks in advance To D helping Minds

[Former Member]

Hi,

Check in the Entry help/check tab, the srch help attached will be displayed in that.

Regards,

Sharin.

[former_member181962]

Hi Sagar Singh,

There are various ways of providing the search help.

viz:

Input help implemented with check table

Explicit search help attachment to data element

Input help with fixed values

Firstly it is not correct that you get serach helps only for key fields of table.

YOu will get search helps for all the data elements which have search helps defined(Double clik on the data element and go to Further Characteristics tab.For BUKRS also, the data element BUKRS has the search help C_T001 attached to it.

YOu will get search help for fields with DOMAINs having fixed values or Value tables.

Regards,

Ravi Kanth Talagana

[sagar_ranasingh]

Hey Thnks...

Yes i got C_T00 search help for Bukrs..

In the FIELD_CHARACTERISTIC tab of DATA ELEMENT DiSPLAY page.

and i also created a Searchhelp for for a ztable-field..and also attched the searchhelp with tht field.. and in the Value Table , I have Given the Table name.

When i am using dat filed in screen, Its search help is displaying as usual..But in "DataElement Display" Page , its nt displaying any search help under FIELD_CHARACTERISTIC Tab. and

But y its displaying the message " No search Help Associated with the BUKRS field" , When i choose Bukrs field in Table t001 and clicked the "Search-Help" Button (Justright to Foreign Key Button).

Pls clear me....

[Former Member]

Search help can be attached at both table level and dataelement level.If the search help is associated at table level search help will not list under FIELD_CHARACTERISTIC of data element.

About the value table as you have provided you need to define relation ship with the value table to make it as check table.

" No search Help Associated with the BUKRS field" : The search help is assigned at Data element level not table level.

[Reference|http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21ee93446011d189700000e8322d00/content.htm]

Hope this is clear.

Regards,

Gurpreet

[sagar_ranasingh]

Search help can be attached at both table level and dataelement level.If the search help is associated at table level search help will not list under FIELD_CHARACTERISTIC of data element.

About the value table as you have provided you need to define relation ship with the value table to make it as check table.

" No search Help Associated with the BUKRS field" : The search help is assigned at Data element level not table leve

__Yes i have D_efined the relation with the Value Table As Check Table._

Cud u pls explain me this A little more..

Yes i am almost clear..thnks brother..

[Former Member]

__Yes i have D_efined the relation with the Value Table As Check Table._

Cud u pls explain me this A little more..

1) When you define the relation between Value table and the Foreign key table the value table becomes check table.

2) Foreign key table can only have value that exists in check table(Only the specified field),But you can enter any value through programs.

3) When ever you try to enter values in the foreign key table it will be checked against Check table.

4) If you there is not Search help assigned values from the check table will come for F4 else search help.

[Reference|http://help.sap.com/saphelp_nw70/helpdata/EN/e2/667092730811d2959500a0c929b3c3/frameset.htm]

Hope this is clear.

Regards,

Gurpreet

[sagar_ranasingh]

thnks to Gurupreet......

i am cleared upto some level..