How to get Backend (R/3) system type

[Former Member]

Hi team,

Currently backend (R/3) system details are maintained in SPRO ->Supplier Relationship Management ->SRM Server -> Technical Basic Settings -> Define Backend Systems. Here we maintain entry of logical system, its description, RFC Destination, system type and other fields. Values of backend systems are used at lots of place by referring table BBP_BACKEND_DEST quoting system type in where clause of select query. Currently values of system type are hardcoded as R3470 but now our backend (R/3) system is upgraded to ECC6.0 and this can happen later as well whenever SAP plans for new release.

So now we are looking how we can remove this hardcoding from select query so that whenever system is upgraded, this detail need not to be changed. Please suggest the place either table or function module from where we can get details for system type.

Thanks

Siddarth

[Former Member · Accepted solution]

table: bbp_function_map

FM:BBP_LOGICAL_SYSTEM_GETDETAIL

import parameter:

bbp_backend_detail-sys_type

Regards

Lauren

[Former Member · Accepted solution]

Hi Lauren,

Currently we are getting details using following query: -

    SELECT SINGLE log_sys dest
           FROM bbp_backend_dest
           INTO (v_logsys, v_rfcdes)
           WHERE sys_type = 'R3470'.

Function Module BBP_LOGICAL_SYSTEM_GETDETAIL provided by you uses same table to retrieve details based on log_sys from BBP_BACKEND_DEST table and we want to overcome harcoding done in where clause as SYS_TYPE = 'R3470'.

Please help me out in overcoming this.

thanks

Siddarth

[laurent_burtaire · Accepted solution]

Hello Siddarth,

When you have only one backend system, better way is to use BBP_GET_BACKEND_SYSTEMS function module instead of reading directly BBP_BACKEND_DEST table using SYS_TYPE as select criteria.

If more than one backend is linked to SRM, you have to use LOGSYS given by ET_LOGICAL_SYSTEMS table from function module above.

In this way, your logsys will be used as select criteria, depending on which backend must receive RFC call. It will be also hard coded in your select, but normally you never change a log system, contrary to system type (due to upgrade).

Regards.

Laurent.