CN107358475A - A kind of floating price management platform based on SAP - Google Patents
A kind of floating price management platform based on SAP Download PDFInfo
- Publication number
- CN107358475A CN107358475A CN201710607770.6A CN201710607770A CN107358475A CN 107358475 A CN107358475 A CN 107358475A CN 201710607770 A CN201710607770 A CN 201710607770A CN 107358475 A CN107358475 A CN 107358475A
- Authority
- CN
- China
- Prior art keywords
- price
- data
- code
- sent
- safeguarded
- 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
- 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/0283—Price estimation or determination
Landscapes
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Strategic Management (AREA)
- Finance (AREA)
- Game Theory and Decision Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of floating price management platform based on SAP, including pass through the maintained from front end that Intranet/outer net connects and inquiry terminal and background data base;Background data base includes:Maintenance data storage module:Store the data safeguarded;Data are sent and receiving module:Forward end, which is safeguarded, to be sent data to be safeguarded with inquiring about terminal, receives the data safeguarded sent from maintained from front end and inquiry terminal, reception from maintained from front end with inquiring about the querying condition data and forward end is safeguarded and inquiry terminal transmission Query Result data that terminal is sent;Price difference and clearing price computing module:According to the querying condition data received, the price difference and clearing price of material are calculated, and result of calculation is sent.The invention enables price composition it is transparent, floating can trace;Pass through the setting of database so that price data is preserved and obtained more stable;Meanwhile the calculating of price and result ensure data consistency using SAP is all unified in.
Description
Technical field
The present invention relates to a kind of floating price management platform based on SAP.
Background technology
SAP is " System Applications and Products " abbreviation, is the soft of enterprise management solution
Part title.SAP transaction codes are the code strings for activating a SAP function window, are generally made up of letter and number.
SAP is only result (transaction code ME11, the buying for paying close attention to its procurement price for raw material COM code PLM1
Information record), but " composition " to it, " floating price differential " and calculating process do not carry out management and control.Price control person can only be
The outer Excel manual managements process of system, then by result typing SAP.It has following defect:1) Excel is due to easy to operate, worker
Operation has the probability of error, and certain workload be present;2) data disconnect with performing the SAP of management, and uniformity is risky;3) float
The statistical analysis of dynamic data still needs to manually complete in Excel, and data preservation is risky.
The content of the invention
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of floating price management platform based on SAP.
The purpose of the present invention is achieved through the following technical solutions:A kind of floating price management platform based on SAP,
Including maintained from front end and inquiry terminal and background data base;Described maintained from front end leads to inquiry terminal and background data base
Cross Intranet/outer net connection;
Described maintained from front end and maintenance and inquiry of the inquiry terminal for carrying out floating price, including:
Material maintenance module:For safeguarding the material code and Material Name data of background data base transmission, and will safeguard
Data afterwards are sent to background data base;
Material texture combines maintenance module:For safeguarding the combination of materials code and combination of materials class of background data base transmission
Not, and by the data after maintenance send to background data base;Described material is made up of multiple materials;
Material calculation of price formula maintenance module:The calculation of price of the every kind of material sent for safeguarding background data base is public
Formula, and the data after maintenance are sent to background data base;
Material maintenance module:For safeguarding the material of background data base transmission and the combination of materials classification of supplier, and
The weight of every kind of material and corresponding calculation of price formula under each classification of the material that background data base is sent are safeguarded, and will
Data after maintenance are sent to background data base;
Of that month material price maintenance module:The price of the of that month each material sent for safeguarding background data base, and will dimension
Data after shield are sent to background data base;
Price difference and clearing price enquiry module:Sent for input inquiry condition and by querying condition data to back-end data
Storehouse, and receive the Query Result sent from background data base;
Described background data base includes:
Maintenance data storage module:For storing the data safeguarded;
Data are sent and receiving module:Data to be safeguarded are sent with inquiry terminal, reception comes from for forward end maintenance
Maintained from front end is with inquiring about the inquiry bar of the data safeguarded, reception from maintained from front end with inquiry terminal transmission that terminal is sent
Number of packages evidence and forward end are safeguarded sends Query Result data with inquiry terminal;
Price difference and clearing price computing module:The querying condition data received with receiving module are sent according to data, are calculated
The price difference of material, clearing price is calculated further according to material base price, and result of calculation is sent to enter with receiving module by data
Row is sent.
Further, the data that described material calculation of price formula maintenance module is safeguarded include:Formula sequence number, formula are retouched
State, material code, Material Name, freight charges, raw material base price, processing charges, currency, unit of weight, clearing unit price, the ups and downs amount of money,
Ladder coefficient, button point discount, company undertake ratio and price difference calculation formula;
The data that described material maintenance module is safeguarded include:COM code, material description, name of material, material specification
Model, material state, vendor code, procurement organization code, base price, currency, combination of materials code, combination of materials description, material
Matter code, Material Name, weight, calculation formula code, unit of weight;
The data that described of that month material price maintenance module is safeguarded include:Material code, Material Name, procurement organization generation
Code, of that month price, currency, unit of weight, year and the moon;
The data that described price difference exports with clearing price computing module include:Year, the moon, procurement organization code, COM code,
Material description, name of material, material specification model, material state, vendor code, base price, currency, combination of materials code, material
Material combination description, material code, material description, weight, unit of weight, this month settle accounts unit price, raw material base price, of that month price,
Price difference, gross spread and of that month clearing price.
Further, described input condition includes procurement organization code, COM code, vendor code and combination of materials
Code.
Further, described maintained from front end and inquiry terminal are PC.
The beneficial effects of the invention are as follows:The invention enables price composition it is transparent, floating can trace;Pass through setting for database
Put so that price data is preserved and obtained more stable;Meanwhile the use of the calculating process and result of price is all unified in SAP,
It ensure that the uniformity of data.
Brief description of the drawings
Fig. 1 is present system block diagram.
Embodiment
Technical scheme is described in further detail below in conjunction with the accompanying drawings:It is as shown in figure 1, a kind of floating based on SAP
Dynamic price control platform, including maintained from front end and inquiry terminal and background data base;Described maintained from front end and inquiry terminal
Connected with background data base by Intranet/outer net;
Described maintained from front end and maintenance and inquiry of the inquiry terminal for carrying out floating price, including:
Material maintenance module:For safeguard background data base send material code and Material Name data (such as the institute of table 1
Show), and the data after maintenance are sent to background data base;
Material | Material Name |
S001 | Cold rolling silicon steel |
S002 | Hot rolling silicon steel |
S003 | Copper cash |
S004 | Aluminum steel |
S005 | Natural gum |
S006 | Magnet steel T111 |
S007 | Magnet steel T320 |
S008 | PA66 |
S009 | 40Cr |
S010 | ADC12 |
S011 | Lead |
S012 | PP expects TC16G80 |
S013 | PP-1 black 160 |
S014 | PA6-2400 |
S015 | ST12 |
Table 1
Material texture combines maintenance module:For safeguarding the combination of materials code and combination of materials class of background data base transmission
Not (as shown in table 2), and the data after maintenance are sent to background data base;Described material is made up of multiple materials;
Table 2
Material calculation of price formula maintenance module:The calculation of price of the every kind of material sent for safeguarding background data base is public
Formula, and the data after maintenance are sent to background data base;
More preferably, in the present embodiment, the data that described material calculation of price formula maintenance module is safeguarded include:Formula
Sequence number, formula description, material code, Material Name, freight charges, raw material base price, processing charges, currency, unit of weight, advice of settlement
Valency, the ups and downs amount of money, ladder coefficient, button point discount, company undertake ratio and price difference calculation formula.Wherein, for freight charges, processing
It is all option that expense, clearing unit price, the ups and downs amount of money, ladder coefficient, button point discount and company, which undertake ratio,;And formula sequence number, public affairs
Formula description, material code, Material Name, raw material base price, currency, unit of weight, clearing unit price and price difference calculation formula are must
Option.
In the present embodiment, described freight charges are involved supplier's freight charges, and described raw material base price is floated for label
Raw material base price during valency, described processing charges are the processing charges that part supplier needs, and described currency includes RMB/U.S.
Gold etc., described unit of weight for kilogram, described clearing unit price, the ups and downs amount of money are the particular/special requirement of supplier, and company holds
The part that company undertakes when load ratio is raw material ups and downs.
For example, for formula serial number A001 calculation formula, difference of the material code for S001 cold rolling silicon steel is calculated
Valency calculation formula=weight * (of that month price+freight charges-raw material base price) * buttons point discount * companies undertake ratio;And publicity sequence number
For A003 and A005 calculation formula, each provide the copper cash that two kinds of material codes are S003 and obtain price difference calculation formula, respectively
For:(1) weight * (of that month price-processing charges-raw material base price) * buttons point discount * companies undertake ratio;(2) weight * (of that month valencys
Lattice-raw material base price) * companies undertake ratio.Because a variety of suppliers have different prices, therefore there can be same material
With a variety of calculation formula.And the of that month price in formula is safeguarded by following of that month material price maintenance modules, and
Weight is safeguarded by material maintenance module.
Material maintenance module:For safeguarding the material of background data base transmission and the combination of materials classification of supplier, and
The weight of every kind of material and corresponding calculation of price formula under each classification of the material that background data base is sent are safeguarded, and will
Data after maintenance are sent to background data base;
More preferably, in the present embodiment, the data that described material maintenance module is safeguarded include:COM code, material are retouched
State, name of material, material specification model, material state, vendor code, procurement organization code, base price, currency, measurement unit,
Combination of materials code, combination of materials description, material code, Material Name, weight, calculation formula code, unit of weight.
For example, COM code is 660080005-0001 material (material description and base price do not describe), name of material is
Motor, material specification model LC1800DC, material state 50Hz220V, vendor code 10001, procurement organization code
For 1000, currency is RMB, and measurement unit EA, combination of materials code is C001 (being referred in table 2), and combination of materials is described as
Cold rolling silicon steel/hot rolling silicon steel/copper cash, material code are that S001/ Material Names cold rolling silicon steel/weight was 10.9/ calculation formula generation
Code is A001, and material code is that S002/ Material Names hot rolling silicon steel/weight is that 40.6/ calculation formula code is A002, material generation
Code is that S003/ Material Names copper cash/weight is that 2.2/ calculation formula code is A003, unit of weight KG.Wherein, calculation formula
Code is that above-mentioned material calculation of price formula maintenance module is safeguarded.
Of that month material price maintenance module:The price of the of that month each material sent for safeguarding background data base, and will dimension
Data after shield are sent to background data base;
More preferably, in the present embodiment, the data that described of that month material price maintenance module is safeguarded include:Material generation
Code, Material Name, procurement organization code, of that month price, currency, unit of weight, year and the moon.
For example, material code is S001 cold rolling silicon steel, procurement organization code is 1000, and of that month price is X, and currency is behaved
People's coin, unit of weight KGH, year 2017, the moon 06.
Price difference and clearing price enquiry module:Sent for input inquiry condition and by querying condition data to back-end data
Storehouse, and receive the Query Result sent from background data base;Wherein, described input condition includes procurement organization code, thing
Material coding, vendor code and combination of materials code.
More preferably, the data that described price difference exports with clearing price computing module include:Year, the moon, procurement organization code, thing
Expect coding, material description, name of material, material specification model, material state, vendor code, base price, currency, combination of materials
Code, combination of materials description, material code, material description, weight, unit of weight, of that month clearing unit price, raw material base price, when
Month price, price difference, gross spread and of that month clearing price.
Described background data base includes:
Maintenance data storage module:For storing the data safeguarded;
Data are sent and receiving module:Data to be safeguarded are sent with inquiry terminal, reception comes from for forward end maintenance
Maintained from front end is with inquiring about the inquiry bar of the data safeguarded, reception from maintained from front end with inquiry terminal transmission that terminal is sent
Number of packages evidence and forward end are safeguarded sends Query Result data with inquiry terminal;
Price difference and clearing price computing module:The querying condition data received with receiving module are sent according to data, are calculated
The price difference of material, clearing price is calculated further according to material base price, and result of calculation is sent to enter with receiving module by data
Row is sent.
More preferably, in the present embodiment, described maintained from front end and inquiry terminal are PC.
Claims (4)
- A kind of 1. floating price management platform based on SAP, it is characterised in that:Including maintained from front end and inquiry terminal, Yi Jihou Platform database;Described maintained from front end is connected with inquiry terminal and background data base by Intranet/outer net;Described maintained from front end and maintenance and inquiry of the inquiry terminal for carrying out floating price, including:Material maintenance module:For safeguarding the material code and Material Name data of background data base transmission, and by after maintenance Data are sent to background data base;Material texture combines maintenance module:For safeguarding the combination of materials code and combination of materials classification of background data base transmission, And the data after maintenance are sent to background data base;Described material is made up of multiple materials;Material calculation of price formula maintenance module:The calculation of price formula of the every kind of material sent for safeguarding background data base, And the data after maintenance are sent to background data base;Material maintenance module:For safeguarding the material of background data base transmission and the combination of materials classification of supplier, and safeguard The weight of every kind of material and corresponding calculation of price formula under each classification of the material that background data base is sent, and will safeguard Data afterwards are sent to background data base;Of that month material price maintenance module:The price of the of that month each material sent for safeguarding background data base, and by after maintenance Data send to background data base;Price difference and clearing price enquiry module:Sent for input inquiry condition and by querying condition data to background data base, and Receive the Query Result sent from background data base;Described background data base includes:Maintenance data storage module:For storing the data safeguarded;Data are sent and receiving module:Safeguarded for forward end and inquiry terminal sends data to be safeguarded, reception comes from front end Safeguard the data safeguarded sent with inquiry terminal, receive the querying condition number sent from maintained from front end with inquiry terminal According to and forward end safeguard with inquiry terminal send Query Result data;Price difference and clearing price computing module:The querying condition data received with receiving module are sent according to data, calculate material Price difference, be calculated clearing price further according to material base price, and result of calculation is sent by data and sent out with receiving module Send.
- A kind of 2. floating price management platform based on SAP according to claim 1, it is characterised in that:Described material The data that calculation of price formula maintenance module is safeguarded include:Formula sequence number, formula description, material code, Material Name, freight charges, Raw material base price, processing charges, currency, unit of weight, clearing unit price, the ups and downs amount of money, ladder coefficient, button point discount, company undertake Ratio and price difference calculation formula;The data that described material maintenance module is safeguarded include:COM code, material description, name of material, material specification model, Material state, vendor code, procurement organization code, base price, currency, combination of materials code, combination of materials description, material generation Code, Material Name, weight, calculation formula code, unit of weight;The data that described of that month material price maintenance module is safeguarded include:Material code, Material Name, procurement organization code, Of that month price, currency, unit of weight, year and the moon;The data that described price difference exports with clearing price computing module include:Year, the moon, procurement organization code, COM code, material Description, name of material, material specification model, material state, vendor code, base price, currency, combination of materials code, material group Close description, material code, material description, weight, unit of weight, this month settle accounts unit price, raw material base price, of that month price, price difference, Gross spread and of that month clearing price.
- A kind of 3. floating price management platform based on SAP according to claim 2, it is characterised in that:Described input Condition includes procurement organization code, COM code, vendor code and combination of materials code.
- A kind of 4. floating price management platform based on SAP according to claim 1, it is characterised in that:Described front end Safeguard that with inquiry terminal be PC.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710607770.6A CN107358475A (en) | 2017-07-24 | 2017-07-24 | A kind of floating price management platform based on SAP |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710607770.6A CN107358475A (en) | 2017-07-24 | 2017-07-24 | A kind of floating price management platform based on SAP |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107358475A true CN107358475A (en) | 2017-11-17 |
Family
ID=60284820
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710607770.6A Pending CN107358475A (en) | 2017-07-24 | 2017-07-24 | A kind of floating price management platform based on SAP |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107358475A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110930201A (en) * | 2020-01-02 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Pricing method and system based on dynamic modeling |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101388090A (en) * | 2008-10-08 | 2009-03-18 | 武汉钢铁(集团)公司 | Product price management system and method |
CN103578023A (en) * | 2012-07-30 | 2014-02-12 | 上海宝信软件股份有限公司 | Modeling implementation system based on steel crude fuel purchasing valuation |
CN104636867A (en) * | 2015-01-30 | 2015-05-20 | 广州盖特软件有限公司 | Method and device for quickly generating material code from texture in ERP system |
CN104751315A (en) * | 2015-04-01 | 2015-07-01 | 北京首钢自动化信息技术有限公司 | E-purchasing system and method |
CN106339834A (en) * | 2016-08-17 | 2017-01-18 | 武汉华星光电技术有限公司 | Product cost statistical method |
CN107103522A (en) * | 2017-05-16 | 2017-08-29 | 上海要票信息技术有限公司 | It is a kind of to be used for the network wholesaler trade platform of artistic ticketing service of performing |
CN107292572A (en) * | 2017-07-21 | 2017-10-24 | 河钢股份有限公司邯郸分公司 | A kind of method of SAP system steel industry spare part sequence number logistic track |
CN110322190A (en) * | 2019-05-28 | 2019-10-11 | 唐山钢铁集团有限责任公司 | The method that steel industry intrabranch service order based on SAP automatically creates |
-
2017
- 2017-07-24 CN CN201710607770.6A patent/CN107358475A/en active Pending
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101388090A (en) * | 2008-10-08 | 2009-03-18 | 武汉钢铁(集团)公司 | Product price management system and method |
CN103578023A (en) * | 2012-07-30 | 2014-02-12 | 上海宝信软件股份有限公司 | Modeling implementation system based on steel crude fuel purchasing valuation |
CN104636867A (en) * | 2015-01-30 | 2015-05-20 | 广州盖特软件有限公司 | Method and device for quickly generating material code from texture in ERP system |
CN104751315A (en) * | 2015-04-01 | 2015-07-01 | 北京首钢自动化信息技术有限公司 | E-purchasing system and method |
CN106339834A (en) * | 2016-08-17 | 2017-01-18 | 武汉华星光电技术有限公司 | Product cost statistical method |
CN107103522A (en) * | 2017-05-16 | 2017-08-29 | 上海要票信息技术有限公司 | It is a kind of to be used for the network wholesaler trade platform of artistic ticketing service of performing |
CN107292572A (en) * | 2017-07-21 | 2017-10-24 | 河钢股份有限公司邯郸分公司 | A kind of method of SAP system steel industry spare part sequence number logistic track |
CN110322190A (en) * | 2019-05-28 | 2019-10-11 | 唐山钢铁集团有限责任公司 | The method that steel industry intrabranch service order based on SAP automatically creates |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110930201A (en) * | 2020-01-02 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Pricing method and system based on dynamic modeling |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105046560A (en) | Third-party credit supervision and risk assessment system and method | |
CN102024189A (en) | System for analyzing manufacturing cost | |
JP2017504126A5 (en) | ||
CN108629670A (en) | The self-service inquiry of one kind and material information maintaining-managing system | |
CN107481113A (en) | Goods wholesale based on internet goes out sale system | |
US7596500B1 (en) | System and method for processing import/export transactions | |
US7711615B2 (en) | Methods, apparatus, systems, computer program products and mediums for use in association with accounting and/or financial analysis | |
US20120123893A1 (en) | Device, System, And Method For Trading Units Of Unique Valuable Assets | |
CN105844392A (en) | Method and system for matching technology transaction | |
CN115860752A (en) | Chemical material sales customer management middle platform and method based on Internet of things | |
Grody et al. | Risk accounting–a next generation risk management system for financial institutions | |
CN115237985A (en) | Investment risk index analysis platform based on ETL | |
CN103430201A (en) | Private company valuation | |
Jauhari et al. | Coordinating a two-level supply chain with defective items, inspection errors and price-sensitive demand. | |
CN107358475A (en) | A kind of floating price management platform based on SAP | |
US20090319380A1 (en) | Facilitating Real Estate Transaction Collaboration | |
KR20030078446A (en) | Method and system for providing business to business electronic commerce service including tracking information | |
Muhammad et al. | Economic order quantity for items with two types of imperfect quality | |
Farag | A planning model for the divisionalized enterprise | |
International Monetary Fund. Statistics Dept. | International Financial Statistics Yearbook, 2017 | |
Han et al. | Empirical Study on Determinants of T/T Payment Risk in International Trade | |
Wu et al. | The carbon footprint calculation model of the integrated ERP framework–green production | |
Jinping | Under the IT environment inventory accounting and management studies | |
Hu | Assessment of international business transaction risk based on big data | |
Olusola et al. | Use of trade credit in Nigeria: a panel econometric approach |
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 | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171117 |