Skip to Content
0
Former Member
May 31, 2008 at 07:59 AM

Issue with 'Where' Condition

27 Views

Hi All,

We have used the following code in our report.

I would like to know what is the logic behind using this type of where condition.....????

SELECT PERNR

KST01

BEGDA

ENDDA FROM PA0027 INTO CORRESPONDING FIELDS OF TABLE IT_PA0027

FOR ALL ENTRIES IN IT_KOSTL

WHERE KST01 = IT_KOSTL-KOSTL

AND ( ( BEGDA <= P_DATE1 AND ENDDA >= P_DATE2 )

OR ( BEGDA >= P_DATE1 AND BEGDA <= P_DATE2 )

OR ( ENDDA >= P_DATE1 AND ENDDA <= P_DATE2 ) ) .

In our selection screen, we have Two dates called Start Date and End Date (Both have no range...they are parameters).

From Date: P_DATE1

To Date: P_DATE2

Can anyone explain me, whats the meaning of above where condition...???

Regards

Pavan