Solution : https://service.sap.com/sap/support/notes/1587897 (SAP Service marketplace login required)
Summary :
An issue has been identified with incorrect SQL generation when executing a left outer join on multiple InfoCubes within an SAP BW InfoSet. This erroneous behavior is due to a program glitch. To address this, users of SAP NetWeaver BW versions 7.00, 7.01, 7.02, 7.11, and 7.30 should import the prescribed Support Packages corresponding to their specific version. Comprehensive details for each Support Package can be found in associated SAP Notes. If an immediate remedy is required, users may implement advance correction instructions after consulting SAP Note 875986 on transaction SNOTE usage.
Key words :
preliminary version sapbwnews nw bw 7, sap netweaver business warehouse 7, preliminary version sapbinews nw 7, solution sap netweaver bw 7, sapbwnews nw bw 7, sap nw bw 7, sap netweaver bw 7, strange invalid sql, left outer join, sap notes mentioned
Related Notes :
| 1583516 | SAPBWNews NW BW 7.30 ABAP SP4 |
| 1581709 | BW InfoSet with InfoCube and LEFT OUTER join |
| 1581161 | SAPBWNews NW BW 7.02 ABAP SP09 |
| 1567706 | SAPBWNews NW7.0 BW ABAP Support Package 27 |
| 1510977 | Prelimenary Version SAPBWNews NW BW 7.11 ABAP SP08 |