topic Re: FTP Connect in Application Development and Automation Discussions

FTP Connect

Former Member — Mon, 07 Oct 2013 05:16:03 GMT

Hello Experts,

I am using FTP_CONNECT Functional Module in 7 to 8 programs for different purposes from FTP. so in all the programs i hard coded user name, password and host name. I want to make these three dynamic. and that should run in back ground process.

Give some suggestion how to make FTP user name, password and host name dynamic. and all the programs should take the same user name, password and host name and any time if we want to change any thing like password or host name we can change without touching the program.

Thanks

Sunita

Re: FTP Connect

Arun_Prabhu_K — Mon, 07 Oct 2013 05:24:16 GMT

Hello Sunita.

How about making the fields username and password as user input fields in all the programs?

Hostname you can get it via function module SCUT_GET_CLIENTHOST.

You can set the data for these fields (username and password) as variant for running the programs in background mode.

Regards.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 05:45:16 GMT

Hi,

Create a Z table with the required fields.

Also create a table maintenance generator for the same.

Maintain login credentials etc in this table.

In your program write a select query and get the data from this table for FTP_CONNECT.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 05:54:47 GMT

Hi Arun,

I think that variant will be deleted when we will restart the server.

and if i m saving it in variant when i m opening next time that T.Code that data is not coming automatically.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 06:05:37 GMT

Hi,

Create a Z-table and create Table Maintenance Generator(TMG) for it so that you can maintain the details whenever the Password changes.

Also for running it in Background, the rfc destination should be SAPFTPA.

Regards

Sajid Shaik

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 06:09:04 GMT

No we cant create tables.. Give any other suggestion. Thanks

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 06:27:04 GMT

Dear Sunita,

The other Method would be to create parameters and assign the values to these parameters in SU01 for the users who are going to use the program.So values would come dynamically for that user.

However the disadvantage here is you need to maintain it for many users and if password changes then you need to change the parameter value for all these users.

In my view, Ztable would be best. So that maintainability of the values would be easier.

Regards

Sajid Shaik.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 07:01:57 GMT

Hi Shaik,

I created Parameters as user and pwd in my program. But in SU01 in which parameter Id we have to assign. User and pwd is not in list of parameter ID.

Thanks.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 07:34:34 GMT

Dear Sunita,

Go through the following Link for creation of Parameter ID

http://scn.sap.com/thread/1034187

Assigning Parameter id is as shown in below screen shot.

Regards

Sajid

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 08:06:24 GMT

Hi Shaik,

I created parameter Id as ZFTP_HOST, ZUSER_NAME, ZUSER_PWD. Then I created 3 data elements where in paramete Id i mentioned the above 3 parameters. Then in my program i written the below code.

PARAMETERS: USER(30) TYPE C LOWER CASE MEMORY ID ZUSER_NAME,
PWD(30) TYPE C LOWER CASE MEMORY ID ZUSER_PWD ,
HOST(64) TYPE C LOWER CASE MEMORY ID ZFTP_HOST.

Then also its not working. Pls suggest.

Thanks

Sunita

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 08:10:01 GMT

Dear Sunita,

All you need to do is -

1. take SM30 and give table name as TPARA and create 3 Parameters .

2. Take SU01 and as given in the above screen shot maintain the values for 3 parameter ids.

Regards

Sajid

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 08:12:26 GMT

Hi Shaik,

Yes I created these three parameters in SM30. and assigned in SU01.

But how to pass in FTP_connect functional module?

Thanks

Sunita

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 08:27:01 GMT

Hi,

By defining the parameters in the selection screen of Program.

Once you have declared the parameters in the Program. Just test it once.

When you run the program, the values will get filled automatically .

Regards

Sajid

Re: FTP Connect

Arun_Prabhu_K — Mon, 07 Oct 2013 09:02:31 GMT

Sunita,

I am not sure why variant should get deleted on restarting the server.

For a tcode executing in foreground, default variant cannot be set. You have to choose the variant and then execute.

Whereas for scheduling a program in background mode, it can be made to execute with specified variant.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 09:33:09 GMT

Its not working, User name and password is not fetching from there.. What to do for that?

Its showing an error message as

Invalid FTP handle

Message no. 04206

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 10:00:55 GMT

Dear Sunita,

Its working in our system.

send me the screen shot of su01.

Also are you executing it in the same client and with same user id (which was used in SU01).

Regards

Sajid

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 11:26:43 GMT

Hi Shaik,

I have attached the image how we maintained in SU01. Yes i have maintained this for same client and same user ID.

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 12:00:13 GMT

Dear Sunita,

you have maintained correctly in Su01.

May be the parameter ids are maintained differently in your program.

PARAMETERS: USER(30) TYPE C LOWER CASE MEMORY ID ZUSER_NAME,
PWD(30) TYPE C LOWER CASE MEMORY ID ZUSER_PWD ,
HOST(64) TYPE C LOWER CASE MEMORY ID ZFTP_HOST.

It should be

PARAMETERS: USER(30) TYPE C LOWER CASE MEMORY ID Z_NAME,
PWD(30) TYPE C LOWER CASE MEMORY ID Z_PWD ,
HOST(64) TYPE C LOWER CASE MEMORY ID Z_HOST.

Regards

Sajid

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 12:08:12 GMT

Like this also I tried but its not working. Give some idea...

Re: FTP Connect

Former Member — Mon, 07 Oct 2013 12:17:40 GMT

Dear Sunita,

All the steps done are correct. I have no idea why its not working for you 😞

Regards
Sajid