Skip to Content
0
Former Member
Apr 06, 2010 at 10:47 AM

Is "Joins & For all entries" in same SQL Query Possible?

166 Views

Hi all Professional,

Can we use "Inner Joins" and "For All Entries In" in the same SQL Query. if possible then pls clarify this query.

Here I am using three Transparent Table and fetching data from them.

SELECT abukrs abelnr ahkont axref2 ashkzg awrbtr agsber azfbdt azterm amwskz asgtxt axref1 agjahr abuzei

bkunnr bwerks bmenge bmeins bmatnr bkoart

cbukrs cbelnr cblart cbldat cbudat cxblnr cgjahr cstgrd cstblg cstblg c~xreversal

INTO CORRESPONDING FIELDS OF TABLE it_bsid FROM ( ( bsid AS a

INNER JOIN acctit AS b ON abukrs = bbukrs )

INNER JOIN bkpf AS c ON cbukrs = abukrs

AND cbelnr = abelnr

AND cgjahr = agjahr )

FOR ALL ENTRIES IN it_bkpf

WHERE

a~belnr EQ it_bkpf-belnr

AND a~gjahr EQ it_bkpf-gjahr

AND a~bukrs EQ it_bkpf-bukrs

AND a~gsber IN so_bus.

After executing this query, I'm getting Dump Error.

Error analysis

When the program was running, it was established that more

memory was needed than the operating system is able to provide savely.

To avoid a system crash, you must prevent this

situation.

-


Last error logged in SAP kernel

-


Component............ "EM"

Place................ "SAP-Server Development_DVL_01 on host Development (wp

2)"

Version.............. 37

Error code........... 7

Error text........... "Warning: EM-Memory exhausted: Workprocess gets PRIV "

Description.......... " "

System call.......... " "

Module............... "emxx.c"

Line................. 1886

Pls resolve, if anybody knows.

Thanks

Devinder