topic Re: Execute T-Code without logging to R/3 in Application Development and Automation Discussions

Execute T-Code without logging to R/3

Former Member — Thu, 14 Nov 2013 09:48:42 GMT

Hello All ,

I am using Excel macros to connect to R/3 and retrive information from table.

Now i want to use same code to execute some T-code like SICF ,SE38,etc without logging to R/3.

Any help or suggestion is highly appreciated.

Thanks,

Sudeep

Re: Execute T-Code without logging to R/3

Former Member — Thu, 14 Nov 2013 10:00:12 GMT

I have made changes to Database Tables using Offline Adobe Forms Scenario. This will be interesting to see. As far as I know, you have to login to SAP for executing Transactions. Waiting for more inputs.

Best Regards,

Jagraj Singh.

Re: Execute T-Code without logging to R/3

Former Member — Thu, 14 Nov 2013 11:10:45 GMT

Hello Sudeep,

It is possible to execute the T-Code from Excel by adding a function in VBA for the RFC call "RFC_CALL_TRANSACTION".

That should work for you, since you already managed to establish a connection to R/3

Br,

Christian

Re: Execute T-Code without logging to R/3

Former Member — Thu, 14 Nov 2013 13:50:04 GMT

Hello Christian,

Thanks for reply.

I am not able to pass arguments to the transaction.

for e.g if i give SE38 in transaction ,how should i give report name to execute..?

or we have some standard SAP functions to execute the reports directly.

sample code :

Set RfcCallTransaction = objBAPIControl.Add("RFC_CALL_TRANSACTION_USING")

RfcCallTransaction.exports("tcode") = "SE38"

RfcCallTransaction.exports("mode") = "N"

...........

i dont know next statement....

Thanks

Sudeep

Re: Execute T-Code without logging to R/3

RaymondGiuseppi — Thu, 14 Nov 2013 13:55:04 GMT

Use one of the RFC enabled FM that execute transactions with some BDC DATA (e.g. RFC_CALL_TRANSACTION_USING table parameter BT_DATA)

Regards,

Raymond

Re: Execute T-Code without logging to R/3

Former Member — Thu, 14 Nov 2013 15:03:06 GMT

Hello Raymond

i am able to get bt_data table and its parameter.

program name & screen no i can give

but i am not able to find details of the screen like field name & field value (specifed by ? in below e.g) .

add_bdcdata BdcTable, "Program Name", "Screen Number", "X", "???", "???"

any help is appreciated.

Thanks,

Sudeeep

Re: Execute T-Code without logging to R/3

RaymondGiuseppi — Thu, 14 Nov 2013 15:07:15 GMT

Use SHDB to record any transaction, it can generate a snippet that you will copy in your code.

SAPMS38M	101
		BDC_CURSOR	RS38M-PROGRAMM
		BDC_OKCODE	=STRT
		RS38M-PROGRAMM	name of program

Regards,

Raymond

Re: Execute T-Code without logging to R/3

Former Member — Fri, 15 Nov 2013 06:40:21 GMT

Hello Raymond ,

thanks for the reply..

it was of great help.

i am able to call the RfcTransaction

but how to capture the output of transaction..?

If RfcCallTransaction.Call = True Then
        Set Messages = RfcCallTransaction.imports("MESSG")
        MsgBox Messages.Value("MSGTX")
    Else
        MsgBox " Call Failed! error: " + GetCustomers.Exception
    End If

this is giving error..."Object Variable or With block Variable not set.

Thanks,

Sudeep

Re: Execute T-Code without logging to R/3

RaymondGiuseppi — Fri, 15 Nov 2013 12:16:52 GMT

What do you call the output of transaction, a spool, an ALV grid, if you actually want to get some result back, better look for GET or GET_DETAIL BAPI.

Regards,

Raymond

Re: Execute T-Code without logging to R/3

Former Member — Mon, 18 Nov 2013 15:02:56 GMT

Hello All,

i am able to execute some t-code like SE38(having no sub screens) with RFC_CALL_TRANSACTION_USING.

but i am unable to call T-codes having inputs from multiple sub screens. i can record the code from SHDB.That code runs fine in R/3 but unable to call the same code remotely.

e.g

add_bdcdata BdcTable, "SAPLSPO1", "0500", "X", "", ""
add_bdcdata BdcTable, "", "", "", "BDC_OKCODE", "=OPT1"
add_bdcdata BdcTable, "", "", "", "BDC_SUBSCR", "SAPLSPO1                                0502SUBSCREEN"

Can anyone help to handle sub screens...

Thanks,

Sudeep

Re: Execute T-Code without logging to R/3

Former Member — Mon, 18 Nov 2013 21:15:59 GMT

Dear Sudeep,

No need to include the line which is for SUB SCREEN(SUBSCR)

Rest of BDC Data can be as it is. Just exclude the BDC_SUBSCR lines.

I Hope it helps.

Regards,

Message was edited by: Matthew Billingham

Re: Execute T-Code without logging to R/3

Former Member — Tue, 19 Nov 2013 04:50:55 GMT

Hi Sudeep,

Could you share with us if you finally make it?

Thank you

Lei

Re: Execute T-Code without logging to R/3

Former Member — Wed, 20 Nov 2013 03:36:35 GMT

This message was moderated.

Re: Execute T-Code without logging to R/3

Former Member — Thu, 21 Nov 2013 04:21:12 GMT

Hello Lei.

I am still struggling with the code.

I am able to login the R/3 and call RFC function but the transaction which i am executing is not giving any output..

I will share techical details once i am through with the code and i am able to execute t-code successfully.

Re: Execute T-Code without logging to R/3

Former Member — Mon, 25 Nov 2013 11:17:57 GMT

Hello All ,

Calling Transaction from RFC's uses bdc data as input for transaction parameters.

From the information i got from variuos sources BDC is obsolete and BAPI is a better way to do things.So i am trying to do the same with BAPI functions.

Thanks for all the help.