topic Re: How to retrieve values from value table? in Application Development and Automation Discussions

How to retrieve values from value table?

Former Member — Wed, 26 Dec 2007 09:11:46 GMT

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.

Re: How to retrieve values from value table?

Former Member — Wed, 26 Dec 2007 09:33:20 GMT

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

Re: How to retrieve values from value table?

former_member404244 — Wed, 26 Dec 2007 09:35:11 GMT

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

Re: How to retrieve values from value table?

Former Member — Wed, 26 Dec 2007 09:35:48 GMT

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>.

Re: How to retrieve values from value table?

Former Member — Wed, 26 Dec 2007 09:44:41 GMT

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

Re: How to retrieve values from value table?

Former Member — Fri, 28 Dec 2007 07:39:32 GMT