Can I update an SAP table from a Java program?

Directly updating tables may not be such a good idea, says expert Austin Sincock.

Austin Sincock, Deloitte

Published: 10 Nov 2004

Is it possible to update an SAP table from a Java program?

SAP does not recommend performing direct table updates to any delivered tables in SAP. The RFC/BAPI layer should provide the appropriate mechanism for updating a business document, which will provide the appropriate table updates. However, if you have custom tables in SAP ("Z" tables) you can write your own custom RFCs to provide direct table updates. Once you have the custom RFC created, simply use JCo to call the RFC from any Java program. Search this site for more information on JCo. You will find articles, tips, etc. from both myself and other Java/SAP programmers.

Dig Deeper on SAP Java and J2EE

Integrating SAP with C++, Java, and Powerbuilder on Sybase and Oracle DBs My landscape is an SAP ECC 6 system and some legacy applications writen in Java, C++, and Powerbuilder using Sybase and Oracle databases. Most of them should read from SAP, and a few should write. I would like to know what tools I can use, some best practices for this instance, and architectural guidelines to make this successful from the beginning.

Set up data encryption between RFC Client and Web AS ABAP with SNC Learn how to enable data encryption for RFC connections to ABAP back ends with this how-to guide for the Application Server developer.

Part 2: Generating metadata for an RFC structure Working with SAP's Java Connector, JCo? Then you should check out this collection of handy utilities for working with RFC/BAPI interfaces when doing development with JCo. These truly are development utilities in the sense that their intent is to provide generic support for almost any programming effort that utilizes JCo to interface with SAP.

Scenario 3: JCo cannot load its RFC middleware layer Misleading or even indecipherable exception messages seem to be the rule of the day when it comes to debugging JCo connector installation exceptions. This checklist by veteran Java expert Austin Sincock sets the record straight on a number of bewildering and headache-inducing exceptions.

How can a Java application pass data to an SAP table using JCo? Updating a table directly in SAP is not recommended practice, says expert A

Updating an external database from SAP Which RFC is best for updating tables from SAP? Expert Austin Sincock provides guidance.

Related Q&A from Austin Sincock

How to provide an SAP R/3 4.5B application server with a Web service interface

How to provide an SAP R/3 4.5B application server with a Web service interface Continue Reading

Consuming a Web service from an SAP 4.6c R/3 application server

A reader wants to know how to consume a Web service from an SAP 4.6c R/3 application server. Continue Reading

With Java development experience, should I go into SAP XI?

Are you a Java/J2EE developer interested in SAP? This expert tip lists the most relevant SAP modules and technologies for you. 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

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

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

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

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

Can I update an SAP table from a Java program?

Directly updating tables may not be such a good idea, says expert Austin Sincock.

Dig Deeper on SAP Java and J2EE

Related Q&A from Austin Sincock

How to provide an SAP R/3 4.5B application server with a Web service interface

Consuming a Web service from an SAP 4.6c R/3 application server

With Java development experience, should I go into SAP XI?

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

Government IT pros: Hiring data scientists isn't an exact science

Tableau 2020.1 unveiled for beta testing

Data scientist vs. data analyst: What's the difference?

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

H-1B lottery change may drive increase in visa applicants

As hiring booms, HR survey raises warning for recruiters

AI in hiring: Why HR should beware of bias

Dig Deeper on SAP Java and J2EE

Related Q&A from Austin Sincock

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.