Skip to Content
avatar image
Former Member

Query problem

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

vf03.jpg (74.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 01, 2016 at 06:33 AM

    try adding blart eq 'OC' in where clause

    Add comment
    10|10000 characters needed characters exceeded