Skip to Content
avatar image
Former Member

Report as per FBL1N - Vendor line Items

Hi Experts,

I have a requirement to generate a report as per FBL1N, the current process is as follows. User enters shipments in dynamic selection > document > Reference > right side Reference. '*' is kept before and after the shipments. Other selections are company code and All items radio button and Execute.

My question is , What are the tables this looks at ? I am assuming BSIK, BSAK and BSEG. How to know which tables it looks at ? I think this may be functional question. If you have any questions please let me know.

Thank you,

Surya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 31, 2007 at 03:04 PM

    Dear surya,

    1. just go to the screen and -


    > click f1 -


    > then technical details

    -


    > click on dataelement -


    > double click on data element

    -


    > then check menu bar -


    > utilities -


    > where used list

    you will find some tables ... so these are the main tables

    2. or other wise go to st05 ,

    activate trace

    do the transaction

    and deactive trace

    and check the details in that u can view tables from that you have to see in which table it is updating..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2007 at 03:04 PM

    Hi,

    you are assuming well. The tables are correct.

    But instead of doing the code with table selection, wy don't you use BAPI

    BAPI_AP_ACC_GETOPENITEMS and

    BAPI_AP_ACC_GETBALANCEDITEMS to retrieve the information?

    This way, i don't need to be worry if there's any missing information in a table.

    Best Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2007 at 03:07 PM

    Hi Surya,

    for FBL1n..tables are used LFA1, LFB1, BSIK and BSAK.

    BSEG is not used.

    you can also check from ST05 transaction.

    Hope it will solve ur problem.

    Regards

    Krishnendu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Surya,

      Do you have a look at the progrm linked with transaction FBL1N ? You can see that this program is linked with a logical database so can't you use the same for your requirement ?

  • avatar image
    Former Member
    Mar 24, 2008 at 06:25 PM

    Our BA defined the requirement properly and identified the necessary tables.

    Add comment
    10|10000 characters needed characters exceeded