AO2.1 - RRI to ECC transaction (SAP Gui vs Web)

I had long discussion about this feature with SAP some years ago, but they didn't agree that SAP GUI is better for many users.

In our project I made a simple workaround. It doesn't work as RRI in general, but helps to move to ERP transaction from excel.

I created simple button on ribbon

and added VBA macro that run sap shortcut with parameters:

shortcut = Path + " -system=" + target + " -client=" + client + " -user=" + user + " -language=RU -reuse=1 -command=""ZBW_RRI_ME23N document=" + order + """ -max"

dummy = Shell(shortcut, vbNormalFocus)

Path is hardcoded:

Private Function GetPath() As String

Dim Path As String

Path = "C:\Program Files (x86)\SAP\FrontEnd\SAPgui\sapshcut.exe"

If File_Exists(Path) = True Then

GetPath = Path

Exit Function

End If

Path = "C:\Program Files\SAP\FrontEnd\SAPgui\sapshcut.exe"

If File_Exists(Path) = True Then

GetPath = Path

Exit Function

End If

End Function

System and client is also hardcoded depending on BW source system:

source = Application.Run("SAPGetSourceInfo", DP, "System")

Case "***"

target = "S1"

client = "100"

Case "***"

target = "S1"

client = "100"

Case "***"

target = "S2"

client = "100"

End Select

Unfortunately file type of examples is not allowed. Please send me or write your email and I'll send you example workbook.