Tuesday, 13 September 2011

Creating New Infoset 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 button - 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..

Creating HRP infotypes

Wednesday, 20 July 2011

Date related function Modules in HR

Function Modules Description
/SAPNEA/J_SC_CONVERT_DATE Covert Date in Japanese Format
/SDF/CMO_DATETIME_DIFFERENCE Calculates difference between two dates/timestamps.
ADD_TIME_TO_DATE Add time to date
BKK_ADD_MONTH_TO_DATE Add months to date
BKK_ADD_WORKINGDAY
BWSO_DATE_GET_FIRST_WEEKDAY Gives the First date of the week for the given date
CACS_DATE_GET_TIMESTAMP Concatenates the date and time format 11-12-2008 10:11:11
CACS_DATE_GET_YEAR_MONTH Gives the Year and month for the given date
CACS_TIMESTAMP_GET_DATE Get date and time from Timestamp
CONVERT_TIME_TERMS
DATE_CHECK_WORKINGDAY Check the day is working day or not for given date & calendar id
DATE_CHECK_WORKINGDAY_MULTIPLE Check the day is working day or not for given date in muliple calendar id
DATE_COMPUTE_DAY Gives the day number in the week (EX 1-Mon,2-TUE etc)
DATE_CONVERT_TO_WORKINGDAY
DATE_TO_DAY Gives the day of the date(Ex Monday, Tuesday etc)
DATE_TO_DAY Get the day of the date (Ex Mon.Tue etc)
F4_DATE FM for F4 help for Date
FIMA_DAYS_AND_MONTHS_AND_YEARS
FIMA_DECIMAL_MONTHS_AND_YEARS Gives the difference between the dates in decimal foemat of number of month & years
GET_WEEK_INFO_BASED_ON_DATE Get the week Number, Sunday date & Monday date for the given date
HR_99S_DATE_ADD_SUB_DURATION Add/Subtract months(M)/days(D)/years(Y) to given date to get the future date
HR_99S_DATE_MINUS_TIME_UNIT Subtract months(M)/days(D)/years(Y) to given date to get the future date
HR_99S_DATE_PLUS_TIME_UNIT Add months(M)/days(D)/years(Y) to given date to get the future date
HR_99S_INTERVAL_BETWEEN_DATES Gives the difference between the dates in days, weeks, years
HR_99S_MONTHS_BETWEEN_DATES *  Returns months between two dates. Both dates are included in the

*  computation. An individual prorata is made for each month

*  Meaning of parameter p_compl:

*  'B' accumulate all complete months and in/complete first month

*  'E' accumulate all complete months and in/complete last month

*  ' ' accumulate all months (incomplete and complete)

*  'X' accumulate only complete months
HR_CALC_YEAR_MONTH_DAY Gives the difference between the dates in days, weeks, years
HR_E_NUM_OF_DAYS_OF_MONTH Number of days in the given month
HR_HCP_ADD_MONTH_TO_DATE Add months to date
HR_IN_GET_DATE_COMPONENTS Splits rge given date in DAY, MONTH, YEAR, Month Small TEXT & Month Long TEXT
HR_MONTHS_BETWEEN_TWO_DATES Gives months bteween the two dates
HR_SGPBS_YRS_MTHS_DAYS Gives the difference between dates in Day,Months, years 7 calendar Days
HRAR_SUBTRACT_MONTH_TO_DATE Subtract's one month from the date
IDWT_READ_MONTH_TEXT Read the month Text
LAST_WEEK Get the Last week Number, Sunday date & Monday date for the given Year and Week number
LOOK_FOR_TIME_TABLE
MONTH_NAMES_GET Gives the list of 12 months text in the given language
MONTH_PLUS_DETERMINE Add months to date
MONTHS_BETWEEN_TWO_DATES Gives months bteween the two dates
MONTHS_BETWEEN_TWO_DATES_NEW
NEXT_WEEK Get the Next week Number, Sunday date & Monday date for the given Year and Week number
NUMBER_OF_DAYS_PER_MONTH_GET Gives you the number of days per month considering the Year
OIL_LAST_DAY_OF_MONTH Gives the last day of the month
OIL_LAST_DAY_OF_PREVIOUS_MONTH Gives the last day of the prevous month
OIL_MONTH_GET_FIRST_LAST Gives the month first day date & last day date
RE_ADD_MONTH_TO_DATE Add months to date
RH_GET_DATE_DAYNAME Gives the day number in the week and day text
RH_PM_CONVERT_DATE_TO_MONTH
RH_PM_CONVERT_DATE_TO_MONTH Gives the difference between the dates in month
RH_PM_CONVERT_DATE_TO_YEAR
RP_CALC_DATE_IN_INTERVAL To calculate the new date by adding/Sub days, months & Year
SG_PS_GET_LAST_DAY_OF_MONTH Last day of the month
TIME_CONVERSION
TM_DATE_CHECK_WORKINGDAY
WDKAL_DATE_ADD_FKDAYS
DATE_CHECK_PLAUSIBILITY
 
  DATE_IN_FUTURE Calculate Future Dates
  DURATION_DETERMINE
Calendar: Determine duration between tw
DELTA_TIME_DAY_HOUR
Difference Between  Date & Time
CALCULATE_DATE Year entry: 2-charact. to
HR_SEN_CRULE_0100_DATE Calculation of a Date (1 Year = 12 Months, 1 Month = 30 Days)
DATE_2D_TO_4D_CONVERSION

Thursday, 14 July 2011

SAP HR - basic iterview questions-Answers

Here I have tried to answer some basic SAP HR Questions:
1. What are infotypes?
Infotype is a logical grouping of related fields of employee information. For example, Employee addresses (Permanent, Temporary, Home, Emergency etc...) form one Infotype.
2. What are personnel actions? What is the transaction for executing personnel actions?
Any activity carried out on an employee (personnel) such as - hiring, promotion, change of pay, termination etc... is called a Personnel Action. In SAP, each actions is performed as a combination of edits to several individual infotypes. The transaction for executing Personnel Actions is PA40.
3. What are the important info types for a hiring action?
The following infotypes are part of the hiring action and will be edited in the same sequence when the hiring action is performed:
  1. 0000 - Actions (to capture employee movement info in the organization)
  2. 0001 - Organizational Assignment (to capture employee positioning in the organization)
  3. 0002 - Personal Data
  4. 0006 - Address
  5. 0007 - Planned Working Time (Store planned working hours for the employee.)
  6. 0008 - Basic Pay
  7. 0009 - Bank Details
  8. 0014 - Recurring Payment
  9. 0015 - Additional payment
  10. 0016 - Contract Elements
  11. 2006 - Absence Quotas

4. What is IMG? What is its importance? What are the functions you can execute using IMG?
IMG is short for "Implementation Guide". It is used for customizing SAP R/3. The SAP Implementation guide lists all the required steps for configuration, customization and implementation of various SAP modules like HR, FI, CO, MM, SD etc... in a simple to understand tree structure. This can be accessed by the transaction "SPRO".
5. What is customizing? What does customizing support?
Customizing means modifying the functionality of the system provided by SAP to meet the needs of the company implementing it.
6. How do you create a Project IMG? What are project views?
On SAP Easy Access Menu, Go to Tools -> Customizing -> IMG -> Project Administration. Click on 'Create' and give necessary details.
7. What are the IMG attributes?
Each IMG activity has the following attributes as part of the IMG structure.
Assignment to ASAP Roadmap, Processing necessity level, Critical function, Assignment to business application component, Country assignment, Assignment to Customizing object, Enhancement.
Further attributes are possible.

8. What is an enterprise structure? enterprise structure is the back bone of HUMAN RESOURCE MANAGEMENT. Enterprise Structure is an structure depicting the organizations units i.e personnel areas, personnel subareas, employees . In Enterprise structure we define company, company code, personnel area , personnel subarea

9. What is a personnel structure? The Enterprise Structure and Personnel structure are used exclusively in system rules for the processing of pay roll, time benefits and changing organization structure
10. What is the highest level of the enterprise structure? Company Code
|
Personnel Area
|
Personnel Sub Area
11. What is company code? Is it defined in HR? If not where is it defined? company code is defined in financial management of enterprise structure. It is a 4 character alpha numeric code to be defined in order to be unique and identifiable.
12. What are personnel areas and its functions?
"A personnel area is an organizational entity representing an area within an enterprise defined by specific aspects of personnel administration, time management and payroll."
13. What are personnel sub areas and its functions?
personnel sub areas are sub divisions of personnel area. The strategies for designing of personnel subareas is to represent a categorization of the position units in the organization. It also helps to define the type of employees or persons to be hired

14. How is an employee in the HR Master data linked to a company to which he belongs?
An employee is an Pers area and Pers Sub area. These are assigned to a Company code and country grouping.
15. Can a personnel area be assigned to many company codes?
A pers area / pers sub area combination can be assigned to one company and one country grouping. Thus a pers are may be linked to one or more company codes. Country code determines currency for the employee. Company code determines the organizational structure that the employee belongs to. It provides the links to FI/CO and for functions/processes like payroll posting, costing. When you assign a person to a pers area/sub area, you also need to assign to a position in an Org unit. To do this the MP000100 goes to the FI module to check if FI is implemented.
16. What are the indicators defined by personnel sub areas?
17. How do you categorize the employee groups?
Employee groups are just ways of categorizing employees such as 'Active', 'Retired', 'Intern', 'Inactive', 'Temporary', etc. however a company may define it.
18. What are employee subgroups and what are the indicators set up using employee subgroups?
Employee subgroups are used to break down the Employee Groups such as someone who is in the 'Active' group could be considered several different types of employees within the organization. The subgroups can be defined how a company sees fit be it different types of 'Hourly' and 'Salary' groups or defined by administrative position or task.
19. Employee groups are two character and employee subgroup are two character representations in the IMG. Do you support this statement? Employee group is one character i.e. 1 active , Employee sub group is division of employee group two characteristics i.e 02- salaried employee....
No, Employee Groups are single alphanumeric characters while Subgroups are two character.
20. In the HR Master data where are planned working times for an employee seen?
In transaction 'PA20' or 'PA30', Planned working time (infotype 0007) can be found under the contract data tab. Or give the infotype as 7 in the infotype field in PA20 or PA30 click on Display button on top.
21. Do I need to give country assignment to personnel sub areas in customizing? If true support the statement and if not what’s true?
False. See answer to Q 15 above.
22. What are the various objects in an organizational plan?. How does any company use an organizational plan?
An organizational plan is a hierarchical overview of the organization and is comprised of Org Units (O), Positions (S), Jobs (C), Persons (P), Cost Centers (K), Tasks, and Users.
23. Describe the following
  1. Tasks - a specific function or activity that can belong to another
  2. Job - Description of activity performed by the employee
  3. Position - occupied by an employee in the company , it is company specific
  4. Organizational unit - describes various units of the company it depends on tasks and functions
  5. Cost Center - cost center can be related to organizational unit and position.
24. Which of the above objects belong to HR?
All of them are utilized in HR.
25. How do you integrate OM and PA? If integration is active what happens when a position is entered in IT 0000.? What else does the system default? Can these values be changed? What is this called?
The integration switch PLOGI - ORGA must be set (value X) in the table T77S0 to enable the integration between OM and PA. If the integration is active, on entering the position in IT 0000, the system populates the org unit, cost center, job, company code, business area, payroll area etc by default in IT0001.
26. Are cost center assignments hierarchical? Where do you assign these in OM?
Yes. Cost center assignment is inherited from the hierarchy above. Cost center can be assigned to an organizational unit or a position.
27. What are attributes of objects? Is vacancy a common attribute for all objects? Object attributes are object name and abbreviations object type object ID planned status planned version relationship validity
28. What are the other additional organizational assignments?
29. Name the three administrators? How do you default these in IT0001?
Personnel administrator, Payroll administrator and Time administrator. these are defaulted using the feature PINCH
30. What is organizational key? How many bytes/characters does it constitute? How can it be defined? What is it mainly used for?
31. What are employee attributes and how are they classified? Employee attributes are activity status, employment status and training status.
32. What are features? What is the transaction for features?
Features are objects in the system that determine a specific value by querying different enterprise personnel or data structure fields. The value is known as a "return code" or "result". This value is used to determine default values and to control certain system processes. Features enhance system flexibility. Transaction: PE03. Example: Feature ABKRS provides a default value for the payroll area. This is based on the data found in an employee’s Org Assignment.
33. What are the features to default and in which infotype
1.Work Schedule Rule SCHKZ- IT0007 2.Pay Scale Data TARIF-IT0008 3.Wage Type Model LGMST-IT0008 4.Administrator groups PINCH-IT0001 5.Number Range Intervals NUMKR
Feature NUMKR is used to define whether the employee numbering created for such personnel area would be created internal (proposed by the system) or external assignment (User Define).
Feature TARIF can be used to default basic pay Info group entries per Personnel Sub Area based on pay scale type/area and its relationship with payscale group and leveling.
Another useful feature is ABKRS, that is the feature which defaults payroll area
34. Number Range Intervals
NUMAP is the feature in order to identify the Applicant Number Ranges   
NUMKR is the feature in order to identify the Infotype 0000 (Actions) while Hiring an employee
35. What is ABKRS? feature for default payroll areas
ABKRS : Default Value for Payroll Area Task : This feature enables you to obtain the default value for the payroll area. Use : Infotype 0001, Organizational Assignment Procedure : The return value of the feature is a payroll area from table T549A, Payroll Areas. This can be overwritten and is reassigned and displayed in a warning message when changes are made to the organizational assignment.

36. What are the two ways of maintaining features? Transaction Code PE03
37. What is the info type to store personal data for an employee?
Ans : 0002
38. Where are the default values for working hours per period taken from in IT 0008?
39. Why is employee subgroup grouping for pcr significant for payroll?
40. What does collective agreement provision determine? How do you depict different payments in the system?
41. What does employee subgroup grouping for CAP allow you to assign?
42. What is payscale type and payscale area? Payscale type - industry eg: Metal/Chemical Industry Payscale Area - Geographic Region

43. You assign payscale types and areas to
  1. Company code
  2. Payroll area
  3. Employee subgroup
  4. Personnel subarea
44. What are wage types? How wage types are broadly classified? Wage types are classified as Model Wage types starts with M Customized wage types start with number Technical Wage types always starts with /
45. How do you set up wage types? PU30 - copy wage type from model wage type T511- Wage type characteristics
46. What are slash wage types? Technical wage types, these are generated during payroll calculations and cannot be maintained directly.
47. Why are wage type groups used? Give some examples of wage type groups.
48. What is transaction pu95?
49. Where in the IMG do i ensure that the wage types are associated with the enterprise and personnel structure.?
50. Where are all wage types stored?
51. Are all wage types permissible for all info types ? If Yes or NO support statement?
52. What are the wage type characteristics that can be defined?
53. How do you valuate wage types? Where do you configure this in the IMG?
54. What are module name and module variant?
55. Explain significance of TARIF , SUMME and PRZNT in regards to indirect valuation?
56. Briefly explain the two different ways to perform pay increase?
57. In dynamic pay increase what are variants A, G, D, E, T , C and R?
58. What are the info type attributes?
59. What are system controls?
60. What is DYNPRO ? What are the main elements of a screen?
DYNPRO represetns the screen and it's flow logic in module 
    pool concept.
Screen elements = text fields, input/output field, drop down list box, check boxes, push  button,  box, sub screen, table controls/ step loops, tabstrip control, status icon, OK_CODE field
http://www.thespot4sap.com/Articles/SAP_Design_Screen_Elements.asp
61. What naming conventions are the info types subject to?
62. Where are the info types relevant to retroactive accounting for payroll and time management defined?
63. What are the significance of field triggers in retroactive accounting?
64. What do you need to do in the IMG to specify certain info types for certain countries only?
65. Where can you store a passport photo of an employee? Where do you do the settings in the IMG?
66. What is TCLAS = A and TCLAS = B?
67. Where can you change the attributes of individual screens?
68. What are infotype menus or info menus? Are they user group dependable?
69. What setting do i need to make for a SAP user to see that he has the relevant infotype menus?
70. Where do I assign the IG (infogroup) to the personnel action type? Are infogroups user group dependable?
71. What is IGMOD?
IGMOD is a feature. The SAP description of the feature is
IGMOD Infogroup Modifier
Object                                                                    
                                                                           
   Feature                                                                 
                                                                           
 Task                                                                      
                                                                           
   Grouping combinations of control features in an event using a modifier. 
                                                                           
 Use                                                                       
                                                                           
   o   Table - Infotype groups - T588D                                     
                                                                           
   o   Infotype - Events - (I0000)                                         
                                                                           
 Procedure                                                                 
                                                                           
   In table T5299, the nameup is, in turn, defined in table T588D in       
   conjunction with the control features: company code, personnel area,    
   employee group, employee subgroup.                                      
                                                                           
   The return code of the feature is a modifier which reads table T588A.   

72. For a country reassignment action what setting do i need to do in the IMG?
73. What are additional actions? What are the ways in which i can activate additional actions for an employee? Where are additional actions stored? Can we see the infotype record where additional actions are stored directly?
74. What is the significance of status indicator in personnel actions?
75. What are MSN20, MSN21 and MSN32 in relation to personnel actions?
76. Where do you define the action reason in the IMG?
77. What is user group dependency of the action menu?
78. With a leaving action what is the employment status changed to?
79. What are dynamic actions? What can they trigger?
80. What is PAMA? What is M0001?
81. What are general authorizations?
82. What are structural authorizations?
83. How are authorizations defined? An authorization object can define maximum 15 fields that occur in an authorization? True or False?
84. What is an authorization profile? How are users authorizations determined?
85. What is a role? How the access to transactions, reports and web based applications included in a role defined?
86. Roles can be found under generic name SAP_HR*? True or False?
87. What is a profile generator?
88. How do you create users?
89. What are the ways of setting up general authorization checks?
90. What are the two types of double verification principle ? Explain with example?
91. Authorization main switches are stored in Table T74SO or T76SO or T77SO? To permit extended authorization check along with master data check what settings need to be done?
92. Describe in brief the period of responsibility with reference to a user giving examples?
93. What are P_ORGIN and P_ORGXX?
94. What are evaluation paths?
95. To implement structural authorizations you need to have existing the PA module? True or False?
96. What do C, S, P and O stand for?
97. What do mean by the terms
  1. Status vector
  2. Display depth
  3. Period
  4. Function Module
98. Describe in brief giving examples how period of responsibility is determined for the general authorization check in a structural authorization check?
99. What are PD profiles and SD profiles? What do they do?
100. What do you mean by planned times? Where are these stored for an employee?
101. What do you mean by actual times? Where are these stored for an employee?
102. What do you mean by deviations? Where are these stored for an employee?
103. What do you mean by negative time and positive time? Where do you use time evaluation?
104. What is RPTQTA00? What does it do? What is RPTIME00?
105. What is time management status 7? What is it used for?