Prblem while creating the view

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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...

[Former Member]

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

[Former Member]

Thank you rammohan ,

Your reply gives me the exact solution.

Thanks a lot.