Mass maintainance in MM-
1. Mass Maintainance means to change a master data or transactional data in mass
2. SAP has provided Mass Maintainance for many objects
Examples:Material masters, BOMs, Routings, Workcenters in PP
In MM --> Inforecords, PO,s Preqs etc
To do master record mass maintenance
You can use tcode MASS and then select your Object type or there is few specific mass maint. Tcode is available like for PO = MEMASSPO etc. but you can use MASS also for that you need to select the object type for PO
Tips for mass modification:
Use object type BUS1001 and generate. Then you have to know the tables where the field you want to modify is. Pick the fields in their folder and generate again. Then in selection pick the materials or use other selection criteria. Generate again.
In the upper side of the screen insert the data and click the button 'carry out a mass change'.
Save and leave.
Master records mass maintenance can be done:
Material master, info record, vendor, PO, PR, etc.
What do you mean by mass maintenance?
MASS maintenance means - suppose you want to change prticaulr field of material for all the mateirl of certian plant or all the plant you can do using mass like wise for certian PO value if you want to cahnge you can use mass.
There a lot of transactions for specific mass changes. MASS is also one of the transactions among them.
- Mass Change in material master. MM17 - Mass change in BOM. CS20 - Mass change in work center. CA85 - Mass change in Reference opn set. CA95 - Mass change in PRT. CA75
- SU10 Mass changes to User Master. - SU12 Mass Changes to User Master Records.
- CO44 Mass processing of orders. - F.80 Mass reversal of documents. - FOFO Mass release. - FOVX Mass processing of offers. - IMAM Mass maintenance of approp.requests. - KE55 Mass Maintenance PrCtr Master Data. - XD99 Customer master mass maintenance. - XK99 Mass maintenance, vendor master.
Monday, July 28, 2008
Planning & Production Alternate Plant
The planning plant and production plant are used in case of the cross plant planning. Through demand management we can plan across the plants.For each material there is a planning plant and production plant or ordering plant. The planning plant procures and stores the materials independently of orders. There are also one or more ordering plants in which the materials are used for sales orders, production orders, or for other requirements.It can be controlled through the special procurement key in MRP 2 view of the material master. - Planning plant is the plant in which you don't produce that particular plant (A) but you need them so you plan them and get produced in another plant(B). And this plant also belongs to the same orgainisation.
Now you create a special procuremnt for the Plant A and you maintain in the mateirl master.so whenever demand comes in the Plant (A) it will be planned here and the same requreiemnt will be transfered to plant b and there it will prodcued and transfered to the plant-a. - Suppose there are two plants A & B in an organisational structure. Suppose you need a material in plant A but you cannot produce it in plant A because of unavailability of resources. And these resources are available in plant B.
So you can produce the material in plant B and the requirement is thru plant A (e.g thru MRP). Here plant A becomes planning plant & plant B becomes production plant.
To carry out the actual planning and production, follow the following steps- 1) In SPRO, in the special proc key parameter's setting for plant A, mention plant B as the alternative plant.
2) Prepare the material master of the required material in plant A, in MRP 2 view maintain spl proc key as 40 (proc from alt plant) or 80 (production in alternative plant)
3) Maintain the material master in the alternative plant too. In MRP 2 maintain proc type = E. Maintain routing.
4) Carry out MRP run in plant A. If there is any demand, a STPR (spl proc key 40) or planned order (spl proc key 80) will be created in plant A. The stock requirement list will show plant B as the production plant.
5) In case of 40, a planned order will be created in plant B. In case of 80, with proper settings, the planned order in plant A after converting becomes a production order in B.
6) Carry out the production. In case of 40 the material can be sent to plant A from B thru STPO. In 80 the stock in plant A is directly updated when you hit a
Now you create a special procuremnt for the Plant A and you maintain in the mateirl master.so whenever demand comes in the Plant (A) it will be planned here and the same requreiemnt will be transfered to plant b and there it will prodcued and transfered to the plant-a. - Suppose there are two plants A & B in an organisational structure. Suppose you need a material in plant A but you cannot produce it in plant A because of unavailability of resources. And these resources are available in plant B.
So you can produce the material in plant B and the requirement is thru plant A (e.g thru MRP). Here plant A becomes planning plant & plant B becomes production plant.
To carry out the actual planning and production, follow the following steps- 1) In SPRO, in the special proc key parameter's setting for plant A, mention plant B as the alternative plant.
2) Prepare the material master of the required material in plant A, in MRP 2 view maintain spl proc key as 40 (proc from alt plant) or 80 (production in alternative plant)
3) Maintain the material master in the alternative plant too. In MRP 2 maintain proc type = E. Maintain routing.
4) Carry out MRP run in plant A. If there is any demand, a STPR (spl proc key 40) or planned order (spl proc key 80) will be created in plant A. The stock requirement list will show plant B as the production plant.
5) In case of 40, a planned order will be created in plant B. In case of 80, with proper settings, the planned order in plant A after converting becomes a production order in B.
6) Carry out the production. In case of 40 the material can be sent to plant A from B thru STPO. In 80 the stock in plant A is directly updated when you hit a
The Overall Flow For SAP PP
What are the stages in PP?
The PP flow consists of planning and execution as described.
Here is the flow of PP in simple language:
First of all demand is generated for the product to be produced through demand management. It calculated the quantities to produce and the time for the final assembly.
The data from demand management is transferred to MRP. The data from demand mgt can come from Customer Sales Order (firm) or Planned Order (forecast).
The MRP checks for the availability of material at various stages of BOM. In case material is not available MRP generated planned order and Purchase requisition for production of components in house and procurement from vendor respectively.
The planned orders are converted into production order by the planner and the purchase requisition are converted into purchase order by the purchaser.
Production in charge converts the planned order to production order and carries out the production activities once the order is released for production. Production is carried out as per the operation steps provided in the routing. Work centers are also mentioned with each operation in the routings where these operations are to be carried out.
Once the production is completed production confirmation is done and goods movement (delivery created) takes place.
Capacity planning is yet another part of PP which planes the capacities for various work centers. MPS is another tool which is used to plan out the master products. If MPS is to be run the inputs are provided from demand management to MPS. And the out put from MPS is then feed into MRP
The PP flow consists of planning and execution as described.
Here is the flow of PP in simple language:
First of all demand is generated for the product to be produced through demand management. It calculated the quantities to produce and the time for the final assembly.
The data from demand management is transferred to MRP. The data from demand mgt can come from Customer Sales Order (firm) or Planned Order (forecast).
The MRP checks for the availability of material at various stages of BOM. In case material is not available MRP generated planned order and Purchase requisition for production of components in house and procurement from vendor respectively.
The planned orders are converted into production order by the planner and the purchase requisition are converted into purchase order by the purchaser.
Production in charge converts the planned order to production order and carries out the production activities once the order is released for production. Production is carried out as per the operation steps provided in the routing. Work centers are also mentioned with each operation in the routings where these operations are to be carried out.
Once the production is completed production confirmation is done and goods movement (delivery created) takes place.
Capacity planning is yet another part of PP which planes the capacities for various work centers. MPS is another tool which is used to plan out the master products. If MPS is to be run the inputs are provided from demand management to MPS. And the out put from MPS is then feed into MRP
List of PP Transport Request and their IMG Path
1) Define Distribution Keys IMG > Production Planning for Process Industries > Master Data > Material List > Item Data > Item Data from related areas > Define Distribution Keys
2) Determine Person responsible for Resource – IMG > Production Planning for Process Industries > Master Data > Resource > General Data > Determine Person responsible
3Define Planner Group- IMG > Production Planning for Process Industries > Master Data > Master Recipe > Define Capacity Planner
4) Define Capacity Planner – IMG > Production Planning for Process Industries > Master Data > Resource > Capacity Requirement Planning > Determine Capacity Planner
5) Determine Standard Value Parameter – IMG > Production Planning for Process Industries > Master Data > Resource > General Data > Standard Value > Define Parameter
6) Define Setup Groups and Setup Group Categories Define set up groups and set up categories – IMG > Production Planning for Process Industries > Master Data > Master Recipe > Data for operations and phases > Define set up groups and set up group categories
7) Define copy setting between plants-Process IMG > Production Planning for Process Industries > Process Management > Tools > Define copy setting between plants
8) Define Set Up Control Recipe destination – IMG > Production Planning for Process Industries > Process Management > Control Recipe/PI sheet > Set up control recipe destination
9Define MRP controller – IMG > Material Management > Consumption based Planning > Master Data > Define MRP controller 10) Special Procurement – IMG > Material Management > Consumption based Planning > Master Data > Define Special procurement types
11) Define Floats (Scheduled Margin Key)- IMG > Material Management > Consumption based Planning > Planning > Define Floats (Scheduled Margin Key)
12Define Splitting of Forecast requirements for MRP- IMG > Material Management > Consumption based Planning > Evaluation > Forecast > Define Splittng of forecast requirements of MRP
13) Maintain Correction Factors for Forecast IMG > Material Management > Consumption based Planning > Planning > Procurement > Maintain Correction factors for forecast
14 Carry Out Overall Maintenance of Plant Parameters Maintaining plant parameters in MRP – IMG > Material Management > Consumption based Planning > Plant Parameters > Carry out overall maintenance of plant parameters
15) Define Planning Horizon Define Planning Horizon – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Define Planning Horizon
16) Activate Requirement Planning – IMG > Material Management > Consumption based Planning > Planning > Activate Requirement Planning
17) Define Range of Coverage Profiles (Dynamic Safety Stock) Range of coverage profile – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Define range of coverage profile (Dynamic Safety Stock)
18) Define Stock in Transfer and Blocked Stock Availability IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Stocks > Define Stock in transfer and blocked stock
19) Define MRP Areas IMG > Material Management > Consumption based Planning > Master Data > MRP areas > Define MRP areas
20) Carry out maintenance of MRP groups IMG > Material Management > Consumption based Planning > MRP groups> Carry out maintenance of MRP groups
21) Define Scope of total Planning - MRP IMG > Material Management > Consumption based Planning > Planning > Define Scope of total Planning
22 Define Order Types Define Order Type- IMG > Production Planning for Process Industries > Process Order > Master Data > Order > Define Order Type
23Define Order Type Dependent parameters – IMG > Production Planning for Process Industries > Process Order > Master Data > Order > Define Order Type Dependent parameters
24) Define Production Scheduler – IMG > Production Planning for Process Industries > Process Order > Master Data > Bill of Material > Define Production Scheduler
25 Define Checking Control - Process Order Define Availability Check – Define Checking Control – IMG > Production Planning for Process Industries > Process Order > Operations > Availabilty Check > Define Checking Control
26) Define Checking Rule for backorder processing – IMG > Production Planning for Process Industries > Process Order > Operations > Availabilty Check > Define Checking rule for back order processing
27Define Stock and batch determination for good movement – IMG > Production Planning for Process Industries > Process Order > Operations > Define Stock and batch determination for good movement
28) Specify Scheduling Parameters Specify Scheduling Parameters – IMG > Production Planning for Process Industries > Process Order > Operations > Scheduling > Specify Scheduling Parameters
29) Define Reduction Strategies Define Reduction Strategy – IMG > Production Planning for Process Industries > Process Order > Operations > Scheduling > Resource data > Define Reduction Strategy
30) Define Confirmation Parameters Define Order Confirmation – IMG > Production Planning for Process Industries > Process Order > Operations > Confirmation > Define Confirmation Parameters
31) Define Valuation of Goods Received Define valuation of goods receive – IMG > Production Planning for Process Industries > Process Order > Integration > Define Valuation of goods received
32) MRP creation indicator – IMG > Material Management > Consumption based Planning > Planning > Define creation indicator
33) Define safety stock – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Stocks > Define Safety Stocks
34) Define alternative determination of Production – IMG > Production Planning for Process Industries > Process Order > Operations > BOM selection > Define alternate determination of production
35) Define no. ranges – IMG > Production Planning for Process Industries > Process Order > Master data > Order > Number Ranges > Define number ranges for orders
2) Determine Person responsible for Resource – IMG > Production Planning for Process Industries > Master Data > Resource > General Data > Determine Person responsible
3Define Planner Group- IMG > Production Planning for Process Industries > Master Data > Master Recipe > Define Capacity Planner
4) Define Capacity Planner – IMG > Production Planning for Process Industries > Master Data > Resource > Capacity Requirement Planning > Determine Capacity Planner
5) Determine Standard Value Parameter – IMG > Production Planning for Process Industries > Master Data > Resource > General Data > Standard Value > Define Parameter
6) Define Setup Groups and Setup Group Categories Define set up groups and set up categories – IMG > Production Planning for Process Industries > Master Data > Master Recipe > Data for operations and phases > Define set up groups and set up group categories
7) Define copy setting between plants-Process IMG > Production Planning for Process Industries > Process Management > Tools > Define copy setting between plants
8) Define Set Up Control Recipe destination – IMG > Production Planning for Process Industries > Process Management > Control Recipe/PI sheet > Set up control recipe destination
9Define MRP controller – IMG > Material Management > Consumption based Planning > Master Data > Define MRP controller 10) Special Procurement – IMG > Material Management > Consumption based Planning > Master Data > Define Special procurement types
11) Define Floats (Scheduled Margin Key)- IMG > Material Management > Consumption based Planning > Planning > Define Floats (Scheduled Margin Key)
12Define Splitting of Forecast requirements for MRP- IMG > Material Management > Consumption based Planning > Evaluation > Forecast > Define Splittng of forecast requirements of MRP
13) Maintain Correction Factors for Forecast IMG > Material Management > Consumption based Planning > Planning > Procurement > Maintain Correction factors for forecast
14 Carry Out Overall Maintenance of Plant Parameters Maintaining plant parameters in MRP – IMG > Material Management > Consumption based Planning > Plant Parameters > Carry out overall maintenance of plant parameters
15) Define Planning Horizon Define Planning Horizon – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Define Planning Horizon
16) Activate Requirement Planning – IMG > Material Management > Consumption based Planning > Planning > Activate Requirement Planning
17) Define Range of Coverage Profiles (Dynamic Safety Stock) Range of coverage profile – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Define range of coverage profile (Dynamic Safety Stock)
18) Define Stock in Transfer and Blocked Stock Availability IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Stocks > Define Stock in transfer and blocked stock
19) Define MRP Areas IMG > Material Management > Consumption based Planning > Master Data > MRP areas > Define MRP areas
20) Carry out maintenance of MRP groups IMG > Material Management > Consumption based Planning > MRP groups> Carry out maintenance of MRP groups
21) Define Scope of total Planning - MRP IMG > Material Management > Consumption based Planning > Planning > Define Scope of total Planning
22 Define Order Types Define Order Type- IMG > Production Planning for Process Industries > Process Order > Master Data > Order > Define Order Type
23Define Order Type Dependent parameters – IMG > Production Planning for Process Industries > Process Order > Master Data > Order > Define Order Type Dependent parameters
24) Define Production Scheduler – IMG > Production Planning for Process Industries > Process Order > Master Data > Bill of Material > Define Production Scheduler
25 Define Checking Control - Process Order Define Availability Check – Define Checking Control – IMG > Production Planning for Process Industries > Process Order > Operations > Availabilty Check > Define Checking Control
26) Define Checking Rule for backorder processing – IMG > Production Planning for Process Industries > Process Order > Operations > Availabilty Check > Define Checking rule for back order processing
27Define Stock and batch determination for good movement – IMG > Production Planning for Process Industries > Process Order > Operations > Define Stock and batch determination for good movement
28) Specify Scheduling Parameters Specify Scheduling Parameters – IMG > Production Planning for Process Industries > Process Order > Operations > Scheduling > Specify Scheduling Parameters
29) Define Reduction Strategies Define Reduction Strategy – IMG > Production Planning for Process Industries > Process Order > Operations > Scheduling > Resource data > Define Reduction Strategy
30) Define Confirmation Parameters Define Order Confirmation – IMG > Production Planning for Process Industries > Process Order > Operations > Confirmation > Define Confirmation Parameters
31) Define Valuation of Goods Received Define valuation of goods receive – IMG > Production Planning for Process Industries > Process Order > Integration > Define Valuation of goods received
32) MRP creation indicator – IMG > Material Management > Consumption based Planning > Planning > Define creation indicator
33) Define safety stock – IMG > Material Management > Consumption based Planning > Planning > MRP calculation > Stocks > Define Safety Stocks
34) Define alternative determination of Production – IMG > Production Planning for Process Industries > Process Order > Operations > BOM selection > Define alternate determination of production
35) Define no. ranges – IMG > Production Planning for Process Industries > Process Order > Master data > Order > Number Ranges > Define number ranges for orders
PP Year End To Do List
These are the activities we have defined for ALL areas including PP and they are in addition to your normal month end closing:
1. Create new material document number ranges for the new year.
2. Generate period rules for Asset Accounting.
3. Do Asset Accounting year end close and Fiscal year change.
4. Roll all A/R and A/P balances.
5. Close out all nominal / P&L accounts in accounting.
6. Enter all cost center budgets for the new year.
7. Enter new standard costs for your materials for January 1 of the new year.
8. Maintain the planning for your activity type used in your work centers for the new year (otherwise you will not be able to do confirmations in the new year.)
9. Create calendar for new year.
1. Create new material document number ranges for the new year.
2. Generate period rules for Asset Accounting.
3. Do Asset Accounting year end close and Fiscal year change.
4. Roll all A/R and A/P balances.
5. Close out all nominal / P&L accounts in accounting.
6. Enter all cost center budgets for the new year.
7. Enter new standard costs for your materials for January 1 of the new year.
8. Maintain the planning for your activity type used in your work centers for the new year (otherwise you will not be able to do confirmations in the new year.)
9. Create calendar for new year.
Compare Production Confirmation against Planned by Work Centre
Compare Production Confirmation against Planned by Work Centre*REPORT ZASSEMBLY_EFFICIENCY LINE-SIZE 255 NO STANDARD PAGE HEADING LINE-COUNT 065(001).TABLES: AFKO, "Order header data PP orders AFPO, "Order item AFRU, "Order completion confirmations AUFM, "Goods movements for order AFVV, "DB structure of the quantities/dates/values in the oper MARA. "General Material DataDATA: BEGIN OF INT_EFF OCCURS 100, MATNR TYPE AFKO-STLBEZ, MTART TYPE MARA-MTART, AUFNR TYPE AFKO-AUFNR, GSTRI TYPE AFKO-GSTRI, GLTRI TYPE AFKO-GLTRI, GAMNG(9) TYPE C, MENGE(9) TYPE C, PLN01(9) TYPE C, ISM01(7) TYPE P DECIMALS 2, DAUAT TYPE AFPO-DAUAT, END OF INT_EFF.DATA: FDATE LIKE SY-DATUM, LDATE LIKE SY-DATUM.DATA: YGAMNG(7) TYPE P DECIMALS 2, YMENGE(7) TYPE P DECIMALS 2, YPLN01(7) TYPE P DECIMALS 2, XMENGE(7) TYPE P DECIMALS 0, XSTDRATE(7) TYPE P DECIMALS 2, XACTRATE(7) TYPE P DECIMALS 2, XLINEEFF(7) TYPE P DECIMALS 2, XUTILISA(7) TYPE P DECIMALS 2.SELECT-OPTIONS XWERKS FOR AFRU-WERKS DEFAULT 'SAP'.SELECT-OPTIONS XBUDAT FOR AFRU-BUDAT.SELECT-OPTIONS XAUFNR FOR AFRU-AUFNR.START-OF-SELECTION.SELECT * FROM AFRU WHERE BUDAT IN XBUDAT AND WERKS IN XWERKS AND AUFNR IN XAUFNR. CLEAR AFPO. SELECT SINGLE * FROM AFPO WHERE AUFNR = AFRU-AUFNR. CLEAR AFKO. SELECT SINGLE * FROM AFKO WHERE AUFNR = AFRU-AUFNR. CLEAR MARA. SELECT SINGLE * FROM MARA WHERE LVORM = '' AND MATNR = AFKO-STLBEZ. CLEAR AFVV. SELECT SINGLE * FROM AFVV WHERE AUFPL = AFRU-AUFPL AND APLZL = AFRU-APLZL. IF AFVV-VGE01 = 'MIN'. AFVV-VGW01 = AFVV-VGW01 / 60. ENDIF. PERFORM GET_DATA_AUFM. PERFORM GET_DATA.ENDSELECT.PERFORM LOOP_INT_EFF.END-OF-SELECTION.FORM GET_DATA.* Reverse Confirmation IF AFRU-STOKZ = 'X'. MULTIPLY AFRU-LMNGA BY -1. MULTIPLY AFRU-ISM01 BY -1. MULTIPLY AFRU-ISM02 BY -1. MULTIPLY AFRU-ISM03 BY -1. MULTIPLY AFRU-ISM04 BY -1. MULTIPLY AFKO-GAMNG BY -1. MULTIPLY AFVV-BMSCH BY -1. MULTIPLY AFVV-VGW01 BY -1. MULTIPLY AFVV-VGW02 BY -1. MULTIPLY AFVV-VGW03 BY -1. ENDIF.* Plan Activities IF AFVV-BMSCH <> 0. INT_EFF-PLN01 = ( AFKO-GAMNG / AFVV-BMSCH ) * AFVV-VGW01 * 60. ENDIF.* Actual Activities INT_EFF-ISM01 = AFRU-ISM01.* Material No. IF AFKO-PLNBEZ = SPACE. INT_EFF-MATNR = AFKO-STLBEZ. ELSE. INT_EFF-MATNR = AFKO-PLNBEZ. ENDIF. INT_EFF-MTART = MARA-MTART. INT_EFF-AUFNR = AFKO-AUFNR. INT_EFF-GSTRI = AFKO-GSTRI. INT_EFF-GLTRI = AFKO-GLTRI. INT_EFF-GAMNG = AFKO-GAMNG. INT_EFF-MENGE = XMENGE. INT_EFF-DAUAT = AFPO-DAUAT. COLLECT INT_EFF. CLEAR INT_EFF.ENDFORM.FORM GET_DATA_AUFM. CLEAR XMENGE. SELECT * FROM AUFM WHERE AUFNR = AFKO-AUFNR AND BWART IN ('101', '102'). IF AUFM-SHKZG = 'H'. MULTIPLY AUFM-MENGE BY -1. ENDIF. ADD AUFM-MENGE TO XMENGE. ENDSELECT.ENDFORM.FORM LOOP_INT_EFF. LOOP AT INT_EFF. CLEAR: XSTDRATE, XACTRATE, XLINEEFF, XUTILISA. IF INT_EFF-PLN01 <> 0. XSTDRATE = INT_EFF-MENGE / INT_EFF-PLN01. ENDIF. IF INT_EFF-ISM01 <> 0. XACTRATE = INT_EFF-MENGE / INT_EFF-ISM01. XUTILISA = INT_EFF-PLN01 - INT_EFF-ISM01. ENDIF. IF XSTDRATE <> 0. XLINEEFF = XACTRATE / XSTDRATE. ENDIF. YGAMNG = INT_EFF-GAMNG. YMENGE = INT_EFF-MENGE. YPLN01 = INT_EFF-PLN01. WRITE:/ INT_EFF-MATNR UNDER ' Material', INT_EFF-MTART UNDER ' Matl', INT_EFF-AUFNR UNDER 'Production', INT_EFF-GSTRI UNDER 'Start', INT_EFF-GLTRI UNDER ' Finish', YGAMNG UNDER 'Production Ord', YMENGE UNDER ' Receipt Qty', YPLN01 UNDER ' Plan Hr', INT_EFF-ISM01 UNDER ' Actual Hr', XSTDRATE UNDER ' Std Rate', XACTRATE UNDER ' Actual Rate', XLINEEFF UNDER 'Efficiency (%)', XUTILISA UNDER 'Utilisation Typ', INT_EFF-DAUAT UNDER 'PP Type'. ENDLOOP.ENDFORM.TOP-OF-PAGE.FORMAT COLOR COL_TOTAL. WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, 110 'Assembly Line Efficiency Report - Closed (Period)', 200 SY-UNAME, SY-PAGNO. SKIP. WRITE: /1 ' Material', 20 ' Matl', 25 'Production', 36 'Start', 47 ' Finish', 58 'Production Ord', 73 ' Receipt Qty', 88 ' Plan Hr', 103 ' Actual Hr', 118 ' Std Rate', 133 ' Actual Rate', 148 'Efficiency (%)', 163 'Utilisation Typ', 179 'PP Type'.INITIALIZATION. LDATE = SY-DATUM. LDATE+6(2) = '01'. LDATE = LDATE - 1. FDATE = LDATE. FDATE+6(2) = '01'. MOVE: FDATE TO XBUDAT-LOW, LDATE TO XBUDAT-HIGH. APPEND XBUDAT.
Production Planning - Extract data from MRP Table
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*
* A sample program to extract data from the MRP table.
*
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REPORT ZMRPTABLE.
TABLES: MDKP, "Header Data for MRP Document
MDTB, "MRP table
MDTC, "Aggregated MRP table items
T457T. "Description of MRP elements
DATA: BEGIN OF MDTBX OCCURS 0.
INCLUDE STRUCTURE MDTB.
DATA: END OF MDTBX.
SELECT-OPTIONS: PLANT FOR MDKP-PLWRK OBLIGATORY,
MATNR FOR MDKP-MATNR OBLIGATORY.
CLEAR: MDKP, MDTB.
SELECT * FROM MDKP WHERE DTART EQ 'MD'
AND MATNR IN MATNR
AND PLWRK IN PLANT.
WRITE:/ MDKP-MATNR, MDKP-PLWRK.
IF MDKP-CFLAG EQ 'X'.
CLEAR MDTBX. REFRESH MDTBX.
IMPORT MDTBX FROM DATABASE MDTC(AR) ID MDKP-DTNUM.
LOOP AT MDTBX.
MOVE MDTBX TO MDTB.
SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.
IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.
WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDLOOP.
ELSE.
SELECT * FROM MDTB
WHERE DTNUM EQ MDKP-DTNUM
ORDER BY PRIMARY KEY.
SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.
IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.
WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDSELECT.
ENDIF.
ENDSELECT.
*
* A sample program to extract data from the MRP table.
*
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REPORT ZMRPTABLE.
TABLES: MDKP, "Header Data for MRP Document
MDTB, "MRP table
MDTC, "Aggregated MRP table items
T457T. "Description of MRP elements
DATA: BEGIN OF MDTBX OCCURS 0.
INCLUDE STRUCTURE MDTB.
DATA: END OF MDTBX.
SELECT-OPTIONS: PLANT FOR MDKP-PLWRK OBLIGATORY,
MATNR FOR MDKP-MATNR OBLIGATORY.
CLEAR: MDKP, MDTB.
SELECT * FROM MDKP WHERE DTART EQ 'MD'
AND MATNR IN MATNR
AND PLWRK IN PLANT.
WRITE:/ MDKP-MATNR, MDKP-PLWRK.
IF MDKP-CFLAG EQ 'X'.
CLEAR MDTBX. REFRESH MDTBX.
IMPORT MDTBX FROM DATABASE MDTC(AR) ID MDKP-DTNUM.
LOOP AT MDTBX.
MOVE MDTBX TO MDTB.
SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.
IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.
WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDLOOP.
ELSE.
SELECT * FROM MDTB
WHERE DTNUM EQ MDKP-DTNUM
ORDER BY PRIMARY KEY.
SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.
IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.
WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDSELECT.
ENDIF.
ENDSELECT.
Subscribe to:
Posts (Atom)