cancel
Showing results for 
Search instead for 
Did you mean: 

create a value help with data from on-premise with RAP on BTP

sebastian_wilhelm1
Participant

Hi Experts!

I'm creating a transactional App with RAP on BTP and my requirement is actually quite simple.

I want to display Article Data which are stored in a S/4 On-Premise System and store some Article Attributes in a table on BTP. I built a database table, CDS Views, Business Service,... . The user must be able to select an article via a value help in the app.

Do you know, how I can create a value help with article ids (matnr) or more article information from the on-premise system?

I think this is a very common task?! I've been searching a lot but couldn't find any answers.

Thanks and regards,

Sebastian

Accepted Solutions (1)

Accepted Solutions (1)

kaidehmann
Advisor
Advisor
0 Kudos

Hi Sebastian,

you can implement a custom entity to fetch data from a remote system and then use the custom entity as value help. Please have a look at the Remote Function Module (RFC) - Get Data from an On-Premise System Using a Custom Entity tutorial and the Developing a UI Service with Access to a Remote Service RAP documentation.

Best regards
Kai

sebastian_wilhelm1
Participant
0 Kudos

Hi Kai, Thanks for you answer. This worked!

Do you know (or is there a tutorial) how can I implement a search help based on the field value of another ui-field. E.g. In field 1 is a Plant entered, in field 2 I want a search help for articels (but only assigned to the given plant). The articles will also be red via oData from an on-premise system.

I haven't found any information about such a (common?) szenario.

kaidehmann
Advisor
Advisor
0 Kudos

Hi Sebastian,

glad to hear that this solved your problem. I would appreciate if you accept the answer.

Your second question is related to value help with restrictions based on another input field in ABAP Environment with RAP, correct? I have provided an answer in the other post.

Best regards
Kai

Answers (1)

Answers (1)

sagarprusty1988
Explorer
0 Kudos

Hello,

In a RAP model, we need to provide the value help view to the material field in CDS view.

You can use C_MM_MaterialValueHelp CDS view as the search help here for material.

Please try to do a where used list which will be helpful to incorporate in your requirement.

It will not be same as the GUI one but it is the standard solution.

Annotations as below

@Search.searchable : true
@Consumption.valueHelpDefinition: (..)


Refer Link for the details of the annotations.

sebastian_wilhelm1
Participant
0 Kudos

Hi Sagar! I couldn't find a cds view called C_MM_MaterialValueHelp in my ABAP Environment on our BTP. Searched in Eclipse > Ctrl + Shift + A. I also searched under "Released Objects" manually but couldn't find such a CDS View! Is this view outdated?

Another question: how can such a cds view access the data on the on-premise system? I guess, this won't work automatically