function or bapi returning customers or vendors with open items

[Former Member]

Dear experts.

may you please tell me which function or bapi can i use that will return all customers or vendors with open items per given plant. i have tried to use BAPI_AR_ACC_GETOPENITEMS and BAPI_AP_ACC_GETOPENITEMS but they return open items for a given customer and vendor respectively per given company code.

[uwe_schieferstein]

Hello Willard

Does the SAP standard provide such a report? If so, look through the coding of the report to see how SAP selects the data (perhaps using a function module or class method). If not, then you have to write your own RFC-enabled function module based on the mentioned BAPIs.

Regards

Uwe

[Clemenss]

willard,

the term "open items per given plant" is not defined exactly. VENDORS and CUSTOMERS are not linked to specific plant. GOODS are produced and stotred in one or more plants. They may be sold by a sales organization linked to a company code. Copany may have seral plants.

That may be one reason for SAP not to provide the function you are looking for.

Please give more information about company structure and sales and purchase process.

Regards,

Clemens