Filling a field in a Z table

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

Matthew Billingham

Published: 21 Nov 2006

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.

Dig Deeper on SAP data management

Tips on processing records in SAP internal tables SearchSAP.com development expert Matthew Billingham shares some of his tips for better processing records in SAP internal tables.

Deleting entries from a dynamic table I have dynamic internal table . How do I delete entries from this table on the basis of some condition.

MySQL full outer join workaround A MySQL expert offers a workaround for the lack of syntax support for full outer joins.

Query to select CLOB field I want a simple query to get the output of a clob type field in Oracle. I have inserted text ("this is a test for clob") in the clob field. How to select this?

When not to use indexes One of the most important questions is when should you create an index. This book excerpt will help you find the answer.

Transport List Report Task 2: Create a Dataset This excerpt from Chapter 5 of the book Microsoft SQL Server 2005 Reporting Services 2005 explains how to create a dataset for a Transport List Report.

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

A look inside the new Redwood Oracle UI design

The two designers who head Oracle's Redwood user experience and branding effort explain the philosophy behind the new look and ...

Process mining software pulls back curtains on how processes work

Here's what two vendors, Celonis and Signavio, offer in the emerging field of process mining software, which enables ...

Epicor ERP system focuses on distribution

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

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

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

How to streamline feature engineering for machine learning

Structured data is necessary in machine learning, but sifting through data is time consuming. Streamlining the feature ...

SearchAWS

AWS seeks niche in the cloud UC market

AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.

National Australia Bank cashes in on AWS training and certification

Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...

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 ...

SearchBusinessAnalytics

Easy-to-use coding tools a new opportunity for BI vendors

In a Q&A, Yellowfin CTO Brad Scarff talks about why analytics software vendors have recently introduced low-code tools for ...

Low-code tools serve BI customer needs

With easy-to-use tools for application development a growing trend among BI vendors, Yellowfin CTO Brad Scarff discusses the ...

Augmented analytics tools: Business uses, benefits and barriers

This guide examines the capabilities and potential benefits of augmented analytics technologies and offers guidance on how to use...

SearchContentManagement

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

New capabilities added to Alfresco Governance Services

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

SearchHRSoftware

As hiring booms, HR survey raises warning for recruiters

Job candidates will reject a job offer if the employer makes missteps in the recruiting process, a new HR survey reports.

AI in hiring: Why HR should beware of bias

AI in hiring may seem like the perfect solution to remove conscious and unconscious biases that already exist in people, but ...

IT's technology experience problem gets HR tool

Technology deployments have been blamed for loss of productivity and even employee resignations. A new tool from Qualtrics could ...

Filling a field in a Z table

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

Dig Deeper on SAP data management

Related Q&A from Matthew Billingham

Getting data to show in an SAP ALV Grid

Transferring data to new sales orders in SAP VA01

Changing all SAP user account passwords from one location

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

A look inside the new Redwood Oracle UI design

Process mining software pulls back curtains on how processes work

Epicor ERP system focuses on distribution

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

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

SearchDataManagement

Aerospike 4.8 advances database persistent memory support

Data warehouse technologies evolve as vendors look skyward

How to streamline feature engineering for machine learning

SearchAWS

AWS seeks niche in the cloud UC market

National Australia Bank cashes in on AWS training and certification

Overcome these VMware Cloud on AWS migration challenges

SearchBusinessAnalytics

Easy-to-use coding tools a new opportunity for BI vendors

Low-code tools serve BI customer needs

Augmented analytics tools: Business uses, benefits and barriers

SearchContentManagement

Acquia acquisition of AgilOne CDP signals CX platform expansion

Personalization engines help engage and retain customers

New capabilities added to Alfresco Governance Services

SearchHRSoftware

As hiring booms, HR survey raises warning for recruiters

AI in hiring: Why HR should beware of bias

IT's technology experience problem gets HR tool

Dig Deeper on SAP data management

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.