problem in database view

[former_member189410]

wen i created a databaseview for lips and ekpo table

giving following warning does it matter data is not coming, plz let me know the solution

Type conflict in join LIPS-VGPOS = EKPO-EBELP

i gave the following join conditions .

ekpo-ebeln = lips-vgbel .

ekpo-ebelp = lips-vgpos .

fields of view.

ebeln,

ebelp,

lfig(quantity)

verm(unit)

folllowing warning ocured and no data is displayed plz let me know the reason and how i can correct it.

Type conflict in join LIPS-VGPOS = EKPO-EBELP

thnx.

[former_member189410]

Of course it matters....As fellow SDN'ers tell you...Fields must have the same lenght in a Join condition....Your not going to be able to make it work....Tried to find another table to join the 3 of them and fix the problem...

Greetings,

Blag.

[former_member189410]

its urgent plz let me know

[Former Member]

VGPOS is 6 char long and EBELP is 5 characters long.They must be identical in all respects.

But your view join makes no sense to me at all.

Regards,

Ravi

[former_member189410]

thnx ravi,

dat i have checked wen i put the values from one table to other it displays the result

but view display no data

but its as per requirement ,

let me know dat due to this warning data is not coming

thnx

[former_member189410]

thnx,

i want to know dis only .

is this warning matters

[Former Member]

Of course it matters....As fellow SDN'ers tell you...Fields must have the same lenght in a Join condition....Your not going to be able to make it work....Tried to find another table to join the 3 of them and fix the problem...

Greetings,

Blag.

[former_member189410]

thnx blag

[Former Member]

Hi,

You are getting error because, <b>EKPO-EBELP is of data type <i><u>NUMC with length 5</u></i></b> WHILE <b>LIPS-VGPOS is of data type <i><u>NUMC with length 6</u></i></b>.

In join condition the data type of both the fields shold be same.

Regards,

RS