Passing Multiple Parameters Filter in RSAPInvoke

[sdas1983]

Hi Piers,

I am facing a new challenge while using RSAPInvoke.
I want to pass multiple parameters filter with it. The code works fine with single parameters, but not with multiple parameters.

library(RSAP)
con <- RSAPConnect(ashost="-----",sysnr="13",client="600",user="----",passwd="----",lang="EN", trace="1", lcheck="1")
parms <- list(W_SDATE = '20181101', W_EDATE = '20181129', W_MATKL = 'APTC')
data <- RSAPInvoke(con, "YSD_ZSDSR2N_RFC", parms)

Now I want to pass multiple filter for W_MATKL like 'APTC' and 'GATC'. Now the result I am getting for 'GATC' only, or 'APTC' only if I put it second position.

parms <- list(W_SDATE = '20181101', W_EDATE = '20181129', W_MATKL = c('APTC','GATC'))

I did it by running the code twice with changing the filter parameter, but I want to do it at a single go.
Please help how to do it.

Regards,
Sumanta Das

[piersharding]

Hi -
I don't know what the interface description looks like for YSD_ZSDSR2N_RFC - is W_MATKL a structure or a table?

Cheers,
Piers.

[sdas1983]

Hi Piers,

I have talked with the SAP engineer here at my company. He says W_MATKL is of type "Variable". It is neither a table nor a structure.

Regards,
Sumanta

[sdas1983]

Hi Piers,

I came up with a solution below.

parms <- list(W_SDATE = '20181101', 
              W_EDATE = '20181129',
              W_MATKL = c('APTC','GATC'))
parms_2 <- expand.grid(parms,KEEP.OUT.ATTRS = F,stringsAsFactors = F)

main_data <- NULL

for (i in 1:nrow(parms_2)) {
  assign(paste0("parms_3",i),as.list(parms_2[i,]))
  assign(paste0("data_3",i),RSAPInvoke(con, "YSD_ZSDSR2N_RFC", get(paste0("parms_3",i)))$IT_DATA)
  main_data <- rbind(main_data,get(paste0("data_3",i)))
}

It’s working for me. Also, please check if you can incorporate this in RSAP for the parameters list to convert it into expand.grid and then pass the rows one by one into RSAPInvoke.

Thanks,
Sumanta

[piersharding]

Hi -
So it looks like the parameter is a single value only so it has to be passed in one at a time. This is highly specific to your particular RFC.
Cheers,
Piers.