07-17-2007 12:12 PM
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
07-17-2007 12:21 PM
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
07-17-2007 12:15 PM
Hi,
try bapi is BAPI_ACC_GL_POSTING_POST
<b>Reward points</b>
Regards
07-17-2007 12:15 PM
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
07-17-2007 12:15 PM
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
07-17-2007 12:21 PM
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
01-21-2016 4:09 PM