SAP Note 1583842 - Constant Selection Append used as an outer join (CSA)

Component : Analyzing Data -

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 :

1583516SAPBWNews NW BW 7.30 ABAP SP4
1581709BW InfoSet with InfoCube and LEFT OUTER join
1581161SAPBWNews NW BW 7.02 ABAP SP09
1567706SAPBWNews NW7.0 BW ABAP Support Package 27
1510977Prelimenary Version SAPBWNews NW BW 7.11 ABAP SP08
1419539SAPBWNews NW BW 7.01 ABAP SP10
944815Problems with 'Constant selection' (english version)
834996Probleme mit der Eigenschaft 'Konstante Selektion'