topic Re: Function Module for GL open Items in Application Development and Automation Discussions

Function Module for GL open Items

Former Member — Tue, 17 Jul 2007 11:12:09 GMT

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

Re: Function Module for GL open Items

Former Member — Tue, 17 Jul 2007 11:15:23 GMT

Hi,

try bapi is BAPI_ACC_GL_POSTING_POST

Reward points

Regards

Re: Function Module for GL open Items

Former Member — Tue, 17 Jul 2007 11:15:46 GMT

Use the table BSIS 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

FAGL_GET_OPEN_ITEMS_GL

FAGL_GET_OPEN_ITEMS

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: Function Module for GL open Items

Former Member — Tue, 17 Jul 2007 11:15:59 GMT

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

Re: Function Module for GL open Items

Former Member — Tue, 17 Jul 2007 11:21:08 GMT

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

Re: Function Module for GL open Items

Former Member — Thu, 21 Jan 2016 16:09:55 GMT

This message was moderated.