topic Get open and close items in Application Development and Automation Discussions

Get open and close items

Former Member — Tue, 22 Dec 2009 06:54:56 GMT

Hello All,

I need to get Open and Close items for customer based on company code....i mean to say user don't want to give customer number he want to get Open and Close item for all customer under that company code.

It would be great if some one suggest me any function module and BAPI name....

Re: Get open and close items

Former Member — Tue, 22 Dec 2009 07:07:52 GMT

Hi,

I/m not sure whether there is any FM for the requirement.Instead can have a look into this BAPI_AR_ACC_GETOPENITEMS Customer account open items at a key date or CUSTOMER_OPEN_ITEMS FM

In a report prpgram.. Hit the KNB1 table for a specify company code fetch all the customer and using these customers fetch the open and closed items.

Regards,

Aditya

Edited by: aditya on Dec 22, 2009 12:42 PM

Edited by: aditya on Dec 22, 2009 12:46 PM

Re: Get open and close items

Former Member — Tue, 22 Dec 2009 07:17:56 GMT

Hi Narayandas ,

Table BSID contains the open items and table BSAD contains Cleared Item,

You can refer to these two table.

Hope this helps to You.

Regards,

Nikhil