Skip to Content
author's profile photo
Former Member

How to extract contents from structure field ZEILE ?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 01:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 11:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • Posted on Aug 23, 2007 at 11:33 AM

    data : l_text type eeno_dypn-zeile.

    Move eeno_dynp to l_text.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 11:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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?