Solution : https://service.sap.com/sap/support/notes/1435772 (SAP Service marketplace login required)
Summary :
For InfoSets utilizing left outer joins with providers, issues arise when INCLUDING conditions (LT, LE, NE, NB) do not account for possible NULL values, which are inherent to left outer joins. Columns within these joins no longer permit EXCLUDING conditions owing to incorrect previous usage and technical handling of NULL values in SAP (all columns default to NOT NULL). The system will display error message 807 for violations. Solution involves implementing correction via Note 1434241 and corresponding Support Packages detailed in various other SAP Notes, ensure to reference Note 875986 for transaction SNOTE guidance.
Key words :
left outer join tables, sap concept null values, left-outer-join, left outer join, left outer joins, sap netweaver bw 7, sap nw bw 7, null default values, sapbinews nw bi 7, including conditions lt
Related Notes :
| 1500161 | BW query on InfoSet with LEFT OUTER join terminates |
| 1434241 | InfoSet with InfoCube with several navigation attributes |
| 1431124 | SAPBWNews NW BW 7.02 ABAP SP04 |
| 1419541 | Preliminary version SAPBWNews NW BW 7.10 ABAP SP10 |
| 1407599 | Preliminary Version SAPBWNews NW BW 7.20 ABAP SP03 |
| 1407598 | SAPBWNews NW BW 7.0 ABAP SP 24 |
| 1392433 | SAPBINews NW7.11 BW ABAP Support Package 05 |
| 1369294 | SAPBINews NW7.01 BW ABAP Support Package 07 |