on 09-08-2009 8:09 PM
Hi Guys,
I am trying to create a view from table A and table B. Data in table A and table B are as follows.
Table A TableB
Field_1 Field_2 Field_1 Desc_1
A1 B1 A1 New York
A1 B1 A2 Albany
A1 B2 A3 Rochester
A1 B2 A4 Buffalo
A1 B2 A5 Syracuse
A2 B1
A2 B2
I want to get the following result:
Field_1 Desc_1 Field_2
A1 New York B1
A1 New York B1
A1 New York B2
A1 New York B2
A1 New York B2
A2 Albany B1
A2 Albany B2
Please advise me which type of view should I create. I create Maintenance view and I am getting following error"
"No database view exists for view Z_TEST_VIEW".
Please help in creating a view without the error.
Thanks,
Since your requirement is to view logically connected data from different tables, try creating the "database view".
http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
10 | |
8 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.