ABAP Select data from SAP table J_7LPUBS 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 J_7LPUBS 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 J_7LPUBS. 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 J_7LPUBS 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_J_7LPUBS TYPE STANDARD TABLE OF J_7LPUBS,
      WA_J_7LPUBS TYPE J_7LPUBS,
      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: <J_7LPUBS> TYPE J_7LPUBS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM J_7LPUBS
*  INTO TABLE @DATA(IT_J_7LPUBS2).
*--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_J_7LPUBS INDEX 1 INTO DATA(WA_J_7LPUBS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_7LPUBS>-ICON = 1.
<J_7LPUBS>-ICON_FI = 1.
<J_7LPUBS>-VBELN = 1.
<J_7LPUBS>-BUDAT = 1.
<J_7LPUBS>-BLTYP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_J_7LPUBS-BLART, sy-vline,
  WA_J_7LPUBS-MBELN, sy-vline,
  WA_J_7LPUBS-SVBLN, sy-vline,
  WA_J_7LPUBS-VBLNS, sy-vline,
  WA_J_7LPUBS-VBLN_PRE, sy-vline,
  WA_J_7LPUBS-MWSKZ, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_J_7LPUBS 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_J_7LPUBS 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_J_7LPUBS INTO WA_J_7LPUBS.


*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 VBELN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_J_7LPUBS-VBELN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_J_7LPUBS-VBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit EXCRT, internal->external for field KURSF
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_J_7LPUBS-KURSF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_J_7LPUBS-KURSF.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_J_7LPUBS-GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_J_7LPUBS-GJAHR.
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_J_7LPUBS_STR, 
ICON TYPE STRING,
ICON_FI TYPE STRING,
VBELN TYPE STRING,
BUDAT TYPE STRING,
BLTYP TYPE STRING,
BLART TYPE STRING,
MBELN TYPE STRING,
SVBLN TYPE STRING,
VBLNS TYPE STRING,
VBLN_PRE TYPE STRING,
MWSKZ TYPE STRING,
RUNDG TYPE STRING,
WAERU TYPE STRING,
NETWE TYPE STRING,
NETSE TYPE STRING,
KORWE TYPE STRING,
MWSBE TYPE STRING,
MWSKE TYPE STRING,
KURST TYPE STRING,
KURSD TYPE STRING,
KURSF TYPE STRING,
WAERK TYPE STRING,
NETWR TYPE STRING,
NETSR TYPE STRING,
KORWR TYPE STRING,
MWSBR TYPE STRING,
MWSKR TYPE STRING,
NETSH TYPE STRING,
KORWH TYPE STRING,
MWSBH TYPE STRING,
MWSKH TYPE STRING,
NETWB TYPE STRING,
MWSBB TYPE STRING,
ENTNA TYPE STRING,
ENTNR TYPE STRING,
BUKRS TYPE STRING,
LAND1 TYPE STRING,
ZNEHM TYPE STRING,
PLVRS TYPE STRING,
KPROZ TYPE STRING,
KZPRAD TYPE STRING,
PERINR TYPE STRING,
PERID TYPE STRING,
PERIO_GELD TYPE STRING,
DATPE TYPE STRING,
DATAB TYPE STRING,
DATBI TYPE STRING,
GJAHR TYPE STRING,
RSPOID_VK TYPE STRING,
RSPOID_VB TYPE STRING,
RSPOID_VX TYPE STRING,
FMGRP TYPE STRING,
FMGBA TYPE STRING,
PGNAM TYPE STRING,
RONAM TYPE STRING,
DTANAM TYPE STRING,
FONAM TYPE STRING,
DTAKZ TYPE STRING,
KZKUER TYPE STRING,END OF T_EKKO_STR.
DATA: WA_J_7LPUBS_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_J_7LPUBS_STR-ICON sy-vline 
WA_J_7LPUBS_STR-ICON_FI sy-vline 
WA_J_7LPUBS_STR-VBELN sy-vline 
WA_J_7LPUBS_STR-BUDAT sy-vline 
WA_J_7LPUBS_STR-BLTYP sy-vline 
WA_J_7LPUBS_STR-BLART sy-vline 
WA_J_7LPUBS_STR-MBELN sy-vline 
WA_J_7LPUBS_STR-SVBLN sy-vline 
WA_J_7LPUBS_STR-VBLNS sy-vline 
WA_J_7LPUBS_STR-VBLN_PRE sy-vline 
WA_J_7LPUBS_STR-MWSKZ sy-vline 
WA_J_7LPUBS_STR-RUNDG sy-vline 
WA_J_7LPUBS_STR-WAERU sy-vline 
WA_J_7LPUBS_STR-NETWE sy-vline 
WA_J_7LPUBS_STR-NETSE sy-vline 
WA_J_7LPUBS_STR-KORWE sy-vline 
WA_J_7LPUBS_STR-MWSBE sy-vline 
WA_J_7LPUBS_STR-MWSKE sy-vline 
WA_J_7LPUBS_STR-KURST sy-vline 
WA_J_7LPUBS_STR-KURSD sy-vline 
WA_J_7LPUBS_STR-KURSF sy-vline 
WA_J_7LPUBS_STR-WAERK sy-vline 
WA_J_7LPUBS_STR-NETWR sy-vline 
WA_J_7LPUBS_STR-NETSR sy-vline 
WA_J_7LPUBS_STR-KORWR sy-vline 
WA_J_7LPUBS_STR-MWSBR sy-vline 
WA_J_7LPUBS_STR-MWSKR sy-vline 
WA_J_7LPUBS_STR-NETSH sy-vline 
WA_J_7LPUBS_STR-KORWH sy-vline 
WA_J_7LPUBS_STR-MWSBH sy-vline 
WA_J_7LPUBS_STR-MWSKH sy-vline 
WA_J_7LPUBS_STR-NETWB sy-vline 
WA_J_7LPUBS_STR-MWSBB sy-vline 
WA_J_7LPUBS_STR-ENTNA sy-vline 
WA_J_7LPUBS_STR-ENTNR sy-vline 
WA_J_7LPUBS_STR-BUKRS sy-vline 
WA_J_7LPUBS_STR-LAND1 sy-vline 
WA_J_7LPUBS_STR-ZNEHM sy-vline 
WA_J_7LPUBS_STR-PLVRS sy-vline 
WA_J_7LPUBS_STR-KPROZ sy-vline 
WA_J_7LPUBS_STR-KZPRAD sy-vline 
WA_J_7LPUBS_STR-PERINR sy-vline 
WA_J_7LPUBS_STR-PERID sy-vline 
WA_J_7LPUBS_STR-PERIO_GELD sy-vline 
WA_J_7LPUBS_STR-DATPE sy-vline 
WA_J_7LPUBS_STR-DATAB sy-vline 
WA_J_7LPUBS_STR-DATBI sy-vline 
WA_J_7LPUBS_STR-GJAHR sy-vline 
WA_J_7LPUBS_STR-RSPOID_VK sy-vline 
WA_J_7LPUBS_STR-RSPOID_VB sy-vline 
WA_J_7LPUBS_STR-RSPOID_VX sy-vline 
WA_J_7LPUBS_STR-FMGRP sy-vline 
WA_J_7LPUBS_STR-FMGBA sy-vline 
WA_J_7LPUBS_STR-PGNAM sy-vline 
WA_J_7LPUBS_STR-RONAM sy-vline 
WA_J_7LPUBS_STR-DTANAM sy-vline 
WA_J_7LPUBS_STR-FONAM sy-vline 
WA_J_7LPUBS_STR-DTAKZ sy-vline 
WA_J_7LPUBS_STR-KZKUER sy-vline      INTO ld_text SEPARATED BY SPACE.

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