Skip to Content
0
Former Member
Nov 04, 2008 at 06:28 AM

Restrict Data by Reading Infocube from ABAP

35 Views

Hi SDN Community

I have written ABAP in order to read the contents of the ODS. This code is in a BADI, and against a customer exit variable that is placed in the query.

Is it possible to write similar ABAP code to query a cube

and retrieve same Funct_loc1.

Thank you.

Simon

  • Read Production Cube to determine all the Alternative Labels

  • (Functional Locations)

SELECT Funct_loc1

FROM /bic/aearo_o5000

INTO lst_range-low

WHERE /BIC/ZDATIVAR = '0000000030'

AND /BIC/ZCCFUNCCD = ls_ccfunccode

AND /BIC/ZSOURSYS = 'CQ'

AND FISCYEAR = ld_fiscyear

AND SOURSYSTEM = ls_soursystem.

lst_range-sign = 'I'.

lst_range-opt = 'EQ'.

append lst_range to e_s_export-e_t_range.

lv_count = lv_count + 1.

ENDSELECT.