topic Re: Select Statment in Application Development and Automation Discussions

Select Statment

Former Member — Wed, 27 May 2009 09:46:31 GMT

Hi All,

i want to get MSEHL in t006 table,but when my select statement it says invalid colum,any can help me this??

Thanks

kanishka

Former Member — Wed, 27 May 2009 09:47:52 GMT

The field is MSEHI.

Former Member — Wed, 27 May 2009 09:48:52 GMT

hi,

The field MSEHL is in T006A. In table T006 you don't have any field named as MSEHL.

Regards,

Nikhil

Edited by: Nikhil Kayal on May 27, 2009 3:19 PM

Former Member — Wed, 27 May 2009 09:48:56 GMT

Probably u mean MSEHI?

Max

Former Member — Wed, 27 May 2009 09:49:04 GMT

HI,

It is because MSEHL belongs to table T006A.

Table T006A is the text table of T006.

In SE11 when you display the table T006; from the menu options Goto-->Text Table

You will find the texttable and the field.

Regards,

Ankur Parab

Former Member — Wed, 27 May 2009 09:49:23 GMT

its is MSEHI and not MSEHL in t006.

Former Member — Wed, 27 May 2009 09:49:53 GMT

Dear kanishka,

There is no filed called MSEHL in table T006. If you have someother problem then come with little more details.

Hope this solved your problem.

Regards,

Vijay

Former Member — Wed, 27 May 2009 09:50:06 GMT

Hi,

Provide your select statement.

I could not see any MSEHL field in the table T006. It is only MSEHI. Check it out.

Regards

Ramesh Sundaram