Skip to Content
avatar image
Former Member

Finding fields in tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 13, 2007 at 09:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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

  • avatar image
    Former Member
    Dec 13, 2007 at 09:54 AM

    Hai Vishal,

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

    You can check these entries in this table.

    with regards,

    Eswar.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2007 at 09:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Dec 13, 2007 at 12:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded