topic Re: Create selection conditions for database view in Application Development and Automation Discussions

Create selection conditions for database view

Former Member — Fri, 29 May 2009 03:48:11 GMT

Hi,

I want to create a database view contains table IFLOTX.

In selection conditions for this view I want to add condition as follow:

IFLOTX-SPRAS = sy-langu " system language

My question here is how to define system language in Comparison Value column.

Thanks,

Re: Create selection conditions for database view

Former Member — Fri, 29 May 2009 03:53:30 GMT

Hi Khanh,

Can you be little specific do you want to create a db view considering even the sy-lang or is it something different.

Revert with clarity so that I can be able to provide u the solution.

Thanks and Regards

Srikanth.P

Re: Create selection conditions for database view

Former Member — Fri, 29 May 2009 04:01:00 GMT

Hi SRIKANTH,

The problem is when creating db view which contains table IFLOTX, it requires all key fields from this table. As my understanding I want to create a selection condition for key field SPRAS (language key) equals the language which the current user log on.

Is this possible? If no pls give me some instructions.

Thanks,

Re: Create selection conditions for database view

Former Member — Fri, 29 May 2009 04:09:44 GMT

Hi Khanh,

Try decalring a varible which is of type Sy-lang and use this variable in your selection by equating it to the SPRAS field.

Just make a try .

Hope you have understood

Thanks and Regards

Srikanth.P

Re: Create selection conditions for database view

Former Member — Fri, 29 May 2009 04:16:43 GMT

Hi Srikanth,

Thank you for your postings. After review carefully, I found that table IFLOTX contains a very little records and I will join it with the created view in ABAP code.

Thanks,