12-29-2013 5:15 AM
Hi Sapians,
I need a help on the below Query .
I have created a table <ZFITABLE> in which field <Function> as Key Field and created some entries .
Created another table <ZFITABLE3> in which field <Function> as Key Field in domain -->> Value range ---->> i specified first
Table <ZFITABLE> as value table .
Now when i execute the second table <ZFITABLE3> in selection screen for Function field i am not able to get F4 help for it with
entries which are maintained in the first..
Can you please look in the attach file and help me ...
This one i dont want to create a Check table or elementary search help .. i want to use only value table
12-29-2013 5:58 AM
HI Venkatesh.
1. First, you need to create an elementary search help in SE11. Provide a name, description and the fields. (<Function>). In the definition tab, specify the value table from which the values must be read. (ZFITABLE). Save and Acitivate it. Execute it.
2. Next, attach this search table to the second table ZFITABLE3.
Now, you can get the values for your field on F4.
12-29-2013 5:38 AM
Without using the Elementary search help or check table , I am not sure how you can link the 2 tables.For example there are a number of tables out there that have same fields used as key using same generic domains too..(like in HR-key for example).The simple question is how can we link one table to another for the field?
If there is any specific reason for not going ahead with the check table or F4 help,then it would be easier to understand the scenario....
12-29-2013 6:28 AM
Hi Byju,
Thanks for your reply.
i understood your question there is no specific reason .it was said to maintained a value table to fectch details from the first one,
12-29-2013 6:42 AM
Ok,Because since you have used the same fieldname and domain for both the tables,the easiet option would be to generate a checktable for the ZFITABLE3,the system will automatically propose the usage of ZFITABLE for the action.Once completed,this will serve as check and also provide with a flexible F4.
Hope it helps...
12-29-2013 5:58 AM
HI Venkatesh.
1. First, you need to create an elementary search help in SE11. Provide a name, description and the fields. (<Function>). In the definition tab, specify the value table from which the values must be read. (ZFITABLE). Save and Acitivate it. Execute it.
2. Next, attach this search table to the second table ZFITABLE3.
Now, you can get the values for your field on F4.
12-29-2013 6:26 AM
Thanks for the response ,
After doing the above mentioned can i give the table zfitable in ZFITABLE3 ..
i have linkeded with search help for the field ...
do i need to specify anything in the value table for this case..
little confusion please tell me.
with check table i m able to get the F4 help....
12-29-2013 6:43 AM
Hi ,
i am getting below msgs
Check domain ZFUNCTION (AMIT/16.02.13/12:14)
Domain ZFUNCTION is not key domain of value table ZFITABL
Table ZFITABLE is also a value table for other domains
Domain ZFUNCTION is correct
12-29-2013 6:46 AM
For the table ZFITABLE being used as checktable,the field function should be of type 'Key'...
12-29-2013 6:51 AM
i have checked 'Key' for the field Function in both the tables and both tables has same domains ..
is that correct?? or do i need to change soemthing pls help.
12-29-2013 6:58 AM
Warning message displayed after activation is ok
The table ZFITABLE containing the values should have the field 'function' as key.For the other table,it is based on your business requirement(it may or may not be the key)
Check the Table SCARR , field CURRCODE...This will give you a visual example and better undestanding on how to approch the same
12-29-2013 7:15 AM
Thanks for your Guiding Byju.
I have already maintained as Function as key field in ZFITABLE and elementry serch help created and assigned and this table is working fine ..giving me F4 help for the Entries .
Now i used this ZFITABLE in ZFITABLE3 as value table ...
in zfitable3 also function is the key field ..so now in selection screen as per my assumption
as ZFITABLE is maintained as value table in this table so this function field should poplute the F4 help .
is my assumption wrong.
below are the screen shoots
12-29-2013 7:25 AM
Once the ZFITABLE is set as checktable for ZFITABLE3,then the F4 will be displayed from values of ZFITABLE.
For understanding this,simply create a local report and write the following code.
Parameters : p_fxn type ZFITABLE3-function.
The F4 listed will be values of ZFITABLE.