Hi, I need PQL code for below query.
1) Need Sum total of "BSEG"."WRBTR" column based on a new manually created column having concatenation of "BSEG"."LIFNR" and "BKPF"."XBLNR".
Page 1 / 1
Im not sure how you want to show it, as a 1 number kpi or in a table as each value per each LIFNR+XBLNR combination.
If in a table then the solution is pretty easy, just make the concatenation as the dimension and then simple sum in the KPI should be sufficient.
Otherwise if you need it in data model (or KM) I would just go about pulling the XBLNR value to the BSEG table (as BKPF to BSEG is 1:N) and then summing by it.
Im not sure how you want to show it, as a 1 number kpi or in a table as each value per each LIFNR+XBLNR combination.
If in a table then the solution is pretty easy, just make the concatenation as the dimension and then simple sum in the KPI should be sufficient.
Otherwise if you need it in data model (or KM) I would just go about pulling the XBLNR value to the BSEG table (as BKPF to BSEG is 1:N) and then summing by it.
Thank you for your reply. I am new to PQL. I want to show in a table as each value per each LIFNR+XBLNR combination. 1) I did concatenation in dimension : CONCAT (LTRIM("BSEG"."LIFNR",'0'),' ' , "BKPF"."XBLNR") which is working fine. I have given the column name as "Spl Key1" 2) Now, how do I sum in the KPI. Thank you for your time.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.