Skip to Content
0
May 26, 2018 at 05:13 PM

Cannot generate combinations for MultiProvider (RSPLS_CR-013) for Characteristic Relationship

2652 Views

Hi All,

I am getting the error -Cannot generate combinations for MultiProvider (RSPLS_CR-013) when I execute my input ready query based on an Aggregation Level.

The AL is based on a Composite Provider. The CP contains a Direct Update DSO which is used for planning and a HANA View (actuals data).

I have created a Exit based Characteristic Relationship, that has the CREATE method implemented.

The CR is created on top of the Direct Update DSO. Source Chars are CostCenter and Controlling Area. Target Char is Emp ID.

Code for the CREATE method is as follows:

CALL METHOD seldr_to_range
EXPORTING
i_tsx_seldr = i_tsx_seldr
IMPORTING
e_t_range = lt_range.

LOOP AT lt_range INTO ls_range WHERE chanm = 'COSTCENTER'.
SELECT empid
FROM /bic/DSO
INTO table lt_emp
* FOR ALL ENTRIES IN lt_range

WHERE CC = ls_range-low(10).

IF sy-subrc EQ 0.
LOOP AT lt_emp INTO ls_emp.
ls_range_app-chanm = 'EMPID'.
ls_range_app-low = ls_emp-emp.
ls_range_app-sign = 'I'.
ls_range_app-compop = 'EQ'.
APPEND ls_range_app TO lt_range.
ENDLOOP.
ENDIF.
ENDLOOP.

Have I missed something in the Code ?

Is it correct to create the CR on the Direct Update DSO and then execute it from a query based on AL ?

Please provide your inputs.

Thanks in advance,

Amrita