Solution : https://service.sap.com/sap/support/notes/1548125 (SAP Service marketplace login required)
Summary :
In SAP systems, non-cumulative key figures like 0TOTALSTCK are computed at query runtime because they are not stored in the fact tables directly. Instead, these figures rely on cumulative inflows and outflows (using key figures such as 0ISSTOTSTCK and 0RECTOTSTCK) to compute inventory data for specific time points. The related SAP note provides insights into this computation process and outlines how data is structured and handled during initializations and data loads. The note emphasizes the importance of understanding this process to accurately interpret query results in inventory management scenarios. Techniques like the setting of 0RECORDTP and handling reference points are detailed for effective data querying and system performance optimization.
Key words :
l-tablesid_0requid sid_0calday_f sid_0calday_t modefrom modeto-------------------------------------------------------- -1 20100504 20100507the record, /irj/sdn/howtoguides choose sap netweaver 2004 -> business intelligence ->, sid_0requid sid_0plant sid_0calday_f sid_0calday_t modefrom modeto------------------------------------------------------------------- -1 1 20100504 20100507 -1 2 20100504 20100512please note, sid_0requid sid_0calday_f sid_0calday_t modefrom modeto-------------------------------------------------------- -1 20100504 20100507 -2 0 20100510 fa query, /saphelp_nw70/helpdata/en/8f/da1640dc88e769e10000000a155106/frameset, ] validity table[iii] stock initialization & dtp[iv] data mart[, handle inventory management scenarios [ii]process flow, 0recordtp filled correctly [iv] data mart, metadata[ii] process flow [ii, special loading process called stock initialization
Related Notes :
| 1710236 | SAP HANA DXC: DataSource Restrictions |
| 1681396 | Query Performance |
| 1591837 | How to analyze query results |
| 1501907 | Non-cumulative cubes, validity interval,non-cumulative logic |
| 1479893 | BW LISTCUBE improvements |
| 590370 | Too many uncompressed request (f table partitions) |
| 589024 | Reports in BW with storage location and stock type chars. |
| 586163 | Composite Note on SAP R/3 Inventory Management in SAP BW |
| 375098 | Data mart extraction from non-cumulative InfoCubes |