2007 Jul 17 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
2007 Jul 17 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
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
2007 Jul 17 12:15 PM
Hi,
try bapi is BAPI_ACC_GL_POSTING_POST
<b>Reward points</b>
Regards
2007 Jul 17 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
2007 Jul 17 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
2007 Jul 17 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
2016 Jan 21 4:09 PM
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |