Finding fields in tables

[Former Member]

dear friends,

I am not getting the one fields in fi module the trascaction is fb03 in that one long text is there in which user feed the text so can anybody tell that in which table that data goes .

thnaks,

vishal bhagwat

[Former Member]

Go to the transaction fb02 and enter Now click on the long text place the cursor in the text and double click on it It will take you to the editior . There In the menu path select Go to -> Header .

There you will see the folowing parameters.

Name:

Text:

ID:

Language:

These parameters you need to pass in READ_TEXT fm

and remember that the type fileds you are passing should be of same type .

just check the FM and declare accordingly.

Name is nothing but your ordr number ramaining are same for all orders.

Thanks,

Nageswar

[ThomasZloch]

the 50 character text is in BSEG-SGTXT.

if you refer to the long text "Notes" on line item level, these are stored in tables STXH and STXL and can be read using FM READ_TEXT with OBJECT = 'DOC_ITEM', ID = '0001', LANGUAGE = SY_LANGU and NAME = concatenation of BUKRS, BELNR, GJAHR and BUZEI.

Cheers

Thomas

[Former Member]

Hi Thomas,

Thanks for the sol'n but how to get the data from stxh & stxl tables and assign to the read_text fm.

thanks,

vishal Bhagwat.

[Former Member]

Hi vishal,

To use READ_TEXT fm u should export CLIENT , ID , LANGUAGE , NAME, OBJECT.

To get these parameter double click on header text which u want to display, It will open in editor, then choose <b>Goto -> Header</b> menu. u will get these parameters.

sample code ...

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = '0001'

LANGUAGE = 'EN"

NAME = '0098010578'

OBJECT = 'VBBK'

TABLES

LINES = IT_LINES2

regards,

vijay

[Former Member]

Hai Vishal,

The filed values of FB03 are captured by the table BSEG.

You can check these entries in this table.

with regards,

Eswar.

[Former Member]

Hi,

Thanks for the table but in that only sgtxt field is there but user enter the data in the long text field which is zeile which is not in bseg i don't get yet so can u help me for that?

Thanks.

vishal bhagwat.

[Former Member]

if its text then it has to be in either of STXH or STXL table..

U can fetch it using FM READ_TEXT

in SE11 check out the above 2 tables

Hope dis helps..

[Former Member]

Hi Prashant,

Thanks for answer but how to use the read_text fm?

Thanks

vishal bhagwat

[asik_shameem]

Hi

press F1 on the field, and press <b>technical attributes</b> and see the table name. if u dont find the table, press F4 and press F1 and do the same.

[Former Member]

Hi

Shameem,

Thanks for ur answer but it is struture not table and that field is zeile .

now how to find that table in which that data goes?