Home > Default > No of Jobs Per Org Unit

No of Jobs Per Org Unit

November 30Hits:0
Advertisement
Hi Guys
I want to count number of employees related to a job in an organizational unit. So whats the relation between organizational unit and job. How it can be calculated.
I think Tables for this pupose are.
HRP1000.
HRp1001.
I am trying to use query given below but its not working.
SELECT *
FROM HRP1001
INTO ZIT1001
WHERE PLVAR = '01'
AND OTYPE = 'O'
AND SUBTY = 'B003'.
APPEND ZIT1001.
ENDSELECT.
Please note that I have to count number of employees in for all jobs in all departments. e.g
Departments -
Managers--Software Engineer-- Officer
Information Trech -
3 -
10 -
5
HR -
5 -
0 -
10
A detailed answer is appreciated.
Thnx

Answers

Firstoff, I would suggest you to take a look at the delivered Report RHXSTAB0.  It might suiot your requirement & avoid custom developement.
~Suresh

Read other 3 answers

Tags:

Related Articles

  • Unit Testing, Null, and WarningsOctober 11

    I have a Unit Test that includes the following lines: Dim nullarray As Integer()() Assert.AreEqual(nullarray.ToString(False), "Nothing") The variable "nullarray" will obviously be null when ToString is called (ToString is an extension

  • REJECT_CODE Vendor information and/or Operating Unit information is missingOctober 11

    hi i am using Oracle Applications : 11.5.10.2. i am trying to load suppliers and suppliers data into oracle AP. i tried doing this with some sample data. i executed the following code below : insert into AP_SUPPLIERS_INT (VENDOR_INTERFACE_ID, VENDOR_

  • HT2589 We have purchase 5 apple minis and would like them all on one account.  That way we can monitor the use of these units.  they will be used strickly for a business application.  can I use one account in itunes or must i have multiple.October 11

    We have purchased 5 apple minis and would like them all on one account, that way we can monitor the use of these units.  They will be used strickly for a business application.  Can I use one account in itunes or must i have multiple.Not going to happ

  • How do I move settings from one Airport unit to another?October 11

    I am considering buying one of those new Airport Expresses, the one with dual band. I have a few questions about importing the settings (from my existing Extreme unit): - Is it true that it's better to start from scratch when setting up the new unit

  • List view in mobile units.October 11

    Why is not list view a choice in mobile units?In my case Android.Its hard to have en overview in files when you only can scroll around i icon view.PLS fix for better user friendliness!!!Concern all mobile units i beleve.You might want to post your re

  • Error while defining alt unit of measurement in material masterOctober 11

    All SAP gurus, i am trying to define a alt unit of measurement in a finished material, the base unit of measurement is in MT, and the sales unit is nos. the conversion formula is 53 nos = 1kg i.e. 1MT = 53000 nos. as conversion can be done only with

  • IPod Touch no longer working with car Head Unit since updateOctober 11

    Hi there, I have a problem with using my iPod Touch with my car's head unit. I've been using my iPod Touch with the Alpine IDA X001 Head unit fitted in my car for the last 3 months without any problems, however I installed the latest software update

  • Currency unit in Report painterOctober 11

    Hi, I met a problem when i maintain a report using report panter. Table FAGLFLEXT is used for the library, and I want to using currency translation function. I use Basic key figure "HSL local currency" and CC_HSL translation local currency for t

  • Org unit date in adhoc queryOctober 11

    Hi I have created a TEM query in SQ02, based on infoset \SAPQUERY\HR_TEM_E (logical database PCH),  in which I am outputting object name and date (P1000), and org unit (P8004). The output on the org unit name corresponds to the most current version o

  • Systemd unit for Glassfish v4 serverOctober 11

    Hi all! Im trying to set up sytemd unit for glassfish4 web server but I am ending up in failed satate.. Here's what I got: cat /usr/lib/systemd/system/glassfish.service [Unit] Description=GlassFish Server [Service] ExecStart=/home/pian/glassfish4/bin

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.721 s.