topic Re: Syntax needed for particular month in Select Statement in Application Development and Automation Discussions

Syntax needed for particular month in Select Statement

Former Member — Tue, 09 Dec 2008 14:23:07 GMT

Hi Guys,

My Issue is I am selection some fields from IMRG table into some internal table.

In this I need to select some records based on month condition.

Means I need to get the records info into the internal table regarding this month.

If i execute this report next month it should fetch the data from that month only.

How to make the syntax in select statement.

Thanks & Regards ...

Prasad.

Re: Syntax needed for particular month in Select Statement

Former Member — Tue, 09 Dec 2008 14:26:18 GMT

Then what are your selection criteria if its date then

you have to use a begin date and end date and where you need to mention high and low and use the same in your select statement

SELECT VBRK~VBELN AS VBELN

VBRK~VKORG AS VKORG

VBRK~VTWEG AS VTWEG

VBRP~PRODH AS PRODH

VBRK~FKDAT AS FKDAT

SUM( VBRP~FKLMG ) AS FKLMG

SUM( VBRP~NETWR ) AS NETWR

INTO CORRESPONDING FIELDS OF WA_TAB FROM VBRK AS VBRK JOIN VBRP AS VBRP

ON VBRK_{VBELN = VBRP}VBELN

WHERE VBRP~MATNR = WA_TAB-MATNR

AND VBRP~WERKS = WA_TAB-WERKS

AND VBRK~FKDAT BETWEEN S_DATE-LOW AND S_DATE-HIGH

AND VBRK~VKORG IN S_VKORG

AND VBRK~VTWEG IN S_VTWEG

AND VBRK~FKSTO NE 'X'

AND VBRK~FKART EQ 'ZBI1'

AND ( VBRK_{VBTYP EQ'M' OR VBRK}VBTYP EQ 'P' OR VBRK_{VBTYP EQ 'O' OR VBRK}VBTYP EQ '6'

OR VBRK~VBTYP EQ '5' )

GROUP BY VBRK_{VBELN VBRK}VKORG VBRK_{VTWEG VBRP}PRODH VBRK_{FKDAT VBRP}FKLMG.

WA_TAB-VAR0 = ( ( WA_TAB-VAR0 + WA_TAB-FKLMG ) ).

WA_TAB-VAR34 = ( WA_TAB-VAR34 + WA_TAB-NETWR ).

Edited by: sabyasachi kar on Dec 9, 2008 3:26 PM

Re: Syntax needed for particular month in Select Statement

Former Member — Tue, 09 Dec 2008 14:28:06 GMT

Hi,

In different variable, get the current month from the sy-datum variable. You can then use this variable in the select statement.

Best Regards.

Re: Syntax needed for particular month in Select Statement

Former Member — Tue, 09 Dec 2008 14:28:08 GMT

Hi sabyasachi kar ,

Thanks for the response.

But I am not using any selection screen for my report.

Thanks...Prasad.

Re: Syntax needed for particular month in Select Statement

Former Member — Tue, 09 Dec 2008 14:31:01 GMT

Hi Abaper,

I can understand what u r saying. I used my syntax like this

select point vlcod erdat from IMRG into table ITAB

where vlcod NE space and erdat eq sy-datum+4(2).

but i am not getting the records.

Thanks...Prasad.