Macro Excel to Sap

[Former Member]

Hello,

I have somo questions and i hope you can help me

I want to make a macro in Excel to extract transactions from SAP (transactions like ST06, ST02, RZ20, SPAD, SPOOL, ST03)

Its possible extract information from any transaction?

I want to ask you if i need to create a RFC?

if I need to dowland SAP JCO ?

And Can you tell me what i need more to make this possible?

Thanks for your answer

Regards

[Former Member]

Nobody has a answer to me i need to know if is possible extract information about tcodes (ST02, SMLG, ST03, SPAD, SP12, SCC4)

I know, there are macros in excel but i don't know if i can extract information about tcodes basis.

Please help me

Regards

[Ulrich_Schmidt]

Hi Jimena,

a transaction can only be executed in SAPGui. So you need to find a remote enabled function module that provides the data you are interested in. Sometimes such an RFM can be found by executing the transaction in the debugger and looking at where gets the data from that it then displays. Sometimes the transaction calls an FM for reading this data, and if this FM is remote-enabled, you can use it as well from your Excel sheet. (If it is not remote-enabled, you need to create a wrapper FM and make that one remote-enabled.)

Sometimes it's also a good idea to look up the ABAP package (DEV Class) of the transaction and then search for function groups in the same package in order to find an API that provides the required data.

For calling the function modules from Excel I would not use JCo (Java Connector): a much better choice for this case would be NCo (.NET Connector), which allows calling RFMs from Microsoft environments like VB.NET or C#. See https://service.sap.com/connectors  --> SAP Connector for Microsoft .NET

Best Regards, Ulrich