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.