How to retrieve values from value table?

[Former Member]

hi all,

i had post several thread on this but there are no answer to my question. i need to do a select statement which help me to check whether this particular field for etc (gender) the value inside this gender may consist of male and female but this value is located inside a value table. So i was wondering how do i do my select statement and find out whether does that particular field has a value table that link with it? is there a step by step guide to teach me? as i m a newbie. thx a million. point will be rewarded.

[Former Member]

Hi,

Use the FM /FSCAA/BAPI_HELP_VALUES_GET by passing the table and the field for which u have the values defined. you will get all the details in the return table. You can write select by populating the values into one of the ranges and use the 'in' option inthe select statement to obtained the desired result.

Thanks & Regards

Vijaya

[former_member404244]

Hi,

value table is nothing but default check table..so go to the domain of that particular, u can see the value table..so directly u can make a query on that..

for example

the value table for plants(werks) is T001W...T001W table will ahve all the plants....

now u can write query on T001W and retrieve the values..

Regards,

Nagaraj

[Former Member]

Hai,

You can use function module G_DOMAIN_READ to find the value table for the particular Domain.

If you give some domain name, It returns a structure that contains the Value table(Field Name: ENTITYTAB). Get this table name into a variable.

So you can select data from this table. If value table name is stored in v_value_table

You can use select statement like this:

SELECT * FROM (v_value_table) where <condintion1>.

[Former Member]

Hi Nagaraj & all,

but before that i have a screen which allow a user to choose the field from a drop down list, so this will be a dynamically choosen value table. can anyone teach me step by step or guide me by showing me codes to start with? thx

[Former Member]

s