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

Problem in database view

Private_Member_15166 — Mon, 19 Jan 2015 12:48:53 GMT

Hi ABAPers,

After a long time i am back here to ask a question but it doesn't mean i have stopped using it.

I have to make some changes in existing view,which has been used earlier in some places.

This is the joint tables.

CSLA

CSLT

ZCO_STREAM

ZCO_ROLE

ZCO_STREAM_ROLE

with some joint condition like this.

CSLA	MANDT	=	CSLT	MANDT
CSLA	KOKRS	=	CSLT	KOKRS
CSLA	LSTAR	=	CSLT	LSTAR
CSLA	DATBI	=	CSLT	DATBI
CSLA	MANDT	=	ZCO_STREAM	MANDT
CSLA	ZZCO_STREAM	=	ZCO_STREAM	CO_STREAM
CSLA	MANDT	=	ZCO_ROLE	MANDT
CSLA	ZZCO_ROLE	=	ZCO_ROLE	CO_ROLE
CSLA	MANDT	=	ZCO_STREAM_ROLE	MANDT
CSLA	ZZCO_STREAM	=	ZCO_STREAM_ROLE	CO_STREAM
CSLA	ZZCO_ROLE	=	ZCO_STREAM_ROLE	CO_ROLE

Now i have to add a different Z table which has been added in CSLA customization for infotype.

Currently when i am running this view then i am getting the data in view but after using the new table and defining the joint conditions i am getting message that no entries found.

But when i am checking that particular value in each table then it exist.

Please suggest me that why this is happening.

Best Regards

Dhananjay

Re: Problem in database view

Former Member — Mon, 19 Jan 2015 13:07:28 GMT

Hi Dhananjay

Did you delete the old TMG first, then create TMG with new table?

regards,

Archer

Re: Problem in database view

Private_Member_15166 — Mon, 19 Jan 2015 13:23:58 GMT

No table maintenance generator for this.

Re: Problem in database view

Private_Member_15166 — Mon, 19 Jan 2015 14:19:40 GMT

Hi I am going to tell step by step procedure and where i am getting error.

First i have a database view, which has been used in search help.

Here after clicking on content button(shown in red) i am getting the values in this view.

After adding this table and join conditions, i am not getting data in this view after clicking on content.

ZSF_Role_code is the primary key of ZSF_Role table and this table has been defined as a check table in CSLA table.

And as i am comparing in the table there is value available but i am getting this message.

Please let me know that where i am making mistakes.

Thanks and Regards

Dhananjay

Re: Problem in database view

Former Member — Mon, 19 Jan 2015 16:26:19 GMT

hi dhananjay,

please check also data types. may be mismatching and unable to join.

Re: Problem in database view

Private_Member_15166 — Tue, 20 Jan 2015 05:35:13 GMT

Hi Abdul,

Data types are same.. As you may see here..

ZZSF_ROLE_CODE

ZSF_ROLE_CODE

for CSLA Table and

ZSF_ROLE_CODE

for ZSF_ROLE table.. Left side is field name and right one is data element..

Your's help will be appreciated

Re: Problem in database view

Private_Member_15166 — Tue, 20 Jan 2015 06:25:29 GMT

Hi Also in first case i am getting this warning but view is working properly..

Check dependent search help ZDC_TEST

Width 332 of parameter list is too large for personal help

Search help ZDC_TEST was checked with warnings

Key field CSLT-SPRAS missing

All fields are evaluated as key field

View ZDC_TEST is consistent

and after changing i am getting the same error..

Does it making a problem??

Regards