Skip to Content
author's profile photo Former Member
Former Member

How to Fetch a data from HR Master Tables?

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 20, 2008 at 08: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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.