Solution : https://service.sap.com/sap/support/notes/1583842 (SAP Service marketplace login required)
Summary :
After migrating from 3.X to 7.X Query Designer, the "Show unposted values" option is missing under constant selection for characteristic 0INFOPROV due to the CSA feature's use for outer joins. In release 7.00 and above, this is addressed by the "access type for result values: master data" functionality, simplifying the display of unposted values without constant selection. Users can now employ an InfoSet with DSO and BasisCube for similar functionality by modeling a left outer join and directly integrating conditions into SQL queries, bridging the gap left by the older CSA approach. Implementing note 1581709 is crucial for this setup.
Key words :
location material4712 a4712 b4712 cthe join criteria, location material startdate enddate deletiondate4712, location material calenderday keyfigure4712, slow moving item scenario, 2010 400the desired query result, left outer join, jeft outer joined, left outer joined, show unposted values, display unposted values
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 |
1419539 | SAPBWNews NW BW 7.01 ABAP SP10 |
944815 | Problems with 'Constant selection' (english version) |
834996 | Probleme mit der Eigenschaft 'Konstante Selektion' |