5 minute read

How Can I Add an Entry to an SAP Table?

In principle, there are several ways to add an entry to an SAP table. One is in the form of standardized transactions (for example, VOE4 for editing the EDPAR table) or using maintenance transactions such as SM30. However, both options are not always available. Either there is no separate transaction for maintaining a table or no maintenance dialog has been created for a particular table. This often occurs with Z tables.

Sometimes it can be useful to add a few entries to a table quickly for test purposes, so that a particular functionality can be tested. One possibility is presented below. This type of data change should only be performed on test systems and not on production environments. In most cases, however, this is prevented anyway by the lack of access to the corresponding transactions in production environments.

Add entry to an existing SAP table

Option A): Using the standard transaction SE16 or SE16n

This option is the “cleanest” approach, but is only available if a maintenance dialog is created for the table and table processing is allowed. To check whether there is a maintenance dialog, call transaction SE11, enter the table name and press F8. Click on “Delivery and Maintenance” to display the editing option.


Eintrag in eine SAP Tabelle hinzufüge Transaktion SE11
Transaction SE11

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

If “Display/Maintenance Allowed with Restrictions” or “Display/Maintenance Not Allowed” is activated, only options B), C) or D) come into consideration – see below.

If “Display/Maintenance Allowed” is activated, however, entries can be created using transaction SE16 or SE16n. To change existing entries, you can use transaction SM30, for example.

Eintrag in eine SAP Tabelle hinzufüge Transaktion SE16
Transaction SE16

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

The newer transaction SE16n provides its own maintenance dialog, which can be called via “View Maintenance”. You can use this to change existing entries and create new entries.Eintrag in eine SAP Tabelle hinzufüge Transaktion SE16n
Transaction SE16n

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Option B) Via transaction SE37

If it is not possible to add entries by default using transaction SE16, the following approach can also be chosen.

First, open transaction SE37 and choose the function module SE16N_INTERFACE. Then start the dialog with F8 or by clicking on “Test/Execute”.

If it is not possible to access transaction SE37, continue with option C or D (see below).

Eintrag in eine SAP Tabelle hinzufüge Transaktion SE3
Transaction SE37

The following dialog will then open.

Eintrag in eine SAP Tabelle hinzufüge Transaktion SE37 Detail
Transaction SE37: Detail view

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

In the first line, instead of <THE_TABLE_NAME>, enter the name of the table for which new entries are to be added. Enter an X for each of the parameters I_EDIT and I_SAPEDIT. Then execute with F8.

This opens the selected table and new entries can be added with the function “New entry”. Furthermore, existing entries can also be changed very easily.

Eintrag in eine SAP Tabelle hinzufüge Transaktion MARA Beispiel
MARA table Example

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

The tabular display allows easy editing, as seen in programs like Excel, for example.

White Paper - EDI Integration in SAP

Option C): Using transaction SE16 with debug mode

In the first step, start transaction SE16 and select the desired SAP table. Then press F8 to execute the transaction so that the individual table entries are displayed.

Eintrag in eine SAP Tabelle hinzufüge Transaktion SE16 Listenansicht
Transaction SE16: List view

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Double-click on one of the existing SAP table entries to open the detailed view of an entry.

Eintrag in eine SAP Tabelle hinzufüge Transaktion SE16 Detailansicht eines Eintrags
Transaction SE16: Detail view of an entry

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Then enter “/h” in the command field to start the debug mode. Click once more in the command field and press Enter to start a debug session.

Eintrag in eine SAP Tabelle hinzufüge Transaktion Debug Mode
Debug Mode

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

The ABAP code under the transaction then opens. Double-click on the variable “code” in the ABAP code (left arrow). Then change the value of the variable in the right-hand window to “EDIT” (for editing) or “INSR” (for inserting) and confirm with Enter.

Eintrag in eine SAP Tabelle hinzufügen Transaktion Debug Modus zum Ändern einer Variable
Debug mode to change a variable

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Then press F8 to finish the code. The entry can now be edited or a new entry can be added.

Option D): Using transaction SE16N with debug mode

Start transaction SE16n, enter SAP table name and press F8.

Eintrag in eine SAP Tabelle hinzufügen Transaktion S16n Tabellenauswahl
SE16n: Table selection

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Start the debug mode in the detail view by entering /h in the command field. Then press Enter again in the command field to start a new debug session. In the debug session, add the following two variables, set the value to “X” and finish the execution with F8.

  • GD-SAPEDIT
  • GD-EDIT

SE16n - Neue Variablen hinzufügen
SE16n: Add new variables

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

The entries can now be edited or a new entry can be added.

SE16n - Neuer Eintrag
SE16n: New entry

© 2020. SAP SE or an SAP affiliate company. All rights reserved. Used with permission of SAP SE.

Any questions?

Do you still have questions about SAP or EDI? Get in touch with us – we are always happy to help!

SAP ERP and SAP S/4HANA are the trademarks or registered trademarks of SAP SE or its affiliates in Germany and in several other countries.

Subjects

most read

Keep on reading

3 minute read

How to create an SAP transaction code

Want to know how to create an SAP transaction code for an existing ABAP program so that you can easily call the program?

6 minute read

How to Set Up and Manage Automatic SAP Jobs

SAP jobs can be used to automate processes in SAP ERP so they can be carried out without user intervention. We explore the key features.

4 minute read

IDoc Status Change in SAP ERP

IDoc statuses are not always the clearest - particularly when errors occur. In this article we explain how to change IDoc status as required.

5 minute read

Alternatives to the Seeburger PI Adapter

The end of maintenance for the Seeburger PI Adapter is imminent. What alternatives are there and which is the best suited for your business?

4 minute read

IDocs in SAP S/4HANA: The Differences to SAP ECC 6.0

The change to S/4HANA also impacts the format of IDocs. In this article we explore IDocs in S/4HANA and the new and changed elements.

11 minute read

Migration to SAP S/4HANA - 5 Key Considerations

Are you prepared for migration to SAP S/4HANA? Discover the 5 key questions all businesses looking to upgrade to SAP's new ERP system should consider.

11 minute read

Exchange of Electronic Invoices with the SAP eDocument Framework

Companies have to increasingly implement e-Invoicing for different countries. This blog post explains how the SAP eDocument Framework can help you.

2 minute read

How Can You Save an IDoc from SAP on Your Hard Drive?

Wondering how to export IDocs as a file on your local computer? We created a handy guide!

5 minute read

Create and Process UBL Documents with Attachments in SAP

Enable your SAP solution for UBL based e-Invoicing over Peppol. Click here for an example case based on the XRechnung in Germany.

6 minute read

IDoc Processing in an SAP ERP System with Transaction BD87

Companies utilising SAP ERP and exchanging documents need a central tool to manage, view and search for IDocs. Transaction BD87 is the answer.

12 minute read

EDI_DC40: Understand the SAP IDoc Control Record

A correctly filled control header is essential for the identification and processing of IDocs. We show what settings are needed in SAP.

6 minute read

An Overview of the Most Important SAP Modules

Before introducing new software, companies need to understand and assess its value. SAPs ERP system offers a lot of functionality through its different modules.

We use cookies to provide an optimal website experience. You decide which one you want to allow. Depending on the setting, however, not all functionalities may be available to you. Data protection & imprint.