Go Back   Wiki NewForum > SAP HR Configuration 6000 Real-time Screen Shots > SAP HR/HCM Forum

SAP HR/HCM Forum SAP HR Configuration 6000 Real-time Screen Shots SAP HR, Configurations, Steps, Online Training, Screen shots, Download, Payroll, Time Management, Time Evaluation, TM, Personnel Administration, PA, Organization Management, OM, Personnel Development, PD, Sample Resumes, Free, Tips, Documents, SAP Help, SAP HR Forum, Discussion Forum, E-recruitment in SAP HR , mySAP, Certification, Interview Questions & Answers, Course Employee Master Data, Work Schedules, Payroll sub modules, Absence, Attendance, Quotas, Gross salary, Tax calculation, Statutory, Legislation, Forms, Reports, Year end Activities, Certification Review, Technical Principles, Third Party Vendors, Testing, UAT, SAP HR FAQ, ESS and MSS, AS-IS, TO-BE, Integration, GL, FICO, SD, MM, Transaction Codes, T-codes, LSO, HR module Tables, Queries, Positive & Negative Time Recording, PCR, Schema, Features, Functions, Operations, SDN SAP, Payroll Driver, Errors, Solutions, Structures in Human Resources, Actions, IMG Steps, Path, Benefits, Info Type, Country Payrolls, India, USA, Canada, Germany, France, Specification, Error Message, HR Sapscripts, HR ABAP Reports, HR Authorizaton, Training and Event Management, SAP Solution Manager, CATS, Wage Types, Free HR eBook (PDF) SAP Reference Books on Human Resources, SAP Certification Exam & More.

Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average.
  #1  
Old ,
welcomewiki welcomewiki is offline
Member
 
Join Date: Dec 2008
Location: India
Posts: 138,633
welcomewiki has disabled reputation
Default How to Create Infoset Query (SAP Query)

Steps on how to proceed to create a Query:

ADHOC QUERY
A query can be created to extract information from master records i.e Infotypes. For example, by creating a query , the data relating to an employee contained in various Infotypes can be extracted.


Proceedure :
Decide on the various Infotypes we want to make the query. Decide on the area where we want to query i.e Global area or Standard area. Standard area is client specific and globel area will include all clients.
Menu : HR – PM – Admn - Information System - Adhoc Query
Select area standard and select the user group already created
Creation of new query :

TC SQ03 - Select Environment – Select Standard Area - Enter -- If new user group is to be created, enter name of the user group, click on create and enter necessary information and exit after saving

TC SQ02 - Enter name of the Infoset – Create – enter name of Infoset - Data source -- > Table join by basis table – give name of table e.g pa0000 - Enter - Click on insert table if we want to include more tables – give name of table one by one and after finishing, place cursor on the joining lines and right click to delete unwanted relationships - check - and go back - field groups - include all table fields - click on generate ****on - go out

TC SQ03 - Select user group - eg. Payroll
Infoset - Enter name of newly created Infoset
Assign users and Infosets - Assign infosets - put tick on payroll - save and go back


TC PAAH - Expand the nodes and put tick on relevant fields depending upon necessity
Save the query by giving the same name as infoset for easyness..
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Topic 57: SAP HR Ad-Hoc Query welcomewiki Download Real-time Configuration Documents with 6000 Screen Shots 77
How to create a HR infotype? welcomewiki SAP HR/HCM Forum 0
HCM - Create Positions welcomewiki SAP HR/HCM Forum 0


hit counter code
All times are GMT. The time now is .


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
January, February, March, April, May, June, July, August, September, October, November, December 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th, 9th, 10th, 03th, 12th, 13th, 14th, 15th, 16th, 17th, 18th, 19th, 20th, 21th, 22nd, 23rd, 24th, 25th, 26th, 27th, 28th, 29th, 30th, 31st.1.10.2014,2.10.2014,3.10.2014,4.10.2014,5.10.2014,6.10.2014,,7.10.2014,8.10.2014,9.10.2014,10.10.2014,11.10.2014,12.10.2014,,13.10.2014, 14.10.2014,15.10.2014,16.10.2014,17.10.2014,18.10.2014,,19.10.2014,20.10.2014,21.10.2014,22.10.2014,23.10.2014,24.10.2014,,25.10.2014, 26.10.2014,27.10.2014,28.10.2014,29.10.2014,30.10.2014,,31.10.2014,