store fields to qvd from different tables

[settu_periasamy]

Hi,

I have loaded the qvw in binary load. Now i need to store some fields from that file. But the tables are different.

eg.

Binary sample.qvw;

....

.....

store mara.normt, %customer,vbrk.kzwi2,  into check.qvd;

Please give suggestion.

Regards,

Settu

[PradeepReddy]

I think it is not possible.

If u wish to store the multiple tables in a QVD,

1) Store them as separate QVDs

2) Combine them into single table and then store that single table into QVD.

[anbu1984 · Accepted solution]

First create a new table combining the fields you want to write to QVD.Also mention the common fields if any between these tables. Otherwise you will get cartesian product

NewTable:

Load mara.normt from mara;

Join(NewTable)

Load vbrk.kzwi2 from vbrk;

Store NewTable into check.qvd(qvd);