Skip to Content
0
V A
Sep 03, 2008 at 12:19 PM

Logic needed

36 Views

i have selection as

SELECT-OPTIONS: S_BUDAT FOR MKPF-BUDAT OBLIGATORY .

SELECT-OPTIONS: S_BKTXT FOR MKPF-BKTXT.

my select query is

SELECT MBLNR MJAHR XBLNR BKTXT

INTO (ITAB_NEW-MBLNR,ITAB_NEW-MJAHR,ITAB_NEW-XBLNR,

ITAB_NEW-BKTXT)

FROM MKPF

WHERE VGART = 'WE'

AND BLART = 'WE'

AND BUDAT IN S_BUDAT

AND BKTXT = S_BKTXT

AND TCODE2 = 'MIGO_GR'.

SELECT EBELN LIFNR MATNR DMBTR ZEILE WERKS INTO

(ITAB_NEW-EBELN,ITAB_NEW-LIFNR,ITAB_NEW-MATNR,

ITAB_NEW-DMBTR,ITAB_NEW-ZEILE,ITAB_NEW-WERKS)

FROM MSEG

WHERE MJAHR = ITAB_NEW-MJAHR

AND MBLNR = ITAB_NEW-MBLNR

AND WERKS IN S_WERKS

AND BWART = '101'

AND KZZUG = ''.

IF SY-SUBRC = 0.

APPEND ITAB_NEW.

ENDIF.

ENDSELECT.

ENDSELECT.

My query is

header text (BKTXT) user is entering data as 47-1233/120808

47-form no./date

i wish if user enter 1233 in selection screen my query should run.Please guide how to control this.