Retriving records from info type 0194
I m doing Outbound Interface and this is my requirement>pls go through the description listed below and give some suggetions.
For all employees who have Infotype 0194 records valid in the time period or payroll period selected who have the vendor selected on the selection screen, you have to read the payroll results and find the Garnishment document in the GRORD if it exists. If a time period is selected, you must search for all payroll results with a check date that falls in that time period. If a payroll period is selected, search for that particular payroll and any off-cycle payroll whose check date falls between the begin date and end date of that pay period.
Once you searched IT 0194 for Employees (EE) with the Garnishment Vendor selected and then found the payroll results to process, you must search through payroll internal GRDOC and find the same vendor. If the vendor is found, search the payroll Results Table (RT) for the V0 split which matches the GRDOC record. Then use this amount(s) for the Deduction Amount field.
EE Selects Time Period and Vendor -> search through table 0194 for that vendor in that time period -> for the garnishment records found, search payrolls in the time period to see if the garnishment was deducted
This are the fields i need to download with deduction amount
Social Security Number:
Employee First Name:
Employee Last Name:
Payroll Results RT