Z function module execution in other user id on same server.

[former_member515797]

Hi,

I am having a Z function module which is created by using SHDB (BDC recording). this FM creats an excel file and sends some data into it.

My question is : when I am excuting the program that is accessing this FM from other USER ID & PWD it is throughing sy-subrc =1,001. and it is not creating the excel file.

can you pls help me.

Ameen.

[Sm1tje]

when you are running this function module, is that in foreground of background?

If in background, check your mode when calling CALL TRANSACTION 'XXX' MODE 'X'? Could cause the problem???

[former_member515797]

Hi micky,

Thanks for the reply,

it is a background job.

the MODE in CALL TRANSACTION is N,

I tried this will MODE as A, it is working fine but not with N Mode.

[Former Member]

it is a background job.

the MODE in CALL TRANSACTION is N,

I tried this will MODE as A, it is working fine but not with N Mode.

In Background.

Are you creating the File on Frontend. If it is On Frontend then it will fail for obvious reasons.

In background frontend operations will fail.

In foreGround it will work, because Frontend is accessible here.

[former_member515797]

Sorry Micky & Yesh,

it is frontend job.

complete description of my problem.

My requirement is : Sending data from spool to excell sheet using spool request id.

I used SHDB on Tcode SP01 did the recording and saved the process as FM.

MODE = N, UPDATE = 'A'

When I am executing the FM in other USER ID area not on created area It's sy-subrc = 1,001 and it is not sending data to excell sheet .

so, this is my problam. can u please help me.

Ameen.

Edited by: Ameen Basha Md on Apr 4, 2008 11:52 AM