Select Statement in ABAP

[Former Member]

Hi All,

I have one requirement, there i need to fetch the data for the following fields.

PA0001-BTRTL, PA2001-PERNR, PA2001-BEGDA, PA2001-ENDDA, PA2001-AWART, PA2001-BEGUZ, PA2001--ENDZU, PA2001-STDAT.

here the PERNR should be in PA0000 infotype.

here, personal subarea BTRTL is equal to DE01 then the Absence types 0200, 0201 and 0350 only be displayed.

& if the personal subare BTRTL is equal to AT22 then all Absence types should be displayed.

I need all the records for BTRTL is equal to DE01 and BTRTL is equal to AT22. I mean, three for DE01 and all for AT22.

please suggest how to write the select statement to achieve the requirement.

Regards,

Nagarjuna.

[Former Member]

y

[Former Member]

if BTRTL is equal to DE01 then

select query with where clause --Absence types 0200, 0201 and 0350

else

select query without where clause of absence type

[prateek]

Please post in ABAP forum and close it here.

Regards,

Prateek