No of fields in table t157b changes when we execute

[Former Member]

Hi all,

when we see table T157D through se11 it is showing 3 fields MANDT, BWART, GRUND in fields tab but when we execute it, it is showing 4 fields MANDT, BWART, GRUND, GRTXT from where this 4th field is coming. I have write a small program to check the no of fields in table T157D BY using SELECT * FROM T157D into IT_T157D here it showing 3 fields MANDT BWART GRUND in internal table. but if we see this same table in se16 or se16n it is showing 4 fields.

Can anybody please say me why it is happening so

Thanks in Advance

[Former Member]

Hi ,

the fourth field is from the Text table linked to the main table T157D. You can see the text table using GOTO->Text table in se11 for table T157D which is T157E. So ideal speaking the table consist of 3 fields only and the other table is linked this table and consist of the text descriptions.. So in select query you get only three fields, if you want the descp field fetch from T157E.

Hope this helps you

Raj

[tarangini_katta]

Hi,

In SE11

IF you go to EXTRA-->Search HElp for table

Click on that you will get that name H_T157D this earch help.

From this search help you r geeting GRTXT in the output.

I hope u r pblm solved.

Thanks