topic Re: Select Records in Application Development and Automation Discussions

Select Records

Former Member — Fri, 29 May 2009 04:35:37 GMT

HI all,

I am trying to retrieve VTEXT from T179 table ,when i am selecting it says unknown column name,please help me..

Thanks

kanishka

Former Member — Fri, 29 May 2009 04:37:47 GMT

Hi,

The table T179 not having VTEXT

Former Member — Fri, 29 May 2009 04:39:20 GMT

Hi,

U will get the VTEXT field in table T179T.

Hope it will solve ur problem.

Former Member — Fri, 29 May 2009 04:40:03 GMT

Hi,

write a select query with T179T table.... instead of T179 table....

This will resolve your problem

Regards,

Siddarth

Former Member — Fri, 29 May 2009 04:40:19 GMT

Dear kanishka,

Use this table T179T for selecting VTEXT.

You will find your desired text.

Feel free to ask any doubts.

Regards.

Vijay

Former Member — Fri, 29 May 2009 04:41:35 GMT

Hi kanishka dhanesh,

Can retrieve from table T179T - Materials: Product hierarchies: Texts.

Regards,

Suneel G

Former Member — Fri, 29 May 2009 04:43:00 GMT

Use table T179T instead of T179.

Hope it will work.

Former Member — Fri, 29 May 2009 05:17:58 GMT

from table T179T

SPRAS SPRAS LANG 1 0 Language Key

PRODH PRODH_D CHAR 18 0 Product hierarchy

VTEXT BEZEI40 CHAR 40 0 Description

when ever u face problem finding a field in which table.

go to TCODE: SE15. give the field name and execute.