is that possible to get data from sap if is yes how we can do it

[Former Member]

HI all,

is that possible to get data from afnr table to an Asp page.

how to do it. can anyone help me.

Adv Thanks & Regards

Guhapriyan

[Former Member]

You can use an asp function that call sap function module "RFC_READ_TABLE" via RFC or you can open a view on the sap database.

Gianluca

[Former Member]

Hi Guhapryan,

one can do it by BDC/bapi or ALE/IDOC or EDI

u check out which i spossible for u.

if u elabrate the question i can xplain in u better,let me knwo the xact scenario.

regards

[Former Member]

Hi,

Currently in our company we are not using .Net.

we are using ASP backend SQL Server

and SAP Back end SQL Server.

the calibration details and the testing details of the cylinder are entered in one java application.

i am trying to fetch the order details of particular material from sap while doing calibration?

Thanks & Regards

Guhapriyan Subrahmanyam

[athavanraja]

Then the option left is to use DCOM .

More info on DCOM

http://msdn.microsoft.com/library/en-us/dndcom/html/msdn_sapdcom.asp

SAMPLE CODE

http://www.tek-tips.com/viewthread.cfm?qid=494927&page=1

Regards

Raja

[Former Member]

hi,

u can write the select query to fetch data in an internal table in a Remote enabled function module.

with that u can use RFC to transfer data.

U may even generate RFC interface either for C or VB.

Hope it will help u.

Regards,

Ankur

[jayanthi_jayaraman]

Hi,

I think you can write a report to retrive that data from AFNR table and then in that report by using download you can download it to text file.

Then by giving that page as link in ASP,you can achieve.

I am not sure whether that is correct.Check it and let me know also.

Regards,

J.Jayanthi

[Former Member]

Hi Guhapriyan,

Using BAPI's you can achieve this.

make your page .NET client and SAP system as server.

This link may help you...

http://help.sap.com/saphelp_erp2004/helpdata/en/c2/5d2ac570228941bc60c0e66580b18a/content.htm

Regards,

Narinder Hartala

[athavanraja]

Check out this.

http://forums.rainbowportal.net/ShowPost.aspx?PostID=2818

Regards

Raja