4 weeks ago
All,
This is my current query in SAP
SELECT "Project","Project Name","Labor Budget","Labor Billed","Address1","period","year","month","EnergyType" From REA
I want to replace certain values inside the Energy Type column. For example I have rows like this
Project | Project Name | Labor Billed | Labor Budget | Address1 | Period | Year | Month | EnergyType |
1 | Elmers Ave | 171100 | 2550 | 460 Madison Ave | 201501 | 2015 | 1 | solar |
1 | Elmers Ave | 171100 | 3000 | 460 Madison Ave | 201601 | 2016 | 1 | Solar |
1 | Elmers Ave | 171100 | 3750 | 460 Madison Ave | 201507 | 2015 | 7 | solar |
Project | Project Name | Labor Billed | Labor Budget | Address1 | Period | Year | Month | EnergyType |
2 | Avenue St | 231100 | 2550 | 11 lee ave | 201501 | 2015 | 1 | Wind |
2 | Avenue St | 231100 | 3000 | 12 lee ave | 201601 | 2016 | 1 | Wind (L) |
2 | Avenue St | 231100 | 3750 | 13 lee ave | 201507 | 2015 | 7 | Wind (L) |
I would like to replace underscore "solar" with capital "Solar" & replace "Wind (L)" with "Wind" Is this possible?
Hi,
what is mean with SAP here? SAP offers a wide range of different products.
If you talk about ABAP you can do an update on the databse table as described in the documentation.
https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abapupdate_source.htm
Best,
Edrilan Berisha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
8 | |
7 | |
6 | |
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.