Need your help regarding BEx Query....
My requirement is to segregate data based on Excise document no.
I need to generate plant in the report based on Excise Doc. no. as below:
Excise doc Plant
If excise doc no starts with 1 then Plant will be P1, if excise doc no starts with 2 then P2 etc.
how can i achive this?