Get open and close items

[Former Member]

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....

[Former Member]

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

[Former Member]

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

[Former Member]

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