select query (HR ABAP)

[Former Member]

Hi ..

i am writing a driver program for smartform.

I have a field DATEDEM (date of demise)

The condition is that DATEDEM = P0041-DAT01 for P0041-DAR01 .

Please help me how to write the select query to get DATEDEM from infotype 0041.

Here P0041-DAR01 = Date type &

P0041-DAT01 = Date for date type.

Please help.

Thanks & Regards,

Preeti

[Former Member]

hi Preeti,

why do you want to write a select query on infotype ... you can get the data by using macro..

get pernr.

this will get you the data for all the infotypes that you have declared.....and then can select that record based on you condition.

if having some problem please can you make your screnario a bit more clear ....

Regards,

Jayant

[Former Member]

can any one help me on this please.

[Former Member]

hi Preeti,

why do you want to write a select query on infotype ... you can get the data by using macro..

get pernr.

this will get you the data for all the infotypes that you have declared.....and then can select that record based on you condition.

if having some problem please can you make your screnario a bit more clear ....

Regards,

Jayant

[dustyplanet]

This is a raw form of the query that needs to be used, please note that some more fields may need to be qualified in the where clause if you want a consistent result.

SELECT SINGLE DAT01 from PA0041 INTO (DATEDEM) 
    WHERE PERNR = PPERNR     'Replace with the current PERNR
          AND DAR01 = 'P0'.      'P0 is Date Type for Date of Death

<i>This is just indicative of the logic to be used and does not contain important things like checking the validity of the infotype record etc., which you will need to add according to your needs to the where clause of the query.</i>

Nevertheless, hope this puts you on the right track...

Regards,

Dushyant Shetty

[jayanthi_jayaraman]

Hi,

You can use the function module hr_read_infotype to get the data from 41 infotype.

If logical database is used,then use rp_provide_from_last macro.