With the help of klanduedoc’s knowledge which he shared
http://klanguedoc.hubpages.com/hub/Silent-Connection-with-SAPLOGON-with-RFC SDK-Example-RFC-Excel-VBA, I managed to develop a reporting system which uses the silent connection to SAP downloads sale orders headers & lineitems in two separate table in access database and then it generates sales & targets reports on daily basis. The users are happy.
One thing I am looking for. That is, a way (preferably a BAPI) to which I give date as a parameter and it should return to me a list of all sale orders for that particular day.
Why Do I need That?
Because I intend to use that list to monitor the changes which frequently occur in our scenario. For example a sale order which was originally entered for customer x last month… Now the same sale order is changed, it now belongs to customer Y. Another example is: A sale order in which 20 items of a product were sold last month, now the same saleorder is showing 35 items…
looking forward to the guidelines (source code - hints)