Function Module for GL open Items

[Former Member]

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

[Former Member]

Hi,

try bapi is BAPI_ACC_GL_POSTING_POST

<b>Reward points</b>

Regards

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

This message was moderated.