CN109242550A - A kind of steel process cost forecasting system - Google Patents
A kind of steel process cost forecasting system Download PDFInfo
- Publication number
- CN109242550A CN109242550A CN201810954107.8A CN201810954107A CN109242550A CN 109242550 A CN109242550 A CN 109242550A CN 201810954107 A CN201810954107 A CN 201810954107A CN 109242550 A CN109242550 A CN 109242550A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- version
- prediction
- data processing
- 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.)
- Granted
Links
Classifications
-
- 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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
Abstract
The invention discloses a kind of steel process cost forecasting systems, it is related to steel industry cost accounting technical field, the system comprises: data processing module, the data processing module sends prediction data by the way of CUBE, and the data processing module provides Row control table；Prediction data recording module, the prediction data recording module and the data processing module communicate to connect, and the prediction data recording module receives the prediction data, and carries out input interface design and data processing logical definition to the prediction data according to CUBE；Process control module, the process control module are communicated to connect with the data processing module, the prediction data recording module respectively, and the process control module carries out the control of node editing mode by the Row control table.Reduction artificial treatment is reached, has reduced person works' amount, improve the technical effect of working efficiency.
Description
Technical field
The present invention relates to steel industry cost accounting technical field, in particular to a kind of steel process cost forecasting system.
Background technique
Cost budgeting is the core component of production and operation budget, refers to company according to the specific production of budget phase and warp
The predetermined costs that battalion's situation is worked out, is the pre-event management of cost, is the important component of company's Production&Operations Management.
But present inventor during inventive technique scheme, has found above-mentioned technology extremely in realizing the embodiment of the present application
It has the following technical problems less:
In the prior art, cost accounting mainly pass through user on cost convolution method fall back on by hand processing realize, be related to
System is numerous, there is the problems such as processing logic is complicated, the labor intensive time is long, timeliness is poor by hand.
Summary of the invention
The present invention provides a kind of steel process cost forecasting systems, solve cost accounting in the prior art and are related to system
It is numerous, there is processing logic complexity, labor intensive time length, the technical problem of timeliness difference by hand, has reached the artificial place of reduction
Reason reduces person works' amount, improves the technical effect of working efficiency.
The present invention provides a kind of steel process cost forecasting system, the system comprises: data processing module, the number
Prediction data is sent by the way of CUBE according to processing module, and the data processing module provides Row control table；Predict number
According to recording module, the prediction data recording module and the data processing module are communicated to connect, and, the prediction data typing
Module receives the prediction data, and fixed to prediction data progress input interface design and data process method according to CUBE
Justice；Process control module, the process control module are logical with the data processing module, the prediction data recording module respectively
Letter connection, the process control module carry out the control of node editing mode by the Row control table.
Preferably, the process control module controls interface data inputting, wherein the interface data include current
Monthly plan logging data, current moon craft real time data, measuring and calculating process sub-interface data.
Preferably, the process control module uses the website JSP programming framework WEB, and passes through RFC function, reading writing information
The background state table in library, and web page contents are controlled.
Preferably, the prediction data recording module specifically includes: creating unit, and the creating unit is for creating cost
Calculate version, by selection time and version number, carries out version creation, and edition data and current real-time data one after creation
It causes；Unit is deleted, it is described to delete unit according to predicted time and version number to the version progress delete operation created；Management is single
Member is submitted when data and mistake occurs, and the data can not be changed, and be cancelled by the administrative unit to the data；
Wherein, the creating unit realizes version creation using BPS standard copy function；The deletion unit is deleted using BPS standard
Function realizes that version is deleted；The administrative unit deletes function using BPS standard copy function and BPS standard and exit function is real
Existing version is recalled.
Preferably, the node editing mode includes that 0 state and 1 state look into data when node state is 0
It sees and edits；When node state is 1, data are checked.
Preferably, the prediction data recording module is by the business datum of user's typing and node state write back data to institute
State data processing module.
Preferably, according to SAP ERP, MES three-level system, manpower system, feeding system, manual batch derivative according to described in acquisition
Prediction data, wherein the write-back function of the data processing module data is realized using the standard feature of SAP BPS.
Preferably, user checks forecasting of cost report based on the mode of SAP Bex book.
Said one or multiple technical solutions in the embodiment of the present invention at least have following one or more technology effects
Fruit:
1, in a kind of steel process cost forecasting system provided in an embodiment of the present invention, the system comprises: data processing
Module, the data processing module sends prediction data by the way of CUBE, and the data processing module provides process control
Tabulation；Prediction data recording module, the prediction data recording module and the data processing module communicate to connect, and, it is described
Prediction data recording module receives the prediction data, and carries out input interface to the prediction data according to CUBE and design sum number
According to processing logical definition；Process control module, the process control module respectively with the data processing module, the prediction number
It is communicated to connect according to recording module, the process control module carries out the control of node editing mode by the Row control table.Solution
It is numerous that cost accounting in the prior art of having determined is related to system, there is by hand that processing logic is complicated, the labor intensive time is long, timeliness
The technical problem of difference has reached reduction artificial treatment, reduces person works' amount, improves the technical effect of working efficiency.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
Fig. 1 is a kind of structural schematic diagram of steel process cost forecasting system in the embodiment of the present invention；
Fig. 2 is a kind of method logical schematic of steel process cost forecasting system in the embodiment of the present invention.
Specific embodiment
The embodiment of the invention provides a kind of steel process cost forecasting systems, to solve cost accounting in the prior art
It is related to that system is numerous, there is by hand that processing logic is complicated, the labor intensive time is long, timeliness difference technical problem.
Technical solution in the embodiment of the present invention, general thought are as follows:
A kind of steel process cost forecasting system provided in an embodiment of the present invention, the system comprises: data processing module,
The data processing module sends prediction data by the way of CUBE, and the data processing module provides Row control table；
Prediction data recording module, the prediction data recording module and the data processing module communicate to connect, and, the prediction number
The prediction data is received according to recording module, and input interface design and data processing are carried out to the prediction data according to CUBE
Logical definition；Process control module, the process control module respectively with the data processing module, the prediction data typing
Module communication connection, the process control module carry out the control of node editing mode by the Row control table.Reach and has subtracted
Few artificial treatment reduces person works' amount, improves the technical effect of working efficiency.
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
Embodiment one
Fig. 1 is a kind of structural schematic diagram of steel process cost forecasting system in the embodiment of the present invention.As shown in Figure 1, institute
The system of stating includes:
Data processing module 1, the data processing module 1 send prediction data, and the data by the way of CUBE
Processing module 1 provides Row control table；
Further, according to SAP ERP, MES three-level system, manpower system, feeding system, manual batch derivative according to acquisition institute
State prediction data, wherein the write-back function of the data processing module data is realized using the standard feature of SAP BPS.
Further, user checks forecasting of cost report based on the mode of SAP Bex book.
Specifically, the system is divided into two large divisions, totally three modules.Two parts refer to foreground and backstage two parts,
Foreground is that user uses interface, is from the background support operational model.Foreground partition includes two modules: the i.e. described measuring and calculating Row control
Module 3 and the prediction data recording module 2.Back partition includes a module: being the data processing module 1.It is described
Data processing module 1 mainly comes the parts such as source model, operational model and calculation of measured data results model including calculation of measured data, contains
Main back partition is covered.The data processing module 1 sends prediction data by the way of CUBE, wherein CUBE is
The abbreviation of InfoCube (information cube), and data are stored on CUBE, pass through the remittance defined on the data processing module 1
Summer condition and filter condition, access data and are calculated.And the data processing module 1 provides Row control table, this at
This forecasting system includes the forecasting of cost of 22 procedures in total, can be adjusted in each process with manual setting this procedure forecast cost
The real-time cost of all downstream processes will be had an impact after whole.It can analyze in 21 (not including crude fuel) procedures at this item
Three classes: the finished product of upstream process；Basic cost item required for this process；Point of basic cost item needed for this process
Class.It is designed as being stored by unified Information Provider for the basic cost item in all process steps, the Information Provider pair
21 procedures comprising crude fuel provide basic cost item data.Wherein needed and relevant object in each procedure at this item
Item number, account of finance carry out mapping matching, are fetched, are kept away using the dynamic that the configuration information is implemented as this item in system data flow
The shortcomings that exempting from code HARDCODE, it is therefore desirable to create relevant configuration information table in systems and realize the function.The system
Data source include SAP ERP, MES three-level system, manpower system, feeding system, manual batch derivative according to etc., wherein big portion
Data in divided data source be already present on before data model in, therefore the system data center include before
The data model that the related service modular model and this subsystem of creation need to create.The system data write-back function design makes
It is realized with the standard feature of SAP BPS.SAP BPS provides the function of checking, modify data based on WEB.End user makes
Check that the report exhibition of complex format had both may be implemented in forecasting of cost report, BW book with the mode based on SAP Bex book
It is existing, also facilitate reporting and counting for related statements.
Prediction data recording module 2, the prediction data recording module 2 are communicated to connect with the data processing module 1,
And the prediction data recording module 3 receives the prediction data, and carries out input interface to the prediction data according to CUBE
Design and data processing logical definition；
Further, the prediction data recording module 2 specifically includes: creating unit, and the creating unit is for creating
Cost accounting version carries out version creation by selection time and version number, and edition data and current number in real time after creation
According to consistent；Unit is deleted, it is described to delete unit according to predicted time and version number to the version progress delete operation created；Pipe
Unit is managed, is submitted when data and mistake occurs, and the data can not be changed, and be removed by the administrative unit to the data
Pin；Wherein, the creating unit realizes version creation using BPS standard copy function；The deletion unit is deleted using BPS standard
Except function realizes that version is deleted；The administrative unit deletes function and exit function using BPS standard copy function and BPS standard
Realize that version is recalled.
Specifically, the prediction data recording module 2 is realized using BPS function, be mainly responsible for data inputting interface and
The realization of correlation function and related statements exposition, the prediction data recording module 2 specifically include: creating unit, pipe
Unit is managed, unit is deleted, specifically, the creating unit is created for cost accounting version, passes through selection calendar years months and version
This number, version is created, the edition data after creation is consistent with current real-time data, and no longer automatically updates, and every month allows
At most create five versions.Version manager can be in this interface selection prediction days and version number, version number up to 5, i.e.,
Version 001,002,003,004,005 carries out predicted version creation operation；The deletion unit is for deleting version, support pair
The version created carries out delete operation, and version manager can select prediction days and version number to carry out prediction version at this interface
This delete operation；The administrative unit is recalled and save value for version, if certain procedure maloperation submit one edition it is wrong
Data, but it has been in not modifiable state, administrator can be notified to carry out version and recall as remedial measure.Administrator logs in
Afterwards, it can choose some specific process, carry out recalling version operation and necessary save value behaviour after confirming its days and version
Make.After version is recalled, subsequent any process is made an amendment and can be all reset, and the mode of operation of subsequent any process also will resetting
To untreated or processing status.This design scheme enhances the flexibility of system.It should be noted that: if administrator recalls
To a certain procedure (operating successfully), any process of postorder all must be modified and be saved in order again and submit.Create version
Realized using BPS standard copy function, replicate " 000 version/00 state " data, creation " 001 version/10 state " data；It deletes
Function is deleted using BPS standard except version to realize, deletes all data for choosing version.It recalls version and uses BPS standard replicated
Function+BPS standard is deleted function+exit function and is realized, is retracted into specified days, designating step, and by other associated works
The mode of operation of sequence does corresponding change by ABAP.Dimension involved in crude fuel price portion and index arrange as follows: dimension:
Material, calendar years months, calendar year, BPS process (YR0), BPS data inputting state (000), BPS version (000), the combustion of BPS original
Material classification indicators: last month quantity in stock, inventory's valence last month, of that month planning price, of that month order volume, of that month estimated amount of reach, this month disappears
Consumption, of that month procurement price, consumption price, quantity in stock, inventory's valence.Support saves data in data inputting, saves
The data Pending The Entry Into Force of state is supported to submit to having saved data, and data come into force after submission.According to business needs, crude fuel
The data that prediction module generates are submitted the basic data as forecasting of cost module in crude fuel prediction module data
When, data can be filled into automatically to the CUBE's of postorder forecasting of cost module by manual withdrawal data by process chain or user
Corresponding data position.Modify node data state table, the data mode of this node is changed to it is processed, meanwhile, allow later process
Submit data.Data are submitted to be realized using BPS standard replicated/deletion function, deletes " 000 version/010 state " data, creation
" 001 version/020 state " data, forecasting of cost module initialization function is by calling the process chain of BW to realize that data mode is more
Newly realized by carrying out ABAP enhancing to submitting button.The forecasting of cost table sample of downstream process is shown in each process logic table sample, involved
And dimension and index it is as follows: dimension: at current row system, calendar years months, calendar year, BPS process, BPS data inputting state
(000), BPS version (000), display, BPS cost classification, BPS process level index: last month, actually unit price, last month were practical single
Consumption, last month it is practical single at, of that month planned unit price, when monthly plan unit consumption, when monthly plan list at, unit price, real-time unit consumption, in real time in real time
Dan Cheng, real-time wastage in bulk or weight, real-time totle drilling cost, prediction unit consumption, prediction it is single at, prediction wastage in bulk or weight, prediction totle drilling cost, prediction is than practical
Price difference, prediction is poorer than planned price, prediction is poorer than actual consumption, prediction is poorer than plan consumption, prediction is poorer than actual cost, pre-
Surveying, prediction poorer than planned costs influences than real price difference, predicts to consume difference shadow than plan than the influence of actual consumption difference, prediction
It rings, predict to influence than planned price difference.
To guarantee that process establishment and approval process being normally carried out and record to the data of each flow nodes, in addition to
Meet except dimension required by table sample normal presentation, dimension field relevant to data mode as follows need to be increased: version: being used for
Measuring and calculating version is distinguished, 001 or 002 or 003 or 004 or 005 version is divided into, 000 version is real-time edition data typing state: being used
In the typing state for distinguishing data, system 000 saves as 010, and having been filed on is 020.Further, data, which save, uses BPS
Standard feature realizes that data are submitted to be realized using BPS standard replicated/deletion function, creates " 001 version/010 state ", deletes
" 001 version/10 states " data become " 001 version/020 state " data, and data mode is updated by carrying out to submitting button
ABAP enhancing is realized.
Process control module 3, the process control module 3 are recorded with the data processing module 1, the prediction data respectively
Enter the communication connection of module 2, the process control module 3 carries out the control of node editing mode by the Row control table.
Further, the process control module 3 controls interface data inputting, wherein the interface data include
Current monthly plan logging data, current moon craft real time data, measuring and calculating process sub-interface data.
Further, the process control module 3 uses the website JSP programming framework WEB, and passes through RFC function, read-write letter
The background state table in library is ceased, and web page contents are controlled.
Specifically, the process control module 3 is mainly responsible for system home page login, the control of each process cost accounting process
System.When user logs in the forecasting of cost system login page using web browser, page function includes: that the page is shown currently
Ongoing version, version creation time, last procedure confirm people, last procedure acknowledging time and process are true
Recognize state；One shares 22 procedures, and that had safeguarded cost procedure can be used green background color, and that does not safeguard can be used red
Background color is displayed in blue background color in processing；After the modification of per pass process cost, the knot of each procedure downstream is influenced whether
Fruit, the treatment process are calculated automatically by system, wherein crude fuel process needs to manually perform the communicating predicted road Jia Zhixia of process chain
Process.After this procedure, which is modified, to be completed and submit, which becomes green background color, and can not modify, and can only check and work as
The data that preceding version has been filed on.Meanwhile the downstream process of the procedure allows access into modification；It can be shown in homepage recently together
Process cost confirms people and confirmation date, acknowledging time, and mouse is moved to the process for having saved cost, i.e. green area, and meeting exists
Occur process cost confirmation date, acknowledging time and confirmation people below picture.Further, for interface, the boundary
Face function includes the typing of this monthly plan, manual real time data typing, measuring and calculating process sub-interface data manipulation etc..Typing this month meter
Draw: every monthly plan, which issues rear user, can select this monthly plan of certain procedure typing at this interface.Typing this month, counts in real time by hand
According to: user can select certain procedure typing this month craft real time data at this interface.This monthly plan and this month, count in real time by hand
It all can just be allowed to create version in this month after the completion according to typing operation, any one, which is not completed, is not allowed to creation version
This.Sub-interface: sub-interface plays permission control, allows more people function of the typing different data to same interface simultaneously, Yong Huke
To select corresponding sub-interface to carry out relevant operation at this interface in formally calculating pre- flow gauge.Sub-interface does not permit with female interface
Perhaps simultaneously operation data.The 3 core backstage table of process control module is that the two-dimensional state control table of BW (can be made and directly write
DSO form), self-built backstage table.This module technical way is to cooperate RFC letter using one website WEB of JSP programming framework
Number reads and writes BW background state table, and carries out control realization to web page contents.When the corresponding picture frame of the different processes of click either text
Word will jump to the BPS page in a manner of hyperlink, use the same BW user's checking Website login and BW/BPS system from the background
System.
Further, the node editing mode includes that 0 state and 1 state carry out data when node state is 0
It checks and edits；When node state is 1, data are checked.
Further, the prediction data recording module by the business datum of user's typing and node state write back data extremely
The data processing module.
Specifically, data are supplied to and the prediction data by the data processing module 1 in a manner of real-time CUBE
Recording module 2 accesses；The prediction data recording module 2 carries out calculation of measured data input interface design using CUBE as data basis
With data processing logical definition, and the prediction data recording module 2 carries visual page editing machine, and developer can pass through
The mode of addition WEB interface control carries out WEB page design, and control needs binding data processing logical definition part (BPS0) to determine
The plan function of justice.Layout control bundle plans function by hand, for supporting user to carry out data inputting.Button control binding
Data administration program function, for code, the modification process of calling BW process chain to be saved, deleted, executed to logging data
Control table etc..Developer generates BSP Application after visualization interface editing machine carries out WEB interface design,
In, BSP Application is one kind of SAP WEB development scheme, and each BPS Application corresponds to unique chain ground connection
Location, user can be in corporate intranets by directly inputting WEB interface after the completion of network address access design.The data processing module 1
Row control table being provided for 3 end of process control module to control for node editing mode, node is divided into 0 and 1 two states,
When node state is 0, not only data can be carried out to check but also can edit data, when node state is 1, only logarithm
Data can not be edited according to check.The information of node control table is to be updated by BPS, such as user is at some
When node clicks submitting button, Background scheduling ABAP code revision Row control table.The prediction data recording module 2 is to typing
After the completion of interface, unique chained address will be generated to each input interface.3 end of process control module passes through to every
The access to BPS web interface is realized in a node binding chained address.
Embodiment two
A kind of application method of steel process cost forecasting system of the invention is described in detail below, specifically such as
Under:
The system is by giving full play to SAP BW (Business Information Warehouse, commercial matters information storehouse
Library, hereinafter referred to as BW) data upload, report query and BPS (Business Planning and Simulation, business
The write back data function of plan and simulation, hereinafter referred to as BPS) carry out procedure and the standardization of cost of implementation measuring and calculating business, reach
Specification process reduces artificial treatment, the effect of specification report system.As shown in Fig. 2, the system convention of application method includes: pre-
It surveys cost and defaults real-time cost, can modify, and data are shown in report after saving modification；Crude fuel forecast price is used for iron steel
The unit price of spent material, previous process semi-finished product cost are used for the unit price of next procedure；Crude fuel, regenerant, energy medium can
To collect detail item, shown in report every detail cost (energy medium cannot daily access, show total assembly
This)；Equipment material shows total totle drilling cost according to resistance to material, spare part, machine material, the large-scale major class such as Work tool and the easy-consumed goods of low value；
Each process can individually adjust the forecast cost of this procedure, will generate shadow to the real-time cost of all downstream processes after adjustment
It rings.
The calculation formula being related to: crude fuel price expectation part: quantity in stock+this month of material quantity in stock=the end of last month
It is expected that amount of reach (being defaulted as of that month order volume, can adjust)-this monthly consumption (beginning of the month craft typing can adjust)；Ironmaking, steel
Base, steel rolling forecasting of cost: unit price=standard price,Unit cost=unit price * unit consumption, totle drilling cost
The realization of=yield * unit cost, wastage in bulk or weight=product inventory, this system mainly uses MVC (Model View
Controller is model (model)-view (view)-controller (controller)) abbreviation, hereinafter referred to as MVC) frame
Frame is a more classical frame of screen programming and Web wrapper, is separated with a kind of service logic, data, interface display
Service logic is gathered an inside components by method tissue code, interactive at improvement and personalized customization interface and user
Meanwhile it not needing to rewrite service logic.MVC is grown up by unique for mapping traditional input, handling and exporting
Function is in the structure of the graphic user interface of a logic.The system is broadly divided into the realization of three parts: BW, BPS, JSP.
Specifically, SAP BW is one of the integrated component of mySAP business intelligence (BI), be SAP data and non-SAP data acquisition,
Storage, analysis and management provide integrated, the platform towards commercial affairs.The data of this system are mainly stored in the more of BW system
In a model.Since process cost project is more, and the same items of cost have different data sources in different processes, same
Material data source under the items of cost is also different.Therefore, for the scalability of structure, by the items of cost (including female item and
Subitem) carry out coding storage.In DSO (data storage object, hereinafter referred to as DSO) Z9_O03 in the BPS items of cost (each process)
The corresponding cost classification (female item) of configuration, level, cost element, material and access logic, pass through maintenance in (each process classification)
The DSO data control each items of cost of different processes, the access logic of material, and extract the items of cost by the DSO
Classification；BPS (Business Planning and Simulation, business plan and simulation, hereinafter referred to as BPS) BPS is base
It is built in SAP BW, plays write back data function, the modification of WEB checked with data is provided, be based on BW master data and reality
When CUBE (full name InfoCube, information cube, hereinafter referred to as CUBE) build, data are stored on CUBE, by BPS
Definition summarizes condition and filter condition, is accessed and is calculated to data；JSP (Java Server Pages, hereinafter referred to as
JSP)；It is provided in Shoudu Iron and Steel Co capital Tang cost accounting system using the interface JSP and shows the interface BPS hyperlink, passes through color change and use
The functions such as family interaction.JSP exploitation is related to four portion requirements: page layout, shows current state, URL link, and state control (is led to
Cross color).This system in addition to user needs the data such as planning data, manual data of typing, remainder data all using place
Reason chain form automatically updates, such as inventory's valence of crude fuel, planning price, purchasing price, standard price, the cost statement data of other processes
Deng.Automatic updating data is divided into monthly more new data and daily more new data, monthly updates and monthly updates once, daily updates
It realizes according to specified time point and updates daily daily.The data between not homologous ray are not only incorporated in this way, are greatly reduced
The workload handled by hand also achieves human-machine interaction forecasting of cost, i.e., each process business personnel can to part at
Notebook data is modified.Main flow is the initialization of crude fuel price, crude fuel price expectation data inputting, forecasting of cost data
Initialization, forecasting of cost data inputting, forecasting of cost report are checked, carry out the initialization of crude fuel price by process chain daily,
Calculate the cost information of each process automatically by process, each process business personnel can modify to departmental cost data
(carrying out by the sequence such as crude fuel, Iron-smelting, steel making working procedure), system generates the statement of costs of each process, makes for analysis
With.The process that this forecasting of cost relates generally to is divided into four major class: crude fuel, ironmaking, steel-making, steel rolling.Wherein, ironmaking is divided into mine
Choosing, pelletizing, sinter, 4 procedure of molten iron, steel-making are mainly one procedure of steel billet, and steel rolling is divided into hot rolled coil, hot-rolled leveling, heat
Roll crosscutting, cold rolling it is sour roll (one or two is cold), cold rolling acid rolls (three is cold), cold-rolling continuous annealing (one or two is cold), cold-rolling continuous annealing (three is cold), cold rolling cover
Move back (one or two is cold), cold rolling cover annealing (three is cold), cold-rolling galvanization (one or two is cold), cold rolling is tin plating, plate pickling, plate is chill, plate plating
Zinc, plate color coating, tin plate.Forecasting of cost method braiding logic figure is as follows: yield balance method: yield from the back to the front, gradually
Balance；Cost convolution method: the amount of money then, is gradually carried down before.
Said one or multiple technical solutions in the embodiment of the present invention at least have following one or more technology effects
Fruit:
1, in a kind of steel process cost forecasting system provided in an embodiment of the present invention, the system comprises: data processing
Module, the data processing module sends prediction data by the way of CUBE, and the data processing module provides process control
Tabulation；Prediction data recording module, the prediction data recording module and the data processing module communicate to connect, and, it is described
Prediction data recording module receives the prediction data, and carries out input interface to the prediction data according to CUBE and design sum number
According to processing logical definition；Process control module, the process control module respectively with the data processing module, the prediction number
It is communicated to connect according to recording module, the process control module carries out the control of node editing mode by the Row control table.Solution
It is numerous that cost accounting in the prior art of having determined is related to system, there is by hand that processing logic is complicated, the labor intensive time is long, timeliness
The technical problem of difference has reached reduction artificial treatment, reduces person works' amount, improves the technical effect of working efficiency.
Although preferred embodiments of the present invention have been described, it is created once a person skilled in the art knows basic
Property concept, then additional changes and modifications can be made to these embodiments.So it includes excellent that the following claims are intended to be interpreted as
It selects embodiment and falls into all change and modification of the scope of the invention.
Obviously, those skilled in the art can carry out various modification and variations without departing from this hair to the embodiment of the present invention
The spirit and scope of bright embodiment.In this way, if these modifications and variations of the embodiment of the present invention belong to the claims in the present invention
And its within the scope of equivalent technologies, then the present invention is also intended to include these modifications and variations.
Claims (8)
1. a kind of steel process cost forecasting system, which is characterized in that the system comprises:
Data processing module, the data processing module send prediction data, and the data processing mould by the way of CUBE
Block provides Row control table；
Prediction data recording module, the prediction data recording module and the data processing module communicate to connect, and, it is described pre-
Measured data recording module receives the prediction data, and carries out input interface design and data to the prediction data according to CUBE
Handle logical definition；
Process control module, the process control module respectively with the data processing module, the prediction data recording module
Communication connection, the process control module carry out the control of node editing mode by the Row control table.
2. the system as claimed in claim 1, which is characterized in that the process control module controls interface data inputting,
In, the interface data include current monthly plan logging data, current moon craft real time data, measuring and calculating process sub-interface number
According to.
3. the system as claimed in claim 1, which is characterized in that the process control module uses JSP programming framework WEB net
It stands, and by RFC function, the background state table in reading writing information library, and web page contents is controlled.
4. the system as claimed in claim 1, which is characterized in that the prediction data recording module specifically includes:
Creating unit, the creating unit, by selection time and version number, carry out version wound for creating cost accounting version
It builds, and the edition data after creation is consistent with current real-time data；
Unit is deleted, it is described to delete unit according to predicted time and version number to the version progress delete operation created；
Administrative unit is submitted when data and mistake occurs, and the data can not be changed, by the administrative unit to the data
It is cancelled；
Wherein, the creating unit realizes version creation using BPS standard copy function；The deletion unit uses BPS standard
It deletes function and realizes that version is deleted；The administrative unit deletes function using BPS standard copy function and BPS standard and exits function
Version is able to achieve to recall.
5. the system as claimed in claim 1, which is characterized in that the node editing mode includes 0 state and 1 state, works as section
When dotted state is 0, data are checked and are edited；When node state is 1, data are checked.
6. the system as claimed in claim 1, which is characterized in that the prediction data recording module is by the business number of user's typing
According to node state write back data to the data processing module.
7. the system as claimed in claim 1, which is characterized in that according to SAP ERP, MES three-level system, manpower system, feed intake
System, manual batch derivative are according to the acquisition prediction data, wherein the write-back function of the data processing module data uses SAP
The standard feature of BPS is realized.
8. the system as claimed in claim 1, which is characterized in that user checks that cost is pre- based on the mode of SAP Bex book
Observe and predict table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810954107.8A CN109242550B (en) | 2018-08-21 | 2018-08-21 | Steel process cost prediction system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810954107.8A CN109242550B (en) | 2018-08-21 | 2018-08-21 | Steel process cost prediction system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109242550A true CN109242550A (en) | 2019-01-18 |
| CN109242550B CN109242550B (en) | 2021-09-21 |
Family
ID=65071284
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810954107.8A Active CN109242550B (en) | 2018-08-21 | 2018-08-21 | Steel process cost prediction system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109242550B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110428134A (en) * | 2019-06-28 | 2019-11-08 | 唐山钢铁集团有限责任公司 | Iron and steel enterprise's day-rate cost accounting method based on SAP platform |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN201111052Y (en) * | 2007-10-26 | 2008-09-03 | 深圳职业技术学院 | Old motor vehicle identify evaluating apparatus |
| US20100138190A1 (en) * | 2002-12-09 | 2010-06-03 | Verisae, Inc. | Method and system for tracking and reporting emissions |
| CN102109846A (en) * | 2011-03-01 | 2011-06-29 | 南昌弘益科技有限公司 | Intelligent automated control method for traditional Chinese medicine production |
| CN102903063A (en) * | 2012-09-19 | 2013-01-30 | 中国电力科学研究院 | Integral electricity market operation system |
| CN103886419A (en) * | 2014-03-27 | 2014-06-25 | 国家电网公司 | Power grid operation mode planning, checking and analyzing system |
| CN104852992A (en) * | 2015-06-09 | 2015-08-19 | 湖北天盾电子技术有限公司 | On-line intelligent system for safety emergency based on multiple communication networks and sensing equipment |
| CN104951954A (en) * | 2014-03-25 | 2015-09-30 | 上海旭中市场信息咨询有限公司 | FMCG research system |
| CN105045583A (en) * | 2015-07-08 | 2015-11-11 | 哈尔滨工程大学船舶装备科技有限公司 | Visualized process based IETM (Interactive Electronic Technical Manual) fault class data module creation apparatus and creation method therefor |
| CN105094818A (en) * | 2015-07-14 | 2015-11-25 | 国家信息中心 | Construction method and system for comprehensive application of natural resources based on SOA |
| CN105354025A (en) * | 2015-10-18 | 2016-02-24 | 广州赛意信息科技有限公司 | Service model configuration system and method based on mobile application |
| JP2016065275A (en) * | 2014-09-24 | 2016-04-28 | Ｊｆｅスチール株式会社 | State in blast furnace estimation device and state in blast furnace estimation method |
| CN107430613A (en) * | 2015-03-23 | 2017-12-01 | 甲骨文国际公司 | Knowledge-intensive data handling system |
| CN108090823A (en) * | 2017-12-20 | 2018-05-29 | 重庆八戒财云网络科技有限公司 | accounting data management system based on SaaS |
| CN108369700A (en) * | 2015-10-27 | 2018-08-03 | 屯屯·闻 | Mobile-payment system |
| JP6493447B2 (en) * | 2016-08-02 | 2019-04-03 | Ｊｆｅスチール株式会社 | Hot metal temperature prediction method, hot metal temperature prediction device, blast furnace operation method, operation guidance device, hot metal temperature control method, and hot metal temperature control device |
-
2018
- 2018-08-21 CN CN201810954107.8A patent/CN109242550B/en active Active
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100138190A1 (en) * | 2002-12-09 | 2010-06-03 | Verisae, Inc. | Method and system for tracking and reporting emissions |
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN201111052Y (en) * | 2007-10-26 | 2008-09-03 | 深圳职业技术学院 | Old motor vehicle identify evaluating apparatus |
| CN102109846A (en) * | 2011-03-01 | 2011-06-29 | 南昌弘益科技有限公司 | Intelligent automated control method for traditional Chinese medicine production |
| CN102903063A (en) * | 2012-09-19 | 2013-01-30 | 中国电力科学研究院 | Integral electricity market operation system |
| CN104951954A (en) * | 2014-03-25 | 2015-09-30 | 上海旭中市场信息咨询有限公司 | FMCG research system |
| CN103886419A (en) * | 2014-03-27 | 2014-06-25 | 国家电网公司 | Power grid operation mode planning, checking and analyzing system |
| JP2016065275A (en) * | 2014-09-24 | 2016-04-28 | Ｊｆｅスチール株式会社 | State in blast furnace estimation device and state in blast furnace estimation method |
| CN107430613A (en) * | 2015-03-23 | 2017-12-01 | 甲骨文国际公司 | Knowledge-intensive data handling system |
| CN104852992A (en) * | 2015-06-09 | 2015-08-19 | 湖北天盾电子技术有限公司 | On-line intelligent system for safety emergency based on multiple communication networks and sensing equipment |
| CN105045583A (en) * | 2015-07-08 | 2015-11-11 | 哈尔滨工程大学船舶装备科技有限公司 | Visualized process based IETM (Interactive Electronic Technical Manual) fault class data module creation apparatus and creation method therefor |
| CN105094818A (en) * | 2015-07-14 | 2015-11-25 | 国家信息中心 | Construction method and system for comprehensive application of natural resources based on SOA |
| CN105354025A (en) * | 2015-10-18 | 2016-02-24 | 广州赛意信息科技有限公司 | Service model configuration system and method based on mobile application |
| CN108369700A (en) * | 2015-10-27 | 2018-08-03 | 屯屯·闻 | Mobile-payment system |
| JP6493447B2 (en) * | 2016-08-02 | 2019-04-03 | Ｊｆｅスチール株式会社 | Hot metal temperature prediction method, hot metal temperature prediction device, blast furnace operation method, operation guidance device, hot metal temperature control method, and hot metal temperature control device |
| CN108090823A (en) * | 2017-12-20 | 2018-05-29 | 重庆八戒财云网络科技有限公司 | accounting data management system based on SaaS |
Non-Patent Citations (4)
| Title |
|---|
| 中国企业联合会管理现代化工作委员会: "《国家级企业管理创新成果 2018 第24届 下》", 31 March 2018 * |
| 格尔德·哈特曼: "《Product Lifecycle Management with SAP》", 31 December 2007 * |
| 苏海涛: "ERP系统成本中心费用核算方法的研究", 《科技风》 * |
| 金广欣: "生产成本预测系统在完善制造型企业成本经营管理中的作用", 《信息系统工程》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110428134A (en) * | 2019-06-28 | 2019-11-08 | 唐山钢铁集团有限责任公司 | Iron and steel enterprise's day-rate cost accounting method based on SAP platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109242550B (en) | 2021-09-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Batra et al. | Multinational firms and the theory of international trade and investment | |
| CN103136618B (en) | The online management method of construction program | |
| US6684384B1 (en) | Extensible object oriented framework for general ledger | |
| US20140324509A1 (en) | Scheduling and budgeting for projects | |
| US7197484B1 (en) | Asset management advice system and recording medium containing program of the system | |
| US20120271748A1 (en) | Engineering process for a real-time user-defined data collection, analysis, and optimization tool (dot) | |
| CN105046560A (en) | Third-party credit supervision and risk assessment system and method | |
| JP2006505068A (en) | Information processing system that determines taxation information | |
| WO1993012489A1 (en) | Data processing technique for scoring bank customer relationships and awarding incentive rewards | |
| CN102938096B (en) | A kind of implementation method of the power plant registration information declaration system of dynamic configuration | |
| DE202016009077U1 (en) | Segmentation and stratification of composite portfolios of investment securities | |
| Chen et al. | Formerly assembled, but now designed in China? Assessing the domestic value-added of activities in gross exports | |
| CN109242550A (en) | A kind of steel process cost forecasting system | |
| NOVIKOV et al. | Improving the enterprise resource planning system based on digital modules of the industry 4.0 concept | |
| CN116228141A (en) | ERP system and ERP device for production management | |
| CN114610801A (en) | Generation method of line and column report template | |
| CN107729305B (en) | Automatic conference material generation method based on database and front-end display technology | |
| CN107545340A (en) | It is a to be based on wechat platform website processing system | |
| CN111783411A (en) | Report automatic generation system and method based on scheduling synchronization line loss | |
| WO2021132603A1 (en) | Information processing device, information processing method, and program | |
| JP2005099904A (en) | Method for rearranging and adjusting financial statement in financial accounting system | |
| MacGregor | What users think about computer models | |
| CN111126013A (en) | Hydraulic and hydroelectric engineering construction safety management system | |
| DE202022106989U1 (en) | Artificial intelligence and blockchain based system for managing e-commerce big data for logistic supply chain | |
| Royhan et al. | Systematic Literature Review Impact of RPA Implementation on Company Performance |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |