Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Import data from cluster table PCL2 filtered

Former Member

‎2009 Feb 23 9:11 AM

0 Kudos
133

Hi,

i'd like to know if it is possible to import data from cluster table PCL2 indicating a filter.

I'll give you a filter example to understand what i need:

"Get all the employees with an amount greater than 1000u20AC in wage type 9000 in november 2008"

One aproach to answer this question is to get each employee in the company 1 by 1 importing their payroll results for november 2008 and getting RX area to see if wage typ 9000 is greater than 1000u20AC.

This aproach is extremely unefficient if you have many employees in your company, because you have to read all of them. I'm wondering if it is possible to get directly from the database only the employees that acomplish the condition.

Thank you

1 REPLY 1

Former Member

‎2009 Feb 23 9:25 AM

0 Kudos
74

There is no way other than get the payroll results for the given pernr in the given period

and get required data for lgart = 9000.