CN107316174A - A kind of method thawed automatically according to work order demand based on SAP - Google Patents
A kind of method thawed automatically according to work order demand based on SAP Download PDFInfo
- Publication number
- CN107316174A CN107316174A CN201710607719.5A CN201710607719A CN107316174A CN 107316174 A CN107316174 A CN 107316174A CN 201710607719 A CN201710607719 A CN 201710607719A CN 107316174 A CN107316174 A CN 107316174A
- Authority
- CN
- China
- Prior art keywords
- stock
- voucher
- field
- order
- mobile type
- 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
- 238000000034 method Methods 0.000 title claims abstract description 19
- 239000000463 material Substances 0.000 claims abstract description 120
- 238000007689 inspection Methods 0.000 claims abstract description 85
- 238000004519 manufacturing process Methods 0.000 claims abstract description 17
- 238000003860 storage Methods 0.000 claims abstract description 7
- 238000009826 distribution Methods 0.000 claims description 8
- 238000003306 harvesting Methods 0.000 claims description 3
- 230000000717 retained effect Effects 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 abstract description 6
- 238000012795 verification Methods 0.000 abstract description 2
- 238000007726 management method Methods 0.000 description 7
- 235000015110 jellies Nutrition 0.000 description 5
- 239000002994 raw material Substances 0.000 description 5
- 238000010257 thawing Methods 0.000 description 5
- 239000008274 jelly Substances 0.000 description 4
- 239000000243 solution Substances 0.000 description 4
- 239000012086 standard solution Substances 0.000 description 3
- 206010021703 Indifference Diseases 0.000 description 2
- 238000003556 assay Methods 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 230000004913 activation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008014 freezing Effects 0.000 description 1
- 238000007710 freezing Methods 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- 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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a kind of method thawed automatically according to work order demand based on SAP, following steps are performed：S1：The production order searched in SAP system；S2：The material and quantity required of independent demand are captured, is compared with unrestricted stock, when demand can not be met up to S3；S3：The merchandiser purchase order for meeting work order correspondence sales order is searched, the stock of mobile type 103 is listed；S4：The earliest stock of voucher will be put in storage in the stock of mobile type 103 to take out successively, until need satisfaction；S5：BAPI interfaces are called to transfer items if material need not be examined；If necessary to examine, judge whether corresponding inspection lot has recorded result, BAPI interfaces are called if having, its qualified quantity is transferred items.The present invention reduces artificial, high conversion efficiency：Do not need storehouse data person artificially to check stock, thawed one by one again after storehouse data person verification buying order, sales order, the relation of work order are not needed when conversion.
Description
Technical field
The present invention relates to a kind of method thawed automatically according to work order demand based on SAP.
Background technology
SAP is " System Applications and Products " abbreviation, is the soft of enterprise management solution
Part title.MRP（Material Requirement Planning, MRP）Refer to according to each level of product structure
The subordinate and quantitative relation of article, using each article as plan object, using the period of completing as time reference back scheduling, by advance
Phase length is distinguished each article and assigned plans the sequencing of time, is that MRP manages mould in a kind of industrial manufacturing enterprise
Formula.
For the specific operating efficiency in part, there are different management and control points in different departments：（1）Finance go out from fund management and control
Hair, it is desirable to goods and materials purchase storage when not with supplier's pending accounts, and need to wait until goods and materials production consumption after, then with supplier tie
Calculate, i.e. consignment pattern.（2）Sell the requirement from client, it is desirable to which purchase order binds sales order, the stock of correspondence storage
Also sales order is bound, i.e., with monotype.
SAP standard solutions are：, can only because SAP standard features can not realize purchase order merchandiser and consignment simultaneously
By being used in buying order binding sales slip and the pairing of mobile type 103 and 105, sale, the management and control effect of finance are reached.Its
In, SAP mobile types are to be used to indicating the number of three of material movement (receive/deliver/dump/dump keep accounts) in SAP system
Word/letter.Generally divide several major classes:Receive, deliver, dump, storehouse adjustment, mobile type 103 refer to purchase order receive to
The stock of frozen state, mobile type 105 refers to the stock that receives for ratifying to freeze in warehouse.SAP transaction codes are activation one
The code string of individual SAP function windows, is generally made up of letter and number.
For the inspection-free SAP standard transaction handling processes of goods and materials, including following steps：（1）SAP standard transaction codes
MIGO receives according to buying order, uses mobile type 103.Now SAP stocks " unrestricted stock " do not increase, respective amount increase
" receive freeze stock ", and without accounting voucher generation.（2）Handle 103 receive after, depositary management is by material handling to given zone
Domain, into frozen state.（3）After the corresponding work order row work of sales order, SAP generation productions are reserved single.（4）Storehouse material issuing people
Member checks the material of " need for independence " in reserved list, using standard transaction code MMBE check material " unrestricted stock " whether
There is difference to lack.（5）Lack if any difference, then judge whether " receive the stock freezed " has quantity to thaw.（6）If quantity,
MMBE can inquire corresponding all buying orders by right button.（7）A buying order is selected, standard transaction code MIGO is used
Receive, mobile type 105.Now " the unrestricted stock " of the SAP materials increases respective amount, and " receive the stock freezed " subtracts
It is few, and generate accounting voucher.（8）The 6th to 7 step is operated repeatedly, until the material " unrestricted stock " meets reserved list and required.
（9）Storehouse personnel need to repeat 4 to 8 steps, lack until owning " need for independence " material indifference in the reserved list of the work order.（10）Finance
During monthly closing entry, the date pending accounts generated by accounting voucher.
For the non-inspection-free SAP standard transaction handling processes of goods and materials, including following steps：（1）SAP standard transaction generations
Code MIGO receives according to buying order, uses mobile type 103.Now SAP generates inspection lot, no accounting voucher.（2）Quality inspection personnel
The inspection lot of non-quality inspection is inquired about in transaction code QA32, the qualified rear typing quality inspection result of quality inspection is unqualified, handles the return of goods.
（3）For quality inspection it is qualified 103, depositary management is by material handling to specific region, into frozen state.（4）In sales order correspondence
Work order row's work after, SAP generation productions are reserved single.（5）Storehouse material issuing personnel inspection reserves the material of " need for independence " in list, makes
Whether there is difference to lack with standard transaction code MMBE " the unrestricted stocks " for checking material.（6）Lack if any difference, then judge " jelly of receiving
Whether the stock of knot " has quantity to thaw.（7）If quantity, standard transaction code MMBE can be inquired by right button
Corresponding all buying orders.（8）The inspection lot of the voucher of buying order 103 is inquired about by standard transaction code ME23N.（9）Pass through
Standard transaction code QA12, passing number is transferred items, thawed.Now " the unrestricted stock " of the SAP materials increases respective amount,
" receive the stock freezed " is reduced, and generates accounting voucher.（10）7-9 is operated to walk repeatedly, until material " the unrestricted storehouse
Deposit " meet reserved single requirement.（11）Storehouse personnel need to repeat 5 to 10 steps, until owning " independent to need in the reserved list of the work order
Ask " material indifference lack.（12）During financial monthly closing entry, the date pending accounts generated by accounting voucher.
But the defect in SAP standard solutions includes：For storehouse custodial officer, by face of several ask
Topic：（1）It is currently to be in " receive the stock freezed " to have which goods and materials in my storehouse, and quantity is how many（2）These " jellies of receiving
The stock of knot " I when should go operation 105；Operate many small numbers；（3）Material if necessary to operation is a lot, my energy
Fast operating is completed；And the solution of SAP standards, it but can not quickly, intuitively solve these problems：（1）SAP standard things
Business code MMBE can inquire about " receive the stock freezed ", but once can only inquire about a COM code, and COM code is necessary
Know, input.Other inquiring stock standard transaction codes can lot size inventories, but can not show " receive the stock freezed ".（2）
SAP standard transaction handling processes are visible, and storehouse data person is passive, it is impossible to actively after work order is assigned, very first time batch,
Intuitively find that the difference that there is " receive the stock freezed " in " need for independence " lacks.（3）From SAP standard transaction processing streams,
Operation needs item by item, crosschecked, and efficiency is low, malfunctions when measuring big and easily.
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 automatic according to work order demand based on SAP
The method of defrosting.
The purpose of the present invention is achieved through the following technical solutions：It is a kind of automatic according to work order demand based on SAP
The method of defrosting, performs following steps at regular intervals：
S1：The basic date is set, and with basic date+N days for scope, in removal search SAP system, Date Required is within this range
Produce order；
S2：The material and quantity required of independent demand, are compared with the unrestricted stock in stock during crawl production order is reserved, when
When stock can not meet demand, to step S3；
S3：All merchandiser purchase orders for meeting work order correspondence sales order are searched, and list the buying of wherein mobile type 103
Order is received to the stock of frozen state；
S4：With first in first out, the purchase order of mobile type 103 is received into the stock of frozen state storage voucher most
Early stock takes out successively, until need satisfaction；
S5：Judge whether material needs inspection, if need not examine, directly invoke BAPI interfaces and transfer items；If desired
During inspection, judge whether corresponding inspection lot has recorded result, the data are excluded if input result is not done, BAPI is called if having
Interface, its qualified quantity is transferred items；
S6：Output report, implementing result is shown.
Further, described method is further comprising the steps of after implementing result is shown：
S7：If the work order in certain time still has difference to lack, procurement staff urges goods at once.
Further, step S3 ~ S6 includes following sub-step：
S81：According to work order information, the account in association order AFPO tables and buying voucher sets the corresponding field of EKKN tables,
Described corresponding field includes O/No., row item number and COM code；
S82：Exclude the corresponding all row projects of purchase order for deleting that identification field LOEKZ is non-NULL in EKKN tables；
S83：Exclude to delete identification field LOEKZ in buying voucher project EKPO tables or deliver goods and completed in identification field ELIKZ
Any one is the purchase order and row project of non-NULL；
S84：EKPO tables are inquired about, only reservation subject distribution classification field KNTTP is M and international trade condition field INCO2 is extension
The purchase order and row project of account；Wherein, subject distribution classification field KNTTP is that M is expressed as changing procurement request by MRP
Into purchase order；
S85：According to the purchase order of reservation and row project, searched in buying voucher history EKBE tables, obtain all materials
Voucher numbering LFBNR and row item number BUZEI；；
S86：Non- quality inspection stock and the quantity of the quality inspection stock of mobile type 103 respectively to mobile type 103 be determined and
Transfer items, wherein the quantity for non-quality inspection stock is determined and transferred items including following sub-step：
S8611：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, is retained in QAMB tables and can not find inspection lot field PRUEFLOS and inspection lot and thing in QAMB tables
The value for expecting the reftype field TYP between voucher is 1 material voucher numbering and row item number, and wherein TYP value is equal to 1 expression
For the material voucher set up according to document；
S8612：Numbered according to the material voucher of reservation, all material credential fields BELNR, row item number are found in EKBE tables
Field BUZEI and corresponding mobile type field BWART, amount field WESBS；
S8613：Calculate stock-mobile type of the stock-mobile type 104 for stockpile number=mobile type 103 that harvest is freezed
The stock of 105 stock+mobile type 106, and according to material voucher number sorting；Wherein, mobile type 105 refers to approval
Frozen state is received in warehouse, and mobile type 104 refers to the abatement rollback of mobile type 103, and mobile type 106 refers to moving
The abatement rollback of dynamic Class1 05；
S8614：Compared according to each 103 material credential fields BELNR stockpile numbers calculated with lacking quantity, when first
The corresponding stockpile number of 103 material credential fields searches the inventory of next 103 material credential fields less than when lacking quantity
Amount, until meeting demand；
S8615：According to the 103 material credential fields BELNR and row item number field BUZEI found, adjusted using mobile type 105
Transferred items with BAPI interfaces；
Quantity for quality inspection stock is determined and transferred items including following sub-step：
S8621：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, inspection lot field PRUEFLOS is found and in QAMB in the connection QAMB tables of inspection lot and material voucher
The value of reftype field TYP in table between inspection lot and material voucher is 1；Then according to the inspection lot field PRUEFLOS
The thing for the use of the mobile type of decision-making field VCODE non-NULLs being 103 is found in the view QAVE tables using the inspection lot of decision-making
Expect voucher and row item number, retain the material voucher numbering found and row item number, wherein decision-making field VCODE non-NULLs represent matter
Inspection person typing quality inspection result：
（1）When can not find the i.e. reftype field TYP's of material voucher in table QAMB according to inspection lot field PRUEFLOS
During value TYP=3, it is determined as that non-quality inspection is transferred items, wherein, TYP=3 are expressed as the material voucher that quality inspection is transferred items；
（2）When material voucher can be found in table QAMB according to inspection lot field PRUEFLOS, according to the material voucher of reservation
Numbering, find all material credential fields BELNR, row item number field BUZEI and corresponding mobile type field BWART,
Amount field WESBS；And calculate stock-shifting of the stock-mobile type 104 for the stockpile number=mobile type 103 freezed of receiving
The stock of stock-mobile type 124 of stock+mobile type 106 of dynamic Class1 05, by material voucher number sorting；Mobile class
Type 124 represents to return goods；
S8622：Compared according to the stockpile number that each 103 voucher is calculated with lacking quantity, when first 103 material voucher pair
The stockpile number answered searches the stockpile number of next 103 material voucher less than when lacking quantity, until meeting demand；
S8623：Inspection lot field PRUEFLOS according to finding calls BDC interfaces to transfer items.
Further, the result of described report output includes：Sales order, sales order row project, production order, work
Factory, production order Start Date, reserved numbering, reserved row item number, COM code, material description, aggregate demand quantity, material issuing
Quantity, net demand quantity, available stock quantity, lack quantity, 103 receive the stock freezed, stock locations, batch.
Further, the described setting basic date includes the date based on automatic set Date.
The beneficial effects of the invention are as follows：（1）The present invention reduces artificial, high conversion efficiency：Storehouse data person is not needed not only
It is artificial to go to check stock；And when conversion, it is not necessary to storehouse data person verification buying order, sales order, the pass of work order
After system, then thaw one by one.Both consignment pattern of the finance from fund management and control on's requirement had been realized, sale is realized again from client
Requirement set out with monotype.（2）The present invention changes from passive to active conversion work, and the scope of system automatic conversion work order is
The same day, to secondary N days, prevents work order after work is sent, because difference lacks and stops line.
Brief description of the drawings
Fig. 1 is the inventive method flow chart.
Embodiment
Technical scheme is described in further detail below in conjunction with the accompanying drawings：
As shown in figure 1, a kind of method thawed automatically according to work order demand based on SAP, at regular intervals（Each hour）
Perform following steps：
S1：Automatically on the date based on setting Date, be demand day in scope, removal search SAP system with basic+2 days dates
The production order of phase within this range；Wherein, AFPO tables are the main table of work order.
Specifically, the main Table A FKO of work order basic Start Date field GSTRP first, can inquire work order passage time,
Associated again by work order number, inquire about the main Table A FPO of work order, obtain sales slip and row item number.
S2：Unrestricted stock's ratio during crawl production order is reserved in the material and quantity required, with stock of independent demand
Compared with when stock can not meet demand, to step S3；
Wherein, there is the attribute value of independence/concentration two in SAP material bases data, concentrate after representative operation MRP, no matter originate
How, all demands all collect for a buying or production order；, can be according to different after independent representative operation MRP
The different buying of sales order requirement source generation or production order.And the present embodiment solves material for need for independence
Thaw.In addition, in SAP standard schemes, attribute is the material concentrated, and is to use " consignment pattern ", " freezing " " solution again will not be used
The pattern of jelly ".And the material of need for independence, it can not but use " consignment pattern ".Quantity required refers to the material of need for independence
Involved work order quantity required.
Specifically, step S2 needs with work order detail list RESB to associate the main Table A FPO of COM code work order with work order number
（MANTR fields are equal to MANTR fields in EKPO tables in RESB tables）It is associated, then can inquires the material for the demand of feeding intake
Detailed and quantity, available stock is inquired about further according to material, is obtained difference and is lacked.
AFPO is the main table of work order, and RESB is work order detail list；That is AFPO is the finished product A for the work order production deposited, 100；And
RESB be deposit to produce A, it is necessary to the raw material a, b, c, d, e, f ... that are fed intake, what we to be thawed is raw material, so
RESB raw material are found by AFPO, then it is aggregate demand to calculate raw material.Work order Table A FPO is associated with by sales order
EKKN, be buying order order detail list, these buying details be also raw material, correspondence resb the demand that feeds intake.
S3：All merchandiser purchase orders for meeting work order correspondence sales order are searched, and list wherein mobile type 103
Purchase order is received to the stock of frozen state；
Specifically, the main Table A FPO of work order is associated with buying table EKKN with sales order number, item number, can inquire which buying
It is singly to be purchased for the work order of this sales order.Wherein, according to work order information, in association order AFPO tables and buying voucher
Account the corresponding fields of EKKN tables is set, described corresponding field includes O/No.（KDAUF fields are equal in AFPO tables
In VBELN fields in EKKN tables, AFPO tables KDAUF fields represent in sales order number, EKKN tables VBELN fields represent sale and
Distribute voucher number）, row item number（KDPOS fields are equal to KDPOS fields in VBELP fields in EKKN tables, AFPO tables in AFPO tables
Represent that VBELP fields represent sales bill project in sales order row, EKKN tables）；Wherein, association order AFPO tables are
Account in conventional data table in SAP, buying voucher sets EKKN tables to be also the conventional data table in SAP.
S4：With first in first out, the purchase order of mobile type 103 is received into the stock of frozen state be put in storage with
The earliest stock of card takes out successively, until need satisfaction；
Specifically, the step is made up of following sub-step：
S41：Exclude the corresponding all row projects of purchase order for deleting that identification field LOEKZ is non-NULL in EKKN tables；Delete mark
Character learning section LOEKZ is that non-NULL represents not delete；
S42：Exclude to delete identification field LOEKZ in buying voucher project EKPO tables or deliver goods and completed in identification field ELIKZ
Any one is the purchase order and row project of non-NULL；Wherein, buying voucher project EKPO tables are the conventional data table in SAP,
Delivery has completed identification field ELIKZ and has represented that delivery is not completed for non-NULL；
S43：EKPO tables are inquired about, only reservation subject distribution classification field KNTTP is M and international trade condition field INCO2 is extension
The purchase order and row project of account；Wherein, subject distribution classification field KNTTP is that M represents that buying order is " designated sale order "
, international trade condition field is pending accounts, that is, it is consignment pattern to represent the buying order, that is, storage of receiving not pending accounts, after consumption
Pending accounts again；
Wherein, subject distribution classification field is the property value purchased inside single-line item, and above-mentioned material attribute is
When " independence ", the purchase order that the procurement request that correspondence MRP runs out is changed into, this " subject distribution classification " is just M, is represented
" the independent buying of sales order ", this kind of buying order can all follow sales order+row project, and sales order is directly arrived after receiving
Stock, rather than general stock, other sales orders are can not to consume not corresponding sales order stock therewith.
SAP standard solutions are " designated sale order " " consignment " again for buying order, no industry simple and practical scheme, generally
Freeze by 103, then the processing of 105 thawing modes, this is also that this program wants the specific defrosting for solving the problems, such as this kind of buying order.
S44：According to the purchase order of reservation and row project, searched in buying voucher history EKBE tables, obtain all
Material voucher numbering LFBNR；Wherein, buying voucher history EKBE tables are the conventional data table in SAP.
S5：Judge whether material needs inspection（QAMB is inquired about with 103 material vouchers above, typ=1, if any record, then
It is to need quality inspection）If when need not examine, directly invoking BAPI interfaces and transferring items；During if necessary to examine, judge corresponding
Whether inspection lot has recorded result, and the data are excluded if input result is not done, and BAPI interfaces are called if having, by its qualified quantity
Transferred items；
Specifically, for needing the material of quality inspection, in the material voucher in S4 steps, inquire about, find in table QAMB
Inspection lot PRUEFLOS：If there is no assay in QAMB tables, it is necessary to be searched again by inspection lot PRUEFLOS contingency tables QAVE
Assay VCODE；If quality inspection result VCODE is non-NULL in QAVE tables（Now there is quality inspection result）, reexamine and whether solved
Jelly is transferred items（Inquiry QAMB, typ=3, if any record, then this inspection had defrosting）, if it is, calculating the remaining jelly that can be transferred items
Stock is tied, qualified stock is freezed if it is not, then calculating.After having calculated, Bapi is called to transfer items.
S86：Non- quality inspection stock and the quantity of the quality inspection stock of mobile type 103 respectively to mobile type 103 carries out true
Determine and transfer items, wherein the quantity for non-quality inspection stock is determined and transferred items including following sub-step：
S8611：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, is retained in QAMB tables and can not find inspection lot field PRUEFLOS and inspection lot and thing in QAMB tables
The value for expecting the reftype field TYP between voucher is 1 material voucher numbering and row item number, and wherein TYP value is equal to 1 expression
For the material voucher set up according to document；
S8612：Numbered according to the material voucher of reservation, all material credential fields BELNR, row item number are found in EKBE tables
Field BUZEI and corresponding mobile type field BWART, amount field WESBS；
S8613：Calculate stock-mobile type of the stock-mobile type 104 for stockpile number=mobile type 103 that harvest is freezed
The stock of 105 stock+mobile type 106, and according to material voucher number sorting；Wherein, mobile type 105 refers to approval
Frozen state is received in warehouse, and mobile type 104 refers to the abatement rollback of mobile type 103, and mobile type 106 refers to moving
The abatement rollback of dynamic Class1 05；In SAP, each mobile type has corresponding abatement type, like " do wrong, data
Rollback ".So in logic 104 be exactly 103 " abatement rollback ", 106 be exactly 105 " abatement rollback ".From the point of view of in business, it is
The abatement that done wrong is possible to, so logic will consider.
S8614：Compared according to each 103 material credential fields BELNR stockpile numbers calculated with lacking quantity, when the
The corresponding stockpile number of one 103 material credential fields searches the storehouse of next 103 material credential fields less than when lacking quantity
Quantity is deposited, until meeting demand；
S8615：According to the 103 material credential fields BELNR and row item number field BUZEI found, adjusted using mobile type 105
Transferred items with BAPI interfaces；
Quantity for quality inspection stock is determined and transferred items including following sub-step：
S8621：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, inspection lot field PRUEFLOS is found and in QAMB in the connection QAMB tables of inspection lot and material voucher
The value of reftype field TYP in table between inspection lot and material voucher is 1；Then according to the inspection lot field PRUEFLOS
The thing for the use of the mobile type of decision-making field VCODE non-NULLs being 103 is found in the view QAVE tables using the inspection lot of decision-making
Expect voucher and row item number, retain the material voucher numbering found and row item number, wherein decision-making field VCODE non-NULLs represent matter
Inspection person typing quality inspection result：
（1）When can not find the i.e. reftype field TYP's of material voucher in table QAMB according to inspection lot field PRUEFLOS
During value TYP=3, it is determined as that non-quality inspection is transferred items, wherein, TYP=3 are expressed as the material voucher that quality inspection is transferred items；
（2）When material voucher can be found in table QAMB according to inspection lot field PRUEFLOS, according to the material voucher of reservation
Numbering, find all material credential fields BELNR, row item number field BUZEI and corresponding mobile type field BWART,
Amount field WESBS；And calculate stock-shifting of the stock-mobile type 104 for the stockpile number=mobile type 103 freezed of receiving
The stock of stock-mobile type 124 of stock+mobile type 106 of dynamic Class1 05, by material voucher number sorting；Mobile class
Type 124 represents to return goods；
S8622：Compared according to the stockpile number that each 103 voucher is calculated with lacking quantity, when first 103 material voucher pair
The stockpile number answered searches the stockpile number of next 103 material voucher less than when lacking quantity, until meeting demand；
S8623：Inspection lot field PRUEFLOS according to finding calls BAPI interfaces to transfer items.
S6：Output report, implementing result is shown.
Wherein, above step can be realized by transaction code SM37.
More preferably, in the present embodiment, described method is further comprising the steps of after implementing result is shown：
S7：If the work order in certain time still has difference to lack, procurement staff urges goods at once.
More preferably, in the present embodiment, the result of described report output includes：Sales order, sales order row project,
Produce order, factory, production order Start Date, reserved numbering, reserved row item number, COM code, material description, aggregate demand
Quantity, quantity issued, net demand quantity, available stock quantity, lack quantity, 103 receive the stock freezed, stock locations,
Batch.
Claims (5)
1. a kind of method thawed automatically according to work order demand based on SAP, it is characterised in that：Perform at regular intervals following
Step：
S1：The basic date is set, and with basic date+N days for scope, in removal search SAP system, Date Required is within this range
Produce order；
S2：The material and quantity required of independent demand, are compared with the unrestricted stock in stock during crawl production order is reserved, when
When stock can not meet demand, to step S3；
S3：All merchandiser purchase orders for meeting work order correspondence sales order are searched, and list the buying of wherein mobile type 103
Order is received to the stock of frozen state；
S4：With first in first out, the purchase order of mobile type 103 is received into the stock of frozen state storage voucher most
Early stock takes out successively, until need satisfaction；
S5：Judge whether material needs inspection, if need not examine, directly invoke BAPI interfaces and transfer items；If desired
During inspection, judge whether corresponding inspection lot has recorded result, the data are excluded if input result is not done, BAPI is called if having
Interface, its qualified quantity is transferred items；
S6：Output report, implementing result is shown.
2. a kind of method thawed automatically according to work order demand based on SAP according to claim 1, it is characterised in that：
Described method is further comprising the steps of after implementing result is shown：
S7：If the work order in certain time still has difference to lack, procurement staff urges goods at once.
3. a kind of method thawed automatically according to work order demand based on SAP according to claim 1, it is characterised in that：
Step S3 ~ S6 includes following sub-step：
S81：According to work order information, the account in association order AFPO tables and buying voucher sets the corresponding field of EKKN tables,
Described corresponding field includes O/No., row item number and COM code；
S82：Exclude the corresponding all row projects of purchase order for deleting that identification field LOEKZ is non-NULL in EKKN tables；
S83：Exclude to delete identification field LOEKZ in buying voucher project EKPO tables or deliver goods and completed in identification field ELIKZ
Any one is the purchase order and row project of non-NULL；
S84：EKPO tables are inquired about, only reservation subject distribution classification field KNTTP is M and international trade condition field INCO2 is extension
The purchase order and row project of account；Wherein, it is designated sale order that subject distribution classification field KNTTP is expressed as buying order for M
's；
S85：According to the purchase order of reservation and row project, searched in buying voucher history EKBE tables, obtain all materials
Voucher numbering LFBNR and row item number BUZEI；；
S86：Non- quality inspection stock and the quantity of the quality inspection stock of mobile type 103 respectively to mobile type 103 be determined and
Transfer items, wherein the quantity for non-quality inspection stock is determined and transferred items including following sub-step：
S8611：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, is retained in QAMB tables and can not find inspection lot field PRUEFLOS and inspection lot and thing in QAMB tables
The value for expecting the reftype field TYP between voucher is 1 material voucher numbering and row item number, and wherein TYP value is equal to 1 expression
For the material voucher set up according to document；
S8612：Numbered according to the material voucher of reservation, all material credential fields BELNR, row item number are found in EKBE tables
Field BUZEI and corresponding mobile type field BWART, amount field WESBS；
S8613：Calculate stock-mobile type of the stock-mobile type 104 for stockpile number=mobile type 103 that harvest is freezed
The stock of 105 stock+mobile type 106, and according to material voucher number sorting；Wherein, mobile type 105 refers to approval
Frozen state is received in warehouse, and mobile type 104 refers to the abatement rollback of mobile type 103, and mobile type 106 refers to moving
The abatement rollback of dynamic Class1 05；
S8614：Compared according to each 103 material credential fields BELNR stockpile numbers calculated with lacking quantity, when first
The corresponding stockpile number of 103 material credential fields searches the inventory of next 103 material credential fields less than when lacking quantity
Amount, until meeting demand；
S8615：According to the 103 material credential fields BELNR and row item number field BUZEI found, adjusted using mobile type 105
Transferred items with BAPI interfaces；
Quantity for quality inspection stock is determined and transferred items including following sub-step：
S8621：According to step S85 obtained material voucher numbering LFBNR and row item number BUZEI, inquiry inspection lot and material
The connection table QAMB of voucher, inspection lot field PRUEFLOS is found and in QAMB in the connection QAMB tables of inspection lot and material voucher
The value of reftype field TYP in table between inspection lot and material voucher is 1；Then according to the inspection lot field PRUEFLOS
The thing for the use of the mobile type of decision-making field VCODE non-NULLs being 103 is found in the view QAVE tables using the inspection lot of decision-making
Expect voucher and row item number, retain the material voucher numbering found and row item number, wherein decision-making field VCODE non-NULLs represent matter
Inspection person typing quality inspection result：
（1）When can not find the i.e. reftype field TYP's of material voucher in table QAMB according to inspection lot field PRUEFLOS
During value TYP=3, it is determined as that non-quality inspection is transferred items, wherein, TYP=3 are expressed as the material voucher that quality inspection is transferred items；
（2）When material voucher can be found in table QAMB according to inspection lot field PRUEFLOS, according to the material voucher of reservation
Numbering, find all material credential fields BELNR, row item number field BUZEI and corresponding mobile type field BWART,
Amount field WESBS；And calculate stock-shifting of the stock-mobile type 104 for the stockpile number=mobile type 103 freezed of receiving
The stock of stock-mobile type 124 of stock+mobile type 106 of dynamic Class1 05, by material voucher number sorting；Mobile class
Type 124 represents to return goods；
S8622：Compared according to the stockpile number that each 103 voucher is calculated with lacking quantity, when first 103 material voucher pair
The stockpile number answered searches the stockpile number of next 103 material voucher less than when lacking quantity, until meeting demand；
S8623：Inspection lot field PRUEFLOS according to finding calls BAPI interfaces to transfer items.
4. a kind of method thawed automatically according to work order demand based on SAP according to claim 1, it is characterised in that：
The result of described report output includes：Sales order, sales order row project, production order, factory, production order start day
Phase, reserved numbering, reserved row item number, COM code, material description, aggregate demand quantity, quantity issued, net demand quantity,
Available stock quantity, lack quantity, 103 receive the stock freezed, stock locations, batch.
5. a kind of method thawed automatically according to work order demand based on SAP according to claim 1, it is characterised in that：
The described setting basic date includes the date based on automatic set Date.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710607719.5A CN107316174B (en) | 2017-07-24 | 2017-07-24 | SAP-based automatic unfreezing method according to work order requirements |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710607719.5A CN107316174B (en) | 2017-07-24 | 2017-07-24 | SAP-based automatic unfreezing method according to work order requirements |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107316174A true CN107316174A (en) | 2017-11-03 |
| CN107316174B CN107316174B (en) | 2020-07-28 |
Family
ID=60179234
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710607719.5A Active CN107316174B (en) | 2017-07-24 | 2017-07-24 | SAP-based automatic unfreezing method according to work order requirements |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107316174B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113537792A (en) * | 2021-07-21 | 2021-10-22 | 深圳登科云软件有限公司 | Optical communication product collaborative manufacturing platform |
| CN113762898A (en) * | 2021-09-14 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Order information processing method and device, electronic equipment and readable medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080004120A1 (en) * | 2006-06-30 | 2008-01-03 | Leviathan Entertainment, Llc | Management and Protection of Creative Works in a Virtual Environment |
| CN102521326A (en) * | 2011-12-04 | 2012-06-27 | 山西太钢不锈钢股份有限公司 | Method for automatically interacting quality inspection data between manufacturing execution system (MES) and systems applications and products in data processing (SAP) system |
| CN102609806A (en) * | 2012-01-08 | 2012-07-25 | 山西太钢不锈钢股份有限公司 | Automatic water and powder deducting method of metallurgy raw materials based on check result |
| CN103021219A (en) * | 2012-11-27 | 2013-04-03 | 四川省电力公司技术技能培训中心 | Intelligent simulation system for power ERP service |
| CN204119275U (en) * | 2013-12-10 | 2015-01-21 | 中国海洋石油总公司 | Storage bar code data network transmission system |
| CN106094746A (en) * | 2016-06-08 | 2016-11-09 | 上海应用技术学院 | A kind of automobile exterior product manufacturing performs system and method |
-
2017
- 2017-07-24 CN CN201710607719.5A patent/CN107316174B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080004120A1 (en) * | 2006-06-30 | 2008-01-03 | Leviathan Entertainment, Llc | Management and Protection of Creative Works in a Virtual Environment |
| CN102521326A (en) * | 2011-12-04 | 2012-06-27 | 山西太钢不锈钢股份有限公司 | Method for automatically interacting quality inspection data between manufacturing execution system (MES) and systems applications and products in data processing (SAP) system |
| CN102609806A (en) * | 2012-01-08 | 2012-07-25 | 山西太钢不锈钢股份有限公司 | Automatic water and powder deducting method of metallurgy raw materials based on check result |
| CN103021219A (en) * | 2012-11-27 | 2013-04-03 | 四川省电力公司技术技能培训中心 | Intelligent simulation system for power ERP service |
| CN204119275U (en) * | 2013-12-10 | 2015-01-21 | 中国海洋石油总公司 | Storage bar code data network transmission system |
| CN106094746A (en) * | 2016-06-08 | 2016-11-09 | 上海应用技术学院 | A kind of automobile exterior product manufacturing performs system and method |
Non-Patent Citations (3)
| Title |
|---|
| 崔甫荣: "基于SAP R/3的企业生产计划管理***的实现与二次开发", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 熊华: "企业ERP***实施方案设计和生产计划模块二次开发的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 王洁莉: "某电力公司SAP***物流管理子***的设计与实施", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113537792A (en) * | 2021-07-21 | 2021-10-22 | 深圳登科云软件有限公司 | Optical communication product collaborative manufacturing platform |
| CN113762898A (en) * | 2021-09-14 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Order information processing method and device, electronic equipment and readable medium |
| CN113762898B (en) * | 2021-09-14 | 2024-04-16 | 北京沃东天骏信息技术有限公司 | Order information processing method, apparatus, electronic device and readable medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107316174B (en) | 2020-07-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102819789B (en) | E-commerce SCM system | |
| Bourland et al. | Exploiting timely demand information to reduce inventories | |
| Arbulu et al. | Kanban in construction | |
| US8046273B2 (en) | System and method for purchase order creation, procurement, and controlling | |
| CN109740624A (en) | A kind of logistics supply chain needing forecasting method based on big data | |
| CN105868992A (en) | Method for managing commodity sales and warranty periods in cash register system by using auxiliary codes | |
| CN107316174A (en) | A kind of method thawed automatically according to work order demand based on SAP | |
| Bottani et al. | A model for assessing economic and environmental sustainability dimensions of a fashion supply chain and a case study | |
| Lysa et al. | Exploring the relationships between demand attitudes and the supply amount in consumer-driven supply chain for FMCG | |
| Hao et al. | Research on e-commerce distribution optimization of rice agricultural products based on consumer satisfaction | |
| Johnson et al. | The macroeconomics of NEP | |
| CN109670774A (en) | A kind of inventory's logistic management system based on Internet of Things | |
| Chen et al. | An overview of workflow management system structure in the supply chain | |
| Handayani et al. | Identification of risk event of mushroom supply chain in langsa city by SCOR method | |
| Havenga et al. | From logistics strategy to macrologistics: Imperatives for a developing world | |
| Boone et al. | The benefits of information sharing in a supply chain: An exploratory simulation study | |
| Radhakrishnan et al. | Genetic algorithm based inventory optimization analysis in supply chain management | |
| Reyes et al. | Applying lean manufacturing techniques to distribution requirements planning in ecuadorian flour industry | |
| Mehdi et al. | Efficiency of Green Supply Chain in the presence of non-discretionary and undesirable factors, using Data Envelopment Analysis | |
| Tazhibekova et al. | The role of information and digital tools in supply chain management during the Covid crisis | |
| Berkutova et al. | Scientific and Methodological Approach to the Rating of Organizations of the Russian Military-Industrial Complex Developing Civilian Manufacturing | |
| Sokolov et al. | Developing budgeting and control in throughput accounting system | |
| Далекорей et al. | CONTROLLING OF LOGISTICS PROCESSES AT THE ENTERPRISE | |
| Gelashvili | WAYS OF IMPROVEMENT OF BUSINESS PROCESSES IN THE POST AND LOGISTIC ORGANIZATION IN THE CONDITIONS OF THE COMPETITIVE MARKET | |
| Retnonigsih | The performance of apple chips supply chain management at small industry in Batu City |
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 |