Interface

[Former Member]

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

[Former Member]

HI

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

or

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

[Former Member]

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

[kiran_k8]

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.

[Former Member]

Hi Kiran,

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

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

[Former Member]

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.