Dear Expert, I have problem this query below. I have grouping function to split group and show subtotal and grandtotal but it's grandtotal wrong position to top row (Red) what i want to below row (green).. Please you resolve to me...Code : SELEC...

Dear expert.. I have script months_between docdate and Current_date , this result picture.. example Posting date is 30.06.23 and Current_date is 28.07.23 but it not show value is 1 in months_between? Please you help me,I want write query is last 10...

To.Expert Please suggest to me write query compare between qty in stock and AR Invoice and AR Credit memo in SAP B1 HANA Thank you

My query Fixed Asset is show some duplicate row. It difference Remain life fileld but Green mark is True update. Please you suggest it not show red mark in my query My Query.. below SELECT T2."PeriodCat" as "Period", T0."ItemCode" as "Asset ...