SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


Update Database Table Data using ABAP SE16N_INTERFACE

SAP programmers can use se16n_interface ABAP function module to update database table although it is not a safe method to update field values directly on database table. Using se16n_interface can be considered as a way of table data maintenance method for custom lookup data that your ABAP developers use in their codes

Execute SAP SE37 transaction code.

SE37 SAP transaction code

Type the SE16N_INTERFACE ABAP function module name

se16n_interface ABAP function module

Press F8 to execute the ABAP function module se16n_interface

When the ABAP function module se16n_interface input variables are displayed for execution, enter the parameter values marked with red in below screenshot.

Enter the table name in I_TAB,
Mark with 'X' the input parameters I_EDIT, I_SAPEDIT and I_DISPLAY.
Additionally, ABAP programmers or SAP users can alter the numeric value of the input parameter I_MAX_LINES which limits the number of rows returned from the target ABAP table by the function module se16n_interface

update SAP database table using ABAP function module

If SAP table has many rows that can be expressed with thousands returning all rows with deleting the i_max_lines is not a good solution.
IT_SELFIELDS internal table can be used to pass filters based on target table field name with associated filter values as a structure.
Following screenshot is showing that I have added the Campaign_ID field as a parameter to the se16n_interface function module with a specific value. ABAP programmers can add aditional fields to limit the returned data rows for database update using se16n_interface.

ABAP function module to update SAP table data

After ABAP programmers execute the function module se16n_interface with configured values, a list of database table rows will be returned. The returned table records are displayed in a format just like Microsoft Excel where table row cells can be edited seperatedly.

Again one last note, it is not safe to directly update SAP database tables using method described in this ABAP tutorial. This may break the data integrity causing unexpected behaviour in data flow and business processes. If you are updating a table field in an ABAP table, be sure that you know the process that the ABAP table is taking place and changes will not affect in negative.






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table






Related Articles and Tutorials(http://www.kodyaz.com/sap-abap/update-table-data-using-abap-se16n_interface.aspx)
Convert Smartform to PDF in Print Preview Mode
Create Business Object in SAP
Delete All Data from SAP Database Table
Export SAP Data to Fixed Length Text File
Complete List of SAP Modules
Free Adobe LiveCycle Designer Download
How to Upload Data to SAP from Excel File using alsm_excel_to_internal_table Function Module
Upload Data from Excel File in ABAP using TEXT_CONVERT_XLS_TO_SAP
Email Spool Request using SAPOffice - Spool to PDF
How to Create SAPScript Text using SO10 Transaction Code
How to Display SAP Graphics using SE78 Transaction Code
Sales Tables among ABAP Tables (SAP Sales and Distribution SD Tables)
SAP Payment Terms Table and ZTERM Texts Table for ABAP Developers
SAP Tutorial - Convert Spool Request to PDF File using RSTXPDFT4 ABAP Report
ABAP Debugging using Log Point and Break Point
ABAP Runtime Error ST22 Transaction using Short Dump Analysis
ABAP Shared Memory Objects Tutorial with Sample ABAP Code
Add Web Dynpro Applications to SAP Favorites Menu
ABAP Authority-Check Object For User Other Than Current
Call Function Module using RFC Destination in ABAP
Change Fields for Selection in SE11 ABAP Data Browser
Compare Code in ABAP using SE39 SplitScreen Editor
Connect SAP from Eclipse using ABAP Project
Convert the table using the Database Utility (SE14)
Convert Sales Unit into Text using Function Module in Target Language
ABAP Code Inspector Check Variants for HANA Migration Optimization
Create SAP Dynamic Variant using Date Calculation
Create Scheduled Job using SAP SM36 Transaction
Create Search Help in ABAP for Web Dynpro Component
Create Transaction Code for Web Dynpro Application
Create SAP Transaction to Maintain ABAP Table using SM30
Create Transport Request for Text Translations using RS_LXE_RECORD_TORDER
List Locks in SAP system using SM12 Transaction Code
Prevent DYNPRO_SEND_IN_BACKGROUND Error in Background Process
Enable Remote Debugging in ABAP using RSRDEBUG
How to Execute SAP Program in Background Task
Export Graphics from SE78 SAP Form Graphics Administration using ABAP program
How to Export IDOC as Excel and Save as Local File from WE02 Transaction
Export SAP Spool Requests as PDF using SP01 Transaction
How to Find SAP Role Users Assigned for Transaction Code
How to Delete Standard Text using SO10 SAP Transaction
How to Find User Exits in ABAP Codes of SAP Transaction
How to Transport SAP Graphics using SE78 Transaction
Import and Export SO10 Standard Text using RSTXSCRP ABAP Program
Main program for include RV61Bxxx not found
Invoice Output fail because of missing Billing Type text in TVFKT table
Primary key change not permitted for value table
Business Document Service Error: Error when accessing graphic (BDS), RC = 5
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
SAP Purchase Order Tables, Transaction Codes and Output
Graphics White Background Displayed Grey on SAP Smartform Output
Export Table Contents into Text File and Download File
SE63 Smartform Translation and Export using SLXT Program
Search and Find SAP Transaction Code using SE93 or SEARCH_SAP_MENU
How to Set Start Transaction in SAP GUI
Unicode Character Problem in IFS File Interface
Web Dynpro Text Translation using Assistance Class
Transport Variants of an ABAP Program into Workbench Request
TVAP Item Category and SAP Table TVAPT for Text Translations
Unlock Objects Locked in Request or Task using Transport Organizer Tools
Update Database Table Data using ABAP SE16N_INTERFACE
VF31 SAP Transaction to Reprocess Billing Output Messages
Function module is not released for the Internet
Switch ABAP Variable Value with Translate using Mask
Switch ABAP Variable Value with Translate using Mask


Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems