Journal of Korea Society of Industrial Information Systems (한국산업정보학회논문지)

Korea Society of Industrial Information Systems (한국산업정보학회)
권호 표지
DOI QR코드

DOI QR Code

SAP R/3 System Interface Technologies Analysis and VBA Applied Data Input Proposal

SAP R/3 시스템 인터페이스 기술분석과 VBA 활용 데이터 입력 제안

  • 김영렬 (충북대학교 경영정보학과) ;
  • 강태구 (충북대학교 경영정보학과) ;
  • 이은범 (충북대학교 비즈니스융합학과)
  • Received : 2016.01.21
  • Accepted : 2016.04.26
  • Published : 2016.04.30
Download PDF
⟨ Previous Next ⟩

Abstract

Many companies have attempted to strengthen competitiveness by introducing information technology ERP system in a changing and global competitive business environment. However, ERP systems can not meet all the requirements that occur in the enterprise. After the system introduced, When it operates with existing systems or with new systems, the need for strong interface technology along with the appearance of the ERP have been gradually increased. In this paper, we selected SAP R/3 system as a typical ERP system. Among the modules of SAP R/3, MM module was chosen. Interface technologies for SAP R/3 Systems integrate mulltiple R/3 systems and non R/3 systems, and play important roles in expanding the company's business process. VBA approach was implemented as the data interface design between SAP R/3 and other systems. It proved to reduce the feeling of resistance from user's point of view. It also proved to improve the operational efficiency in a convenient input and output manner of purchase request data.

많은 기업들은 경영 환경의 변화와 글로벌 경쟁 속에서 경영관리의 필수요소로 자리 잡은 ERP 시스템을 도입하여 경쟁력을 강화하고 있다. 그러나 하나의 ERP 시스템만으로 기업에서 발생하는 모든 요구 사항을 만족시킬 수 없기에 시스템 도입 후에도 기존 시스템을 결합하여 운용하거나 새로운 시스템을 도입하기도 하며 각 기업의 ERP 시스템들이 연결, 통합되기도 한다. 이와 같은 이유로 ERP 출현과 함께 보다 강력하고 편리한 인터페이스 기술에 대한 필요성이 점차 증가해왔다. 본 연구에서는 ERP 시스템 중 기업들이 가장 많이 사용하는 SAP R/3 시스템을 채택하였고, SAP R/3의 여러 모듈 중 MM 모듈을 선택하여, MM 모듈 내의 구매요청 데이터의 입력과 처리를 위해 R/3 시스템에서 제공하고 있는 인터페이스 기술과 함께 새로이 VBA 기술을 사용하여 SAP R/3 시스템의 새로운 데이터 인터페이스를 설계 및 구현 방안을 제시하였다. 이 방안의 장점은 사용자 관점에서 시스템 사용에 대한 거부감을 줄일 수 있으며 보다 편리한 구매요청 데이터 입력과 출력으로 업무 효율성을 높일 수 있는 것으로 나타났다.

Keywords

References

  1. Yeong Real Kim, "A New Effective SAP ERP Education Approach Through The Development of Educational Virtual Company", Korea Society of Industrial Information Systems, Vol. 16, No. 1, pp. 49-58, 2011.
  2. Myeonggil Choi, Kijoo Kim, WonJoo Hwang, ByungGyu Kim, "A study on the quality of ERP system arrecting sarisfaction and job performance", Korea Society of Industrial Information Systems, Vol. 16, No. 3, pp 89-90, 2011. https://doi.org/10.9723/jksiis.2011.16.3.089
  3. Tae Su Kang, "Reporting framework based on SQL using dynamic code generation techniques in SAP R/3 system", Graduate School Sogang University of Information & Technology Master's thesis, 2011.
  4. Jin Seo Park, Yeong Real Kim, "JIT (Just-In-Time) Process Implementation with SAP R/3 System", Proceedings of the Korea Society for Industrial Information Systems Conference, Vol. 19, pp. 160-163, 2009.
  5. Hown Sug Cho, Jung Hwa Hong, Hee Kyung Yu, "A Study on the Recognition Level Analysis of Accountant General's ERP System Account Module Composition", Korea Accountin Information Association, Vol. 25, No. 1, pp. 269-294, 2007.
  6. SAP, "Empowering Finance for E-Business", 2001.
  7. Seok Hee Han, Sang Beon Han, "A Case Study of System Interface between Digital Manufacturing and ERP for Manufacturing Engineer's Business Productivity Improvement", The Korean Society of Automotive Engineers 30th anniversary Conference, pp. 1386-1398, 2008.
  8. Gartner Research Report, "Application Integration and Web Services : Proven Guidelines for Effective Integration", 2005.
  9. Doh Wan Kim, "Research on systems development of SAP ERP Integration with Existing Legacy Systems to replace XI", Graduate School ULSAN UNI. SCHOOL of Industry Master's thesis, 2014.
  10. Danielle Larocca, "Sams Teach Yourself Sap R/3 in 24 Hours: In 24 Hours", Sams Publishing, 1999.
  11. Eun Ju Go, "(A) Study on Implementation of an Integration system between SCM and ERP system under make-to-order Production Environment : Advanced Planning and Scheduling system of Chemical Industry", Graduate School EWHA WOMANS UNI. SCHOOL OF BUSINESS Master's thesis, 2001.
  12. Arvind Nagpal, John Pitlak, "ALE, EDI & IDoc Technologies for SAP", Prima Tech, 2001.
  13. Yeong Sik Seo, "A Design and Implementation of a Data Interface between two systems for the Financial Information Using the ALE(Application Link and Enabling) on SAP R/3 System", Graduate School Sogang University of Information & Technology Master's thesis, 2003.
  14. Yeon Mi Kim, "A Study on Implementation of Interface between ERP and Non-ERP", Graduate School EWHA WOMANS UNI. SCHOOL OF Information Science Master's thesis, 1998.
  15. Yeong Real Kim, Tae Gu Kang, Jin Seo Park, "SAP R/3 MM Module utilizes ERP procurement management system", Bumhan Book Corp, 2014.