There are two queries on same infoprovider (ODS). The report contains the following fields.
Plant, Profit center, Sales document, Item, Created on, Sales Document type, Status, Shipment complete In, Original Comm. PGI Date, Orig Cust Reg PGI Date, Last Act GI. Date, Material, Ship to party, order quantity, Total PGI Qty, Total Deliveries PGI, Early/Ontime PGI Qty, Late PGI Qty, Remaining Open Qty, open days past due, Early/ontime indicator, Late indicator.
For SO's: Service level - Sales Item View [CusReq Revised] - Detail
For STO's: Source OnTime Delivery - (Agreed / Stat Date) [Detail]
I ran the report by using Analyzer in excel sheet by the following fields. In this, if the material is delivered late, it is not showing ‘1’ in the Late indicator field.
Thanks in Advance,