Fetch description form text table

[Former Member]

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?

[Former Member]

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

[rejish_balakrishnan]

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 .