How to extract contents from structure field ZEILE ?

[Former Member]

hi,

i need to extract the contents from this structure field ZEILE which is a note text field. may i know how can i access the contents stored in it?

Structure : EENO_DYNP

Field : ZEILE

Data Element : EENO_ZEILE

[former_member223537]

data : l_text type eeno_dypn-zeile.

Move eeno_dynp to l_text.

[Former Member]

Raja,

Of course a structure contains values only at run-time and only if the program puts them there.

So two approaches, depending on the exact nature of your requirement.

[1] Find the database field used by the program to populate ZEILE, and look there.

[2] Debug the program.

Neither of these is necessarily easy.

I can give further info.

John

[Former Member]

Dear John,

Can you please find out for me the table and the field name in which this data is stored? This structure field is used in the accounting document line items to store long text information about each document line item. If you go to fb03 and zoom down to document line item you will come to a screen where this structure field is shown.

Can you please find out this table and field name?

[Former Member]

1) use tcode st05

2) activate trace

3) run program

4) deactivate trace

5) display trace

6) it will show you details , from which tables data is coming.

[Former Member]

Dear Sir,

Can you please find out for me the table and the field name in which this data is stored? This structure field is used in the accounting document line items to store long text information about each document line item. If you go to fb03 and zoom down to document line item you will come to a screen where this structure field is shown.

Can you please find out this table and field name?

[Former Member]

Raja,

Oh, not so easy.

ZEILE is held in the database not as a field but as text.

The header table for the text is STXH.

In this case you need key values TDOBJECT = 'DOC_ITEM'

and TDNAME = the concatenation of company code, doc no, fiscal year and item number, I think.

Finding the text lines involves a statement resembling this:

import tline to lines

from database stxl(tx)

client form-mandt

id stxl_id

ignoring conversion errors.

Earlier in your program, you would have populated fields of stxl_id.

This way of doing things lets us have long texts that are indefinitely long.

John