topic Re: data selection in Application Development and Automation Discussions

data selection

Former Member — Fri, 06 Mar 2009 05:43:25 GMT

Hi Friends, I have 1 problem here

I m prescribing my coding and logic as following:

DATA: KYEAR(4) TYPE C,

NYEAR(4) TYPE C,

KYEAR = SY-DATUM+0(4),

NYEAR = SYEAR - 1 .

IF SYEAR EQ KYEAR AND SMONTH < 4.

SELECT A_{PERNR A}SMONTH A_{SYEAR A}APF A_{VPF A}EPF

B_{TMONTH B}TYEAR B_{EMPLOYEEPF B}EMPLOYERPF

FROM ( ZUPWARDHAWOR AS A INNER JOIN ZTRANS_ENTRY AS B

ON A_{PERNR = B}PERNR )

INTO CORRESPONDING FIELDS OF BODY1

WHERE A~SYEAR BETWEEN NYEAR AND SYEAR

AND A~SMONTH BETWEEN '04' AND SMONTH

AND A~PERNR = SMF1-PERNR AND

B~PERNR = SMF1-PERNR "AND

B_{TMONTH = A}SMONTH AND

B_{TYEAR = A}SYEAR

ORDER BY A_{SYEAR A}SMONTH ASCENDING .

APPEND BODY1.

COUNT = COUNT + 1.

ENDSELECT.

Month name is SMONTH year is SYEAR.

I need when i put JAN 2009 OR Feb 2009 the data should be select from APRIL 2008 to Jan 2009 or Feb 2009.

But according to my logic the data is selecting when i hide month from WHERE condition.

It is selected data from jan2008 to jan 2009. But i want Aprill 2008 to till current month and year.

Plz try to solve it soon.

Regards,

Swapnika

Re: data selection

Former Member — Fri, 06 Mar 2009 05:52:39 GMT

Hi,

Build the range table and use in Selcet quesy


R_YEAR-sign  = 'I'.
R_YEAR-option = 'BT'.
R_YEAR-LOW = NYEAR.
R_YEAR-HIGH= SYEAR.
Append r_YEAR.


R_MONTH-sign  = 'I'.
R_MONTH-option = 'BT'.
R_MONTH-LOW = '04'.
R_MONTH-HIGH= SMONTH.
Append r_MONTH.

SELECT A~PERNR A~SMONTH A~SYEAR A~APF A~VPF A~EPF
B~TMONTH B~TYEAR B~EMPLOYEEPF B~EMPLOYERPF
FROM ( ZUPWARDHAWOR AS A INNER JOIN ZTRANS_ENTRY AS B
ON A~PERNR = B~PERNR )
INTO CORRESPONDING FIELDS OF BODY1
WHERE A~SYEAR In R_YEAR " BETWEEN NYEAR AND SYEAR
AND A~SMONTH IN R_MONTH " BETWEEN '04' AND SMONTH
AND A~PERNR = SMF1-PERNR AND
B~PERNR = SMF1-PERNR "AND

B~TMONTH = A~SMONTH AND 
B~TYEAR = A~SYEAR 
ORDER BY A~SYEAR A~SMONTH ASCENDING .

Re: data selection

dev_parbutteea — Fri, 06 Mar 2009 05:58:33 GMT

Hi ,

please stop posting duplicate threads:

Reported

IF SYEAR EQ KYEAR AND SMONTH < 4.

SELECT A_{PERNR A}SMONTH A_{SYEAR A}APF A_{VPF A}EPF

B_{TMONTH B}TYEAR B_{EMPLOYEEPF B}EMPLOYERPF

FROM ( ZUPWARDHAWOR AS A INNER JOIN ZTRANS_ENTRY AS B

ON A_{PERNR = B}PERNR )

INTO CORRESPONDING FIELDS OF BODY1

WHERE

( ( A_{SYEAR = NYEAR AND A}SMONTH > '04' ) or

( A_{SYEAR = SYEAR AND A}SMONTH < S_month) )

AND A~PERNR = SMF1-PERNR AND

B~PERNR = SMF1-PERNR "AND

B_{TMONTH = A}SMONTH AND

B_{TYEAR = A}SYEAR

ORDER BY A_{SYEAR A}SMONTH ASCENDING .

Edited by: Dev Parbutteea on Mar 6, 2009 7:00 AM

Re: data selection

matt — Fri, 06 Mar 2009 09:02:05 GMT

Do not keep posting the same question. I've deleted the ones you posted earlier. It is unfair on those who answer your query if you keep opening the same question.