Skip to Content

2462279 A1      SAP Notes

Last change on 02/14/2018

This blog provides an overview of the most important SAP notes regarding the topic BW transformation and  HANA processing mode. This blog is part of the blog series  HANA based BW Transformation.

 

From today (02/14/2018) we are collecting all new SAP notes in the consulting SAP Note:

2603241 – Overview and summary of the most important SAP Notes in the context of BW transformations with SAP HANA execution

This SAP Note provides an Excel spreadsheet with all SAP Notes for BW 7.50 and BW/4.

The Excel spreadsheet can be used to filter SAP Notes related to a specific Release / SP.

We do not maintain the below list  further on!

————————————————————————————————————————————-

A1.0 General Notes

2057542 – Recommendation: Usage of HANA-based Transformations

2230080 – Consulting: DTP: Out of memory situation during ‘SAP HANA Execution’ and the ‘Request by Request’ Extraction

2329819 – SAP HANA execution in DTPs (Data Transfer Processes) – Optimizations (Added on 09/21/2016)

 

A1.1      BW 7.40

2067912 – SAP HANA transformations and analysis processes: SAP Notes for SAP NetWeaver 740 with Support Package 8 or higher

2152643 – SAP HANA Processing: SAP HANA Processing: Sorting of records after call of expert script – Manual Activities

2222084 – DTP: Out of memory situation during ‘SAP HANA Execution’ and the ‘Request by Request’ Extraction

2144057 – SAP HANA Processing: BW 7.40 SP8 – SP11: HANA Analysis Processes and HANA Transformations (Part 10)

2159872 – SAP HANA Processing: BW 7.40 SP9 – SP11: HANA Analysis Processes and HANA Transformations (Part 12)

2149500 – SAP HANA Processing: BW 7.40 SP9 – SP11: HANA Analysis Processes and HANA Transformations (Part 13)

2177146 – SAP HANA Processing: BW 7.40 SP8 – SP12: HANA Analysis Processes and HANA Transformations (Part 14)

2189116 – SAP HANA Processing: BW 7.40 SP8 – SP12: HANA Analysis Processes and HANA Transformations (Part 15)

2210944 – SAP HANA Processing: BW 7.40 SP8 – SP13: HANA Analysis Processes and HANA Transformations (Part 16)

2214542 – SAP HANA Processing: BW 7.40 SP8 – SP13: HANA Analysis Processes and HANA Transformations (Part 17)

2230582 – SAP HANA Processing: BW 7.40 SP8 – SP13: HANA Analysis Processes and HANA Transformations (Part 18)

2254397 – SAP HANA Processing: BW 7.40 SP8 – SP14: HANA Analysis Processes and HANA Transformations (Part 19)

2299940 – SAP HANA Processing: BW 7.40 SP8 – SP15: HANA Analysis Processes and HANA Transformations (Part 20)

2367343 – SAP HANA Processing: BW 7.40 SP8 – SP16: HANA Analysis Processes and HANA Transformations (Part 21) (Added on 09/20/2016)

2448895 – SAP HANA Processing: BW 7.40 SP8 – SP17: HANA Analysis Processes and HANA Transformations (Part 22) (Added on 05/23/2017)

2603055 – 740SP20: SAP Hana Execution: No records inserted into the target when target is database table with client field (Added on 02/13/2018)

 

A1.2      BW 7.50

2192329 – SAP HANA Processing: BW 7.50 SP00 HANA Analysis Processes and HANA Transformations

2220753 – SAP HANA Processing: BW 7.50 SP00 – SP01: HANA Analysis Processes and HANA Transformations

2262474 – SAP HANA processing: BW 7.50 with SP00 – SP02: SAP HANA analysis processes and SAP HANA transformations

2281480 – SAP HANA processing: BW 7.50 with SP00 – SP03: SAP HANA analysis processes and SAP HANA transformations

2303781 – SAP HANA processing: BW 7.50 with SP00 – SP03: SAP HANA analysis processes and SAP HANA transformations (II)

2317554 – SAP HANA processing: BW 7.50 with SP00 – SP04: SAP HANA analysis processes and SAP HANA transformations (Added on 10/10/2016)

2353126 – SAP HANA processing: BW 7.50 with SP04 – SP05: SAP HANA analysis processes and SAP HANA transformations (Added on 08/24/2016)

2385163 – SAP HANA processing: BW 7.50 with SP04 – SP06: SAP HANA analysis processes and SAP HANA transformations (Added on 11/15/2016)

2424016 – SAP HANA processing: BW 7.50 with SP04 – SP07: SAP HANA analysis processes and SAP HANA transformations (Added on 02/03/2017)

2467323 – SAP HANA processing: BW 7.50 with SP04 – SP08: SAP HANA analysis processes and SAP HANA transformations (Added on 05/10/2017)

2513982 – SAP HANA processing: BW 7.50 with SP04 – SP09: Enhancements error handling process (Added on 08/03/2017)

2517557 – SAP HANA Execution: Filter not working for HAP (Added on 08/11/2017)

2521118 – SAP HANA Transformation: Activation of TRFN with HANA procedures results in an SQL error  (Added on 08/29/2017)

2520298 – SAP HANA Processing: ADSO filter handling for HAP (Added on 08/29/2017)

2520373 – SAP HANA Processing: Missing attribute in the node OPERATION.FORMULA_PROJ (Added on 08/29/2017)

2519726 – SAP HANA Processing: DTP filter on infocube doesn’t work (Added on 08/29/2017)

2527006 – 750SP10: SAP HANA Execution: Extraction from source with stacked Transformation doesn’t work correctly (Added on 08/30/2017)

2534686 – SAP HANA Processing: Error handler (Miscellaneous corrections and improvements) (Added on 09/14/2017)

2538259 – SAP HANA Processing: 0RECORDMODE: Invalid datatype, length or/and scale are missing (Added on 09/22/2017)

2535948 – SAP HANA Processing: Error handler (Duplicate records in error stack) (Added on 09/25/2017)

2544156 : 750SP11: SAP Hana Eexecution: Wrong Aggregation of Key Figures (Added on 10/09/2017)

2543867 – BW750 SP11: SAP HANA Execution: Generation of external HANA views fails for BW query (Added on 10/11/2017)

2547945 – 750SP11: SAP HANA Execution: Error in activation of Error-DTP (Added on 10/12/2017)

2546741 – BW750 SP11: SAP HANA Execution: Full load extraction from Advanced datastore object (Added on 10/12/2017)

2548090 – 750SP11: SAP Hana Execution: Extraction of DTP with transformation with constant rules error out (Added on 10/12/2017)

2546718 – 740SP19: SAP HANA Execution:After import of HAAP doesn’t work correctly (Added on 10/12/2017)

2541540 – SAP HANA Processing: InfoSource Aggregation Behaviour (Added on 10/17/2017)

2541786 – SAP HANA Processing: Ignore ‘Recorde Mode’ filters when calculating packaging criteria for ADSOs (Added on 10/17/2017)

2538296 – SAP HANA Processing: Wrong result set with setting ‘InfoSource Behaves Like a DataSore Object’ (Added on 10/17/2017)

2554423 – SAP HANA Processing: Feature not supported: invalid character encoding: ”,…, (Added on 10/26/2017)

2561441 – 750SP11: Error in Import of Transformation with Source as InfoCube with AMDP Start Script (Added on 11/13/2017)

2557892 – BW 750 SP11: SAP HANA Execution: DTP doesn’t not pick records from datasource based on HANA DB Source system (Added on 11/13/2017)

2557894 – BW 750 SP11: SAP HANA Execution: Numeric overflow for SNUMC conversion exit (Added on 11/13/2017)

2579402 – SAP HANA Execution: DTP Extraction from HANA datasource (Added on 01/12/2018)

 

A1.2.1   Additional notes (BW 7.40 and 7.50)

2365543 – Error in Transformation and missing checks (Added on 09/20/2016)

2368206 – Error in Transformation with expert script (Added on 09/20/2016)

2357761 – 740 SP16: Incorrect aggregation behavior for Cube like ADSOs updated using Expert Routine/Expert Script (Added on 09/21/2016)

2376725 – 750SP6: Deletion of AMDP script does not delete the AMDP class (Added on 10/12/2016)

2353551 – SAP BW 7.50 (SP06) Transport of Transformation does not work (Added on 10/12/2016)

2326847 – SAP BW (ABAP) 7.50 (SP05) error when you activate a transformation with script (Added on 10/12/2016)

2365713 – 750SP6: Minor problems in Transformations with HANA Scripts (Added on 10/12/2016)

2366567 – Transitive attributes in Transformation (Added on 10/12/2016)

2374635 – SAP BW / SAP BW/4HANA wrong messages on execution check; missing checks (Added on 10/12/2016)

2404315 – SAP BW / SAP BW/4HANA (ABAP): check for runtime not work correct (Added on 03/31/2016)

2365508 – SAP HANA based currency conversion: High accuracy (Added on 11/15/2016)

2412904 – InfoObject time columnview does not exist, if the InfoObject is not flagged as InfoProvider  (Added on 03/15/2017)

2442579 – 750SP8: Errors during after import of Transformation with Individual AMDP scripts  (Added on 03/15/2017)

2359959 – Delete table RSDHA_009B_TMP entries (Added on 03/29/2017)

2436433 – DTP execution does not allow mixed scenarios (Added on 04/11/2017)

2487617 – 740SP18: Ambiguous mapping for Units and Currencies in transformation having currency/unit conversion enabled and target as InfoSource (Added on 06/27/2017)

2401080 – 74017:Changing Batch manager settings of a DTP Creates a new HANA Transformation (Added on 07/24/2017)

2453778 – 750SP8: Error during import of Transformations having AMDP Scripts (Added on 07/24/2017)

2410814 – 750SP7: Error in import of DTP having corresponding Transformation as HANA Exper Script (Added on 07/24/2017)

2398869 – 750SP7: Transformation with Invalid Runtime Status can be activated (Added on 07/24/2017)

2392032 – 750SP7: Error in import of transformation with AMDP scripts (Added on 07/24/2017)

 

A1.3   BW/4 HANA

2347871 – SAP HANA processing: BW/4 HANA SP00: SAP HANA analysis processes and SAP HANA transformations (Added on 07/24/2017)

2378164 – SAP HANA processing: BW/4 HANA SP00-SP01: SAP HANA analysis processes and SAP HANA transformations (Added on 07/24/2017)

2406985 – SAP HANA processing: BW/4 HANA SP00-SP02: SAP HANA analysis processes and SAP HANA transformations (Added on 02/20/2017)

2447603 – SAP HANA processing: BW/4 HANA SP00-SP03: SAP HANA analysis processes and SAP HANA transformations (Added on 05/10/2017)

2458274 – SAP HANA processing: BW/4 HANA SP04: SAP HANA analysis processes and SAP HANA transformations (Added on 05/10/2017)

2492137 – SAP HANA processing: BW/4 HANA SP04 – SP05: SAP HANA analysis processes and SAP HANA transformations (II) (Added on 06/21/2017)

2492137 – SAP HANA processing: BW/4 HANA SP04 – SP05: SAP HANA analysis processes and SAP HANA transformations (II) (Added on 08/29/2017)

2532026 – SAP HANA processing: BW/4 HANA SP04 – SP06: SAP HANA analysis processes and SAP HANA transformations (Added on 09/14/2017)

2549793 – SAP HANA processing: BW/4 HANA SP04 – SP06: SAP HANA analysis processes and SAP HANA transformations (II) (Added on 10/17/2017)

2553954 – SAP HANA Execution: ‘Read Master Data’ used a in field based InfoSource (Added on 10/25/2017)

2554017 – SAP HANA Execution: Package size is ignored when using ‘Delta Extraction Mode’ (Added on 10/25/2017)

2554314 – SAP HANA Execution: SAP DBTech JDBC: [266]: inconsistent datatype: search table error: inconsistent datatype (Added on 10/25/2017)

2554951 – SAP HANA Execution: Error during DTP execution “Invalid column name XYZ” (Added on 10/26/2017)

2564373 – SAP HANA Execution: Delta value determination not possible with stacked data flows (Added on 11/15/2017)

2561257 – SAP HANA Execution: Type conversion of type RAW data type fails (Added on 11/15/2017)

2561249 – SAP HANA Execution: Extraction from HCPR is incomplete (Added on 11/15/2017)

2564308 – SAP HANA Execution: Package size is ignored when loading from HCPR without packaging (Added on 11/15/2017)

2560659 – SAP HANA Execution: Keyfigures are getting double in HANA mode (Added on 11/15/2017)

2559274 – SAP HANA Execution: Missing Record as part of Delta Load (Added on 11/15/2017)

2557720 – SAP HANA Execution: Delta pointer is not changing for hana datasource when using streaming (Added on 11/15/2017)

2556744 – SAP HANA Execution: Extraction from DataSource: No Data is extracted (Added on 11/15/2017)

2556315 – SAP HANA Execution: Read from ADSO in transformation – loading incorrect records (Added on 11/15/2017)

2556129 – SAP HANA Execution: The generation of a Calculation Scenario for an error DTP fails (Added on 11/15/2017)

2558514 – SAP HANA Execution: ‘Read from ADSO’ -> duplicates records (Added on 11/15/2017)

2566904 – SAP HANA Execution: Delta load returns all data in serial processing (Added on 11/20/2017)

2571021 – SAP HANA Execution: Request by request data load duplicates records (Added on 11/20/2017)

2571864 – SAP HANA Execution: Adding an aDSO lookup to a transformation causes SQL error 2048 (Added on 11/29/2017)

2572442 – SAP HANA Execution: Duplication of Records With Currency and Uom Conversion (Added on 11/30/2017)

2573208 – SAP HANA Execution: Deletion of delta record works not properly (Added on 12/01/2017)

2573226 – SAP HANA Execution: Hana runtime check in DTP XXX fails with errors (Added on 12/01/2017)

2591476 – SAP HANA Execution: The extraction of InfoObject Attributes or Texts fails (Added on 01/19/2018)

2592689 – SAP HANA Execution: Wrong currency conversion results (Added on 01/23/2018)

2594516 – SAP HANA Execution: Too many records are loaded with processing mode F (Added on 01/25/2018)

2595198 – SAP HANA Execution: DTP runs “Out of memory” when extracting data HANA DataSource (Added on 01/29/2018)

2599708 – SAP HANA Execution: Unable to activate DTP (Added on 02/06/2018)

2600475 – SAP HANA Execution: SQL Error in a loop back transformation in HANA mode with an AMDP start routine (Added on 02/07/2018)

2601154 – SAP HANA Execution: Unexpected SQL Error when loading data to Open Hub Destination (Added on 02/09/2018)

2553733 – BW/4 1.0 SP8: Incorrect processing of Transformation during Edit Mode in RSTRANGUI (Added on 02/09/2018)

 

A1.3.1   Additional notes (BW/4 HANA)

2484713 – Error during transport – changes in routines are not transferred (Added on 06/09/2017)

2491221 – ABAP routines (expert routines) are not handled correctly (Added on 06/21/2017)

2488772 – BW/41.0 SP5: Transport of Individual routines/formula doesn’t work (Added on 06/14/2017)

2270825 – ADSO: Incorrect definition of reporting and extraction views (Added on 06/29/2017)

2480967 – Remodeling/dump during import (Added on 06/29/2017)

 

A1.4   Cross-Release Notes

2504644 – 740SP18: Incorrect aggregation behavior for Cube like ADSOs with fields updated using Expert Routine/Expert Script

2516952 – 750SP11: SAP HANA Execution: Invalid column index error when loading XL Texts using AMDP Script

2423215 – SAP HANA Processing: Non Supported Formulas in HANA Transformations

2505554 – Further  Conversion Exits for SAP HANA-Sourcesystem

2530574 – 750SP10: SAP HANA Execution: Transport of transformation which can be executed in HANA ends in a short dump

2534347 – 750SP10:SAP HANA Execution: Problems in Transformation with Target as Text of Charateristics with Extra Long Text

2554846 – 750SP11: ABAP Runtime errors happen during generation of BW Calculation Scenario

2554952 – 750SP11:SAP Hana Execution: Error in push down of transformation when field PERIV in source mapped to 0FISCVARNT in target

2555107 – SAP HANA Execution: Support XXL Attributes in ADSO

2558465 – SAP HANA Execution: Check Availability

2565655 – SAP HANA Execution: Use of XXL InfoObject as target field within a transformation

2462861 – Data Packaging API for DTP Extraction with packaged/parallel processing: Corrections for NULL-Handling and Partitioned Tables

2511520 – Wrong Data in DTP Extraction with packaged/parallel processing

2502376 – DTP Extraction on ADSO or HANA DataSource terminates with SQL Error b…

2462279 – Packaging API – Sort order for DTP Semantic groups ignored

2564586 – SAP HANA Execution: Enhancing error handling for DTP execution – II (Added on 11/22/2017)

2561897 – SAP HANA Execution: DTP execution uses conversion exit based on source mapping (Added on 11/22/2017)

2563203 – 750SP11: SAP Hana Execution: DTP not HANA Execution Enabled (Added on 11/22/2017)

2416745 – Check of Transformation result in invalid runtime (Added on 01/08/2018)

2569553 – Missing Records when Extracting from DataStore Objects or HANA DataSources (Added on 01/10/2018)

2588204 – SAP HANA Execution: Key figure aggregation with AMDP scripts (Added on 01/12/2018)

2588183 – 750SP12: SAP Hana Execution: Transformation from CHAR to NUMC gets wrong results in hana execution (Added on 01/12/2018)

2601945 – SAP Hana Execution: No records inserted into the target when target is database table with client field (Added on 02/09/2018)

 

A1.5  Data Packaging

2452161 – DTP Parallel Extraction: Wrong Filter Predicate due to missing Parantheses (Added on 11/20/2017)

2446721 – DTP Extraction from a HANA DataSource: SQL Error because of quoted literal for DECIMAL Data type (Added on 11/20/2017)

2432335 – HANA Transformation: Correction for SQL-Errors caused by pre-processing for packaging (Added on 11/20/2017)

2431824 – HANA DataSource: Extraction with package size 1 is not taken into account (Added on 11/20/2017)

2426920 – DTP Execution from HANA DataSource with TIMESTAMP field for packaged read (Added on 11/20/2017)

2425872 – HANA DataSource: DTP Extraction with Packaged Read loads wrong data (Added on 11/20/2017)

2422950 – Technical Enhancement for SAP-internal API (Added on 11/20/2017)

2407375 – HANA DataSource: Enhancements for Conversion Views (2) (Added on 11/20/2017)

2393688 – Technical Enhancement for SAP-internal API (Added on 11/20/2017)

2413817 – HANA DataSource: Extraction with Packaged Read: Enhancement for Rowount Check (Added on 11/20/2017)

2395079 – HANA DataSource: Wrong number of records extracted with packaged read (Added on 11/20/2017)

2394526 – HANA DataSource: Improvements for Packaged Read and Initial Load (Added on 11/20/2017)

2394478 – HANA DataSource: DTP Extraction terminates with syntax error in expression string (Added on 11/20/2017)

2394033 – HANA DataSource: Packaged Read from a Table without Primary Key (Added on 11/20/2017)

 

 

A1.6   Special Notes (not general mandatory)

2355284 – Advanced DataStore Objects: Support of Partitioned Execution (Added on 08/24/2016)

2355229 – Advanced DataStore Objects: Support of Partitioned Execution (Added on 08/24/2016)

 

A1.7      Consulting Notes

2262114 – One Space Handling for ABAP in SAP HANA (Added on 08/03/2017)

2549227 – Consulting:Collection of Consulting notes related to SAP Hana Transformation and SAP Hana Analysis Process (Added on 10/17/2017)

 

A1.8      HANA Notes

2579041 – Unexpected Result for SQL Query with Restriction on Internal Column $rowid$ (Added on 01/10/2018)

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Torsten,

    nice collection of notes (although I haven’t checked only a bunch so far and the one for 7.5 SP4 is of course not yet available 😉 ).

    Some of the links seem to point to only internal SAP servers (containing wdf.sap.corp).

    Maybe you could adjust them either to the “old” links like “http://service.sap.com/sap/support/notes/2342343” or the new links (used in the Support Launchpad) like “https://launchpad.support.sap.com/#notes/2342343/E“?

    with kind regards,

    Philipp

    (0) 

Leave a Reply