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