Select query with multiple material in select option error out

gokul_jayaraman2 — Mon, 22 Aug 2016 11:47:41 GMT

Hi Team,

I have a Program which calls the HANA Sidecar, when material is entered in Multiple option it error out.

It works fine when its given in Range or just single value.

I have attached the selection screen and the error screen.

It always throws this error only when multiple material document is passed.

I have also attached the select query which throws the error.

Please let me know if you need any details.

OPEN CURSOR dbcursor FOR " Note - 'with hold' not allowed

SELECT mkpf~mblnr

mkpf~budat

mkpf~cpudt

mkpf~xabln

mkpf~xblnr

mkpf~bldat

mkpf~cputm

mkpf~usnam

mkpf~bktxt

mkpf~frbnr

mkpf~exnum

mseg~matnr

mseg~bukrs

mseg~werks

mseg~zeile

mseg~lgort

mseg~kunnr

mseg~kdauf

mseg~bprme

mseg~aufnr

mseg~bwart

mseg~meins

mseg~waers

mseg~umwrk

mseg~ablad

mseg~ematn

mseg~prctr

mseg~lgtyp

mseg~umlgo

mseg~kostl

mseg~sgtxt

mseg~ebeln

mseg~ebelp

mseg~erfmg

mseg~erfme

mseg~charg

mseg~insmk

mseg~sobkz

mseg~lifnr

mseg~menge

mseg~shkzg

mseg~dmbtr

mseg~mjahr

mseg~mat_kdauf

mseg~mat_kdpos

mseg~lgpla

mseg~lfbnr

mseg~grund

mara~lvorm

mara~mtart

mara~mbrsh

mara~matkl

marc~maabc

marc~shflg

marc~shzet

marc~schgt

marc~kausf

marc~kzkri

marc~ekgrp

marc~dispr

marc~dismm

marc~dispo

marc~plifz

marc~webaz

marc~ausss

marc~disls

marc~beskz

marc~sobsl

marc~minbe

marc~eisbe

marc~bstmi

marc~bstma

marc~bstfe

marc~bstrf

marc~mabst

marc~umlmc

makt~maktx

makt~spras

mbew~bwtar

mbew~zpld2

mbew~zplp2

mbew~stprs

mbew~peinh

mbew~zplp1

mbew~zplp3

mbew~zpld1

mbew~zpld3

mbew~bwkey

lfa1~name1

ekko~ekorg

ekpo~infnr

ekpo~netpr

ekpo~peinh

ekpo~netwr

ekpo~pstyp

FROM ( mkpf

INNER JOIN mseg

ON mseg~mandt = mkpf~mandt

AND mseg~mblnr = mkpf~mblnr

AND mseg~mjahr = mkpf~mjahr

INNER JOIN mara

ON mara~mandt = mseg~mandt

AND mara~matnr = mseg~matnr

INNER JOIN marc

ON marc~mandt = mseg~mandt

AND marc~matnr = mseg~matnr

AND marc~werks = mseg~werks

INNER JOIN makt

ON makt~mandt = mara~mandt

AND makt~matnr = mara~matnr

AND makt~spras = sy-langu

INNER JOIN mbew

ON mbew~mandt = marc~mandt

AND mbew~matnr = marc~matnr

AND mbew~bwkey = marc~werks

LEFT OUTER JOIN lfa1

ON lfa1~mandt = mseg~mandt

AND lfa1~lifnr = mseg~lifnr

LEFT OUTER JOIN ekko

ON ekko~mandt = mseg~mandt

AND ekko~ebeln = mseg~ebeln

LEFT OUTER JOIN ekpo

ON ekpo~mandt = mseg~mandt

AND ekpo~ebeln = mseg~ebeln

AND ekpo~ebelp = mseg~ebelp )

CONNECTION (v_conn)

WHERE mkpf~mblnr IN so_mblnr

AND mkpf~budat IN so_budat

AND mkpf~cpudt IN so_cpudt

AND mkpf~cputm IN so_cputm

AND mkpf~usnam IN so_uname

AND mkpf~bktxt IN so_bktxt

AND mkpf~xblnr IN so_xblnr

AND mseg~matnr IN so_matnr

AND mseg~werks IN so_werks

AND mseg~bwart IN so_bwart

AND mseg~lgort IN so_lgort

AND mseg~ebeln IN so_ebeln

AND mseg~kdauf IN so_kdauf

AND mseg~lifnr IN so_lifnr

AND mseg~sobkz IN so_sobkz

AND mara~matkl IN so_matkl

AND mara~mtart IN so_mtart

AND mara~lvorm = p_lvoma

AND marc~lvorm = p_lvowk

AND makt~maktx IN so_maktx

AND makt~spras = sy-langu

AND marc~prctr IN so_prctr

AND mseg~mjahr IN so_mjahr.

IF dbcursor IS INITIAL.

RAISE EXCEPTION TYPE lcx_cursor_not_open.

ENDIF.

WHILE l_no_further_fetch = space.

FETCH NEXT CURSOR dbcursor

INTO s_movements2.

Thanks,

Gokul

Re: Select query with multiple material in select option error out

amol_samte — Mon, 22 Aug 2016 16:16:41 GMT

For better exception handling why dont you use ADBC...

Re: Select query with multiple material in select option error out

gokul_jayaraman2 — Tue, 23 Aug 2016 19:25:23 GMT

Hi Amol,

Thanks for your reply. We are in process of converting objects to use ADBC, We might need to fix this now before moving to ADBC.

Thanks,

Gokul

topic Re: Select query with multiple material in select option error out in Application Development and Automation Discussions

Select query with multiple material in select option error out

Re: Select query with multiple material in select option error out

Re: Select query with multiple material in select option error out