Mail: sapgeek@gmail.com



Friday, June 11, 2004

The top ten IT skills to have for the next few years

This is not a scientific survey, but merely the opinions of a few agents that we asked. If you have a highly valued skill that isn't on here, don't worry, this is not definitive, but merely the opinions of a few agents. I'm sure if we'd polled others the list might have been slightly different.

Skills on the Up
We polled a number of agents and other sources of information and came up with the following skills that are likely to be on the up over the next few years. Anyone with these skills is likely to be employed, at good rates, even taking into account offshore outsourcing and Fast Track Visa Workers.

1. J2EE
2. .Net
3. C#
4. Project Management
5. Oracle 8 and 9i
6. SAP
7. Business Analysis
8. VB.net
9. NT Novell
10. Java

New Hot Skills
The top three are definitely becoming very hot skills.

It's good to see Project Management up there. It is a much underrated skill.

Business Analysts are also less immune to offshore outsourcing, as they have to remain reasonably close to the business users.

SAP continues to do well and is taking market share from its rivals.

Siebel also gained an honourable mention.

Oracle continues to be very strong, and is also expected to gain even more market share in the coming years.

Honourable Mentions
Other skills that also received honourable mention for the future are some of those from before the downturn such as:-

SQL
Unix
C++
VB
Access
ASP

In fact SQL, Unix and C++ are still the most sought after skills currently, and anyone who has them should stand in good stead.

source: sap-img

test
 

Monday, June 07, 2004

This is my Personality Disorder Test results:

DisorderRating
Paranoid:High
Schizoid:Moderate
Schizotypal:Moderate
Antisocial:Moderate
Borderline:Very High
Histrionic:Moderate
Narcissistic:High
Avoidant:Moderate
Dependent:High
Obsessive-Compulsive:Moderate

-- Personality Disorder Test - Take It! --




hmm I guess not too bad huh~ Prob thats the personality of a no life programmer =)
cheers~
 

Thursday, June 03, 2004

Extra Information on Benefits related.

Function Module:
HR_BEN_READ_HEALTH PLANS
HR_BEN_READ_DEPENDENTS
-BPCAT = 'A' (Benefits Plan category)

HR_BEN_READ_INSURANCE_PLANS
HR_BEN_READ_BENEFICIARIES
-BPCAT = 'B'

HR_BEN_READ_SPENDING_PLANS
HR_BEN_READ_SAVINGS_PLANS
-BPCAT = 'C'
HR_BEN_READ_INVESTMENTS
HR_BEN_GET_PLAN_COST

All the functinos is pretty much straight forward.
The most exiciting phase for this project was the PDF conversion and generation. (Previous post)
Feels l33t after getting the PDF display running..
Screenshot will be up later due to server maintenance.
 

Saturday, May 29, 2004

TO DISPLAY CONFIRMATION FORM ON BSP PAGES IN PDF FORMAT

--------------------
OnInitialization
--------------------
DATA: pdf TYPE rcl_bag_tline.

DATA: l_fsize TYPE i.
DATA: lw_error TYPE rpbenerr.
DATA: li_error LIKE TABLE OF lw_error.

DATA :xstr TYPE xstring,
lpdf TYPE tline .
FIELD-SYMBOLS: TYPE x.
DATA: cached_response TYPE REF TO if_http_response.


CALL METHOD APPLICATION->ME_IUN_GET_BENEFITS_REF
IMPORTING
EXW_ME_BENEFITS_REF = ATW_BENEFITS_REF
.

*procude form in pdf format
CALL FUNCTION 'HR_BEN_FORM_PRINT'
EXPORTING
pernr = ATW_BENEFITS_REF-pernr
barea = ATW_BENEFITS_REF-barea
begda = sy-datum
* ENDDA =
* FORM_DATUM =
form_type = 'C'
* EVENT_DESCRIPTION =
* ENROLLMENT_TYPE =
command = 'PDF'
language = sy-langu
reaction = ' '
IMPORTING
pdf_table = pdf
pdf_fsize = l_fsize
* SUBRC =
TABLES
error_table = li_error.

* create dynamic web page for PDF display
CREATE OBJECT cached_response TYPE cl_http_response
EXPORTING add_c_msg = 1.

* set attributes for PDF display
cached_response->set_header_field(
name = if_http_header_fields=>content_type
value = 'application/pdf' ).
cached_response->set_status( code = 200 reason = 'OK' ).
cached_response->server_cache_expire_rel( expires_rel = 180 ).


* We build the body of the response
* The body of the PDF file
LOOP AT pdf INTO lpdf.
ASSIGN lpdf TO CASTING.
MOVE TO xstr.
cached_response->append_data( data = xstr ) .
ENDLOOP.

* generate URL for output
DATA: guid TYPE guid_32.
CALL FUNCTION 'GUID_CREATE'
IMPORTING
ev_guid_32 = guid.
CONCATENATE runtime->application_url '/' guid INTO display_url.

* output URL.
cl_http_server=>server_cache_upload( url = display_url
response = cached_response ).
RETURN.


------------------------------
layout
------------------------------
*create an iframe then link it with :-
' src="<%=display_url%>" width="100%" height="800px" '

*declare attributes
display_url as type string.
 

Wednesday, May 26, 2004

Printing the Benefits Confirmation Form

*PS: This is just the general idea of how to view the damn confirmation form.

Senario: Benefits Administration Printing the Benefits Confirmation Form
SAP R/3 Menu Path >>Human Resources >> Personnel Management >> Benefits >> Forms >> Confirmation
This process outlines the procedure for printing the benefits confirmation letter if this step was missed during the enrollment process.

Printing of Selection Form (tree structure) Screen
Period Will default to 'today'. Change if necessary.
Personnel number -> Enter the employee's personnel number.
Click on Execute.

Print Confirmation Form Screen
Click on the selection 'box' to the left of the employee's personnel number and name. A Green Check Mark will be displayed in the box.
To display the form before printing, click on Display Form. To print, click on the Green Back Arrow then click on Print Form.
The system will return to the Print Confirmation Form screen.
 

Tuesday, March 23, 2004

SAP HR TABLES

*PS: not a complete ones.. these are the ones I'm currently using...

All personnel administration tables start with PA and the infotype number behind it.
All personnel development/OM tables start with HRP and infotype (e.g. 1000) behind it.
All recruitment tables start with PB and infotype number behind it.

There also are HR tables that start with HRA, HPD, HRT, etc. The easy way to get a list is to use SAP's 'Application Hierarchy', transaction SE81 (select all HR modes in the tree that you are want a list of tables for, click on the 'Information System' button, under Abap Dictionary --> Basic Objs, double click on 'database tables', increase your 'maximun no. of hits' and execute).

Use transaction se11...type in PA* do dropdown and enter, do the same for HRP* and you will have most of the HR transaparent Tables. To access them look for RP_read_* and RP_provide* in Table TRMAC to read a infotype or use the 'select' statement to access the Transparent table.

Transaction SE16 (data browser) is also useful. As mentioned above, the PA infotype tables all begin with PA and are followed by the infotype number e.g. PA0001 for the Org Man infotype.

PA* - PA infotype tables
PCL* - HR clusters
PB* - recruitment tables
PCERT - payroll posting runs


Another useful table is CATSDB for CATS, and PTEX2000 for the CATS transfer table for infotype 2001/2002.

The rest of the HR Tables are as follows:
DD01L Domains
DD02L SAP tables
DD03L Table Fields
DD03T DD: Texts for fields (language dependent)
DD04L Data elements
DD04T R/3 DD: Data element texts
DD05S Foreign key fields
DD06L Pool/cluster structures
DD20L Matchcode Ids
DD24S Fields of a matchcode ID
T000 Clients
T001 Company Codes
T001E Company code-dependent address data
T001P Personnel Areas/Subareas
T012 House banks
T012K House bank accounts
T012T House bank account names
T500L Personnel Country Grouping
T500P Personnel Areas
T500T Personnel Country Groupings
T501 Employee Group
T501T Employee Group Names
T502T Marital Status Designators
T503 Employee Groups / Subgroups
T503K Employee subgroup
T503T Employee Subgroup Names
T504A Benefits - Default Values (NA)
T504B Benefit Option Texts (North America)
T504C Benefit Type (NA)
T504D Benefit Credit Group Amount
T504E Benefit Amount
T504F Benefit Costs
T508A Work Schedule Rules
T508T Texts for Employee Subgroup Groupings for Work Schedules
T510 Pay Scale Groups
T510A Pay Scale Types
T510F Assign Pay Scale > Time Unit, Currency
T510G Pay Scale Areas
T510H Payroll Constants with Regard to Time Unit
T510I Standard Working Hours
T510J Constant Valuations
T510L Levels
T510M Valuation of pay scale groups acc. to hiring date
T510N Pay Scales for Annual Salaries (NA)
T510S Time Wage Type Selection Rule
T510U Pay Scale Groups
T510Y Special Rules for Wage Type Generation
T511 Wage Types
T512R Cumulation Wage Types in Forms
T512S Texts for Cumulation Wage Types in Forms
T512T Wage Type Texts
T512W Wage Type Valuation
T512Z Permissibility of Wage Types per Infotype
T513 Jobs
T514S Table Name Texts
T514T Field Name Texts
T51D2 Wage Type Classes
T51D3 Reduction Rules
T51D4 Cumulation Rules
T527X Organizational Units
T528B Positions - Work Centers
T528C Wage Type Catalog
T528T Position Texts
T529A Personnel Event
T529F Fast Data Entry for Events
T529T Personnel Event Texts
T52BT Texts For HR Objects
T52C0 Payroll Schemas
T52C1 Payroll Schemas
T52C2 Texts for Personnel Calculation Schemas
T52C3 Texts for Personnel Calculation Schemas
T52C5 Personnel Calculation Rules
T52CC Schema Directory
T52CD Schema Directory
T52CE Directory of Personnel Calculation Rules
T52CT Text Elements
T52CX Cross References via Generated Schemas
T52D1 Valid Processing Classes
T52D2 Valid Values for Processing Classes
T52D3 Valid Evaluation Classes
T52D4 Permitted Values for Evaluation Classes
T52D5 Wage Type Groups
T52D6 Wage Type Group Texts
T52D7 Assign Wage Types to Wage Type Groups
T52D8 Valid Processing Classes - Texts
T52D9 Valid Values for Processing Classes - Texts
T530 Reasons for Events
T530E Reasons for Changes
T530F Reasons for Changes
T530L Wage Types for Special Payments
T530T Event Reason Texts
T531 Deadline Types
T531S Deadline Type Texts
T533 Leave Types
T533T Leave Type Texts
T539A Default Wage Types for Basic Pay
T539J Base Wage Type Valuation
T539R Events for Standard Wage Maintenance
T539S Wage Types for Standard Wage Maintenance
T548 Date Types
T548S Date Conversion
T548T Date Types
T548Y Date Types
T549A Payroll Areas
T549B Company Features
T549C Decision Trees for Features (Customers)
T549D Feature Directory
T549L Date modifiers
T549M Monthly Assignment: Payroll Period
T549N Period Modifiers
T549O Text for date modifier
T549P Valid Time Units for Payroll Accounting
T549Q Payroll Periods
T549R Period Parameters
T549S Payroll date types
T549T Payroll Areas
T549M Monthly Assignment: Payroll Period
T549N Period Modifiers
T549O Text for date modifier
T549P Valid Time Units for Payroll Accounting
T549Q Payroll Periods
T549R Period Parameters
T549S Payroll date types
T549T Payroll Areas
T554S Absence and Attendance Types
T554T Absence and Attendance Texts
T554V Defaults for Absence Types
T554Y Time Constraints in HR TIME
T555A Time Types
T555B Time Type Designations
T559A Working Weeks
T559B Name of Working Week
T572F Event Texts
T572G Allowed Values for Events
T572H Event Value Texts
T582A Infotypes
T582B Infotypes Which Are Created Automatically
T582S Infotype Texts
T582V Assignment of Infotypes to Views
T582W Assigns Infotype View to Primary Infotype
T582Z Control Table for PA Time Management
T584A Checking Procedures - Infotype Assignment
T588A Transaction Codes
T588B Infotype Menus
T588C Infotype Menus/Info Groups
T588D Infogroups for Events
T588J Screen Header Definition
T588M Infotype Screen Control
T588N Screen Modification for Account Assignment Block
T588O Screen Modification for Assignment Data
T588Q Screen types for fast entry
T588R Selection Reports for Fast Data Entry
T588S Screen Types for Fast Entry
T588T Menu and Infogroup Designations
T588V Business object type
T588W Event types for infotype operations
T588X Cust. composite definition of event types for IT operations
T588Z Dynamic Events
T591A Subtype Characteristics
T591B Time Constraints for Wage Types
T591S Subtype Texts
T596F HR Subroutines
T596G Cumulation wage types
T596H _Cumulation wage type texts
T596I Calculation rule for cumulation wage types
T596U Conversion Table
T599B Report Classes
T599C Report Classes
T599D Report Categories
T599F Report Classes - Select Options
T777A Building Addresses
T777T Infotypes
T777Z Infotype Time Constraints
T778T Infotypes
T778U Subtypes

Error Messages tables
T100 Messages
T100A Message IDs for T100
T100C Control of messages by the user
T100O Assignment of message to object
T100S Configurable system messages
T100T Table T100A text
T100V Assignment of messages to tables/views
T100W Assign Messages to Workflow
T100X Error Messages: Supplements
 

online