topic Re: Fetch description form text table in Application Development and Automation Discussions

Fetch description form text table

Former Member — Mon, 02 Mar 2009 13:47:24 GMT

hi ,

i have a requirement.

i have a text table

i need the description values corresponding to the values in the text table.

if i do a 'select * ' into the text table, i don't get the description field VTEXT. How do i fetch the description as well?

Re: Fetch description form text table

Former Member — Mon, 02 Mar 2009 13:59:36 GMT

Hi,

First check if the link for the text table-main table exsts..

If so, You can put a select query on the main table and get the description,,

You can check MARA and MAKT(text table) for the requirement..(if you select MARA..you get the description)...Only thing is the LINK between the tables..needed

Regards

Shiva

Re: Fetch description form text table

rejish_balakrishnan — Mon, 02 Mar 2009 14:12:33 GMT

Hi,

First of all the 2 tables needs a relationship.In both table primarykey fields should be same.Use that primary key for retrieving description along foreign ket table .