Skip to Content
0
Oct 29, 2019 at 02:55 AM

Aggregate a column in HANA based transformation.

138 Views Last edit Oct 29, 2019 at 02:57 AM 2 rev

Hi,

I used below select query with group by to aggregate a key figure (TURNOVER) . But the aggregation function:SUM(TURNOVER) is not working. please let me know the correct function to aggregate a column in HANA based BW transformation(BW4HANA).

Below select query is implemented in expert routine.

outTab = select FISCYEAR, FISCPER, FISCVARNT, GL_ACCOUNT, CHRT_ACCTS, COMP_CODE, PROFIT_CTR, COSTCENTER, CO_AREA, FUNC_AREA, CURTYPE, RECORDMODE, CURRENCY, SUM("TURNOVER") as TURNOVER, RECORD, SQL__PROCEDURE__SOURCE__RECORD from :inTab group by "FISCYEAR","FISCPER","FISCVARNT","GL_ACCOUNT","CHRT_ACCTS","COMP_CODE", "PROFIT_CTR","COSTCENTER","CO_AREA","FUNC_AREA","CURTYPE","RECORDMODE","CURRENCY","RECORD", "SQL__PROCEDURE__SOURCE__RECORD";

Regards,

Naveen.