topic Re: problem in database view in Application Development and Automation Discussions

problem in database view

former_member189410 — Thu, 29 Mar 2007 16:22:06 GMT

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.

Re: problem in database view

former_member189410 — Thu, 29 Mar 2007 16:24:50 GMT

its urgent plz let me know

Re: problem in database view

Former Member — Thu, 29 Mar 2007 16:25:04 GMT

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

Re: problem in database view

Former Member — Thu, 29 Mar 2007 16:26:59 GMT

Hi,

You are getting error because, EKPO-EBELP is of data type NUMC with length 5 WHILE LIPS-VGPOS is of data type NUMC with length 6.

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

Regards,

Re: problem in database view

former_member189410 — Thu, 29 Mar 2007 16:27:59 GMT

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

Re: problem in database view

former_member189410 — Thu, 29 Mar 2007 16:30:03 GMT

thnx,

i want to know dis only .

is this warning matters

Re: problem in database view

Former Member — Thu, 29 Mar 2007 19:33:54 GMT

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.

Re: problem in database view

former_member189410 — Fri, 30 Mar 2007 04:38:34 GMT

thnx blag