Create Database view-VBAK and ZTABLE-No common fields

[Former Member]

Hi,

I have to create a Database view by using VBAK and ZTAble where there is no Common fields. One of Z Amount field is referenced to VBAK. So i want to make a join on it by using View. But there is no common field in these two tables. Is it possible to create View without common field. I want currency reference only from VBAk table.

Pleaase suggest a solutions.

Thanks &Regards,

Revathi

[Former Member]

Hi,

I have to create a Database view by using VBAK and ZTAble where there is no Common fields. One of Z Amount field is referenced to VBAK. So i want to make a join on it by using View. But there is no common field in these two tables. Is it possible to create View without common field. I want currency reference only from VBAk table.

Pleaase suggest a solutions.

Thanks &Regards,

Revathi

[bbalci]

Hello,

As far as I understand

you want to use WAERK field of VBAK as currency unit for amounts in your Z table.

But at least you should have document number field to access this field in VBAK

and for a join between that two tables.

If your Z table doesn't have common field with VBAK

how will you decide which record of VBAK is match for your record in Z table?

I think the reference field which set for amount fields in your Z table is incorrect,

Add a new field which type WAERK to your Z table itself and set reference fields for amounts as this field.

I think it'll be more clear solution. And you won't have dumps in ALV.