Query problem

[former_member260061]

this is the main query

clear : itab[], tmpitab[].

*------------Get Open Items-----

select

bukrs

lifnr

*LGORT

*LGOBE

*DB

*CR

zuonr

shkzg

wrbtr

blart

into corresponding fields of table

tmpitab  from bsik where

bukrs eq p_bukrs and lifnr eq p_lifnr

and budat  in s_budat

and zuonr ne '' .

it is fetching from Assignment (4500000417, CHQ# 34343456).

i only want to fetch only PO NO ( 4500000417)

i am using  Assignment (zuonr) and PO no(ebeln) for that.

when i used zuonr eq itab-ebeln. it not giving the right result.

can any one help.

khurram nagi

[Former Member]

try adding blart eq 'OC' in where clause

[former_member260061]

PO number only

[Former Member]

belnr is your document number