Skip to Content
avatar image
Former Member

adhoc query for payroll data


Is it possible to create an ad-hoc query to get the data from payroll cluster. Or as an alternative , has anyone used IT402, 403, 446, 447 etc to get the payroll information from ad-hoc query? We do not use the TAx Reporter. So I will have to generate thse infotypes, if we want to use them

Please suggest.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 04, 2009 at 01:44 AM

    i dont think unless and untill we run the pay roll live the cluster will get updated

    did u tried PC00_M99_CWTR once pls check and let me know

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2009 at 12:38 PM


    You can fetch the payroll results via Adhoc Query via payroll infotypes.

    We have done this.

    if any help required please let me know.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi William,

      A programmer can create an ABAP report with payroll results directly from the cluster using SAP supplied function modules. But if you want to use Ad Hoc Query, you must first create data in a payroll infotype. You may use IT0402 or create your own copy. Suggest one or more copies of IT0402 such as 9402.

      You will have to configure the wage types you want in your infotype - IMG: Personnel Management --> Human Resources Information System --> Payroll Results. Follow the four steps - Define Evaluation Wage Types. Here you name the wage types you want recorded. Assign Wage Types - assign the actual SAP names or custom named wage types to your naming convention from the first step. Themajor step is then Set Up Payroll Infotypes. Here you place your Evaluation Wage Types into the Payroll infotype and Generate it. This creates the infotype with all its attributes for you. Then, if you want it filled each time payroll is run, do the last step Set Up Assignment to Payroll. It is not necessary to do this last step as you can use report RPABRI00 to fill the infotypes. Then in SQ02, add the payroll infotype to your infoset. You may have to rename the fields to give you names you recognize when viewed in Ad Hoc.

      Then you can report away on Payroll data in Ad Hoc Query. Remember, the only wage types included are the ones you have set-up. And if you have assigned it to payroll, the data is as of the last payroll run. Thus, off -cycle data will not be picked up until the next payroll.