SAP Upload Sales Forecast for Inventory Valuation

3
1. MD62 - Change Planned Independent Requirement
MENU PATH
Logistics> Production> Production Planning> Demand Management> PIR > Change (MD62)
Entry procedures
*. Please pay attention on “select version “
5
1. MD62 - Change Planned Independent Requirement
Entry procedures
1. 2. 3. Click select all button Click delete button Press save button
6
2. ZAP204 – Forecast Upload
Transaction Code Menu Path Objective
ZAP204 To mass upload Planned independent requirement
7
8
2. ZCSD002– Forecast Upload
Entry procedures
20
6. MCEC – Material Analysis
MENU PATH
Logistics> Production> Production Planning> LTP> Evaluations> PIS> Material (MCEC)
Entry procedures
1. Planning Scenario: 105
26
7. KSPP – Transfer Planned Activity Requirement (CN DON’T USE THIS STEP)
MENU PATH
Logistics> Production> Production Planning> LTP> Environment> Activity Requirement> Transfer to Cost Centers (KSPP)
Transaction Code Menu Path Objective
MD79 Logistics> Production> Production Planning> Demand Management> Evaluation > Excel Interface (MD79) To Display PIRs in Excel format
11
3. MD79 – Excel Interface
MENU PATH
Logistics> Production> Production Planning> Demand Management> Evaluation > Excel Interface (MD79)
Entry procedures
1. 2. 3. 4. 5. 6. Reqmts Plan: Plan requirement number Plant: 3394 Version: Z2 = Eco Plan From-To: Forecast Period Planning period: M = Month Press enter or click the button
Entry procedures
1. 2. 3. 4. 5. 6. Plant: 3394 Version: P01 Period: 1 to 12 (All year) Fiscal Year: 2016 Test Run
๏ Material/plant
7. Press execute button
Yearly Plan
9
2. ZAP204 – Forecast Upload
Entry procedures
1. If no any red color that mean the forecast is uploaded into SAP successfully
10
3. MD79 – Excel Interface
2
1. MD62 - Change Planned Independent Requirement
Transaction Code Menu Path Objective Sample Data
MD02 Logistics> Production> Production Planning> Demand Management> PIR > Change (MD62) To Change PIRs Finished Goods: C33941301JL005A0 Raw Material: C33940101GX45014
13
4. MS01 – Long Term Planning Run
Transaction Code Menu Path Objective
MS01 Logistics> Production> Production Planning> LTP> LTP> Planning Run> Online (MS01) To Execute Long Term Planning (Online)
1. Plant: 3394 2. Updated date: Planning period(must the same as excel ) 3. Period: Monthly 4. File name: Text file in PC 5. Test run: If tick, then it just only simulate 6. Press execute button Data Template
17
5. MS70 – Transfer data to LIS
MENU PATH
Logistics> Production> Production Planning> LTP> Evaluations> PIS> Setup Data (MS70)
Entry procedures
1. Planning Scenario: 105 2. Version: 000
2. 3. 4. 5. 6.
๏ .Record
.:3394 Plant: 3394 Month: Press Execute button
Sample raw material : C33940101GX45014
21
Entry procedures
Report will display by Material: 1. PO value: It is the total value for the all year. 2. Order quantity: It is the total quantity for the all year 3. PO price: PO value / Order quantity
4
1. MD62 - Change Planned Independent Requirement
Entry procedures
1. Select Requirement Plan number that you need to Clear data. 2. Press enter or click the button
3. ๏ .Record
4. 4. 5.
Exchange rate type: M ⃞ Test session Press execute button
18
To Transfer estimated price from LTP to Operation Planning (LIS)
Transaction Code Menu Path Objective
KSPP Logistics> Production> Production Planning> LTP> Environment> Activity Requirement> Transfer to Cost Centers (KSPP) To Transfer Planned quantity from LTP to Activity
14
4. MS01 – Long Term Planning Run
MENU PATH
Logistics> Production> Production Planning> LTP> LTP> Planning Run> Online (MS01)
Entry procedures
1. 2. 3. 4. 5. 6. 7. 8. Planning Scenario: 105 Plant: 3394 Processing key: NEUPL Create MRP list: 1 Planning mode: 3 Scheduling: 2 Include firm planned orders: 1 Press enter or click button
II. Part: PPC Dept.
4. 5. 6. MS01 : Long Term Planning Run in Foreground MS70 : Transfer data to LIS MCEC : Material Analysis
III. CO Dept.
7. ZAMM002 : Slow Moving Inventory Valuation
9.
Confirm again to run MRP
15
MS04 Display LTP result
16
5. MS70 – Transfer data to LIS
Transaction Code Menu Path Objective
MS70 Logistics> Production> Production Planning> LTP> Evaluations> PIS> Setup Data (MS70) To Transfer estimated price from LTP to Operation Planning (LIS)
Sample raw : C33940101GX45014
22
6. MCEC – Material Analysis
23
6. MCEC – Material Analysis
24
6. MCEC – Material Analysis
25
7. KSPP – Transfer Planned Activity Requirement
1. 2. 3. 4. Plant: 3394 Version: Z2 = Long Term Click execute button Choose Table in next screen
12
3. MD79 – Excel Interface
Entry procedures
1. We can see all the FG requirements in excel format here
Upload Sales Forecast & Inventory Valuation
09th of Sep, 2016 Localize to CN JAMES
Contents
I.
Part: Sales Dept.
1. 2. 3. MD62 : Change/Clean Planned Independent Requirement ZAP204 : Forecast Upload (CN: ZCSD002) MD79 : Excel Interface
19
6. MCEC – Material Analysis
Transaction Code Menu Path Objective
Hale Waihona Puke MCEC Logistics> Production> Production Planning> LTP> Evaluations> PIS> Material (MCEC) To Evaluate Purchasing Volume by Material for each scenario