Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with select query

Hi Experts,

I have a problem with below select query where it is excluding lower orders of collective order, where these orders are released but not confirmed.

I got a requirement where I have to show the lower orders along with header order (collective orders ) in report which are released but not confirmed.

Please help me ....... rewarded....

SELECT aauart awerks akdauf akdpos

bftrmi baufnr bstlbez baufpl

blead_aufnr bprodnet " crueck crmzhl

cvornr carbid clmnga cxmnga

crmnga cism04 cism05 cbudat

d~kunnr

e~arbpl

FROM aufk AS a

INNER JOIN afko AS b

ON baufnr EQ aaufnr

INNER JOIN afru AS c

ON caufnr EQ aaufnr

LEFT JOIN vbak AS d

ON dvbeln EQ akdauf

INNER JOIN crhd AS e

ON eobjid EQ carbid AND ewerks EQ awerks

INTO CORRESPONDING FIELDS OF TABLE i_data

WHERE a~auart IN s_auart

AND a~kdauf IN s_vbeln

AND a~werks EQ p_werks

AND b~aufnr IN s_aufnr

AND b~ftrmi IN s_ftrmi

AND c~stokz EQ ''

AND c~stzhl EQ '00000000'.

Regards,

Suresh goud

Former Member
Not what you were looking for? View more on this topic or Ask a question