How to Fetch a data from HR Master Tables?

[Former Member]

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.

[former_member226519]

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

[Former Member]

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

[Former Member]

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.