ABAP Select data from SAP table J_3RF_DIXML_IZVPOL into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP J_3RF_DIXML_IZVPOL 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_3RF_DIXML_IZVPOL. 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_3RF_DIXML_IZVPOL 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_3RF_DIXML_IZVPOL TYPE STANDARD TABLE OF J_3RF_DIXML_IZVPOL,
      WA_J_3RF_DIXML_IZVPOL TYPE J_3RF_DIXML_IZVPOL,
      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_3RF_DIXML_IZVPOL> TYPE J_3RF_DIXML_IZVPOL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM J_3RF_DIXML_IZVPOL
*  INTO TABLE @DATA(IT_J_3RF_DIXML_IZVPOL2).
*--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_3RF_DIXML_IZVPOL INDEX 1 INTO DATA(WA_J_3RF_DIXML_IZVPOL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_J_3RF_DIXML_IZVPOL ASSIGNING <J_3RF_DIXML_IZVPOL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_3RF_DIXML_IZVPOL>-KEY = 1.
<J_3RF_DIXML_IZVPOL>-BUKRS = 1.
<J_3RF_DIXML_IZVPOL>-GJAHR_IN = 1.
<J_3RF_DIXML_IZVPOL>-NUM_IN = 1.
<J_3RF_DIXML_IZVPOL>-BELNR_ORIG = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_J_3RF_DIXML_IZVPOL-GJAHR_ORIG, sy-vline,
WA_J_3RF_DIXML_IZVPOL-BELNR_CORR, sy-vline,
WA_J_3RF_DIXML_IZVPOL-GJAHR_CORR, sy-vline,
WA_J_3RF_DIXML_IZVPOL-REVNO, sy-vline,
WA_J_3RF_DIXML_IZVPOL-TYPE, sy-vline,
WA_J_3RF_DIXML_IZVPOL-LIFNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_J_3RF_DIXML_IZVPOL 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_3RF_DIXML_IZVPOL 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_3RF_DIXML_IZVPOL INTO WA_J_3RF_DIXML_IZVPOL. *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 GJAHR, internal->external for field GJAHR_IN CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_J_3RF_DIXML_IZVPOL-GJAHR_IN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_3RF_DIXML_IZVPOL-GJAHR_IN.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field GJAHR_ORIG CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_J_3RF_DIXML_IZVPOL-GJAHR_ORIG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_3RF_DIXML_IZVPOL-GJAHR_ORIG.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field GJAHR_CORR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_J_3RF_DIXML_IZVPOL-GJAHR_CORR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_3RF_DIXML_IZVPOL-GJAHR_CORR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit GJAHR, internal->external for field GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_J_3RF_DIXML_IZVPOL-GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_3RF_DIXML_IZVPOL-GJAHR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field OPERATOR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_J_3RF_DIXML_IZVPOL-OPERATOR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_3RF_DIXML_IZVPOL-OPERATOR.
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_3RF_DIXML_IZVPOL_STR,
KEY TYPE STRING,
BUKRS TYPE STRING,
GJAHR_IN TYPE STRING,
NUM_IN TYPE STRING,
BELNR_ORIG TYPE STRING,
GJAHR_ORIG TYPE STRING,
BELNR_CORR TYPE STRING,
GJAHR_CORR TYPE STRING,
REVNO TYPE STRING,
TYPE TYPE STRING,
LIFNR TYPE STRING,
KUNNR TYPE STRING,
FILEPROGVAR TYPE STRING,
FILEFORMVER TYPE STRING,
FILENAME TYPE STRING,
KND TYPE STRING,
TGKEY TYPE STRING,
BUKRS TYPE STRING,
GJAHR TYPE STRING,
NUM TYPE STRING,
DOC_TYPE TYPE STRING,
LIFNR TYPE STRING,
KUNNR TYPE STRING,
OPER_NAME TYPE STRING,
OPER_INN TYPE STRING,
OPER_ID TYPE STRING,
OPERATOR TYPE STRING,
RECV_FILE TYPE STRING,
RECV_DATE TYPE STRING,
RECV_TIME TYPE STRING,
RECV_DI_SIGN TYPE STRING,
RECV_INVOICE TYPE STRING,
NAME_ORIG TYPE STRING,
DATE_ORIG TYPE STRING,
EXT_ORIG TYPE STRING,
DATE_REV TYPE STRING,
REVNO TYPE STRING,
DATE_CORR TYPE STRING,
EXT_CORR TYPE STRING,
DATE_CORR_REV TYPE STRING,
REVNO_CORR TYPE STRING,
SENDER TYPE STRING,
ID TYPE STRING,
ORG_NAME TYPE STRING,
INN TYPE STRING,
KPP TYPE STRING,
ADDR TYPE STRING,
COUNTRY TYPE STRING,
FULL_ADDRESS TYPE STRING,
POSTCODE TYPE STRING,
REGION TYPE STRING,
CITY1 TYPE STRING,
CITY2 TYPE STRING,
CITY3 TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM1 TYPE STRING,
HOUSE_NUM2 TYPE STRING,
LOCATION TYPE STRING,
PERSON TYPE STRING,
LAST_NAME TYPE STRING,
FIRST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
JOBPOS TYPE STRING,
INN TYPE STRING,
SVIDET TYPE STRING,
ADDITIONAL_DATA TYPE STRING,
AUTH_BASIS_ORG TYPE STRING,
AUTH_BASIS TYPE STRING,
ORG_NAME TYPE STRING,
PARTNER_TYPE TYPE STRING,
RECEIVER TYPE STRING,
ID TYPE STRING,
ORG_NAME TYPE STRING,
INN TYPE STRING,
KPP TYPE STRING,
ADDR TYPE STRING,
COUNTRY TYPE STRING,
FULL_ADDRESS TYPE STRING,
POSTCODE TYPE STRING,
REGION TYPE STRING,
CITY1 TYPE STRING,
CITY2 TYPE STRING,
CITY3 TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM1 TYPE STRING,
HOUSE_NUM2 TYPE STRING,
LOCATION TYPE STRING,
PERSON TYPE STRING,
LAST_NAME TYPE STRING,
FIRST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
JOBPOS TYPE STRING,
INN TYPE STRING,
SVIDET TYPE STRING,
ADDITIONAL_DATA TYPE STRING,
AUTH_BASIS_ORG TYPE STRING,
AUTH_BASIS TYPE STRING,
ORG_NAME TYPE STRING,
PARTNER_TYPE TYPE STRING,
SIGNATURE TYPE STRING,
LAST_NAME TYPE STRING,
FIRST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
JOBPOS TYPE STRING,
INN TYPE STRING,
SVIDET TYPE STRING,
ADDITIONAL_DATA TYPE STRING,
AUTH_BASIS_ORG TYPE STRING,
AUTH_BASIS TYPE STRING,
ORG_NAME TYPE STRING,END OF T_EKKO_STR. DATA: WA_J_3RF_DIXML_IZVPOL_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_3RF_DIXML_IZVPOL_STR-KEY sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-BUKRS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-GJAHR_IN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-NUM_IN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-BELNR_ORIG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-GJAHR_ORIG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-BELNR_CORR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-GJAHR_CORR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-REVNO sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-TYPE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LIFNR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-KUNNR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FILEPROGVAR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FILEFORMVER sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FILENAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-KND sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-TGKEY sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-BUKRS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-GJAHR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-NUM sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-DOC_TYPE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LIFNR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-KUNNR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-OPER_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-OPER_INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-OPER_ID sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-OPERATOR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECV_FILE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECV_DATE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECV_TIME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECV_DI_SIGN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECV_INVOICE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-NAME_ORIG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-DATE_ORIG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-EXT_ORIG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-DATE_REV sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-REVNO sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-DATE_CORR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-EXT_CORR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-DATE_CORR_REV sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-REVNO_CORR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-SENDER sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ID sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ORG_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-KPP sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ADDR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-COUNTRY sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FULL_ADDRESS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-POSTCODE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-REGION sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY1 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY2 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY3 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-STREET sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-HOUSE_NUM1 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-HOUSE_NUM2 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LOCATION sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-PERSON sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LAST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FIRST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-MIDDLE_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-JOBPOS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-SVIDET sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ADDITIONAL_DATA sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS_ORG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ORG_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-PARTNER_TYPE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-RECEIVER sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ID sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ORG_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-KPP sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ADDR sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-COUNTRY sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FULL_ADDRESS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-POSTCODE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-REGION sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY1 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY2 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-CITY3 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-STREET sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-HOUSE_NUM1 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-HOUSE_NUM2 sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LOCATION sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-PERSON sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LAST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FIRST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-MIDDLE_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-JOBPOS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-SVIDET sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ADDITIONAL_DATA sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS_ORG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ORG_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-PARTNER_TYPE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-SIGNATURE sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-LAST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-FIRST_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-MIDDLE_NAME sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-JOBPOS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-INN sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-SVIDET sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ADDITIONAL_DATA sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS_ORG sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-AUTH_BASIS sy-vline
WA_J_3RF_DIXML_IZVPOL_STR-ORG_NAME sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.