topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 27 Jul 2006 11:21:14 GMT

Hi All

I got an Internal table STAB like

DATA: BEGIN OF STAB OCCURS 0,

BELNR LIKE BKPF-BELNR,

END OF STAB.

I want to read one BELNR from BKPF & NOT IN STAB-BELNR..I am trying belo..but not working..HOW CAN I READ

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO

AND BELNR IN STAB-BELNR.

I declare all the variables correctly.

Only problem with select statement. Can any one correct me ASAP.

Is there any other ways…

Thanks & Regards

Rajendra

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:24:31 GMT

Hi,

Try this..

Loop at stab.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO

AND BELNR = STAB-BELNR.

endloop.

Regards,

Shashank

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:24:38 GMT

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO.

can u clear ur question more...

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:25:37 GMT

Hi Rajendra,

First you have to select the record in the internal table STAB after that you can use it in your where condition.

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:26:21 GMT

Hi,

use ranges instead of internal table

ranges r_belnr for bkpf_belnr.

r_belnr-sign = 'I'.

r_belnr-option = 'NE'

r_belnr-low = '00100'.

append r_belnr.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO

AND BELNR IN r_belnr.

Regards

Amole

Re: Select statement

Simha_ — Thu, 27 Jul 2006 11:27:18 GMT

HI,

loop at stab.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO

AND BELNR = STAB-BELNR.

endloop.

Hope it helpss..

Cheers,

SImha.

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:27:25 GMT

Hi,

you should create STAB like select-option internal table.The IN should used only for Validating select-options.

Regards,

bala.

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:27:42 GMT

loop at stab.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BUKRS = COMPCO and BELNR = STAB-BELNR and

GJAHR = g_gjahr and BLDAT = DATE1

AND BUDAT = DATE2.

endloop.

Basically you can use Select single one when you have all key fields of the table otherwise you should use

loop at stab.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BUKRS = COMPCO and BELNR = STAB-BELNR and

and BLDAT = DATE1 AND BUDAT = DATE2 up to 1 rows.

endloop.

Rgds,

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:28:28 GMT

Hi Rajendra,

DATA : DOCNO LIKE BKPF-BELNR.

  SELECT SINGLE BELNR 
                FROM BKPF 
                INTO DOCNO
                WHERE BLDAT = DATE1
                AND BUDAT = DATE2
                AND BUKRS = COMPCO
                AND BELNR NOT IN STAB-BELNR.

HOW DID YOU DECLARE UR STAB-BELNR???

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:28:47 GMT

Hi rajendra,

1. we can use this kind of logic

2. see important code (in bold)

report abc.

DATA: BEGIN OF STAB OCCURS 0,

BELNR LIKE BKPF-BELNR,

END OF STAB.

*----

RANGES : MYBELNR FOR BKPF-BELNR.

data : docno like bkpf-belnr.

LOOP AT STAB.

MYBELNR-SIGN = 'I'.

MYBELNR-OPTION = 'EQ'.

MYBELNR-LOW = STAB-BELNR.

APPEND MYBELNR.

ENDLOOP.

SELECT SINGLE BELNR FROM BKPF INTO DOCNO

WHERE BLDAT = DATE1

AND BUDAT = DATE2

AND BUKRS = COMPCO

where BELNR NOT IN MYBELNR.

regards,

amit m.

Re: Select statement

Former Member — Thu, 27 Jul 2006 11:29:08 GMT

Use select options then Define ur internal table like this....

DATA : BEGIN OF s_tab OCCURS 0,

sign TYPE c,

option(2) TYPE c,

low LIKE mska-werks,

high LIKE mska-werks,

END OF s_tab.

s_tab-sign = 'E'.

s_tab-option = 'BT'.

s_tab-low = rm07m-werks.

s_tab-high = eord-werks.

SELECT matnr werks lgort kalab FROM mska INTO t_mska

WHERE werks IN s_tab AND kalab >= 1 .

Regards

Abhishek