Skip to Content
avatar image
Former Member

Function Module for GL open Items

Hi Experts,

Is there function module to find out Open Item for any GL, like we have Fn Module for Vendor and Customer open items.

Any Suggestions?

Rajiv Ranjan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 17, 2007 at 11:21 AM

    Hi

    No there's is one, but you can use the same concept to get the open item for a certain date just like for vendor and customer.

    The open item are the open items posted on the date <date> and the cleared items posted on the date <date> but cleared after <date>, so:

    DATA: T_GL_ITEMS LIKE STANDARD TABLE OF BSIS.

    * Open Items
    SELECT * FROM BSIS INTO TABLE T_GL_ITEMS WHERE BUKRS = ...
                                               AND HKONT = ....
                                               AND BUDAT <= <DATE>.
    * Clear items:
    SELECT * FROM BSAS APPENDING TABLE T_GL_ITEMS WHERE BUKRS = ...
                                                    AND HKONT = ....
                                                    AND AUGDT > <DATE>
                                                    AND BUDAT <= <DATE>.

    Max

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2007 at 11:15 AM

    Hi,

    try bapi is BAPI_ACC_GL_POSTING_POST

    <b>Reward points</b>

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2007 at 11:15 AM

    You can find out Open Line items directly from table BSIS,

    you don't need to use function module for that,

    anyhow you can still try LOAN_GET_OPEN_ITEMS_GL

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2007 at 11:15 AM

    Hi

    Use the table <b>BSIS</b> straight away by writing a Select query

    Why you need a fun module for this

    BSIS is nothing but GL open items table

    if you need check the fun modules

    <b>FAGL_GET_OPEN_ITEMS_GL</b>

    FAGL_GET_OPEN_ITEMS

    <b>Reward points for useful Answers</b>

    Regards

    Anji

    Message was edited by:

    Anji Reddy Vangala

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2016 at 04:09 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded