topic Re: Prblem while creating the view in Application Development and Automation Discussions

Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:33:40 GMT

Hai guys,

I have a view from sevaral table in R3N system.

But while i iam creating the same in R3S data is not seen in the view.

Can you come with the solution.

Thanks in advance.

Accurate solutions only willl be given points.

Thanks.

Regds,

Rama.Pammi

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:36:57 GMT

have u checked if there is any data in R3S system for that join condition?

If there is no fulfilling data u will not c it.

regds

Nishant

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:37:14 GMT

Hi..

i think there is some problem with the data u are uploading..

check the datatypes and the data in it..

can u be clear with ur problem.

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:38:15 GMT

Hi Rama,

As you told you have join from several tables so; one possible case for no data display could be that there is no data mataching the join conditions.

Because in two different systems data will be different.

Check the selection condition as well.

Regars,

Pankaj Sharma

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:41:02 GMT

In both the systems i am having same data.

but while joining...if i add field "ZFLD(2) of type n" in view, i am unable to get data.

please urgent...

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:43:38 GMT

I declared all the data types as Charcter data type in the the internal table fields.

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:45:41 GMT

Hi Rama,

i hav faced the same prob..

check your both databast tables with comparing field ZFLD(2) .

if both are same..ok..else...

check your internal table data that u r inserting into another system.

suppose data type c of size 2 will not gives u leading zero while ZFLD(2) of type n gives u leading zero..now these 2 fields are not same..

so check the data first...

come back to me if any prob..

Ram

Re: Prblem while creating the view

Former Member — Thu, 05 Apr 2007 12:48:02 GMT

Thank you rammohan ,

Your reply gives me the exact solution.

Thanks a lot.