Wednesday, May 30, 2018

Activating change pointers

Change pointers (better to say ALE change pointers) are essential within ALE (Application Link Enabling) technology. While there is any change (think of CRUD type of operation) done to data (like biz object in SAP e.g. material, customer, sales order etc.) a change documents are generated. In case change pointers are setup for the biz object the changed data is transferred to other systems.

To enable the data exchange like this the change pointers, need to be activated in the system. For this there is a t-code BD61 (program RBDTBDA1) available. It sets flag X into field ACTIVE of table TBDA1.


Tuesday, April 17, 2018

How to call BAPI in SAP from nodejs app

Recently I used nodejs RFC Connector provided by SAP. The module called node-rfc provides bindings for SAP NetWeawer RFC Library. Via the library it is possible to call RFC enabled function modules residing in SAP NetWeaver based ABAP system from nodejs, leveraging SAP Remote Function Call (RFC) protocol. For installation of the module into your nodejs framework see here.

Below I provide two example nodejs apps showcasing possibilities to passing values to BAPI’s parameters like single values, structures and tables.

I think that the node-rfc module is great option how to interface with SAP systems from heavily used nodejs app like in case of web based apps.

You can find both examples on my github:

demo_BAPI_params1.js      usage of table and variable parameter

//demo prg to showcase usage of table and variable parameters of SAP's BAPI while called from nodejs app via SAP/node-rfc nodule
"use strict";
var rfc = require('node-rfc');
var abapSystem = {
    user: 'sap_user',
    passwd: 'sap_user_pwd',
    ashost: 'sap.nodomain',
    sysnr: '01',
    client: '800'
};
var client = new rfc.Client(abapSystem);
var MAX_ROWS = 3;
var SELECTION_RANGE_str = {
               PARAMETER: "USERNAME",
               SIGN:      "I",
               OPTION:    "CP",
               LOW:       "A*"
        };     
var SELECTION_RANGE_tab = [SELECTION_RANGE_str];
       
client.connect(function(err) {
    if (err) {
        return console.error('could not connect to server', err);
    }  
    client.invoke('BAPI_USER_GETLIST', {
                       MAX_ROWS: MAX_ROWS,
                       SELECTION_RANGE: SELECTION_RANGE_tab
        },
        function(err, res) {
            if (err) {
                return console.error('Error invoking BAPI_USER_GETLIST:', err);
            }
               console.log('Result BAPI_USER_GETLIST:', res);
        });   
});

demo_BAPI_params2.js      usage of structure parameter of SAP's BAPI

//demo prg to showcase usage of structure parameter of SAP's BAPI while called from nodejs app via SAP/node-rfc nodule
"use strict";
var rfc = require('node-rfc');
var abapSystem = {
    user: 'sap_user',
    passwd: 'sap_user_pwd',
    ashost: 'sap.nodomain',
    sysnr: '01',
    client: '800'
};
var client = new rfc.Client(abapSystem);
 
client.connect(function(err) {
  if (err) {
    return console.error('could not connect to server', err);
  }
  var IMPORTSTRUCT = {
    RFCDATA1: 'some value of structure field RFCDATA1',
    RFCDATA2: 'some value of structure field RFCDATA2'
  };
  client.invoke('STFC_STRUCTURE',
    { IMPORTSTRUCT: IMPORTSTRUCT },
    function(err, res) {
      if (err) {
        return console.error('Error invoking STFC_STRUCTURE:', err);
      }
      console.log('Result STFC_STRUCTURE:', res);
  });
});

Friday, March 23, 2018

SAP Lumira product family and versions

As a follow up on my older post about Lumira on where to download it I’m adding more information about the Lumira it-self and also a list of available versions and corresponding release SAP Notes.

SAP Lumira is formerly known as SAP Visual Intelligence and it is successor of SAP BusinessObjects Design Studio 1.x. Following favors of the Lumira are available:

1.   SAP Lumira Server is a processing server for Lumira content on SAP BI Platform. Add-on installation to BI platform. Hosts execution runtime of Discovery stories and Designer applications. Business users view SAP Lumira documents within BI Launchpad.

2. SAP Lumira client part has the following components:

2.1 Lumira Discovery: Rich client application used to visualize and create ad-hoc stories about data. Targeting business key users to connect, acquire, manipulate, and merge data – work with live or imported data.

2.2 Lumira Designer: Rich client app for professional designers of corporate analysis applications based on SAP BW, SAP HANA and universe data sources. Supports shared UI elements (e.g. headers, footers, toolbars). Supports planning applications. It is the product of choice when full support for BW and HANA data models and engine capabilities is required

2.3 Launch pad viewer: Web application that acts a window for users to view information in the form of data, visualizations and reports. It also allows users to export the content to other business applications (like Microsoft Excel) and also to save it to a specified location. Users can also use various analytical tools to explore the information.

3. SAP Lumira Web Applications: This is embedded within the BI Launchpad and CMC applications to allow access to Lumira content within BI Launchpad and CMC (Viewer and Application).

4. SAP BusinessObjects Business Intelligence (BI) platform server: This is where the SAP Lumira Server integrates into BOBJ platform.

5. SAP Lumira, server version for SAP HANA (LS4H): As of the Lumira version 1.28 SAP discontinued future updates to LS4H and Lumira Cloud. See this Note and blog.

Lumira         Latest SPS             Release Date (RTC)          Note
2.2               N/A                         N/A                                   N/A
2.1                init SPS                   15.12.2017                        2561565
2.0                SPS03                     15.11.2017                       2516330
SPS02                     14.08.2017                       2462799
SPS01                     19.07.2017                       2465894
init SPS                   13.04.2017                                
1.30              SPS30                     24.03.2016
1.29              SPS29                     24.03.2016
1.28              SPS28                     09.09.2015
1.27              SPS27                     29.06.2015
1.25              SPS25                     05.05.2015
1.24              SPS24                     27.04.2015
1.23              SPS23                     07.04.2015
1.22              SPS22                     06.02.20152
1.21              SPS21                     15.01.2015
1.20              SPS20                     30.10.2014
1.19              SPS19                     09.10.2014
1.18              SPS18                     31.07.2014                       2034979
1.17              SPS17                     14.06.2014
1.15              SPS15                     06.02.2014
1.14              SPS14                     17.12.2013
1.13              SPS13                     03.12.2013
1.12              SPS12                     03.10.2013
1.11              SPS11                     14.06.2013
1.10              SPS10                     30.04.2013
1.09              SPS09                     29.03.2013                       1885745
1.08              SPS08                     28.02.2013                       1840968
1.07              SPS07                     20.11.2012                       1840966
1.06              SPS06                     17.10.2012                       1776895
1.05              SPS05                     04.10.2012                       1772235
1.04              SPS04                     27.09.2012                       1772240
1.03              SPS03                     04.09.2012                       1772239
1.02              SPS02                     31.08.2012                       1772237
1.01              SPS01                     17.07.2012                       1772236
1.0               init SPS                   11.05.2012                      
         
Where to download the Lumira?
saplumira.com - free personal 30 days version of Lumira Discovery
2021361 - Where to download SAP Lumira software?
1869059 - How to find SAP Lumira on the SAP Software Download Center

Useful information:
Online docu: help.sap.com/lumira
support site component: BI-LUM-SRV-BIP
2449584 - SAP Lumira - Licensing, Download and Activation FAQ *** MASTER KBA ***
2208172 - SAP Lumira Family Supported Versions Matrix

Monday, March 19, 2018

Versions of Analysis for Office

Last update: 14.6.2018

Here’s a short overview on what versions of an Analysis for Office tool (the new BEx) are available.

AfO SPS                 Release Date (RTC)          Note
2.7 SP 0                  13.6.2018                         2609974

2.6 SP 3                  17.5.2018                         2557367
2.6 SP 2                  21.03.2018                       2519188
2.6 SP 1                  07.12.2017                       2519128
2.6 SP 0                  04.12.2017                       2519256

2.5 SP 4                  20.02.2018                       2557401
2.5 SP 3                  14.12.2017                       2541311
2.5 SP 2                  28.09.2017                       2423532
2.5 SP 1                  01.08.2017                       2423329
2.5 SP 0                  31.5.2017                         2423523

2.4 SP 5                  29.11.2016                        2483758      
2.4 SP 4                  01.07.2017                       2402003
2.4 SP 3                  29.05.2017                       2401970


2.4 SP 2                  06.03.2017                       2401950  
2.4 SP 1                  13.01.2017                       2360880  
2.4 SP 0                  28.11.2016                       2360879

2.3 SP 3                  26.05.2016                        2367092
2.3 SP 2                  20.09.2016                       2289542
2.3 SP 1                  22.07.2016                       2289571
2.3 SP 0                  24.05.2016                       2276887

2.2 SP 4                  20.11.2015                        2215168
2.2 SP 3                  05.05.2016                       2241328
2.2 SP 2                  11.01.2016                       2241327
2.2 SP 1                  28.12.2015                       2241326
2.2 SP 0                  16.11.2015                       2215163

2.1 SP 3                  29.05.2015                       2204161      
2.1 SP 2                  14.09.2015                       2164363
2.1 SP 1                  23.07.2015                       2160993
         
2.0 SP 4                  30.07.2015                       2164371
2.0 SP 2                  09.03.2015                       2091746

1.4 SP 17                 08.03.2016                        2241062
1.4 SP 16                08.03.2016                       2241061
1.4 SP 15                07.12.2015                       2139225
1.4 SP 14                30.09.2015                       2139224
1.4 SP 13                20.07.2015                       2139223
1.4 SP 12                14.05.2015                       2139222
1.4 SP 11                09.03.2015                       2059340
1.4 SP 10                10.12.2014                       2059338
1.4 SP 09                10.10.2014                       1910506
1.4 SP 08                29.07.2014                       1910505
1.4 SP 07                12.05.2014                       1910504
1.4 SP 06                24.3.2014                         1910503
1.4 SP 05                05.12.2013                       1909252
1.4 SP 04                14.10.2013                       1909251
1.4 SP 03                05.09.2013                       1854154
1.4 SP 02                23.07.2013                       1854153
1.4 SP 01                11.06.2013                       1854112
1.4 SP 0                  11.06.2013                       1843946

1.3 SP 09                24.06.2013                       1814288
1.3 SP 08                24.04.2013                       1814287
1.3 SP 07                05.04.2013                       1841790
1.3 SP 06                31.01.2013                       1740318
1.3 SP 05                10.12.2012                       1740317
1.3 SP 04                25.01.2013                       1740316
1.3 SP 03                25.01.2013                       1740315
1.3 SP 02                24.08.2012                       1740314
1.3 SP 01                20.07.2012                       1740313

1.2 SP 10                12.09.2012                       1698671
1.2 SP 09                21.08.2012                       1698670
1.2 SP 08                23.07.2012                       1698669
1.2 SP 07                09.07.2012                       1739684
1.2 SP 03                19.03.2012                       1677666

1.1 SP                     N/A                                   1518359

Useful information:
1518359 - SAP BusinessObjects Analysis Office & BIP Add On Release schedule
Online documentation help.sap.com/boao
2482784 - Best Practices in Analysis for Office
Feedback to improve Analysis for MS Office: