HANA Expert Routine : Column Store Issue with DTP

[janardanan]

Hi All,

When loading data to ADSO via Hana Expert Routine I am getting the column store issue.

I'm using following code:

SELECT min( calday ) into LV_START_DATE from :inTab;

SELECT max( calday ) into LV_END_DATE from :inTab;

outTab =
SELECT
COALESCE ( F."/BIC/ZBRANCH",A1."/BIC/ZBRANCH1" ) AS "/BIC/ZBRANCH",
G."FISCPER",
G."FISCYEAR",
'K3' as "FISCVARNT",
'' AS "CALDAY", -----> Showing Error in this Line (Line No : 64 Col 5)
A1."RECORDMODE",
SUM("/BIC/ZDFT_130") AS "/BIC/ZDFT_130",
SUM("/BIC/ZDFT_132") AS "/BIC/ZDFT_132",
0 AS "/BIC/ZOTVPARC",
0 AS "/BIC/ZDFT_084",
0 AS "/BIC/ZDFT_116",
0 AS "AMOUNT",
0 AS "/BIC/ZSERPRDNO",
'DSO11' AS "/BIC/ZTYPE",
'INR' AS "CURRENCY",
ROW_NUMBER( ) OVER( PARTITION BY COALESCE ( F."/BIC/ZBRANCH",A1."/BIC/ZBRANCH1" ) )
AS RECORD FROM

Thanks,

Janardanan.M

[former_member231518]

Hi Janardanan,

I suppose you may add field before "AS" and check this sql statement again.

Best regards,

Tibbie

[Former Member]

Hi Janardanan,

It also recommended to implement all important notes from this collective note (with help of report Z_SAP_BW_NOTE_ANALYZER and attached XML file):

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

Best regards, Andras