Skip to Content
0
Former Member
Dec 26, 2008 at 10:56 AM

Select Statement in ABAP

42 Views

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.