About Torsten_

Torsten_ · 03-24-2017

Last change on 01/28/2018 This blog is part of the blog series HANA based BW Transformation. The following list is based on experiences with real customer messages and is intended to help customers learn from the mistakes of other customers. 9.1 SQ...

Torsten_ · 08-29-2016

4 HANA based BW Transformation - New features delivered by 7.50 SP04 This blog is part of the blog series HANA based BW Transformation. Following new features are shipped with the BW 7.50 Support Package 04 (feature pack): SQL Script (AMDP) b...

Torsten_ · 06-23-2016

3 Analyzing and debugging HANA based BW Transformations This blog is part of the blog series HANA based BW Transformation In this part I’ll describe how a BW transformation can be analyzed and debugged if they would be executed in the database...

Torsten_ · 06-17-2016

2 HANA based Transformation (deep dive)This blog is part of the blog series HANA based BW Transformation.Now I will look a little bit behind the curtain and provide some technical background details about SAP HANA Transformations. The informatio...

Torsten_ · 06-09-2016

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. ...

Torsten_ · 10-20-2023

Hi,use TOP <n> in the SQL Select part.See also: https://answers.sap.com/questions/10529983/selecting-top-n-rows-for-distinct-column-values-in.htmlorhttps://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20fcf24075191014a89e9dc7b...

Torsten_ · 03-11-2023

Hi,SOURCE_FIELDS is a table!Torsten

Torsten_ · 01-04-2023

Hi,therefore you need more than one package.To achieve that reduce the pagacke size, but this means the semantic group must allow that.Torsten

Torsten_ · 12-30-2022

Hi,you are using the field symbol <result_fields> in the where condition before you assign it.You assign it later in the LOOP.Therefore you get an error in the select statement.Torsten

Torsten_ · 07-25-2022

Hi, I'm not longer part of the BW development team, but I'm sure that the option READ ONLY will NOT removed. That means you can not use INSERT and UPDATE statements within the AMDP routine. It is also not possible to encapsulate the statement in a...

User Statistics

User Activity

HANA based BW Transformation – Guidelines and Recommendations

HANA based BW Transformation - New features delivered by 7.50 SP04

HANA based BW Transformation - Analyzing and debugging

HANA based Transformation (deep dive)

HANA based BW Transformation - SAP Notes

Re: AMDP in BW transformation: UP TO 1 ROWS

Re: look up table in sap bw

Re: How to run DTP of expert routine with parallel processing ?

Re: SAP BW Endroutine: Short Dump GETWA_NOT_ASSIGNED on Select Statement

Re: HANA based BW Transformation