Skip to Content
Former Member
Jul 02, 2007 at 04:40 PM

How to avoid nested selects and calc the gross salary without Logical db


Hello everybody,

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) -