ServiceNow SAP Integration Guide

Architecture Overview

Implementation Steps

var sapAction = new sn_ih_integration.IntegrationHub();
var actionName = 'SAP - Execute RFC Function';
var inputs = {
    'connection_alias': 'SAP_Production',
    'function_name': 'BAPI_EMPLOYEE_GETDATA',
    'import_parameters': '{
        "USERID": "' + current.user_name + '",
        "WITH_LOGON_DATA": "X"
    }'
};
var result = sapAction.execute(actionName, inputs);
if (result.status == 'success') {
    gs.info('SAP user data retrieved: ' + result.output);
} else {
    gs.error('SAP RFC call failed: ' + result.error_message);
}

var gr = new GlideRecord('incident');
gr.initialize();
gr.short_description = 'SAP ABAP Error: ' + sapError.message_text;
gr.description = 'System: ' + sapError.system_id + '\n' +
                'Program: ' + sapError.program_name + '\n' +
                'Transaction: ' + sapError.transaction_code + '\n' +
                'Error Class: ' + sapError.message_class + '\n' +
                'Error Number: ' + sapError.message_number;
gr.priority = (sapError.severity == 'A') ? '1' : '2';
gr.category = 'Software';
gr.subcategory = 'SAP Application';
gr.assignment_group = 'SAP Basis Team';
gr.caller_id = gs.getUserID();
var incidentId = gr.insert();
gs.info('Created incident ' + incidentId + ' for SAP error: ' + sapError.message_id);

// Outbound: Create SAP transport request
var sapTransport = new sn_ih_integration.IntegrationHub();
var inputs = {
    'connection_alias': 'SAP_Production',
    'function_name': 'TR_RELEASE_REQUEST',
    'import_parameters': '{
        "IV_REQUEST": "' + current.sap_transport_number + '",
        "IV_SUCCESS_MSG": "X"
    }'
};
var result = sapTransport.execute('SAP - Execute RFC Function', inputs);
if (result.status == 'success' && result.output.EV_SUCCESS == 'X') {
    current.state = '3'; // Implement
    current.sap_release_status = 'Released';
    current.update();
    gs.addInfoMessage('SAP transport request released successfully');
}

try {
    var sapResult = new sn_ih_integration.IntegrationHub().execute('SAP - Get User Data', inputs);
    if (sapResult.status !== 'success') {
        throw new Error('SAP integration failed: ' + sapResult.error_message);
    }
    // Process successful SAP response
    var userData = JSON.parse(sapResult.output);
    gs.info('Successfully retrieved SAP user data for ' + userData.BNAME);
} catch (ex) {
    gs.error('SAP integration error: ' + ex.message);
    var event = new GlideRecord('sysevent');
    event.initialize();
    event.name = 'sap.integration.failure';
    event.parm1 = current.getTableName();
    event.parm2 = current.getUniqueValue();
    event.instance = gs.getProperty('instance_name');
    event.insert();
}

Common Use Cases

Troubleshooting

Pro Tips

• →Implement SAP data archiving awareness by configuring your integration to handle archived records gracefully, using SAP's archive information structures or READ_ARCHIVE function modules to retrieve historical data that may have been moved from active tables to archive files.
• →Leverage SAP's Change Documents (CDHDR/CDPOS tables) to implement real-time delta synchronization instead of full data imports, significantly reducing system load and improving integration performance while ensuring you capture all relevant changes.
• →Create custom SAP function modules (Z-functions) for complex data extractions rather than relying solely on standard BAPIs, as this allows you to implement ServiceNow-specific logic, error handling, and performance optimizations directly in the SAP system.
• →Implement connection pooling optimization by configuring multiple SAP connection aliases for different data types or business processes, allowing you to tune connection parameters, timeout values, and retry logic specific to each integration pattern.
• →Use ServiceNow's Integration Hub bulk data operations combined with SAP's internal table processing to handle large data volumes efficiently, implementing proper commit strategies and progress tracking to prevent RFC timeouts on massive data synchronizations.
• →Establish comprehensive monitoring by creating custom ServiceNow dashboards that track SAP integration metrics including RFC call volumes, error rates, data synchronization lag times, and SAP system availability to proactively identify performance trends and potential issues.

Known Limitations

• —SAP RFC connections are limited by the SAP system's configured dialog work processes and gateway limitations, typically supporting 50-100 concurrent connections per application server, which may require connection pooling strategies for high-volume integrations. Performance degrades significantly when RFC connection limits are exceeded, potentially impacting both ServiceNow and SAP system responsiveness.
• —The SAP Integration Hub spoke requires a MID Server with sufficient memory allocation (minimum 4GB recommended) and SAP JCo library compatibility, limiting deployment options in cloud-only ServiceNow instances without on-premises infrastructure. JCo library updates must be manually coordinated with SAP kernel upgrades and ServiceNow release schedules.
• —Real-time bi-directional synchronization is challenging due to SAP's batch-oriented architecture and database locking mechanisms, often requiring scheduled polling or SAP workflow-triggered updates rather than true real-time data exchange. Complex SAP customizations or heavily modified data structures may not be compatible with standard Integration Hub spoke actions.
• —SAP authorization concepts (authorization objects, profiles, roles) are complex and may require dedicated SAP security expertise to properly configure RFC users with minimal necessary privileges. Over-privileged RFC users pose security risks, while under-privileged users cause integration failures that can be difficult to diagnose.
• —Data volume limitations exist for single RFC calls, typically restricted to 10,000-50,000 records per transaction depending on SAP system configuration and network bandwidth, requiring pagination strategies for large data sets like complete employee or asset master data extractions.

Frequently Asked Questions