ABAP Select data from SAP table AUTHB into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP AUTHB table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to AUTHB. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the AUTHB table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_AUTHB TYPE STANDARD TABLE OF AUTHB,
      WA_AUTHB TYPE AUTHB,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <AUTHB> TYPE AUTHB.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_AUTHB.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM AUTHB
  INTO TABLE IT_AUTHB.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM AUTHB
*  INTO TABLE @DATA(IT_AUTHB2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_AUTHB INDEX 1 INTO DATA(WA_AUTHB2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_AUTHB ASSIGNING <AUTHB>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<AUTHB>-ABAPFORM = 1.
<AUTHB>-ACTVT = 1.
<AUTHB>-ACT_GROUP = 1.
<AUTHB>-ADCOMM = 1.
<AUTHB>-ADGRP = 1.

ENDLOOP.

LOOP AT IT_AUTHB INTO WA_AUTHB.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_AUTHB-ADGRP_P, sy-vline,
  WA_AUTHB-ALG_OBJECT, sy-vline,
  WA_AUTHB-ALG_SUBOBJ, sy-vline,
  WA_AUTHB-APPLIC, sy-vline,
  WA_AUTHB-APPL_COMP, sy-vline,
  WA_AUTHB-ARCH_OBJ, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_AUTHB you want to display...

  WRITE:/ sy-uline.
* Aternatively use generic code to Write field values (and NAME) to screen report
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE wa_AUTHB TO <field>.
    IF sy-subrc <> 0. EXIT. ENDIF.
    WRITE:/ 'Field Value', <field>, sy-vline.
    gd_str = <field> .
    lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ).
    lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ).
    WRITE:/ 'Field Name', lv_fieldname.
  ENDDO.

  
*Redo loop but convert all fields from internal to out value  
LOOP AT IT_AUTHB INTO WA_AUTHB.


*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Convert all fields to display/output versions using conversion routines
  PERFORM convert_all_field_values CHANGING wa_EKKO.
	 
ENDLOOP.

  
*&---------------------------------------------------------------------*
*& Form convert_all_field_values
*&---------------------------------------------------------------------*
FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO.
DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ALPHA, internal->external for field EDI_PRN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-EDI_PRN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-EDI_PRN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field LANGUAGE
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-LANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-LANGUAGE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LOGSYS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-LOGSYS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-LOGSYS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PROJECT_ID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-PROJECT_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-PROJECT_ID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SUBSYSTEM
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-SUBSYSTEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-SUBSYSTEM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field TASK_CLASS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-TASK_CLASS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-TASK_CLASS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field TLANGUAGE
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_AUTHB-TLANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_AUTHB-TLANGUAGE.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_AUTHB_STR, 
ABAPFORM TYPE STRING,
ACTVT TYPE STRING,
ACT_GROUP TYPE STRING,
ADCOMM TYPE STRING,
ADGRP TYPE STRING,
ADGRP_P TYPE STRING,
ALG_OBJECT TYPE STRING,
ALG_SUBOBJ TYPE STRING,
APPLIC TYPE STRING,
APPL_COMP TYPE STRING,
ARCH_OBJ TYPE STRING,
AUTH TYPE STRING,
BDCAKTI TYPE STRING,
BDCGROUPID TYPE STRING,
BRANOBJ TYPE STRING,
BTCADMIN TYPE STRING,
BTCUNAME TYPE STRING,
CARRID TYPE STRING,
CCCATEGORY TYPE STRING,
CFUNCNAME TYPE STRING,
CLASS TYPE STRING,
CLIIDMAINT TYPE STRING,
COMMAND TYPE STRING,
COMMNAME TYPE STRING,
COMMOWNER TYPE STRING,
COMMTYPE TYPE STRING,
COMMUSERS TYPE STRING,
COMPONENT TYPE STRING,
COM_MODE TYPE STRING,
CPICDEST TYPE STRING,
CTS_ADMFCT TYPE STRING,
CUSTMODEL TYPE STRING,
DEVCLASS TYPE STRING,
DICBERCLS TYPE STRING,
DICLEVEL TYPE STRING,
DICOBJTYP TYPE STRING,
DOKU_ACT TYPE STRING,
DOKU_DEVCL TYPE STRING,
DOKU_MODE TYPE STRING,
DOMAIN TYPE STRING,
DXOBJ TYPE STRING,
EDI_CIM TYPE STRING,
EDI_DIR TYPE STRING,
EDI_DOC TYPE STRING,
EDI_MES TYPE STRING,
EDI_POR TYPE STRING,
EDI_PRN TYPE STRING,
EDI_PRT TYPE STRING,
EDI_TCD TYPE STRING,
EDT_ACTION TYPE STRING,
EXTCOMPANY TYPE STRING,
EXTPRODUCT TYPE STRING,
F4ACCESS TYPE STRING,
FILENAME TYPE STRING,
FORMNAME TYPE STRING,
FS_BRGRU TYPE STRING,
HOST TYPE STRING,
IMG_ACTIV TYPE STRING,
INFOTYP TYPE STRING,
INTERFACE TYPE STRING,
ISTAT TYPE STRING,
JOBACTION TYPE STRING,
JOBGROUP TYPE STRING,
LANGUAGE TYPE STRING,
LDAP_SERV TYPE STRING,
LOGSYS TYPE STRING,
MWBFCODE TYPE STRING,
NROBJ TYPE STRING,
NUMBER TYPE STRING,
OAARCHIV TYPE STRING,
OADOKUMENT TYPE STRING,
OAOBJEKTE TYPE STRING,
OBJECT TYPE STRING,
OBJECTTYPE TYPE STRING,
OBJNAME TYPE STRING,
OBJTYPE TYPE STRING,
OFFADMI TYPE STRING,
OFFTCD TYPE STRING,
OLE_APPL TYPE STRING,
OPSYSTEM TYPE STRING,
ORG_CRIT TYPE STRING,
ORG_FIELD1 TYPE STRING,
ORG_FIELD2 TYPE STRING,
ORG_FIELD3 TYPE STRING,
ORG_FIELD4 TYPE STRING,
ORG_FIELD5 TYPE STRING,
ORG_FIELD6 TYPE STRING,
ORG_FIELD7 TYPE STRING,
ORG_FIELD8 TYPE STRING,
OTYPE TYPE STRING,
PLVAR TYPE STRING,
PPFCODE TYPE STRING,
PRCTP TYPE STRING,
PROFILE TYPE STRING,
PROGRAM TYPE STRING,
PROJAUTH TYPE STRING,
PROJECT_ID TYPE STRING,
PROJ_CONF TYPE STRING,
P_ACTION TYPE STRING,
P_GROUP TYPE STRING,
QIOAKTI TYPE STRING,
QIOQID TYPE STRING,
REFMESTYP TYPE STRING,
RFCDEST TYPE STRING,
RFC_CLIENT TYPE STRING,
RFC_EQUSER TYPE STRING,
RFC_INFO TYPE STRING,
RFC_NAME TYPE STRING,
RFC_SYSID TYPE STRING,
RFC_TCODE TYPE STRING,
RFC_TYPE TYPE STRING,
RFC_USER TYPE STRING,
SECTION TYPE STRING,
SPOACTION TYPE STRING,
SPOAUTH TYPE STRING,
SPODEVICE TYPE STRING,
SPOPAGES TYPE STRING,
SQL_ACTION TYPE STRING,
STATE TYPE STRING,
STMSACTION TYPE STRING,
STMSOBJECT TYPE STRING,
STMSOWNER TYPE STRING,
STYLENAME TYPE STRING,
SUBSYSTEM TYPE STRING,
SUBTYP TYPE STRING,
SYSNAME TYPE STRING,
S_ADMI_FCD TYPE STRING,
S_ENQ_ACT TYPE STRING,
S_TSKH_ADM TYPE STRING,
TABLE TYPE STRING,
TASK_CLASS TYPE STRING,
TCD TYPE STRING,
TEXTID TYPE STRING,
TEXTNAME TYPE STRING,
TLANGUAGE TYPE STRING,
TRANOBJ TYPE STRING,
TREE_ID TYPE STRING,
TREE_TYPE TYPE STRING,
TTYPE TYPE STRING,
USER TYPE STRING,
VERSCLISYS TYPE STRING,
WFACTVT TYPE STRING,
WI_TYPE TYPE STRING,
WLVIEW TYPE STRING,
XMIEXTCOMP TYPE STRING,
XMIEXTPGM TYPE STRING,
XMILOGACC TYPE STRING,
SPERRE TYPE STRING,
GROUP_CUST TYPE STRING,END OF T_EKKO_STR.
DATA: WA_AUTHB_STR type T_EKKO_STR.

DATA: ld_text TYPE string.

LOOP AT IT_EKKO INTO WA_EKKO.
  MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR.
  CONCATENATE: sy-vline
WA_AUTHB_STR-ABAPFORM sy-vline 
WA_AUTHB_STR-ACTVT sy-vline 
WA_AUTHB_STR-ACT_GROUP sy-vline 
WA_AUTHB_STR-ADCOMM sy-vline 
WA_AUTHB_STR-ADGRP sy-vline 
WA_AUTHB_STR-ADGRP_P sy-vline 
WA_AUTHB_STR-ALG_OBJECT sy-vline 
WA_AUTHB_STR-ALG_SUBOBJ sy-vline 
WA_AUTHB_STR-APPLIC sy-vline 
WA_AUTHB_STR-APPL_COMP sy-vline 
WA_AUTHB_STR-ARCH_OBJ sy-vline 
WA_AUTHB_STR-AUTH sy-vline 
WA_AUTHB_STR-BDCAKTI sy-vline 
WA_AUTHB_STR-BDCGROUPID sy-vline 
WA_AUTHB_STR-BRANOBJ sy-vline 
WA_AUTHB_STR-BTCADMIN sy-vline 
WA_AUTHB_STR-BTCUNAME sy-vline 
WA_AUTHB_STR-CARRID sy-vline 
WA_AUTHB_STR-CCCATEGORY sy-vline 
WA_AUTHB_STR-CFUNCNAME sy-vline 
WA_AUTHB_STR-CLASS sy-vline 
WA_AUTHB_STR-CLIIDMAINT sy-vline 
WA_AUTHB_STR-COMMAND sy-vline 
WA_AUTHB_STR-COMMNAME sy-vline 
WA_AUTHB_STR-COMMOWNER sy-vline 
WA_AUTHB_STR-COMMTYPE sy-vline 
WA_AUTHB_STR-COMMUSERS sy-vline 
WA_AUTHB_STR-COMPONENT sy-vline 
WA_AUTHB_STR-COM_MODE sy-vline 
WA_AUTHB_STR-CPICDEST sy-vline 
WA_AUTHB_STR-CTS_ADMFCT sy-vline 
WA_AUTHB_STR-CUSTMODEL sy-vline 
WA_AUTHB_STR-DEVCLASS sy-vline 
WA_AUTHB_STR-DICBERCLS sy-vline 
WA_AUTHB_STR-DICLEVEL sy-vline 
WA_AUTHB_STR-DICOBJTYP sy-vline 
WA_AUTHB_STR-DOKU_ACT sy-vline 
WA_AUTHB_STR-DOKU_DEVCL sy-vline 
WA_AUTHB_STR-DOKU_MODE sy-vline 
WA_AUTHB_STR-DOMAIN sy-vline 
WA_AUTHB_STR-DXOBJ sy-vline 
WA_AUTHB_STR-EDI_CIM sy-vline 
WA_AUTHB_STR-EDI_DIR sy-vline 
WA_AUTHB_STR-EDI_DOC sy-vline 
WA_AUTHB_STR-EDI_MES sy-vline 
WA_AUTHB_STR-EDI_POR sy-vline 
WA_AUTHB_STR-EDI_PRN sy-vline 
WA_AUTHB_STR-EDI_PRT sy-vline 
WA_AUTHB_STR-EDI_TCD sy-vline 
WA_AUTHB_STR-EDT_ACTION sy-vline 
WA_AUTHB_STR-EXTCOMPANY sy-vline 
WA_AUTHB_STR-EXTPRODUCT sy-vline 
WA_AUTHB_STR-F4ACCESS sy-vline 
WA_AUTHB_STR-FILENAME sy-vline 
WA_AUTHB_STR-FORMNAME sy-vline 
WA_AUTHB_STR-FS_BRGRU sy-vline 
WA_AUTHB_STR-HOST sy-vline 
WA_AUTHB_STR-IMG_ACTIV sy-vline 
WA_AUTHB_STR-INFOTYP sy-vline 
WA_AUTHB_STR-INTERFACE sy-vline 
WA_AUTHB_STR-ISTAT sy-vline 
WA_AUTHB_STR-JOBACTION sy-vline 
WA_AUTHB_STR-JOBGROUP sy-vline 
WA_AUTHB_STR-LANGUAGE sy-vline 
WA_AUTHB_STR-LDAP_SERV sy-vline 
WA_AUTHB_STR-LOGSYS sy-vline 
WA_AUTHB_STR-MWBFCODE sy-vline 
WA_AUTHB_STR-NROBJ sy-vline 
WA_AUTHB_STR-NUMBER sy-vline 
WA_AUTHB_STR-OAARCHIV sy-vline 
WA_AUTHB_STR-OADOKUMENT sy-vline 
WA_AUTHB_STR-OAOBJEKTE sy-vline 
WA_AUTHB_STR-OBJECT sy-vline 
WA_AUTHB_STR-OBJECTTYPE sy-vline 
WA_AUTHB_STR-OBJNAME sy-vline 
WA_AUTHB_STR-OBJTYPE sy-vline 
WA_AUTHB_STR-OFFADMI sy-vline 
WA_AUTHB_STR-OFFTCD sy-vline 
WA_AUTHB_STR-OLE_APPL sy-vline 
WA_AUTHB_STR-OPSYSTEM sy-vline 
WA_AUTHB_STR-ORG_CRIT sy-vline 
WA_AUTHB_STR-ORG_FIELD1 sy-vline 
WA_AUTHB_STR-ORG_FIELD2 sy-vline 
WA_AUTHB_STR-ORG_FIELD3 sy-vline 
WA_AUTHB_STR-ORG_FIELD4 sy-vline 
WA_AUTHB_STR-ORG_FIELD5 sy-vline 
WA_AUTHB_STR-ORG_FIELD6 sy-vline 
WA_AUTHB_STR-ORG_FIELD7 sy-vline 
WA_AUTHB_STR-ORG_FIELD8 sy-vline 
WA_AUTHB_STR-OTYPE sy-vline 
WA_AUTHB_STR-PLVAR sy-vline 
WA_AUTHB_STR-PPFCODE sy-vline 
WA_AUTHB_STR-PRCTP sy-vline 
WA_AUTHB_STR-PROFILE sy-vline 
WA_AUTHB_STR-PROGRAM sy-vline 
WA_AUTHB_STR-PROJAUTH sy-vline 
WA_AUTHB_STR-PROJECT_ID sy-vline 
WA_AUTHB_STR-PROJ_CONF sy-vline 
WA_AUTHB_STR-P_ACTION sy-vline 
WA_AUTHB_STR-P_GROUP sy-vline 
WA_AUTHB_STR-QIOAKTI sy-vline 
WA_AUTHB_STR-QIOQID sy-vline 
WA_AUTHB_STR-REFMESTYP sy-vline 
WA_AUTHB_STR-RFCDEST sy-vline 
WA_AUTHB_STR-RFC_CLIENT sy-vline 
WA_AUTHB_STR-RFC_EQUSER sy-vline 
WA_AUTHB_STR-RFC_INFO sy-vline 
WA_AUTHB_STR-RFC_NAME sy-vline 
WA_AUTHB_STR-RFC_SYSID sy-vline 
WA_AUTHB_STR-RFC_TCODE sy-vline 
WA_AUTHB_STR-RFC_TYPE sy-vline 
WA_AUTHB_STR-RFC_USER sy-vline 
WA_AUTHB_STR-SECTION sy-vline 
WA_AUTHB_STR-SPOACTION sy-vline 
WA_AUTHB_STR-SPOAUTH sy-vline 
WA_AUTHB_STR-SPODEVICE sy-vline 
WA_AUTHB_STR-SPOPAGES sy-vline 
WA_AUTHB_STR-SQL_ACTION sy-vline 
WA_AUTHB_STR-STATE sy-vline 
WA_AUTHB_STR-STMSACTION sy-vline 
WA_AUTHB_STR-STMSOBJECT sy-vline 
WA_AUTHB_STR-STMSOWNER sy-vline 
WA_AUTHB_STR-STYLENAME sy-vline 
WA_AUTHB_STR-SUBSYSTEM sy-vline 
WA_AUTHB_STR-SUBTYP sy-vline 
WA_AUTHB_STR-SYSNAME sy-vline 
WA_AUTHB_STR-S_ADMI_FCD sy-vline 
WA_AUTHB_STR-S_ENQ_ACT sy-vline 
WA_AUTHB_STR-S_TSKH_ADM sy-vline 
WA_AUTHB_STR-TABLE sy-vline 
WA_AUTHB_STR-TASK_CLASS sy-vline 
WA_AUTHB_STR-TCD sy-vline 
WA_AUTHB_STR-TEXTID sy-vline 
WA_AUTHB_STR-TEXTNAME sy-vline 
WA_AUTHB_STR-TLANGUAGE sy-vline 
WA_AUTHB_STR-TRANOBJ sy-vline 
WA_AUTHB_STR-TREE_ID sy-vline 
WA_AUTHB_STR-TREE_TYPE sy-vline 
WA_AUTHB_STR-TTYPE sy-vline 
WA_AUTHB_STR-USER sy-vline 
WA_AUTHB_STR-VERSCLISYS sy-vline 
WA_AUTHB_STR-WFACTVT sy-vline 
WA_AUTHB_STR-WI_TYPE sy-vline 
WA_AUTHB_STR-WLVIEW sy-vline 
WA_AUTHB_STR-XMIEXTCOMP sy-vline 
WA_AUTHB_STR-XMIEXTPGM sy-vline 
WA_AUTHB_STR-XMILOGACC sy-vline 
WA_AUTHB_STR-SPERRE sy-vline 
WA_AUTHB_STR-GROUP_CUST sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.