topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 07 May 2008 10:28:01 GMT

Hi,

I am doing one report. In selection screen i have given the company code , month, year.My requirement is based on the month & year it should display the sales document number generated in that month & year. That means it should generate whole month sales document numbers (ie. starting from 1st to 30 or 31st). Can anyone help me for this. I dont know how to write code for this.

Re: select statement

Former Member — Wed, 07 May 2008 10:31:50 GMT

HI,

Use this FM 'PERIOD_DAY_DETERMINE' and pass fiscal year, month and period then it will return first day in month and last day in month. Using these both you can find the sales orders.

Rgds,

Bujji

Re: select statement

Former Member — Wed, 07 May 2008 10:34:03 GMT

WHAT WILL PASS IN PERIOD.

Re: select statement

Former Member — Wed, 07 May 2008 10:38:50 GMT

Hi,

u cannot use it directly in select statement.

check the condition in select...endselect like below.


tables:vbak.
PARAMETERS:mon1(2),year1(4),mon2(2),year2(4).

select * from vbak.
  IF vbak-erdat+4(2) > mon1 and vbak-erdat+4(2) < mon2 and
            vbak-erdat(4) > year1 and vbak-erdat(4) < year2.
"your code    
  ENDIF.
ENDSELECT.

rgds,

bharat.

Re: select statement

Former Member — Wed, 07 May 2008 10:50:02 GMT

hi use this code:

if u have ccode, month and year field than use this quiry:

select * from vbak into table itab where erdat4(2) eq month and erdat0(4) eq year.

if you r giving date as parameter then first u have to get month and year. like this.

month = date+4(2).

year = date+0(2).

now use same query.

reward if useful.

Re: select statement

Former Member — Wed, 07 May 2008 10:52:14 GMT

Hi Hima ,

can u send me the default date setting u have.

i.e how your date is stored either in ddmmyyy or mmddyy.

or yyyyddmm.

i will send coding if you can send me the details.

Pls reward points if found helpful.

Thanks and regards,

Rajeshwar.