This website is not affiliated with, sponsored by, or approved by SAP AG.

DB View with multiple tables

Business Warehouse

Moderators: Snowy, thx4allthefish

DB View with multiple tables

Postby aahmad6723 » Wed Jun 27, 2012 8:58 pm

Hi guys,

I have created a DB view in SRM that has several internal and couple of custom tables in it. Here's the question. Two custom tables Z600H and Z600J has fields with similar technical name in them for example ZCONTRACT_NO. So the view throws an error upon activation Field name ZCONTRACT_NO not unique. Even though the tables are different. Any thoughts of getting around this?

Thanks
aahmad6723
 
Posts: 3
Joined: Wed Jun 27, 2012 8:51 pm

Re: DB View with multiple tables

Postby Gothmog » Thu Jun 28, 2012 3:10 am

The name of the field in the view doesn't need be the same as the name of the field in the table.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: DB View with multiple tables

Postby aahmad6723 » Sat Jun 30, 2012 4:45 pm

Thank you Gothmog.
aahmad6723
 
Posts: 3
Joined: Wed Jun 27, 2012 8:51 pm

DB View Changes

Postby aahmad6723 » Sat Jun 30, 2012 5:00 pm

Guys,

Need some feedback on this scenario.

I created a DB View in SRM for several internal/custom tables in SRM. Created the Datasource in SRM on top of that View and replicated in BI. When I was mapping fields in Transformations, I realised that I needed to add another table in that View. Now, If I went back to the SRM View and made those changes and activated the View, what needs to be done in order for those new fields to appear in the Datasource? There are no options to refresh the datasource so that it will reflect the changes in the VIEW. Any suggestions besides creating a new datasource on the view and do all the mappings again? Any help would be appreciated.

Thanks
aahmad6723
 
Posts: 3
Joined: Wed Jun 27, 2012 8:51 pm

Re: DB View with multiple tables

Postby Gothmog » Mon Jul 02, 2012 3:05 am

I'm moving this back to BI, as your new question is no more related to ABAP.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: DB View with multiple tables

Postby djbenice » Mon Jul 09, 2012 11:53 am

Re-Replicate datasource?
djbenice
 
Posts: 50
Joined: Mon Jan 16, 2006 6:51 am


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 8 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.