How to use negative numbers in maintenance views

When you create a maintenance view for a dictionary table, by default numeric fields can not hold negative values. Learn how to circumvent this problem.

Zuhal Gunes

Published: 17 Feb 2005

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

When you create a maintenance view for a dictionary table, by default numeric fields can not hold negative values. To be able to use negative numbers in a numeric field, the letter 'V' must be added to the end of the default value of the field.

Dig Deeper on SAP ABAP

How can I improve test case prioritization and planning? Want to be a more effective tester? Expert Amy Reichert explains how to plan, prioritize and document regression testing once, so you're better prepared for the tests to come.

Tips for database testing from the cloud What is database testing and how is it important to your application and the company? Get tips to effectively test when data is hosted in the cloud.

Utilizing shape charts with Report Builder 3.0 Shape charts such as pies of funnels are perhaps the simplest chart types available in Report Builder, so it's important to know when (and when not) to use them.

Using range charts for visualization with Report Builder 3.0 A range chart does just what it sounds like – it presents ranges of data in a meaningful way. Report Builder 3.0 includes new functionality for adding ranges to SQL Server reports.

Configuring pointers, scales and ranges with Report Builder 3.0 When working with gauges, three key components can influence the overall effectiveness of your reports. Understanding them can help you get the most out of Report Builder 3.0.

Don't write simplistic test cases What is a "simplistic" test case and how can you avoid writing them?

SearchERP

Epicor ERP system focuses on distribution

Companies like Jergens Industrial Supply are favoring purpose-built ERP systems like Epicor Prophet 21 for distributors over ...

Digital transformation strategy: 6 steps for success

The failure rate of digital transformation is high, but a smart and detailed strategy can vastly improve the outcome of your ...

Top 7 manufacturing challenges for 2020

Growing supply chain complexity, emerging next-gen technologies and other compelling forces will continue to challenge the ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Amazon cloud database and data analytics expand

AWS expands its Redshift data warehouse capabilities including managed storage and query acceleration at the re:Invent 2019 ...

Vendors move away from open source database software licensing

While open source is a key to success for many database vendors, it can also potentially lead to a competitive threat from a ...

Oracle looks to grow multi-model database features

Decade after decade, Oracle continues to be relevant in the database market as it pivots to include an expanding list of ...

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

New AWS cost management tool, instance tactics to cut cloud bills

AWS users like Lyft and Salesforce have figured out how to keep their cloud costs as low as possible, and a new cloud management ...

A complete guide to AWS re:Invent 2019

AWS re:Invent is one of the biggest cloud and IT events of the year. Use this AWS conference guide to get the latest news and ...

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Augmented intelligence features and an in-warehouse data prep tool highlight Sisense's latest update, its second since acquiring ...

Operation Fistula uses data to treat childbirth injuries

Aided by an analytics stack developed by Exasol, nonprofit Operation Fistula is working to end obstetric fistula in targeted ...

Automated tools broaden the future scope of data science

Automated data science tools may make their way into the data science process, but are unlikely to ever be able to do everything ...

SearchContentManagement

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

Top 5 Office 365 skills for SharePoint administrators

Microsoft SharePoint administrators need to branch out in their Office 365 skill set to support products tightly integrating with...

Box cloud content management helps simplify digital work

Box currently has three main areas of focus: integration with enterprise applications, content security and collaboration. The ...

SearchHRSoftware

3 keys to employee engagement measurement

Far too many organizations and their HR departments conduct employee engagement measurement in a way that does more harm than ...

Cornell researchers call for AI transparency in automated hiring

Researchers at Cornell University want vendors to disclose how automated hiring systems are making hiring recommendations. They ...

Why reducing hiring bias isn't easy

Because people may harbor hidden biases, diversity and inclusion initiatives can be difficult to execute. Take an in-depth look ...

Dig Deeper on SAP ABAP

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.