-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: Data Type Conversion
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Data Type Conversion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Jan 19 5:25 PM
- SAP Managed Tags
- ABAP Development
I have a string as follows:
0000060880000
I need to assign it to a field in a database record with
the following type CURR Length 11 Decimals 2
When I move it into this field it is recorded as
60,880,000.00
It should be recorded as 60.88
How would I do that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Jan 19 5:53 PM
- SAP Managed Tags
- ABAP Development
Hi,
I did not understand why you want to store 0000060880000 as 60.88. What is your logic? Would you always divide the no by
1000000 or this is a constant no?
Well, if 0000060880000 is character type then you might have to move it to a numeric variable first then divide and then write to CURR and I suppose you'd need a UOM for the currency. Do you have that logic ready?
Regards
Prasenjit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Jan 19 5:28 PM
- SAP Managed Tags
- ABAP Development
The only way would be to divide the number with 1000000
field = 0000060880000 / 1000000.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Jan 19 5:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2010 Jan 19 5:53 PM
- SAP Managed Tags
- ABAP Development
Hi,
I did not understand why you want to store 0000060880000 as 60.88. What is your logic? Would you always divide the no by
1000000 or this is a constant no?
Well, if 0000060880000 is character type then you might have to move it to a numeric variable first then divide and then write to CURR and I suppose you'd need a UOM for the currency. Do you have that logic ready?
Regards
Prasenjit
Bluesky