I have two queries to clarify,
1) how to avoid nested selects. (scenario : displaying the name of dept , name of org unit , contract details , and loc of store - from diff Txxxx tables based on the value from pa0001-btrtl, plans , orgeh and pa0016-eindt based on pa0001-pernr.
I used nested selects and is working but i knw its not in best practices so want to know the other way out.
2) how to calc salary (without using logical db as it doesnt support unicode) -