Skip to Content
0
Jan 04, 2011 at 05:40 AM

Open PO report in ABAP

780 Views

Hi ,

I am developing a report for open PO .

selection screen contains 2 fields , sales org and creation date.

I m stuck now.

below select query gets the open orders

SELECT ekko~EBELN

ekko~BUKRS

ekko~BSTYP

ekko~BSART

ekko~BSAKZ

ekko~LOEKZ

ekko~STATU

ekko~AEDAT

ekko~ERNAM

ekko~KUNNR

ekbe~BEWTP

into CORRESPONDING FIELDS OF TABLE it_ekko

FROM ekko JOIN ekpo on ekkoebeln = ekpoEBELN

join ekbe on ekpoEBELN = ekbeEBELN

where ekkoekorg in p_org and ekkoBSTYP = 'F' and ekkoLOEKZ = ' ' and ekbeELIKZ = ' ' and ekko~AEDAT in c_date.

but my question is how do I differentiate weather its GR'd IR'd etc . I also want the open quantity ( ordered qty - deliveried qnty)

Can some one give me some hint/logic?

Thanks,

Raj