BI-Dhananjay - 2018-01-10 - 74366 - Break Fix - INV600 issue in Plant 0510 (Saravanan Lakshmanan by 2018-01-31) #wipdoc
BREAK FIX
74366 - INV600 issue in Plant 0510
Problem Summary
Need to fix issues in INV600 report.
Admin Info
Purpose
|
Need to fix issues in INV600 report.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
01-10-2018
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
01-31-2018
|
Document Status
|
Complete
|
Detailed Problem Description
Saravanan Requested on 01/10/2018:
User generated the INV600, we choose plant 0510 – A, then filter all the items with status C, which means true free stock sitting at the warehouse.
And we found the report showing below items, but which already mark as flagged for deletion in SAP:
MI
|
Total
|
10529761
|
16
|
10532367
|
58
|
10666216
|
5
|
11099995
|
1
|
11100083
|
8
|
11100085
|
2
|
11100086
|
5
|
11100089
|
5
|
11100093
|
3
|
11100094
|
4
|
11100095
|
7
|
11100096
|
1
|
11100128
|
4
|
11181932
|
29
|
70085378
|
2
|
70085381
|
6
|
70101083
|
24
|
70122206
|
19
|
70125188
|
72
|
70127221
|
43
|
70134394
|
22
|
70138493
|
26
|
70150794
|
134
|
70177100
|
18
|
70177103
|
15
|
70245849
|
18
|
70248015
|
7
|
80114469
|
28
|
And we also found below items appeared in the report but there’re no information showing in LX02 & MB58 after cross check with logistics team:
11182326
|
APAC CUFF KNIT SEX PISTOLS SCARLET
|
5
|
Scrap
|
11182327
|
APAC CUFF KNIT SEX PISTOLS BLACK
|
10
|
Scrap
|
11194614
|
APAC 5950 LIVE NATION SEX PISTOLS SCRLT
|
17
|
Scrap
|
11194615
|
APAC 5950 LIVE NATION SEX PISTOLS BLK
|
10
|
Scrap
|
11182325
|
APAC CUFF KNIT WU-TANG CLAN HEATHER GRAY
|
7
|
Scrap
|
Solution Analysis and Recommendations
1. Need to check the logic in report.
2. Need Analyze and propose the solutions as below:
a. The below materials already mark as flagged for deletion, this needs to be resolve using MARA table based on filter condition i.e {MARA.LVORM}<>'X'
10529761
|
10532367
|
10666216
|
11099995
|
11100083
|
11100085
|
11100086
|
11100089
|
11100093
|
11100094
|
11100095
|
11100096
|
11100128
|
11181932
|
70085378
|
70085381
|
70101083
|
70122206
|
70125188
|
70127221
|
70134394
|
70138493
|
70150794
|
70177100
|
70177103
|
70245849
|
70248015
|
80114469
|
- b. The below materials has no information in the specified Tcodes but the report brings last MRP run details, Please change MRP Type in Material Master MRP1 View from ND to PD then run MRP and Set back MRP Type as ND in the Material. This will eliminate the records in the report.(This solution is proposed by functional team)
We have bring the Qty values from J_3ADBBA.MENGE.
11182326
11182325
11182327
11194614
11194615
Resolution
1. This issue is fixed using MARA table based on filter condition i.e {MARA.LVORM}<>'X'
2. Validated the date with SAP tables successfully.
Release Information
None