Skip to Content
0
Former Member
Mar 20, 2009 at 06:48 AM

Selction criteria

63 Views

Hi,

Iam new to HR abap.I got one requirement.How to write the logic for selection criteria.

Select all employees as of interface run date (BEGDA <= interface run date <= ENDDA)

Include participants who fall into group 1 or group 2:

Group 1

1)Country Grouping is Canada (MOLGA = 07)

2)AND Company Code is APOC (PA0001-BUKRS)

3)Health plans(IT0167): BPLAN( APOC Medical Plan)

BPLAN (APOC Dental Plan)

Insurance plans (IT0168): BPLAN (APOC Basic Life Insurance)

BPLAN (APOC Optional life Insurance)

BPLAN (APOC Long term Disability)

BPLAN (APOC Basis AD&D)

Group 2

If employee met the above criteria in the previous interface run and does not meet the criteria in the current interface run, include this employee in the interface file.

For dependant records, include all unique dependents (found on dependent tab of PA0167) for all participants sent in the file.

Dependent selected in group 2 should be included in the interface file.

The dependent participation indicator is stored in a table with 20 rows

Loop through PA0167-DTY01 to PA0167-DTY20 for PA0167-BPLAN

If selected employee has PA0167-DTY##=1 or PA0167-DTY##=2 It indicate a dependent is participating in the plan

Retrieve PA0167-DTY## value and PA0167-DID## value

Select dependant record from PA0021

Where PA0021-SUBTY = PA0167-DTY##

AND PA0021-OBJPS = PA0167-DID##

The PA0021 selected above will be the dependent data participating in subscriber's benefit plan. All dependent information required for interface file should be retrieving from PA0021 using PA0021-SUBTY and PA0021-OBJPS as Keys.

please help me regaring that logic.