Filling a field in a Z table

In this expert response, Matt Billingham suggests how to complete created fields within an SAP Z table.

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.

I added a field in my Z table, and now it is a blank field. If I want to fill that field for all records in the Z table, what is the best approach?

You have to write a program using the Open SQL UPDATE command.

This was last published in November 2006

Related Q&A from Matthew Billingham

Getting data to show in an SAP ALV Grid

An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading

Transferring data to new sales orders in SAP VA01

An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading

Changing all SAP user account passwords from one location

An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Supply chain risk management tools vary from generic to niche

Specialized supply chain monitoring and risk tools exist, but you're more likely to use an assortment of general-purpose ...

Oracle Autonomous Database concept extended to PaaS, apps

Having earlier laid the foundation with Oracle Autonomous Database, the vendor unveiled self-driving, self-repairing tools for ...

Three companies display advances in 3D printing technology

Take a look at three printers from Nano Dimension, XJet, and HP demonstrated at the Rapid + TCT additive manufacturing conference...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchDataManagement

GPU databases bring greater parallelism to big data processing

GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data ...

Distributed SQL database wagered on for scalability boost, GDPR

CockroachDB is a distributed database system that seeks to support processing on a global scale, a need that online gambling ...

GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

SearchAWS

EC2 features geared toward modest enterprise adoption

AWS infrastructure services now offer more VM control, licensing flexibility and a price cut -- all part of its plan to lure ...

Assess five ways to deploy AWS containers to production

AWS provides myriad container options to suit different deployment needs. But the biggest consideration might be how much control...

Compare dedicated cloud connections from AWS, Azure and GCP

Leading public cloud providers offer dedicated, albeit different, options to help enterprises securely connect to off-premises ...

SearchBusinessAnalytics

Ten KPI templates for your dashboards

KPIs help companies gauge success, but how do you choose the right metrics to create useful reports? Here you'll find 10 KPI ...

Data visualization process demands smart design, accurate data

Well-designed data visualizations can enable executives to make more-informed business decisions, increasing the potential ROI of...

Seven good data visualization practices for visual integrity

Data visualizations need visual integrity to ensure that the data they present can be interpreted correctly. Follow these design ...

SearchCRM

Customer behavior analytics brings marketing, analytics together

If you want better, more timely access to customers, consider customer behavior analytics, which is driven by the combination of ...

Check off those GDPR call center requirements

With GDPR about to go into full force, there are last-minute details and loose ends to tie up to ensure that your call center ...

HubSpot customer service tool Service Hub aims to transform SMBs

HubSpot's Service Hub, the new customer service product, aims at helping small and medium businesses complete the view of the ...

SearchContentManagement

New age collaboration tools empower the future of ECM

Document management, file-sharing and ECM platforms might represent 'ancient' 1990s technology, but AI and collaboration tools ...

Future of collaboration technology: More Slack and AI, less email

Companies have moved beyond messaging and email to Slack, Teams and even AI-powered scheduling and voice recognition. Are you ...

Adding artificial intelligence bots to Cortana for Office 365

AI bots aren't just for requesting songs and definitions anymore. As enterprises look for ways to bring virtual assistants into ...

SearchHRSoftware

Huge potential of video interview software comes with risks

Tech-savvy millennials' advantage over older workers risks ageism, and AI needs work handling emotions and ethnicity. But few ...

How to solve six of the biggest employee retention challenges

Recruiters are enticing workers with new opportunities on an increasingly frequent basis. Give your employees plenty of reasons ...

Recruiting online giants turn to new technologies

Technology is driving major changes to the recruiting online market. Monster.com and CareerBuilder.com have deployed new job ...

Related Resources

Dig Deeper on SAP MDM software

Related Q&A from Matthew Billingham

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.