3754287 - Physical Inventory Analysis app shows zero booked quantity and incorrect difference value signs - SAP S/4HANA Cloud Public Edition

Physical Inventory Analysis app, the “Difference Quantity” and “Difference Value” fields display only absolute differences, i.e., without a sign (no negative values). Also, it shows shows zero booked quantity.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP S/4HANA Cloud Public Edition

1. Open Physical Inventory Analysis app,
2. Press Adapt Filters and select Storage Location;
3. Press Ok; 
4. Enter any warehouse managed storage location.
5. Press Go;
6. Add the following as rows:
   1. Plant;
   2. Material document;
   3. Movement type.
7. Add the following as columns:
   1. Book value;
   2. Difference value;
   3. Book quantity;
   4. Counted quantity.

Physical inventory documents generated with regards to Warehouse Managed Storage Locations are not supported. The app 'Physical Inventory Analysis' is taking the data from the PI table ISEG, however PI Documents referring to "warehouse managed storage locations" show the Book Qty as 0.00 for all PI documents regardless of whether it’s a GR / GI posting, thus displaying all values as a plus even though we posted a goods issue.

Use Warehouse monitor app.

Warehouse, physical inventory analysis, booked quantity, counted quantity, negative sign, positive sign, 702, 701, 711, 712 , KBA , MM-IM-GF-2CL , Basic Functions (Public Cloud) , Known Error