Solution : https://service.sap.com/sap/support/notes/690106 (SAP Service marketplace login required)
Summary :
SAP Note addresses an issue where records with mode "R" from various DataSources (including 2LIS_02_SGR, 2LIS_02_CGR, and others) do not delete the corresponding records in target ODS (0PUR_O01, 0PUR_O02, and 0PUR_DS03). Start routines were altering the record mode from "R" to "X", initially intended to ensure all records are used for statistical analyses in InfoCubes, not for deletion purposes. The solution involves deleting or modifying these start routines to properly handle deletion records by ensuring that reverse image records contribute correctly to the overall data integrity and performance of the data warehouse. This fix is incorporated in various SAP BI Content versions, improving both data handling and system performance.
Key words :
2lis_02_itm -> 0pur_o012lis_02_sgr -> 0pur_o012lis_02_cgr -> 0pur_o012lis_02_scn -> 0pur_o012lis_02_hdr -> 0pur_o0280pur_o01 -> 0pur_o022lis_02_scl -> 0pur_ds032lis_02_sgr -> 0pur_ds03are changing, coding part>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> elseif data_package-recordmode eq 'r', deleting ods records withthe identical key, elseif comm_structure-recordmode eq 'x', comm_structure-recordmode eq 'n', start routines andall update rules, correct positiveor negative values, 0pur_c07 - 0pur_c09 key figures, deleted purchase order items, infocubes andall key figures
Related Notes :
| 654639 | Compos. note Business Content 3.1 Content Support Package 15 |
| 647749 | SAPBWNews BW 3.0B Support Package 19 |
| 614227 | Compos. note Business Content 3.2 Content Support Package 10 |