Wednesday, February 22, 2017

What is embedded BW?

There is an embedded version of BW available as of NetWeaver 7.0. This means for any SAP NetWeaver based system like ECC 6.0, CRM 7.0, SCM, Solution Manager including SAP Business Suite and S4/HANA there is a BW available inside.

Primarily the  embedded BW shall be used within scenarios that are implemented in host system (ECC, CRM etc.) like embedded reporting scenarios (by leveraging BW's Analytic Manager (OLAP engine)) or embedded planning processes (leveraging BW's planning engine) however it is still full blown BW system. As per SAP they do not advise to use it as enterprise data warehouse.
Below are restrictions that are given by SAP while using the embedded BW:

1. Amount of data - shall not exceed 20% of total data volume in the system. If this happens there is probably a negative impact on core system functions.

2. Licenses – you may require license to run embedded BW in your NetWeaver system.

3. Security - it uses different authorization concept (BW one over classic concept used in ECC)


How to enable the embedded BW? Couple of activities shall be done in order to make the embedded BW work. This includes:
Assign Logical System Client – table RSADMINA
Set BW Namespaces to Modifiable - /BI0/* and /BIC/*
Activation of technical content
Switch On Business Function


More information:
1972819 - Setup SAP BPC optimized for S/4 HANA Finance and Embedded BW Reporting (aka Integrated Business Planning for Finance)

1919631 - Activating the BPC embedded

Monday, February 6, 2017

SAP S4/HANA editions / versions

In this post I try to summarize all versions of S4/HANA that are (or were) available per editions.

Last update:             06.02.2017


SAP S/4HANA On-Premises edition:        
SAP S/4HANA 1610                                          Oct 15, 2016            2346431
SAP S/4HANA 1511 FPS02                                Nov 15, 2015           2214213
SAP S/4HANA 1511 FPS01                                Nov 15, 2015           2214213
SAP S/4HANA 1511                                          Nov 15, 2015           2214213
SAP S/4HANA Finance 1503                              Mar 15, 2015           N/A


SAP S/4HANA Cloud edition:                   
SAP S/4HANA Cloud 1611                                 Nov 21, 2016           2388205
SAP S/4HANA Cloud 1608                                 Aug 12, 2016            2355076
SAP S/4HANA Cloud 1605                                 May 20, 2016           2314618


Legend:
FP = Feature Package Stack
Rel. Note = points to SAP Note; a type of Release Information Note (RIN)

More information:


Monday, January 30, 2017

What foreign currency rate was used in BW currency conversion?

BW uses standard SAP’s ECC functionality with regards to foreign (FX) currency conversion. This means that same set of TCUR* tables are being used while the BW system is doing the conversion. This is valid while doing the FX conversion during transformation /loading of data and also while running reports.


In BW reporting a key figure in report can have Conversion Type specifies in its definition under Conversion tab in its properties. 



The Conversion Type that can be chosen here are defined in the SAP BW backend – in tcode RSCUR. Here all settings like: what and how an Exchange Rate shall be obtained; where a source and target currency shall came from; and Time Reference to which the conversion type shall be tied to are specified.

So this is all that can be setup for the FX conversion. While looking at the converted numbers in the report’s output an issue of wrong data can arise from users. Question here is basically what FX from table TCURR was used?

To find out that for starter an “Currency and Unit Conversion” debugging can be started form t-code RSRT. This is available by hitting on “Execute + Debug” button.


While debugging it can be seen that following function modules are used in following sequence:
RSW_CUR_TRANSLATION_RATE_GET   Wrapper function ->
-> RSW_CTT_GET                                  Reads currency translation type
-> RSW_SCUR_CHECK_AND_GET              Determine source currency
-> RSW_TCUR_CHECK_AND_GET              Determine target currency
-> RSW_TRANSLATION_DATE_GET  determines date used to find translation rate
-> RSW_RATE_GET_BASIC                              determine the translation rate
-> CONVERT_TO_FOREIGN_CURRENCY here function DATA_FROM_DATABASE is called which calls another function DATEN_BEREITSTELLEN and this one finally reads the FS rate from table TCURR for previously determined Currency conversion type; from/to currency, date and client of the SAP BW system.

























Therefore you may want to just set a breakpoint into the FM CONVERT_TO_FOREIGN_CURRENCY to speed up debugging process.
Notice that variable DATC is nothing else just value from EXC_DATE variable converted into internal format by below ABAP statement:

CONVERT DATE exc_date INTO INVERTED-DATE datc.

This means the source variable in character format is converted into target one as complement on nine - difference to the number nine.
Needless to say that above statement is obsolete ABAP statement. It shall be replaced by using TRANSLATE statement.

More information:

Wednesday, January 25, 2017

Deleting error stack of DTP via ABAP

Error stack of DTP is function that is very useful in scenarios where data is not coming in proper format. While using it erroneous records are filtered out and only those which are correct are uploaded into data target. Later on BW administrator can correct the erroneous records and upload it too.


Below there is the error stack req ID 2.115.361 as depicted in DTP’s maintenance screen:


Now imagine that this error stack req is snot needed any more. We can also see it via ABAP report RSB_ANALYZE_ERRORLOG. The report provides a list of all available error stacks request in the system while analyzing contents of error tables:


To delete the error stack data of particular request we can use ABAP report: RSBM_ERRORLOG_DELETE while specifying particular DTP’s ID and ticking off “Delete Log” check box:


This is how output of RSBM_ERRORLOG_DELETE report looks like. After that the error stack req is not visible from RSB_ANALYZE_ERRORLOG either in t-code RSA1.


More information:
1095924 - Correction: Deletion/analyis report for error handling logs











Wednesday, January 18, 2017

Printing to PDF from SAP GUI

In case you need to save an output from SAP GUI into PDF format there are couple of options.


First of all Spool functionality supports saving PDFs within t=codes related to spool request such as SP02. It is available under menu Spool requests -> Forward -> Export as PDF…




In case system is based on older versions of SAP NetWeaver there are couple of ABAP reports that can be used to convert any spool request to PDF such as: RSTXPDFT4.















At last there are few applications t-codes such as in SD module: VF03 (Display Invoice) in which by entering PDF! Into t-code field automatically generates the PDF file.

More information:
1580639 - Is a PDF software required in windows for PDF conversion via device PDF1?

Tuesday, January 17, 2017

ABAP inline declarations

One of the new features of ABAP version 74 is inline declarations within ABAP expressions. The feature helps to shorten ABAP statements as there is no need for specific data variable creation upfront the statement.

The inline declaration is executed using an operator in a expression while placed in declaration position. Result of the inline declaration is used within the ABAP statement at the statement operand.

Examples:
DATA:
TYPES t_itab TYPE TABLE OF i 
             
WITH NON-UNIQUE KEY table_line

DATA(itab) = VALUE t_itab( ( ) ( ) ( ) ). 
LOOP AT itab INTO DATA(wa). 
  
... 
ENDLOOP.
DATA(text) = ’…’.

FIELD-SYMBOL:
TYPES t_itab TYPE TABLE OF i 
             
WITH NON-UNIQUE KEY table_line

DATA(dref) = NEW t_itab( ( ) ( ) ( ) ). 

ASSIGN dref->TO FIELD-SYMBOL(). 

LOOP:

LOOP AT  ASSIGNING FIELD-SYMBOL(). 
  
... 
ENDLOOP.

ASSIGN:
ASSIGN ... TO FIELD-SYMBOL().

READ TABLE:
READ TABLE itab INTO DATA(wa) ...
READ TABLE itab ASSIGNING FIELD-SYMBOL() ... 

FIND:
FIND ... IN ... MATCH COUNT DATA(cnt).

CALL TRANSFORMATION:
CALL TRANSFORMATION ... RESULT XML DATA(xml).

Method call:
oref->methIMPORTING p1 DATA(a1)
 
IMPORTING p2 DATA(a2)
 
... ).
DATA(ref) = class=>factory( ... ).
DATA(ixml) = cl_ixml=>create( ).
DATA(stream_factory) = ixml->create_stream_factory( ).
DATA(document) = ixml->create_document( ). 

SELECT:
Target is work area:
  SELECT SINGLE @abap_true FROM /bic/pcompcod
    
WHERE /bic/pcompcod @i_compcod AND objvers 'A'
    
INTO @DATA(lv_compcode).
Target is internal table:
  SELECT scarr~*spfli~*
     
FROM scarr INNER JOIN spfli ON scarr~carrid spfli~carrid
     
WHERE scarr~carrid @carrier
     
ORDER BY scarr~carrid
     
INTO TABLE @DATA(jtab).


More information:
ABAP demo report: DEMO_SELECT_INLINE_DECLARATION
ABAP News for Release 7.40 – Inline Declarations

Saturday, January 14, 2017

What version of JAVA platform does SAP support?

Most of SAP software even up to now supports Java EE 5 (former name was J2EE – Enterprise Edition) platform which was introduced back in 2006. Reason I write “even” is that fully fledged JAVA platform that was implanted to SAP products is still the Java EE 5. The truth is that SAP NetWeaver 75 supports Java 8 but only in limited modes like web profile. To surprise of many enterprise software folks out there it is needless to say that the Java EE 5 was only supported JAVA platform for years. Since SAP NetWeaver 70 and higher (7.1, 7.2, 7.3 and 74) supported only the Java EE 5 only. Therefore a move to Java 8 was a big step when it was announced in 2015 even though the Java 8 is not fully supported.

To better understand a reason of SAP it is needed to dig further into history. When SAP introduced JAVA Stack of NetWeaver (NW Java) it was more less clear that it is meant as the J2EE server to be used in a SAP environments. Acquisition of Sun by Oracle (in 2010) also didn’t attract the SAP to pay more attention to the JAVA either. Between these facts small clues are laying. One may be even dare to write that the JAVA has not been the focus of SAP. Even before cloud computing era they tried to support JAVA developers with so called Lean Java Server (LJS). That was never a real products but it later formed the JAVA server in SAP HANA Cloud Platform (HCP) which was earlier called SAP NetWeaver Cloud (and some other former names were: NetWeaver Neo or OnDemand Cloud Platform) which is cloud Platform-as-a-Service (PaaS)) offering from SAP. Actually the SAP NetWeaver Cloud supported Java EE 6.

It is obvious that going forward to keep up with rest of the enterprise software world SAP must support newer versions of JAVA platform. It is also reasonable that JAVA underwent many changes between versions the Java EE 5 and the Java 8. Also it needs to be understood that it is not easy to support the version 8 just by releasing a new support package and without disruption of customers installed SAP NW JAVA Stacks.

More information:

2250903 - Supported JVM versions for versions of NetWeaver Java

Friday, January 13, 2017

BPC related customizing in SPRO

Some BPC related parameters are being set up in t-code SPRO. BPC folks are very much aware of this but some BW folks do not know where to find it. So path in SPRO is SAP Customizing Implementation Guide -> Planning and Consolidation -> then e.g. Configuration Parameters -> Set Global Parameters


Thursday, January 12, 2017

HANA 2

On last year Barcelona’s TechEd (Nov. 8–10 2016) a new generation of SAP HANA was introduced – the HANA 2. It is basically a new generation offering functions in areas of DB management, data management, analytical intelligence, and application development. In details they cover following:

DB management – A new active/active read-enabled option allows reading data stored in secondary systems. Before that such a data needed to be replicated first before using it.

Data management – a web based tool called SAP Enterprise Architecture Designer allows to visualize impact of new technologies to current landscapes. E.g. enhancement of tiered storage impacting distributed storage of data by priority.

Analytical intelligence – new algorithms of areas like classification, association, time series and regression were added into predictive library to support job of e.g. data scientists in terms use cases of machine learning.

Application development – in this area functions for application servers, development tools, and development languages were added. New file processor interface allows to extraction of metadata from documents.

Micro services usage of cloud based micro services can enhance applications with analytical insight using APIs and any language or development platform.


More information:

Monday, January 2, 2017

BW: Conversion of DB tables to from Row Store to Column Store

Within a move of SAP NetWeaver based system from any DB to HANA DB there are many steps involved. Also a step of converting tables from row to column based is one of them.

Running the system on HANA DB you can have the table regardless of it store type (either row store or column store). Then depending on type of the system (OLTP or OLAP) majority of tables are set to one of the store types. E.g. in case of OLAP system (e.g. SAP BW) most of the tables are type of column store tables because it delivers a better performance in case of data warehouse data processing (running queries, transforming the data, etc). Also it delivers better compression rate in case of OLAP. On other side in the systems like OLTP it requires balanced approach whereas for some table a row store might be better and for others column store concept.

During HANA migration (or even before that to minimize downtime) an ABAP report called RSDU_MOVE_TO_COLUMN is used convert the tables based on row store to column store. However the program can be run even after the migration to find out what are tables that have potential to be converted to column store. The report has several modes of runtime. In the “Check only” mode a list of biggest row store tables is provided.

Also to see to what store type a particular table is set; see table DD09L (DD: Technical settings of tables) and its field (ROWORCOLST - For distinction between Row or Column Store) in particular.

More information:

2044047 - Pre-BW7.4 SP08 RowStore-to-ColumnStore conversion