CN104239558A - External Excel data uploading system and method based on SAP system - Google Patents
External Excel data uploading system and method based on SAP system Download PDFInfo
- Publication number
- CN104239558A CN104239558A CN201410501673.5A CN201410501673A CN104239558A CN 104239558 A CN104239558 A CN 104239558A CN 201410501673 A CN201410501673 A CN 201410501673A CN 104239558 A CN104239558 A CN 104239558A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- excel
- database table
- sap
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
- G06F16/2386—Bulk updating operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06312—Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Educational Administration (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an external Excel data uploading system and method based on an SAP system. The external Excel data uploading system comprises a database table management module, a data template generation module, a data filling module, a data detection module and a data uploading module. The method comprises the following steps: a database table for Excel data uploading is newly established in an SAP enterprise information system, the data template generation module generates an Excel data template according to the definition of the database table, then data which needs to be uploaded is entered in the data filling module, the forma, range and missing value of the written-in data are checked, and finally the data is uploaded to the database table. The invention solves the problem that the SAP system does not support self-defined external data import, provides a system and a method for automatic uploading of external Excel data based on the SAP system and guarantees data uploading timeliness, accuracy and consistency.
Description
Technical field
The invention belongs to technical field of computer information processing, be specifically related to a kind of SAP its exterior Excel data upload System and method for.
Background technology
In the world, 500 tops of the world enterprise is all configured with SAP ERP system mostly, the large module of wherein purchasing management, production management, quality management, sales management, financial management, cost management, project management and human resource management nine is all practical for most enterprises, and the performance of these functions of modules needs the support of data undoubtedly.But, the information source that some basic data is not detailed in SAP system, such as: the adjustment of generating process control data, control of the economy performance assessment criteria, enterprise dynamic data, external competitive business data etc. are from the data of outside.So, in daily management and business procession, often to need these external datas by Excel data importing, in SAP system, for integration and the statistical study of data, and then to form complete data acquisition in SAP system.If mode by hand carries out Data Integration, not only the workload of manual disposal data is large, and work efficiency is low, and easily causes data inconsistent, thus brings larger opportunity cost to business administration, even may cause administration and supervision authorities decision error.Therefore develop a kind of data upload system that can solve the problem to be very important.
Summary of the invention
The first object of the present invention is to provide a kind of SAP its exterior Excel data upload system; Second object is the using method providing described SAP its exterior Excel data upload system.
The first object of the present invention be achieved in that comprise database table administration module, data template generation module, data fill in module, data detection module and data upload module, wherein:
Database table administration module: for managing the database table set up in SAP enterprise information system;
Data template generation module: for generating Excel data template according to the data field defined in database table;
Data fill in module: for the corresponding data of typing in Excel data template;
Data detection module: for detecting the misdata in tables of data;
Data upload module: for by the data upload in Excel data template in database table.
The second object of the present invention is achieved in that and comprises the following steps:
A, in SAP enterprise information system the database table of newly-built Excel data upload;
B, data template generation module, according to the definition of database table, generate Excel data template;
C, operating personnel fill in the data write Excel data template will needing to upload in module in data;
D, the data detection module data to write carry out format checking, range check and missing value inspection;
E, wrong data are corrected after, by data upload module by data upload in database table.
The present invention overcomes SAP system and does not support the problem that self-defined external data imports, and provides a kind of System and method for automatically uploaded based on the outside Excel data of SAP system, ensure that the promptness of data upload, accuracy and consistance.Database table administration module maintains the database table set up in SAP enterprise information system, for the support that data template generation module provides Excel data template to generate, after template generation, operating personnel are logging data in a template, this typing mode can adopt the mode of batch processing to carry out, avoid work efficiency hand-manipulated low, the problem that data are recorded by mistake, thus ensure that promptness and the accuracy of data upload.The data of data detection module to write carry out the multiple inspections such as format checking, range check and missing value inspection, ensure that the accuracy of data upload.
Accompanying drawing explanation
Fig. 1 is SAP its exterior Excel data upload system schematic of the present invention;
Fig. 2 is SAP its exterior Excel data upload system flow schematic diagram of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is further illustrated, but limited the present invention never in any form, and any conversion done based on training centre of the present invention or replacement, all belong to protection scope of the present invention.
SAP its exterior Excel data upload system of the present invention, comprises database table administration module, data template generation module, data fills in module, data detection module and data upload module, wherein:
Database table administration module: for managing the database table set up in SAP enterprise information system;
Data template generation module: for generating Excel data template according to the data field defined in database table;
Data fill in module: for the corresponding data of typing in Excel data template;
Data detection module: for detecting the misdata in tables of data;
Data upload module: for by the data upload in Excel data template in database table.
The described management of database table administration module to database table comprises data table name, field name, field name, field type, field size, the management of whether uploading and whether showing.
The described data typing mode of filling in module comprises manual typing and batch processing typing.
The inspection of described data detection module to uploading data comprises format checking, range check and missing value inspection.
The using method of SAP its exterior Excel data upload system of the present invention, comprises the following steps:
A, in SAP enterprise information system the database table of newly-built Excel data upload;
B, data template generation module, according to the definition of database table, generate Excel data template;
C, operating personnel fill in the data write Excel data template will needing to upload in module in data;
D, the data detection module data to write carry out format checking, range check and missing value inspection;
E, wrong data are corrected after, by data upload module by data upload in database table.
SAP its exterior Excel data upload system of the present invention is filled in module 3, data detection module 4 and data upload module 5 formed by SAP enterprise information system, database table administration module 1, data template generation module 2, data.SAP enterprise information system is company ERP system, wherein deposit the data of SAP ERP system, generally comprise the day to day operation data of the 8 large modules such as purchasing management, production management, quality management, sales management, financial management, cost management, project management, human resource management, simultaneously within the system can building database table, for database table administration module 1 provides the environment set up data and store.Database table administration module 1 manages the database table set up in SAP enterprise information system, comprise data table name, tables of data title, field name, field name, field type, field size, whether upload and the item such as whether to show, support for data template generation module 2 provides Excel data template to generate.The data field that data template generation module 2 defines according to database table administration module 1, comprise data table name, tables of data title, field name, field name, field type, field size, whether upload, whether show, automatic production Excel uploading data template, fills in module 3 for data and provides template support.Data fill in module 3 according to the template generated at EXCEL data template generation module 2, fill in logging data in module 3, comprising typing manually and batch processing typing by business personnel in data.The data of data detection module 4 pairs of typings carry out multinomial data check, comprise format checking, range check and missing value inspection etc.Check errorless after, upload to the function completing whole system in SAP enterprise information system.
The using method of SAP its exterior Excel data upload system of the present invention, is used to guide operating personnel and how is imported in SAP system by timely, accurate, consistent for the Excel data of outside.When SAP developer not be used in and has external data to upload demand at every turn, the upload program that exploitation is corresponding, only need set up relevant table in SAP system, generates Excel data upload template, can complete the configuration of Excel data upload system.The method is not only increased work efficiency, and reduces O&M cost, also reduces the memory capacity of data upload form in SAP system server, improves system performance, makes it can be used widely in follow-up informatization.
Feature of the present invention:
1, by the Seamless integration-with SAP system, the external data efficiently realizing operation system demand is fast uploaded.
2, overcome and rely on manual entry merely, data are forbidden, the problem of typing mistake, make the accuracy uploaded and promptness have better guarantee.
3, data detection module can realize the multiple inspection to mass data fast, reduces hand inspection labor capacity, increases work efficiency.
As shown in Figure 2, this figure shows working-flow and realizes disposal route, and concrete methods of realizing is as follows:
1, according to service needed, newdata storehouse is shown;
2, according to the definition of database table, data upload template is generated;
3, typing uploading data in data upload template;
4, data check is carried out to the data of typing;
5, check errorless after, then to upload in database table.
Claims (5)
1. a SAP its exterior Excel data upload system, is characterized in that comprising database table administration module, data template generation module, data fills in module, data detection module and data upload module, wherein:
Database table administration module: for managing the database table set up in SAP enterprise information system;
Data template generation module: for generating Excel data template according to the data field defined in database table;
Data fill in module: for the corresponding data of typing in Excel data template;
Data detection module: for detecting the misdata in tables of data;
Data upload module: for by the data upload in Excel data template in database table.
2. SAP its exterior Excel data upload system according to claim 1, is characterized in that the described management of database table administration module to database table comprises data table name, field name, field name, field type, field size, the management of whether uploading and whether showing.
3. SAP its exterior Excel data upload system according to claim 2, is characterized in that the described data typing mode of filling in module comprises manual typing and batch processing typing.
4. SAP its exterior Excel data upload system according to claim 3, is characterized in that the inspection of described data detection module to uploading data comprises format checking, range check and missing value inspection.
5. a using method for the arbitrary described SAP its exterior Excel data upload system of claim 1 ~ 5, is characterized in that comprising the following steps:
A, in SAP enterprise information system the database table of newly-built Excel data upload;
B, data template generation module, according to the definition of database table, generate Excel data template;
C, operating personnel fill in the data write Excel data template will needing to upload in module in data;
D, the data detection module data to write check;
E, wrong data are corrected after, by data upload module by data upload in database table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410501673.5A CN104239558A (en) | 2014-09-27 | 2014-09-27 | External Excel data uploading system and method based on SAP system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410501673.5A CN104239558A (en) | 2014-09-27 | 2014-09-27 | External Excel data uploading system and method based on SAP system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104239558A true CN104239558A (en) | 2014-12-24 |
Family
ID=52227617
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410501673.5A Pending CN104239558A (en) | 2014-09-27 | 2014-09-27 | External Excel data uploading system and method based on SAP system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104239558A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106484806A (en) * | 2016-09-22 | 2017-03-08 | 广州唯品会信息科技有限公司 | Link up the method and device of data |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN108197192A (en) * | 2017-12-26 | 2018-06-22 | 重庆信联达软件有限公司 | It is used to implement the main data system of inside data of enterprise standardization |
| WO2019071509A1 (en) * | 2017-10-12 | 2019-04-18 | 深圳云集智造系统技术有限公司 | Method for launching erp system, device, terminal and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1629851A (en) * | 2003-12-16 | 2005-06-22 | 上海汽轮机有限公司 | Steam turbine product database management method |
| CN101582028A (en) * | 2009-04-09 | 2009-11-18 | 王剑 | Method for rapidly applying dynamic link library component in SAP system |
| CN102404371A (en) * | 2010-09-17 | 2012-04-04 | 捷达世软件（深圳）有限公司 | Simple object access protocol adapter and method thereof for writing file into third party system |
| CN103984680A (en) * | 2014-06-10 | 2014-08-13 | 北京中电普华信息技术有限公司 | Data maintenance method and system of customization table |
-
2014
- 2014-09-27 CN CN201410501673.5A patent/CN104239558A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1629851A (en) * | 2003-12-16 | 2005-06-22 | 上海汽轮机有限公司 | Steam turbine product database management method |
| CN101582028A (en) * | 2009-04-09 | 2009-11-18 | 王剑 | Method for rapidly applying dynamic link library component in SAP system |
| CN102404371A (en) * | 2010-09-17 | 2012-04-04 | 捷达世软件（深圳）有限公司 | Simple object access protocol adapter and method thereof for writing file into third party system |
| CN103984680A (en) * | 2014-06-10 | 2014-08-13 | 北京中电普华信息技术有限公司 | Data maintenance method and system of customization table |
Non-Patent Citations (1)
| Title |
|---|
| 心|悦_蜗牛在裸奔: "SAP ABAP编程 excel数据批量上传--用ALV展示", 《HTTP://BLOG.CSDN.NET/QINYUEZHAN/ARTICLE/DETAILS/39002735》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106484806A (en) * | 2016-09-22 | 2017-03-08 | 广州唯品会信息科技有限公司 | Link up the method and device of data |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| WO2019071509A1 (en) * | 2017-10-12 | 2019-04-18 | 深圳云集智造系统技术有限公司 | Method for launching erp system, device, terminal and computer readable storage medium |
| CN108197192A (en) * | 2017-12-26 | 2018-06-22 | 重庆信联达软件有限公司 | It is used to implement the main data system of inside data of enterprise standardization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10127507B2 (en) | Project management system providing interactive issue creation and management | |
| Santos et al. | Use of simulation in the industry 4.0 context: Creation of a Digital Twin to optimise decision making on non-automated process | |
| US20180012145A1 (en) | Machine learning based analytics platform | |
| CN104036025A (en) | Distribution-base mass log collection system | |
| CN106611246A (en) | Integrated management system of land and resources | |
| US10510044B2 (en) | Project management system providing digital form-based inspections in the field | |
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| US10303690B1 (en) | Automated identification and classification of critical data elements | |
| US11593322B1 (en) | Collaborative data mapping system | |
| US9396090B2 (en) | System overview diagram generator | |
| CN104239558A (en) | External Excel data uploading system and method based on SAP system | |
| CN104216961A (en) | Method and device for data processing | |
| Lee et al. | NESIS: a neutral schema for a web-based simulation model exchange service across heterogeneous simulation software | |
| CN107590749A (en) | A kind of processing method and system with electricity consumption data | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN105354376A (en) | Method and system for interaction between BIM based multi-dimensional data and OA database | |
| Love et al. | Assessing the impact of RFIs in electrical and instrumentation engineering contracts | |
| Ding et al. | Analysis of a building collaborative platform for Industry 4.0 based on Building Information Modelling technology | |
| Son et al. | Product data quality validation system for product development processes in high-tech industry | |
| Wang et al. | [Retracted] ERP System Design for Hydrogen Equipment Manufacturing Industry Based on Low Code Technology | |
| CN103258047A (en) | Data organization method of data warehouse for controlling operation cost of medicine enterprise | |
| WO2017115341A1 (en) | Method and system for utility management | |
| Oudjehane et al. | Big data in construction projects: Risk and opportunity management | |
| Svensson et al. | Improving data quality in witsml data | |
| Zhou | Integration and Optimization of O2O System for College Art Guiding Plartform Implementation based on Spring Cloud Framework |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20141224 |
|
| RJ01 | Rejection of invention patent application after publication |