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...
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...
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...
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...
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.
...
Hi,try this without INTO and the alias is related to the column not to the table (dummy): outtab =
select (select current_date from dummy) AS "CUR_DATE",
"RECORD",
"SQL__PROCEDURE__SOURCE__RECORD"
from :INTAB; Torsten
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...
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