09-19-2008 3:04 PM
HI,
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.
I have to fetch the Deduction amount according to the given Scenario,and I have to create an Outbound Interface Program to which creates an TXt file in Client Application server with Required fields
Case Number:
P0194-GCASE
Social Security Number:
P0002-PERID
Employee First Name:
P0002-VORNA
Employee Last Name:
P0002-NACHN
Deduction Amount:
Payroll Results RT
Can any one pls know me the entire procedure how to fetch the deduction amt based on the given scenario and what r the select statements i have to write to fetch required fields listed above.
09-20-2008 9:14 AM
to provide infotype data you should use logical database PNP (see docu there)
that will create a selection screen by default.
In your report you have to specify
TABLES: PERNR.
INFOTYPES: 0002, 0194, ....
start-of-selection.
get pernr.
here you get all the specified infotypes in tables pxxxx
end-of-selection. " ends processing one pernr and starts with next GET PERNR
there is a function module to read payroll results
PYXX_READ_PAYROLL_RESULT
in your report you have to initialize the buffers first
HR_PCLX_INIT_BUFFER
and then get the cluster directory (RGDIR)
CU_READ_RGDIR
09-21-2008 7:18 AM
It fetch the data from RT tables Ok and what my question is regarding GRDOC and GRORD tables.How to find the Vendor in the tables
09-23-2008 5:18 AM
Hello boss Pls Try to read all the Matter I have given above.I know How to fetch a data From RT Tables But There is one more concept behind that ie., Find the garnishment document in GRORD.