SQL Server administration and T-SQL development, Web Programming with ASP.NET and Javascript, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.




Win FREE BOOK
from Kodyaz



CRM Companies List
Web Based CRM Software





Read SAP Customer Data from KNA1 using kna1_single_reader ABAP Function Module


ABAP kna1_single_reader function module can be used to check the existence of a customer record in SAP KNA1 Customer table using the customer number and return customer data as well as address data.
With this return information kna1_single_reader is one of the most used function modules.

Customer data in SAP system is stored in KNA1 ABAP table.
Customer Address data is stored in ADRC ABAP table.
And both KNA1 and ADRC tables can be joined using the relation KNA1-ADRNR = ADRC-ADDRNUMBER.
Instead of using an OpenSQL query to select this information from SAP tables, function modules can be used by ABAP developers.

But for a single customer, if ABAP developer has Customer Number KUNNR (Kundennummer), using ABAP Function module kna1_single_reader the ABAP developer can return the Customer information and Address information together from SAP system.





Here is sample ABAP code where kna1_single_reader ABAP function module is used for displaying customer data.

DATA :
  i_kunnr LIKE kna1-kunnr,
  o_kna1 LIKE kna1,
  o_address_value LIKE addr1_val.

i_kunnr = 'TR00952702'.

CALL FUNCTION 'KNA1_SINGLE_READER'
 EXPORTING
  i_kunnr = i_kunnr
* I_READ_CAM =
* I_RESET_BUFFER =
* I_BYPASSING_BUFFER =
 IMPORTING
  o_kna1 = o_kna1
  o_address_value = o_address_value
 EXCEPTIONS
  not_found = 1
  parameter_error = 2
  internal_error = 3
  OTHERS = 4.
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

WRITE : /
  'kunnr',
  15 'name',
  30 'address'.

IF o_kna1 IS NOT INITIAL.
 WRITE : /
  o_kna1-kunnr UNDER 'kunnr',
  o_kna1-name1 UNDER 'name',
  o_address_value-name1 UNDER 'address'.
ENDIF.

In the below screenshot, you can see the SAP customer data read from SAP KNA1 table using kna1_single_reader ABAP function module.

sap-abap-function-module-kna1_single_reader

ABAP function modules can manage many complex processes for ABAP developers and ABAP function modules are reusable, so they are most preferred by ABAP programmers.







SAP Resources

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table














Recent and Top SAP Tutorial and ABAP Tutorials

Change Output Condition Records
Web Dynpro Text Translation using Assistance Class
Move Minus Sign from Right to Left of Negative Number in SAP Smartform
Read Address Data using FM ADDR_GET instead of Querying ADRC Table
Add Value Help to Web Dynpro Select Options
Add Web Dynpro Applications to SAP Favorites Menu
Component Usage ALV Does Not Have an Active Component
Web Dynpro Component Service Syntax Error in Program /1BCWDY/O3EC1AX6A3OVKK9L5FXO==CP
Web DynPro Tutorial - Display Spool Requests using Web DynPro Table
Web DynPro Tutorial - How to create Web Dynpro Application (Web Dynpro Component)
Display Data on Web DynPro Table Element
Test Web Dynpro ABAP Component by Creating Web Dynpro Application
Graphics White Background Displayed Grey on SAP Smartform Output
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
How to Spell Numbers using ABAP Spell_Amount Function Module
How to Transport SAP Graphics using SE78 Transaction
How to Delete Standard Text using SO10 SAP Transaction
Dynamic Programming using Field Symbols in ABAP Reports
How to Disable Word Editor in SAP Smartform Text
How to Debug Popup Screen in ABAP
TVAP Item Category and SAP Table TVAPT for Text Translations
ABAP Runtime Error ST22 Transaction using Short Dump Analysis
Create Transport Request for Text Translations using RS_LXE_RECORD_TORDER
SAP Invoice Output Determination Analysis for Not Created Output Message
Set Default Single Values List for SAP Selection Screen Parameter
SAP Payment Terms Table and ZTERM Texts Table for ABAP Developers
How to Create SAPScript Text using SO10 Transaction Code
SAP Smartforms Tutorial - Table Calculations using Sum Total
SAP Smartforms Tutorial - Table Calculations using Count
SAP Smartforms Tutorial - How to Create Smartform
SAP NetWeaver Installation Guide using installshield wizard
SAP Smartforms Table for Sales Order and Invoice Outputs
Email Spool Request using SAPOffice - Spool to PDF
How to Display SAP Graphics using SE78 Transaction Code
SAPScript Transaction Codes
ABAP Tutorial - ABAP String Split Example Code
Sales Tables among ABAP Tables (SAP Sales and Distribution SD Tables)
How to Upload Data to SAP from Excel File using alsm_excel_to_internal_table Function Module
ALV Grid Color - Table Row Background Color in ALV List
Multi Color ALV Grid Color Alternate using ALV Layout info_fname Property
How to Debug SmartForms - Debugging SAP SmartForm in ABAP ?
ABAP - Create Hierarchy Tree List using rs_tree_construct, rs_tree_list_display and snodetext
Create CL_GUI_ALV_GRID ALV Grid Column Header using ABAP Data Element
ABAP Tutorial - SAP Split and ABAP Split String Function
Upload Data from Excel File in ABAP using TEXT_CONVERT_XLS_TO_SAP
SAP Tutorial - Convert Spool Request to PDF File using RSTXPDFT4 ABAP Report
SAP ABAP Tutorial - ALV Grid Example with cl_gui_alv_grid and Screen Painter
SAP Smartforms Tutorial - Create Smartforms Example
SAP Smartforms - How to Call Smartform within ABAP Program
Complete List of SAP Modules






Copyright © 2004 - 2012 Eralper Yilmaz. All rights reserved.
Community Server, by Telligent Systems