Skip to Content
0
Former Member
Jul 10, 2015 at 12:57 PM

WEBI 4.1 - merge line items

20 Views

Hi,

I have 2 BEx queries.

Query 1

Order Item Date1

111 10 20150101

111 20 20150303

111 30 20150602

Query 2

Order Item Date2

111 10 20150507

111 20 20150403

What I would like to achieve:

Order Item Date1 Date2

111 10 20150101 20150507

111 20 20150303 20150403

111 30 20150602

I can merge the orderno, but that results in item referencing problems.

I tried to create 2 variables and concatenate order and item. However merging variables is a no-go area.

We use BO 4.1 support pack 5.

As said before no universe involved, both are BEx queries.

I am not able to create the concatenations in the SAP backend.

Many thanks!