SAP Online Documentation
SAP Consulting Notes
The following note provides a very good and comprehensive discussion of this topic:
| 1548125 Interesting facts about Inventory Cubes |
See also
- List of other relevant SAP Notes
- Blog: BW/4HANA Reporting on alternative time dimensions without storing redundant data
Features / Topics
Troubleshooting NCum Queries
- Checking stock values with the help of transactions LISTCUBE and NCUM_CAL
- Runtime and Memory Consumption (checking query runtime statistics)
Unexpected Query Results
- NC: Unexpected Negative Stock Values (due to incorrect DTP setting)
- NC: Unexpected Movements appear in Stock Query
- NC: Unexpected Query Result when filtering on Movement Types (Using 0MOVETYPE, 0STOR_LOC or 0STOCKTYPE in Queries)
- Validity Area: Validity Interval
Ncum Queries in HANA Systems
- SAP First Guidance SAP NetWeaver 7.50 powered by SAP HANA: Inventory Handling and Non-Cumulative Key Figures in SAP BW powered by SAP HANA
- SAP First Guidance SAP BW/4HANA: Inventory Handling and Non-Cumulative Key Figures in SAP BW/4HANA
- Non-Cumulatives in Advanced DataStores: see documents above and chapter [VIII] of note 1548125
- Archiving Data from InfoProviders with Non-Cumulatives: see documents above
- 2161698 Non-Cumulatives: Pushdown of non-cumulative handling on SAP HANA
Data Mart Extraction from Non-Cumulative InfoCubes and ADSOs
- BWonHANA
- InfoCube -> InfoCube
- InfoCube → ADSO
- ADSO -> ADSO (Advanced DataStores)
- BW based on other Databases (Non-Flat InfoCubes)
- See also note 2325774
- NCUM Extraction via ODP (BW75 to BW/4Hana System)
- Extraction from Ncum QueryProvider: see Example Ncum QPROV
- BWonHANA
Miscellaneous
- Example queries are available in transaction RSFC -> Analytic Engine -> Non-Cumulatives (see also RSFC and KBA 1508237)
- NCUM: Selective Deletion
- SAP Support Guideline: BW-BEX-OT-NC