Skip to Content
avatar image
Former Member

Query on fbl5n (bapi)

Hi All,

Please let me know the funciton module or standard bapi that gives the FBL5N output.

i.e

if we give a customer number in fbl5n it gives corresponding line items.

Please let me know if the above can be done using any function module or standard bapi.

( or )

I am able to get the line item details from bseg table for the given customer according to the fbl5n output.

but bseg is clustered table which results in performance issue for more number of records.

so I tried the same using bsid and bsad tables to get the same output for the given customer to match with fbl5n ouptut.

but it is not matching .

please let me know what measure have to be taken so that the fbl5n output matches with the code that is developed using bsid and bsad tables.

Thanking you in advance

regards,

A.srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 09, 2010 at 09:39 AM

    Hi,

    You can use the BAPI BAPI_AR_ACC_GETSTATEMENT.

    Hope it helps

    Sujay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I don't know why you say that, It is giving me the same result as in FBL5N.

      If you want to choose open items, select only those line items with CLR_DOC_NO is blank.

      All the items match perfectly.

      Sujay

  • avatar image
    Former Member
    Sep 09, 2010 at 10:54 AM

    Hi Srinu,

    Why do you want an another thing for an application which is already there?

    If you want any changes or you need to customize FBL5N then you can do this by copying report RFITEMAR to a Z one.

    Please specify your requirement clearly as to why do you need another report or BAPI for FBL5N since its already there.

    Regards

    Abhii

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Srinu,

      FBL5N gives you a snapshot of customer open / closed items. You can get the same data from BSID / BSAD table.

      Try running FBL5n & simultaneously check BSID & BSAD tables, you'll see the similarities.

      BR,

      Suhas

  • Sep 09, 2010 at 11:19 AM

    FBL5N program is RFITEMAR which use logical database DDF, you could try to use [LDB_PROCESS|http://www.sdn.sap.com/irj/scn/advancedsearch?query=ldb_process], encapsulated in a customer RFC enabled FM.

    Regards,

    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2012 at 05:50 PM

    Hey, i had the same issue. If you still are interested try this FM BAPI_AR_ACC_GETOPENITEMS

    Best regards,

    Juancho

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 01:30 PM

    hi,,

    its possible to call bapi with other bapi?

    Add comment
    10|10000 characters needed characters exceeded