124
VADYBA / MANAGEMENT. 2006 m. Nr. 1(10)
ERP AND EDI SYSTEM AS TOOLS FOR INTEGRATED LOGISTICAL MANAGEMENT SUPPORT
Vladimra Vl kov
This paper deals with problem of the Enterprise Resource Planning (ERP) systems and the Electronic Data Interchange with emphasis on requirements of Logistic Information Systems (LIS). Current ERP systems can be utilised not only for the integration of in-house activities, but also in connection with the Internet it can serve as managerial superstructure for Management Information Systems (MIS), Supply Chain Management (SCM) and Customer Relationship Management (CRM) in the form of extended ERP modules. The most frequently implemented system, SAP R/3, is introduced here, and its structure, advantages and conditions for successful implementation are discussed. The Electronic Data Interchange (EDI) system helps to manage the logistics, as it allows interconnection and integration of the business applications (EAI Enterprise Application Integration). Contributions and possible threats and their elimination in the Czech environment are emphasized, as well as ways to exploit the benefits of the EDI systems. Main requirements for ensuring success of the IS/IT project are summarised. Key words: enterprise resource planning system, electronic data interchange, logistic information systems, supply chain management, customer relationship management.
Introduction
The position of business logistics has changed radically since 1950s of the 20th century, when it started to struggle in economic field. Its task in contemporary ideas on logistics is to optimise integrated logistics systems in their complex. Company, which wants to be successful in present environment of information society and electronic business, needs to have integrated not only all internal processes but also external processes such as, for example, relations with suppliers, with customers, with state administration bodies, etc. This would not be possible to ensure without support and development of information technologies (IT) and information systems (IS), which are considered to be key factors, which allow the growth and development of logistics [1]. Issues from our own investigation of conditions for implementation of logistics into companies in the chemical industry in the Czech Republic, however, repeatedly showed that in many of them high quality information systems were missing. Their disunity, low data cohesion and non-uniform form cause many problems. The company IS supports logistics management only in one third of surveyed companies. One quarter of respondents stated that their IS either does not provide such kind of support or they are not able to judge it [2-4]. IS in these companies sub-serve a mainly only informative and controlling function. The respondents alone considered implementation of new IS as just the second most important possibilities how to enforce fiercely logistics management in contemporary ideas on logistics, immediately next to communication between individual subdivisions. The creation of understanding of contemporary ideas on logistics was named as the third most important factor [1]. The investigations were carried out in the method of written questioning, completed with personal questioning in 35 companies. Informants answered in total 18 questions concerning implementation of logistics in their companies. The aim of this paper is, therefore, to highlight the problems of IS with stress on their support of logistical management. Information system SAP R/3 of company SAP AG is most frequently implemented and employed within companies in the chemical industry in the Czech Republic. Therefore, we will focus hereafter mainly on this system.
Basic requirements on Logistic Information System LIS
Contemporary company is always a component part of social distribution of labour with relations to other social economic systems on the base of partner collaboration. It deals with linkages to suppliers of material items and services, providers of finance capital and know-how, subscribers of products or services, linkages to social surroundings, and nature. The significance of outside surroundings of the company, thus, significantly increased in comparison with the past for important linkages to banking institutions, stock markets, state administration bodies, local government, auditing bodies, assurance companies, and public juridical authorities such as health and social insurance companies. Importance of relations with abroad has grown inprecedently too. The changes in the surroundings have become unpredictable. Company must, therefore, more intensively react to these changes. The reaction can be only short-period, uniphase, and temporary. An alternative possibility is the long-term operation through implementation of IS into the companies. It does not deal, however, with the changes in technology only but it means functional adjusting,
VADYBA / MANAGEMENT. 2006 m. Nr. 1(10)
125
changes in the structure of the company and its processes, interference into company culture, etc. In this context new concepts come up for such as kinetic corporation, fractal enterprise or virtual company [5]. Processes, which take place in separate links in logistic chains, represent the transformation of the customers orders into supplies to customer, which are subsequently realised through logistic functions. The typical cycle of the purchase order consist of the following stages [1]: preparation and handover of the purchase order, acceptance of the purchase order and its entering into the system, order fulfilment, preparation/assembling of the order and packaging, transmission of the ordered goods and receipt of goods at customer side. Simultaneously, source information is transformed into outgoing information according to the scheme in Fig. 1. This transformation must be ensured by a suitable information system [6].
INPUT INFORMATION
Demands data Certified and anticipated orders present demand development Actual stock level of Products, intermediates, raw materials, packings Others data for management of material flux Kapacity standards, bills of materials, technologic processes, lists of worshops, manpower, plan of revisions
TRANSFORMATION
TARGET INFORMATION
Statement of customers requirements Prediction of demand for next period Logistic plan Statement about actual stock level within logistic chain
Fig. 1. Input and output information [6]
Many of these activities are already fully automated in modern systems. It is already fully common at present days to give purchase order in electronic way, for example, from terminals located at purchasers, from which the information are transferred through telephone line or directly by interconnection between computers of supplier and customer, such as EDI are, for example. Exactly purchase orders entries and their fillings are regions where computer technology and information technology brought the biggest contributions from all components of logistics. These contributions come through Table 1 [1]. In general, the function of information system is to supply information in a suitable form, in corresponding scope, in the required time, at a needed place, i.e. to get, to process and to store information for the needs of management system [6]. For the needs of logistic management it means to keep at a disposal such IS, which will supply the data and algorithms needed for effective administration of all mass fluxes and with them conjugated information fluxes and logistic costs. Simply the point is that the fluxes of information must be faster than mass fluxes within supply chains, thus, allowing accessibility of the actual information that is essential for application of modern methods of purchase, production and distribution of goods. Technical and intermediate instruments, equipments and people, all serving the stated purpose, form elements of LIS. Information flows mediated by data carriers serve as linking. LIS should supply information about requirements and expectations of the customer as well as inform the customer about the point where the expected supply occurs just now, as well as about essential surroundings of the logistic system. Here belongs important information about availability and costs of inputs, safety rules, legislative limitations, etc. Both spheres of information must be structured in this way so that they
126
VADYBA / MANAGEMENT. 2006 m. Nr. 1(10)
cover the needs of operational, tactical and strategic level of a logistic system. Logisticians must be able to determine what kind of logistic services will be required, where the bottlenecks are, how to dispatch them and how large the associate costs will be. Only then they can influence productive contents and production scheduling, to harmonize supplies, production and distribution processes with ordering processes. A particularly important principle is also information sharing between partner chain links. They must, therefore, keep at their disposal both enterprise and interfirm information systems. Decision about selection, implementation and continuing innovation of a suitable information system, must be, therefore, an integral part of business strategy of the company. Information system must come out from customers needs and must support logistical management not only within the company but also within the whole supply chain. Integration of internal processes is provided by Enterprise Resource Planning System (ERP), which is gradually substituted by E-business Management (EBM) system for control of electronic business. ERP slowly becomes an integral part of EBM. Contemporary IS/IT is characterised by distributed setting (central, branch, partners). Software applications at different platforms and different operating systems are implemented in this setting. Majority of contemporary organisations can be characterised at side of personal computers by Windows platform, by various server systems (IBM, Compaq, Sun, HP, etc.) and by various protocols (most frequently by TCP/IP). The ability to transfer mutually needful information is fundamental prerequisite for integration of applications, which works at various platforms and which are using various data models, formats and communications protocols and which are applied in various companies. Electronic Data Interchange (EDI) is used already many years for integration of ERP applications.
2. ERP systems with emphasis on SCM
Enterprise Resource Planning System (ERP) is already more than 10-year phenomenon of business applications and of IS/IT at all. Its dynamical development gives among others the evidence the fact that presently we can speak already about five generations of business applications, which take a portrait about functional trends, in which broadening of offer in direction to customers is dominant, as well as about technological trends heading to independent and portable solution [5]. Contemporary ERP systems present very extensive program product, which integrates all important business activities. Their main functional fields are production, logistics, further finance, and support of human resources. ERP system is, therefore, characterised as complex software package, which allows controlling suitably and efficiently business resources. There are three most important management methods in contemporary ERP solutions: Just in Time (JIT), Material Resource Planning (MRP II) and Theory of Constraints (TOC). These methods differentiate themselves by their principles and fields of possible employment. For example, JIT is profitable solution mainly for production in series, or line organized production. MRP II is applicable in both, mass and job-order manufacture. From them TOC is the youngest and simultaneously most dynamically booming method. The fact that this method extends such applications as Supply Chain Management (SCM) and Advanced Planning System (APS) is the reason of TOCs self-assertion. These methods help better exploitation of machines and equipments as well as to optimisation of supply chains [5]. Substantial difference between these methods is in their approach to logistic flow of sequential filling of customers requirements during their realization: JIT method is typical representative of pull system, MRPII method is denoted to be push system and TOC method presents combination of both, where the divider line between pull and push forms socalled bottleneck, i.e. capacity limitation. Ability to automate and integrate basic business processes, share corporate data and processed them intra-plant and create and make accessible information in real time are main features of ERP. Very common mistake is that business information system is usually reduced to ERP concept. ERP creates the core of information system within the company. ERP endeavours to consolidate various spheres of actions and functions across the whole company (organization, institution) as far as to particular program tasks, which serve to various needs of organization divisions of the company. All divisions have their own system of work, they use optimized program for their specific activity and ERP connects their work together. Integrated software works with databases in such way, that different divisions or departments can more easily share information and mutually communicate. IS is gradually propagated recently due to possibility to exploitation of Internet, which has became the tool for extension of ERP systems. Main directions of extension of ERP are mainly in following fields: SCM (Supply Chain Management), CRM (Customer Relationship Management) and MIS (Management Information System). Their interrelationship is illustrated in Fig. 2 as extended ERP system [5]. Components for realisation
VADYBA / MANAGEMENT. 2006 m. Nr. 1(10)
127
of e-commerce such as B2B (Business to Business), B2C (Business to Customer) and e-procurement are becoming the part of integrated solution within the company of ERP type.
MIS SCM ERP CRM
Fig. 2. Extended ERP model of business information system [5]
The offer of ERP solutions is quite extensive on the Czech market. Basl [5] reports that there is altogether 21 Czech and 19 foreign systems available on the market. The most important foreign systems are Bean ERP, One World, Oracle E-business suite and SAP R/3. As we already stated in the introduction part, the product SAP R/3 is from this broad offer the most frequently applied product for ERP solution in studied companies in the Czech Republic however usually without module for logistics [2].
2.1. Introduction of company SAP AG and its product SAP R/3
The abbreviation SAP means Systeme, Andwendungen, and Produkte in Der Datenverarbeitung, which when translated into English means Systems, Applications, Products in Data Processing. Company SAP AG was established in Germany in 1972. This company became the biggest company round the world in the IS category during its thirty years existence. There are branch offices in more than 50 countries in four continents. SAP AG has more than 27,000 employees around the world and last year its pay-off exceeded 7,514 milliard and net income 1,311 milliard . This company provides its business software to more than 26,150 customers. There are currently all together worldwide 88,700 installations in 120 countries with more than 12 million users [7]. In the German market SAP AG introduced the product SAP R/2, which was meant for mainframes only, in 1979. It was the first all-integrating business system and was immediately successful. SAP R/2 spread abroad into the rest of Europe within 1980s. Its architecture of the type client/server became so popular at the end of 1980s years that SAP AG started to develop product SAP R/3, which was introduced on market in 1992. Nowadays SAP R/3 is accessible in 28 language mutations and in 25 professionally specific versions. The heart of SAP R/3 is formed by approximately 10 000 database tables, which control the conditions of starting the processes. Configuration is the process of adjusting of these tables to get SAP to run the way the company wants like. There is no general solving for a specific sector. Solutions are realized on the comprehensive knowledge of the processes in order for there to be the possibility to give better strategic decision, which is based on reliable information. These solutions allow closer interaction with customers and raise the productivity of the company. Presently SAP AG offers following solutions for different branches of industry as well as services [7]: Automotive industry, Banking sector, Pharmaceutical industry, High Tech (Business processes for producers of electro technical facilities), Metallurgy, Chemical industry, Aeronautics & Defence, Media, Defence & Home security, Vocational services, Petrochemical industry, Insurance, Providers of logistics services, Providers of services, Postal services, Consumer goods industry, Industrial machinery & Components, Natural sciences, Retail, Engineering & building industry, Telecommunication, University & research, Utility, Wholesale distribution, Public sector, Health service, Processing industry and Railway.
2.2. Structure of SAP R/3
SAP R/3 is a client/server application using a three-level model (presentation, application and database level). Client/server is standard model for network applications. The program is activated at one computer server, which is waiting until some requirement arrives. One user starts up at some other computer the client (for example client application SAP R/3, browser of www, etc.). Client then contacts the server, requires from it some service and after that it sets up working environment for user. Presentation level or client communicates with the user. Business logic is stored in the application level and database level records and saves all data of the system including transaction and configuration data. There is altogether following twelve application modules, which are from the managers viewpoint the heart of SAP R/3 system:
128 FI - Financial Accounting, CO - Controlling, AM - Asset Management, PS - Project system, WF- Workflow, IS - Industry Solutions, HR - Human Resources, PM - Plant Maintenance, MM - Materials Management, QM - Quality Management, PP - Production Planning and SD - Sales and Distribution. Their interrelationship is illustrated in Fig. 3.
VADYBA / MANAGEMENT. 2006 m. Nr. 1(10)
SD
MM
FI CO
PP
R/3
PM
AM
QM
Client / Server ABAP/4
HR IS
PS WF
Fig.3. SAP R3 Architecture [7]
At present SAP AG shies away from a description of their systems as a collection of modules. They use in connection with the new product the term solutions, which are structured with regard to changes in management in direction to customer response management as follows: