on 01-16-2009 9:30 PM
Hi,
I need to create POC for one of the project I am working on. I am a BW developer so I don't have access to all SAP DB tools. I was wondering if it is possible to define a query expression in the view you built on the table. Table have two seperate columns: CPUDT and CPUTM. I need to concat them and make single column in the view. I know you can do it in regular Oracle database but I am not sure if you can do that through SAP DB tool. Can you please help me?
Thanks,
Kunal
Used FM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No replies?! So I am assuming it's not doable? This is one of the basic things that one can do in RDBMS. Does SAP have limitation when it comes to customizing stuffs?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did I not choose appropriate forum? I thought my question was related to database. Here is a SQL for the view that I would like to build on Oracle table that we have for SAP R/3 system.
CREATE VIEW My_Test_View AS
SELECT Column_1 || || Column_2
FROM My_Table
My question was you can easily define where clause in the View but what about string concat functions. Can you do that in SAP Oracle?
Thanks,
Kunal
Hello,
maybe I am understanding a little bit better now.
So you have got an Oracle view, and you want to create it in SAP dictionary as well, let's say by transaction SE80.
Correct?
Sorry, I don't know the answer; it might be a question for ABAP Dictionary forum, I suppose.
Anyone else with a better idea here?
And by the way, it should be:
CREATE VIEW My_Test_View AS
SELECT Column_1 || Column_2 AS My_Column
FROM My_Table
regards
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.