Solution : https://service.sap.com/sap/support/notes/730373 (SAP Service marketplace login required)
Summary :
When using "Calendar day" as a delta-relevant field in SAP BW for delta load operations, it is imperative to consider the potential data omissions due to the timing of the data updates in the source table. The system sets the status of the delta-relevant field to the current date at the time of extraction, excluding any data added to the source table with the same date post-extraction. It is advisable to use a time stamp field if available, as it provides more accurate and comprehensive data capture for subsequent updates. Adjusting the security interval's lower limit can allow more flexibility in capturing same-day records.
Key words :
adequate time stamp field, delta-relevant field matches, delta-relevant field, provide additional information, delta-relevant fields, transfer duplicate records, individual duplicate records, calendar day type, current day minus, delta load operation
Related Notes :
| 1607601 | FAQ: Delta Errors |
| 622491 | Filling delta fields (consulting note for the generic delta) |
| 595378 | Delta on calendar day: Lower limit calculated incorrectly |
| 539547 | Generic delta with date does not work |