Select-option for LDB PNP

[Former Member]

Hi all,

I'm new in ABAP HR. I create program using PNP logical DB, but some field in select-option doesn't work for example Personnel Area.

regard

Hengky

[Former Member]

this is code...

GET PERNR.

*{ INSERT HCDK901396 7

CHECK SELECT-OPTIONS.

*} INSERT

*

RP_PROVIDE_FROM_LAST: P0001 SPACE PNPBEGDA PNPENDDA,

*{ INSERT HCDK900750 2

P0032 SPACE PNPBEGDA PNPENDDA,

*} INSERT

P2001 SPACE PNPBEGDA PNPENDDA,

P2003 SPACE PNPBEGDA PNPENDDA,

P2011 SPACE PNPBEGDA PNPENDDA.

*

CHECK P0001-PERNR IS NOT INITIAL.

*- BEGIN OF INSERTION AV_MSNADIYA0 MIDK962774

CHECK P0001-WERKS IS NOT INITIAL.

[Former Member]

Dear

LDB has a feature that based on select option it will fetch the data. if it is not selecting the data as per your requirement then you might have not given the selection properly.

in the LDB there are two type of feching data and person.

so you have to check it properly.

every thing is fine even though if it is not selecting

for example.

One PERNR has following data

INDIA from 20.01.2008 to 20.06.2008 and

USA from 21.06.2008 to till today.

for report if your selecion is INDIA and date is from 20.01.2008 to till date it will pick this employee because of Date.

And for same date if your selection is for USA LDB will pick this employee again.

Hope this will give you some sort of understanding

Regards,

Chandrashekhar

[former_member203501]

hi see this example....

TABLES:PERNR.

INFOTYPES:0002,0008.

GET PERNR.

PROVIDE * FROM P0002 BETWEEN PN-BEGDA AND PN-ENDDA.

ENDPROVIDE.

PROVIDE * FROM P0008 BETWEEN PN-BEGDA AND PN-ENDDA.

ENDPROVIDE.

IF SY-SUBRC = 0.

WRITE:/ P0002-PERNR,P0002-BEGDA,P0002-ENDDA,P0002-VORNA,P0008-ANSAL,P0008-PREAS.

ENDIF.

it doesnt mean that it is not working but may be there is no data for that for your selection ..

[Former Member]

But the issue is, when I selecting one pernr which is Active status in certain Personnel number(PA), the data will get pernr, the program will retrieve the data without checking the active status and Personnel area. So in word, Progam will always get the PERNR although the employee has been tranfered & terminated to other PA.