topic Re: Data dictionary value range text in alv output in Application Development and Automation Discussions

Data dictionary value range text in alv output

Former Member — Wed, 06 Oct 2010 15:06:04 GMT

Hi,

I created a Z table with a field 'zstatus' and defined the fixed values 0,1,2 with the respective value range Doc not created, Doc created and Doc cleared.

Now in the output ALV report i have this field 'zstatus' with number 0 or 1 or 2. But for the enduser somehow they should be able to see the description defined in the value range as well.

Can you suggest me how can i display the description also in the output or is it possible to have 'F4' or search help or drill down in the alv output field.

Regards,

Anbu.

Re: Data dictionary value range text in alv output

Sandeep_Panghal — Wed, 06 Oct 2010 15:51:01 GMT

If you are using cl_gui_alv_grid then this can be easily displayed using fieldcatalg option f4availabl = 'X' and pass the ref. tab and ref. field.

Re: Data dictionary value range text in alv output

Former Member — Wed, 06 Oct 2010 15:53:07 GMT

Hi,

you can create a dictionary structure which includes the text field. Then you create a global table in your program using this structure.

After getting the data from your DB table you can add the text to this new field.

After that you use this global table for displaying your alv.

Regards,

Martin

Re: Data dictionary value range text in alv output

Former Member — Wed, 13 Oct 2010 09:12:35 GMT

Hi,

Got the solution, used the function module GET_DOMAIN_VALUES, pass the domain name, and TEXT ='X', you will get all the value range text defined in the domain.

Thanks

-Anbu

Edited by: anbu logu on Oct 13, 2010 11:13 AM

Re: Data dictionary value range text in alv output

Former Member — Wed, 13 Oct 2010 09:22:59 GMT

Hi,

Got the solution, used the function module GET_DOMAIN_VALUES, pass the domain name, and TEXT ='X', you will get all the value range text defined in the domain.

Thanks

-Anbu