SUM( tsl06 ) AS tbal
SUM( hsl06 ) AS rbal
FROM faglflext INTO TABLE lt_bal
WHERE ryear =<input> AND rbukrs IN <input> GROUP BY ryear rtcur racct rbukrs.
In the above query , how can I dynamically change the field name TSL06 based on the period. It means that if the current fiscal period 5, dynamically, it has to come as SUM (TSL05) instead of SUM (TSL06). How can I do this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!