CI-DS list multiple items in a parameter to extract via generated ABAP to IBP

[Alistair1]

Hi,

We have a requirement to pull in product master data records based on a material type selection. 

We have 2 material types required ('HAWA' and 'FERT'). 

We place this in a parameter called $PARAM1

In the join filter we state.

MARA.MTART IN ($PARAM1)

We generate ABAP and place this in ECC so that the filtering is done prior to data transfer to IBP.

If we use a single material type then it works but if we try multiple entries then it does not work. Various combinations of seperator (,|;) and quotations (' " '') have been tried in the parameter list.

One option was to use match_regex to filter but the issue with that is the whole MARA table is read rather than the SQL making a filtered selection which impacts performance.

Can anyone suggest any other ideas on how make the selection please?

Thank you 

Alistair.

[Dirk_1968]

hello, 

we are using CDS views in ECC and implement all logic here. 

CPI only receives the relevant data and we avoid additional manipulation / filtering in CPI that implemented logic is only in one place. 

Regards Dirk 

[Alistair1]

Thanks Dirk for the suggestion.