on 10-23-2015 5:33 PM
Hello Experts,
I am facing an issue with deleted sales order items showing in the BW sales report:
The data from 2LIS_11_VAITM is loading directly to i) DSO - 0SD_O01 and to ii) Infocube - 0SD_C03 cube.
In the ECC system for a sample sales order A, there are only two items eg: 30 and 40
My observations are that:
Could you please let me know how these orders can be identified or eliminated while reporting in Sales cube 0SD_C03 ?
What could be the impact of selective deletion on DSO based on Item deleted field = 'R'? Would this help?
or if I add '0ITEM_DEL' field to 0SD_C03 and map 0STORNO to capture the sales item with status 'R' and restirct this on the sales query?
I have gone through posts but they are mostly data load from DSO and cube.hence I am posting this question.
Thanks. Appreciate all the help I can get.
Regards,
Aboli
HI Aboli,
Prerequisite for a correct delta mechanism is the mapping of DataSource field ROCANCEL to InfoObject 0RECORDMODE. Please refer also to SAP Note 440679 - Processing of deleted transaction data in the ODS.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.