Skip to Content
0
Former Member
Apr 13, 2009 at 07:01 AM

Join condition when field length is not same in a database view

18 Views

hi All,

I am trying to create a database view on table CDHDR & DFKKCRH .join condition is

DFKKCRH MANDT = CDHDR MANDANT

DFKKCRH GPART = CDHDR OBJECTID

but here length of GPART(10) & OBJECTID(90) is different due to which it is not extracting data in BI.

Is there any other way to join these two tables?

Regards,

Sonal