topic Re: Interface in Application Development and Automation Discussions

Interface

Former Member — Thu, 25 Sep 2008 06:02:41 GMT

Hi Gurus!!!

I have a requirement like my client is using third party software to capture vehicle weights on a weigh bridge. How can i fetch this data into SAP ?

Regards,

Nishant Gupta

Re: Interface

Former Member — Thu, 25 Sep 2008 06:10:18 GMT

try getting your values into an excel sheet from yout software, and then upload that excel sheet into your ABAP program.

create a transaction with the reqd fields and then using BDC you can upload your excel sheet data into the Database or wherever youu like.

LSMW will also work.

Regards

Winnie

Re: Interface

kiran_k8 — Thu, 25 Sep 2008 06:25:54 GMT

Nishant,

Just check this Standard program RSFTP007 which uses

CALL FUNCTION 'FTP_CONNECT' to connect to their server and download the data to the application server from where you can read the data again into the internal table which can be used for further processing.

K.Kiran.

Re: Interface

Former Member — Thu, 25 Sep 2008 06:27:38 GMT

Hi Winnie,

Thanks for your reply but this is not one time activity. Daily lots of vehicles will be coming to the Weigh Bridge (For Sales and Purchase. The third party software will be updating the weights in mysql database (Legacy system). Is there any way to extract data from there.

Regards,

Nishant

Re: Interface

Former Member — Thu, 25 Sep 2008 06:30:25 GMT

Hi Kiran,

Can you please explain in detail, how to use this program.

What RFC destination i have to use? which username and password.

Re: Interface

Former Member — Thu, 25 Sep 2008 06:32:18 GMT

Hi Gupta,

Client's 3rd party software stores the result in which format file or DB?

Think whether IDOCs can be used for this.

Regards,

Salini.