on 10-29-2019 2:55 AM
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.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.