ByDesign: Datasource for Production Confirmation including Scrap and reason

[Otavio]

Hello all. Can anyone share details from data source where i can get scrap quantity and details from deviation reason and created on date/time?

The Yield and Scrap reports does not work for us because we want to know scraps reported by month until the production order remains opened.

i´d tried:

SCMPOHDR_ORDSTR_RPU01 - shows the scrap that generated stock. only show if we have good product reported.

SCMPOHDROPU02 - Production Orders/Lot: Dates and Quantities - does not show any scrap because work order is in process
SCMYASU01 - shows the total scrap even if the op is not closed. BY REPORTING POINT this is the yield & scrap report but it will not work because the date filter is OP end date.
SCMPTV01 - does not show scrap
SCMPOHDREXECU01 - Production Orders By Header Execution Details - does not show scrap

Thank you

[hcai]

Dear Customer,

In data source "Yield & Scrap" (SCMYASU01), you can use other date related filters like "Requested Start Date Year Month" to filter all production lots with requested start date within a specific month, no matter the lot has been finished or not. However, this data source has a limitation: characteristic "Scrap Reason" will always display "Not assigned". The reason behind please refer to KBA: https://me.sap.com/notes/3441476

You can try to join this data source with another data source "Confirmation Journal" (SCMCFJU01) which has valid "Scrap Reason". Rule could be like "Reference Document Type" in SCMCFJU01 is "Production Lot" and "Reference Document ID" in SCMCFJU01 equals to "Production Lot ID" in SCMYASU01.

Henry

SAP Technical Support

[Otavio]

Hello Henry. I appreciate your answer, however some points won´t work:

- We need to know scrap for what was made over the month and the start date doesn´t inform it because we have delays in production and some times we anticipate some orders. 

- we need also the reason at the same time because it´s important to know what´s scraped and why over the month.

i thought to use this screen/datasource i mentioned because i can get the transaction time(production time), Scrap quantity and Reason. it´s all we need.

Use Yield and Scrap datasource show all scraps however i cannot filter by date and join with Confirmation journal won´t work too because there have only confirmations with good products reported. if i report(as showed in screen) with zero quantity and 4 scrap it won´t be on Journal.