Site icon SAP Human Resources Experts And Solutions

Payroll report with custom filters (11 techniques)

<p>How would you solve a task where you need to find all employees with negative taxes&quest; The wage type in payroll report should be shown as negative as there was a retro calculation&period; We don&&num;8217&semi;t want to list every single person in the report&comma; only people with negative taxes should be shown&period; This would cut the number of rows in the tax report we&&num;8217&semi;re working on to do data adjustments&period;<&sol;p>&NewLine;<p>Saying in tech language&comma; we need to run  <strong>select &ast; from rt where lgart &equals; &quest; and betrg &lt&semi; 0<&sol;strong>&period; This trivial task to run a very simple payroll report with any custom filters on wage type values is almost impossible in SAP Payroll module&period;<&sol;p>&NewLine;<p>Let&&num;8217&semi;s think what we can offer to our Payroll customers and end-users&period;<&sol;p>&NewLine;<h2>11 techniques to build SAP payroll report with custom filter<&sol;h2>&NewLine;<ol>&NewLine;<li>Standard wage type report&period; We can run the report and then filter values in ALV variant&period; it&&num;8217&semi;s a waste of time and resources as SAP needs to go through every employee&comma; extract all the data&comma; bring it to us and only then we can filter&period; In case of millions of rows&comma; it&&num;8217&semi;s almost impossible to do in ALV screen&period;<&sol;li>&NewLine;<li>Create a technical payslip in PE51 transaction&period; It&&num;8217&semi;s layout would look like CSV &lpar;Comma Separated Values&rpar; file with an employee number&comma; wage type&comma; period&comma; value&period; We can easily download this file and convert to MS Excel&period; It&&num;8217&semi;s a little better than the previous solution&period;<&sol;li>&NewLine;<li>Manually run SAP BI extractor in RSA3 transaction&period; The one cons here is the same as in bullet one &&num;8211&semi; there is no way to filter wage type by value until you get ALV output&period;<&sol;li>&NewLine;<li>Use 4&ast;&ast; payroll infotypes for reporting&period; These are virtual infotypes SAP creates base on Payroll Result Table&period; We can utilize these infotypes in SAP Query and setup filters there&period; It is time-consuming cause it converts cluster results to the infotype records for every single payroll period&period;<&sol;li>&NewLine;<li>PU12 transaction to export data out of SAP HR module&period; It downloads data to external TXT or CSV file which could be easily processed in Excel&period;<&sol;li>&NewLine;<li>DEvelop your own ABAP payroll report&period; Boring&period;<&sol;li>&NewLine;<li>Develop correction payroll schema and analyze needed wage type there&period; If it&&num;8217&semi;s negative&comma; save it&&num;8217&semi;s value in some custom technical wage type&period; Then we can use standard payroll wage types report to review negative values&period;<&sol;li>&NewLine;<li>Develop <a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;howto-organize-sap-testing&sol;" rel&equals;"noopener" target&equals;"&lowbar;blank">eCATT<&sol;a> script to run several SAP functional modules to extract and analyze data from the payroll cluster&period; Output data in some format like SAP spool&period;<&sol;li>&NewLine;<li>Call payroll BAPIs to extract data from SAP into MS Excel&period; This could be coded in Visual Basic to get access to SAP system&period; SAP logon is required and it works only on MS Windows platform&period;<&sol;li>&NewLine;<li>Declusterize payroll cluster &lpar;or move to HANA&rpar;&period; Thus all payroll tables will be just plain tables which could be accessed with SE16 transaction&period;<&sol;li>&NewLine;<li>Run BI reports to analyze anything&period; BI is intended for this task&period;<&sol;li>&NewLine;<&sol;ol>&NewLine;<p>My fantasy has ended here&period; I&&num;8217&semi;ve not found any standard way to download a list of employees who have wage type amount value under some conditions like more&comma; less or between&period;<&sol;p>&NewLine;<p>So&comma; is there a standard way to solve this task&quest; <strong>Share<&sol;strong> and let&&num;8217&semi;s find this out&excl;<&sol;p>&NewLine;

Exit mobile version