topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 16 Nov 2005 08:05:16 GMT

Hi,

Can any one tell me how to get sum(omeng),vbeln from vbbe table where vbeln = '123456' using select statement...

points guaranteed

cheers

kaki

Re: select statement

Former Member — Wed, 16 Nov 2005 08:12:24 GMT

u can control breaks..

copy data to itab.

loop at itab.

at new ebeln

collect itab.

endat

endloop.

is this u were asking?

Re: select statement

Former Member — Wed, 16 Nov 2005 08:13:35 GMT

data: lv_sum like vbbe-omeng.

select sum( omeng ) into lv_sum

from vbbe

where vbeln = '4400000011'.

Re: select statement

abdul_hakim — Wed, 16 Nov 2005 08:14:17 GMT

Hi,

Use the below code.

DATA: VBELN LIKE VBBE-VBELN,

TOT(10) TYPE C.

SELECT SINGLE VBELN SUM( OMENG ) FROM VBBE INTO ( VBELN,TOT )

WHERE VBELN = '123456'.

Regards,

Abdul

Message was edited by: Abdul Hakim

Re: select statement

Former Member — Wed, 16 Nov 2005 08:15:20 GMT

Hi,

data: begin of itab occurs 0,

vbeln like vbbe-vbeln,

omeng like vbbe-omeng,

end of itab.

Select vbeln omeng into table itab from vbbe where vbeln = '123456'.

Thanks.

Re: select statement

Former Member — Wed, 16 Nov 2005 08:21:24 GMT

hi KAKI R

REPORT ZVKRTEST.

DATA: VAR_OMENG TYPE VBBE-OMENG.

SELECT sum( omeng ) from vbbe INTO VAR_OMENG Where vbeln EQ

'0000007225'.

WRITE: VAR_OMENG.

regards,

Vijay Raheja

Re: select statement

Former Member — Wed, 16 Nov 2005 08:26:55 GMT

Hi joseph fryda,

How to select more than one field in single select statement using sum...ur statement is ritht.

select sum( omeng ) into lv_sum from vbbe where vbeln = '41200025'

but i want other fields also...like

select sum( omeng ),vbeln,etenr into lv_sum from vbbe where vbeln = '41200025'

cheers

kaki

Re: select statement

Former Member — Wed, 16 Nov 2005 08:29:21 GMT

check this

select vbeln sum( omeng ) from vbbe into ( vbeln, omeng )

where vbeln = '12345'.

Re: select statement

Former Member — Wed, 16 Nov 2005 08:31:03 GMT

try this for multiple values!!!

data : begin of it_vbbe occurs 0,

VBELN like vbbe-VBELN,

OMENG like vbbe-OMENG,

end of it_vbbe.

select-options : s_vbeln for vbbe-vbeln .

select vbeln sum( omeng ) from vbbe into table it_vbbe

where vbeln in s_vbeln

group by vbeln.

Re: select statement

abdul_hakim — Wed, 16 Nov 2005 08:41:47 GMT

Hi use the foll code for multiple entries.

TABLES VBBE.

SELECT-OPTIONS S_VBELN FOR VBBE-VBELN.

DATA: BEGIN OF WA,

VBELN LIKE VBBE-VBELN,

TOTAL(10) TYPE C,

END OF WA.

DATA ITAB LIKE TABLE OF WA.

SELECT VBELN SUM( OMENG ) FROM VBBE INTO TABLE ITAB WHERE

VBELN IN S_VBELN.

Regards,

Abdul

Re: select statement

jayanthi_jayaraman — Wed, 16 Nov 2005 09:00:00 GMT

Hi,

Types : begin of ty,

vbeln type vbbe-vbeln,

omeng type vbbe-omeng,

end of ty.

data itab type standard table of ty.

select vbeln sum ( omeng ) into table itab where vbeln = '123456'

group by vbeln.

If the above logic is not working,then try the below one.

select vbeln sum ( omeng ) into table itab group by vbeln.

delete itab where vbeln <> '123456'.

Kindly reward points if it helps.

Message was edited by: Jayanthi Jayaraman

Re: select statement

Former Member — Wed, 16 Nov 2005 09:05:31 GMT

data v_omeng like vbbe-vbeln.

select sum ( omeng ) into v_omeng

from vbbe

group by vbeln

having vbeln = '123456'.

Re: select statement

Former Member — Wed, 16 Nov 2005 09:23:24 GMT

DATA SUM LIKE VBBE-OMENG.

DATA : BEGIN OF ITAB OCCURS 0,

VBELN LIKE VBBE-VBELN,

OMENG LIKE VBBE-OMENG,

END OF ITAB.

SELECT VBELN OMENG FROM VBBE INTO ITAB WHERE VBELN = '123456'.

SUM = SUM + ITAB-OMENG.

APPEND ITAB.

ENDSELECT.

uSE THIS CODE.You can change vbeln selection as per your requirement.

Re: select statement

Former Member — Wed, 16 Nov 2005 09:31:44 GMT

REPORT ZSUM11 .

DATA SUM LIKE VBBE-OMENG.

DATA : BEGIN OF ITAB OCCURS 0,

VBELN LIKE VBBE-VBELN,

OMENG LIKE VBBE-OMENG,

END OF ITAB.

SUM = 0.

SELECT VBELN OMENG FROM VBBE INTO ITAB WHERE VBELN = '0000007225'.

SUM = SUM + ITAB-OMENG.

APPEND ITAB.

ENDSELECT.

LOOP AT ITAB.

WRITE / ITAB-VBELN.

WRITE ITAB-OMENG.

ENDLOOP.

WRITE / SUM.

THIS code is printing the data relatecd to vbeln = 7225. You can change urself as u require.This is running code.

I think There is no entry of vbeln equal to 123456.