摘要
随着信息管理系统的不断革新,ERP即企业资源计划信息管理系统的迅速
推广,成熟的企业管理软件成为各大公司的必备项目。同时,随着本单位业务
的扩展,ERP薪资核算系统已不能满足部分实际业务需求,在ERP系统中进行
核算的员工主要为中央全名员工,部分员工如劳务派遣、内退人员、已离职、调
出人员的需在系统外进行手动核算做账,此外,部分单位由于财政管理制度和
ERP上线时间问题,导致需要在系统外进行手工核算做账。因此,需要开发一套
薪酬台账系统,全面管理新疆石油公司员工薪酬福利信息,由手工做账转为系
统做账,减轻财务专责工作强度,提高工作效率。

本文按照软件工程的标准流程,对系统进行了需求分析、功能模块划分、
数据库模式分析,设计了数据库结构和应用程序。按照本单位对线外薪酬管理
的实际业务流程,对人员基本信息和薪酬导入、人员基本信息和薪酬推送、人
员基本信息查询、人员薪酬信息查询、年度台账报表抽取与查询和员工全年收
入明细数据抽取导出等各模块进行功能分析和设计,釆取“自下而上”的方
法,先分别实薪酬台账管理系统的各个模块的具体业务功能,然后形成整体系
统。

系统采用SAP开发环境,运用MVC设计模式,前台采用ALV对报表进行
展示,后台数据库采用Oracle,实现了上述六大功能模块。经过系统测试,该
系统运行良好,部分地州线外薪酬数据巳对平。

关键词:薪酬台账;ERP; SAP
Abstract
Wiih the information management system innovation, ERP is enterprise resource
planning rapid spread of information management systems, sophisticated business
management software company to become the major essential items. Meanwhile, with
the expansion of our business units, ERP payroll accounting system has been unable
to meet part of the actual business needs to be accounted for in the ERP system for the
central staff of the full name of the main staff, some employees such as dispatch, tiie
retired officers have resigned tone a person outside the system needs to do a manual
accounting accounts, in addition, some units due to financial management systems
and ERP on-line question of time, resulting in the need outside the system manual
accounting books in order. Therefore, the need to develop a salary ledger system,a
comprehensive management staff salary and benefits information Xinjiang Oil
Company, made by hand account into the account at the system,reduce the financial
strength of dedicated work, improve work efficiency.
In this paper, according to the standard process of software engineering, analysis
of the system requirements analysis, functional module division,database model,
designed the database structure and the application procedure. According to the unit
on line compensation management of the actual business process, the staff basic
information and salary import, personnel basic information and salary push, staff
basic information, staff information query, the annual accounting statements
extraction and query and employee annual income data extraction derived the module
function analysis and design,to take bottom up approach, each module separately
reatsalarjraccoi^ management system of specific business functions, and then form
the whole system. System uses the SAP development environment, using MVC
design pattern, the prospects of using ALV to report to display, background database
using Oracle, to achieve the six functional modules. By system testing, the system
runs well,part of state compensation data has been on the flat line.
Abstract
In the system operation, the system is pre- exposed defects,such as an
organization unit security check is not stringent enough,the redundant data
transmission system operating efficiency resulting in the need to further optimize later
work
Keywords: Pay Ledger; ERP; SAP