Skip to Content
0
Apr 01, 2016 at 06:14 AM

Query problem

45 Views

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

Attachments

vf03.jpg (74.0 kB)