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
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow


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

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 HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.