Possible to merge 2 tables in single personas screen?

[c_steve]

Currently, we are using manual way to export the entry from BSEG and MARA table into excel format. Then, using vlookup function in excel to combine the data to build the report.

My question here, is that possible to use Screen Personas tools to retrieve data entry from MARA and BSEG table field and merge/display into single screen by filter the date range or company code, or etc. The main objective is to eliminate the manual process of using excel vlookup.

Any thoughts?

[Former Member]

This sounds like something that would much more easily be done with an ABAP report.

[tamas_hoznek]

A lot of things are possible using Personas and its scripting engine - the question is rather if it is the right tool to do something like this.

I imagine it would be technically doable what you're looking for, since you can grab the necessary data either from some grid/table on a screen or via RFC. You can then process this and prepare the collected records to combine the information. May not be the simplest script but it should work.

The problem will come with presenting the merged data, since Personas doesn't have a custom table object. So you would have to either build an HTML table with your script, or use something like a UI5 table to render the data. Especially the latter can get a little complicated, and we usually don't recommend going this route unless absolutely required. If you'd go down this path, then you're getting into an area where developing a UI5 app might make more sense.