topic Re: problem with view in Application Development and Automation Discussions

problem with view

Former Member — Thu, 05 Nov 2009 03:14:09 GMT

Hi all, im having a problem with a view i created, this view has 2 tables and i have made the table/join conditions.

the problem is that when i try to run the view it is displaying all the values in all mandants, i dont know why this is happening...

i already tried to add the field mandt in my tab: table/joi conditions and select it as sy-mandt but its not working...

any body can help me out please? how do i restrict the view to only show me the values for the mandant that im working on?

thanks

Re: problem with view

Former Member — Thu, 05 Nov 2009 03:36:39 GMT

does both tablse have mandt fields?

if yes..

in the join conditions.. add

TABLEA-MANDT = TABLEB-MANDT

Re: problem with view

awin_prabhu — Thu, 05 Nov 2009 03:49:43 GMT

Hi Pizza Girl,

'Table/Join Conditions' tab is used for selecting common fields in both the tables.

I think u have to give ur ur conditions for MANDT in 'Selection Conditions' tab like below.

Table1 MANDT EQ '011' AND

Table2 MANDT EQ '011'

But its not possible, because when u set a 'Selection Conditions' for field MANDT, system will throw below error

'Selection condition not permitted for client'

Thanks,

Re: problem with view

Former Member — Thu, 05 Nov 2009 03:52:06 GMT

@SAP FAN,

you just need to bind the two mandt fields. no need of passing any value to it..

Re: problem with view

Former Member — Thu, 05 Nov 2009 04:01:07 GMT

Hi Friend

What type of View you are creating ?

Please see the definition & purpose of different types of View in this link

[http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm]

if you are creating a database view or Maintaince View , then please do the Table maintaince generation . so that using the

table maintainence generator Events you can achevie your client /mandt data to display .

For table maintainance generator event implementing , please see this link

[https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=93454609]

you can try write abap program using the SAP Function Module, please see this link

[http://help-abap.blogspot.com/2008/09/capture-changed-content-after-fm.html]

Regards ,

Re: problem with view

Former Member — Thu, 05 Nov 2009 04:02:48 GMT

The best way is you can define the constant value of your Mandt in the filter/constant tab in the view creation.

Regards,

Re: problem with view

awin_prabhu — Thu, 05 Nov 2009 04:02:50 GMT

Hi Soumyaprakash Mishra,

I think problem is all common values getting displayed from all clients for table join on MANDT.

Its not about getting common values from two tables based on MANDT for a particular client.

Thanks,

Re: problem with view

Former Member — Thu, 05 Nov 2009 04:14:40 GMT

MANDT is always taken care by SAP iteslf, no need to wwory about it.. you just need to bind.

tke some standard tabe/view examples

Re: problem with view

Former Member — Thu, 05 Nov 2009 16:08:52 GMT

i tried to do this

ausp mandt eq '110' and

cabn mandr eq '110'

but when i try to activate it im getting an error saying that i can have selection for the field mandt

Re: problem with view

Former Member — Thu, 05 Nov 2009 16:11:58 GMT

i also tried the join condition, but it keeps showing me all the values for all mandants, im working on mandand 100 (which is the mandant for development) and im getting values for mandants 110, and 120

Re: problem with view

ThomasZloch — Thu, 05 Nov 2009 16:32:22 GMT

Is it possible that you did not declare the MANDT key fields in the two tables properly? Did you use data element MANDT? If not, which one did you use? It is essential that the data type of the client field is CLNT.

Thomas

Re: problem with view

Former Member — Thu, 05 Nov 2009 16:45:30 GMT

so, this is what i did,

in the tab table conditions i had to declare all the key fields in both tables, this way im still getting all values for all mandants, but they're not repeating.. 😃