ABAP Select data from SAP table J_1UF_LINE_DATA 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_1UF_LINE_DATA 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_1UF_LINE_DATA. 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_1UF_LINE_DATA 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_1UF_LINE_DATA TYPE STANDARD TABLE OF J_1UF_LINE_DATA, WA_J_1UF_LINE_DATA TYPE J_1UF_LINE_DATA, 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_1UF_LINE_DATA> TYPE J_1UF_LINE_DATA. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_J_1UF_LINE_DATA. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM J_1UF_LINE_DATA INTO TABLE IT_J_1UF_LINE_DATA. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM J_1UF_LINE_DATA * INTO TABLE @DATA(IT_J_1UF_LINE_DATA2). *--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_1UF_LINE_DATA INDEX 1 INTO DATA(WA_J_1UF_LINE_DATA2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_J_1UF_LINE_DATA ASSIGNING <J_1UF_LINE_DATA>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_1UF_LINE_DATA>-NACL_DATE = 1.
<J_1UF_LINE_DATA>-HTRANSP = 1.
<J_1UF_LINE_DATA>-COR_REASON = 1.
<J_1UF_LINE_DATA>-HDSHKZG = 1.
<J_1UF_LINE_DATA>-HDWRBTR = 1.
ENDLOOP. LOOP AT IT_J_1UF_LINE_DATA INTO WA_J_1UF_LINE_DATA. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_J_1UF_LINE_DATA-H1WRBTR, sy-vline,
WA_J_1UF_LINE_DATA-H2WRBTR, sy-vline,
WA_J_1UF_LINE_DATA-H3WRBTR, sy-vline,
WA_J_1UF_LINE_DATA-H4WRBTR, sy-vline,
WA_J_1UF_LINE_DATA-VAT14WRBTR, sy-vline,
WA_J_1UF_LINE_DATA-VAT7WRBTR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_J_1UF_LINE_DATA 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_1UF_LINE_DATA 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_1UF_LINE_DATA INTO WA_J_1UF_LINE_DATA. *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 AD202, internal->external for field HDWRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-HDWRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-HDWRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H1WRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H1WRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H1WRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H2WRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H2WRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H2WRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H3WRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H3WRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H3WRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H4WRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H4WRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H4WRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field VAT7WRBTR CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-VAT7WRBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-VAT7WRBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H1EXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H1EXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H1EXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field VAT7EXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-VAT7EXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-VAT7EXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H2EXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H2EXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H2EXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H3EXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H3EXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H3EXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H4EXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H4EXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H4EXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field HDEXTRA CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-HDEXTRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-HDEXTRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H1DISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H1DISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H1DISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field VAT7DISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-VAT7DISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-VAT7DISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H2DISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H2DISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H2DISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H3DISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H3DISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H3DISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field H4DISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-H4DISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-H4DISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field HDDISCNT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-HDDISCNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-HDDISCNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field HDMATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-HDMATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-HDMATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_VAT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_VAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_VAT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_7PERC_VAT CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_7PERC_VAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_7PERC_VAT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_VAT2 CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_VAT2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_VAT2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_1 CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_7PERC CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_7PERC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_7PERC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_2 CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AD202, internal->external for field TOTAL_3 CALL FUNCTION 'CONVERSION_EXIT_AD202_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-TOTAL_3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-TOTAL_3.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_J_1UF_LINE_DATA-MEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_J_1UF_LINE_DATA-MEINS.
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_1UF_LINE_DATA_STR,
NACL_DATE TYPE STRING,
HTRANSP TYPE STRING,
COR_REASON TYPE STRING,
HDSHKZG TYPE STRING,
HDWRBTR TYPE STRING,
H1WRBTR TYPE STRING,
H2WRBTR TYPE STRING,
H3WRBTR TYPE STRING,
H4WRBTR TYPE STRING,
VAT14WRBTR TYPE STRING,
VAT7WRBTR TYPE STRING,
H1EXTRA TYPE STRING,
VAT14EXTRA TYPE STRING,
VAT7EXTRA TYPE STRING,
H2EXTRA TYPE STRING,
H3EXTRA TYPE STRING,
H4EXTRA TYPE STRING,
HDEXTRA TYPE STRING,
H1DISCNT TYPE STRING,
VAT14DISCNT TYPE STRING,
VAT7DISCNT TYPE STRING,
H2DISCNT TYPE STRING,
H3DISCNT TYPE STRING,
H4DISCNT TYPE STRING,
HDDISCNT TYPE STRING,
HDSGTXT TYPE STRING,
HDSGCODE TYPE STRING,
HDSGCODE12 TYPE STRING,
HDMATNR TYPE STRING,
HDMENGE TYPE STRING,
HDTMENGE TYPE STRING,
HKMENGE TYPE STRING,
HKTMENGE TYPE STRING,
HDMEINS TYPE STRING,
HDEZENA TYPE STRING,
HKEZENA TYPE STRING,
MWSKZ TYPE STRING,
HDSTUK TYPE STRING,
HDSERV TYPE STRING,
HDPRC TYPE STRING,
HDNO TYPE STRING,
R_TYPE TYPE STRING,
ERPN TYPE STRING,
TOTAL_VAT TYPE STRING,
TOTAL_14PERC_VAT TYPE STRING,
TOTAL_7PERC_VAT TYPE STRING,
TOTAL_VAT2 TYPE STRING,
TOTAL_1 TYPE STRING,
TOTAL_14PERC TYPE STRING,
TOTAL_7PERC TYPE STRING,
TOTAL_2 TYPE STRING,
TOTAL_3 TYPE STRING,
ZERO_GROUP TYPE STRING,
MEINSTXT TYPE STRING,
MEINS TYPE STRING,
HDMEINS_DESCR TYPE STRING,
MENGE_LONG TYPE STRING,
TAX_RATE TYPE STRING,
EXEMPTION_CODE TYPE STRING,
XML_TI_ITEM_NUM TYPE STRING,
SERVICE_CODE TYPE STRING,
IMPORT_FLAG TYPE STRING,
TAX_AMOUNT TYPE STRING,
TAX_RATE4CALC TYPE STRING,
GROUP_CORR TYPE STRING,
COR_RSN_CODE TYPE STRING,END OF T_EKKO_STR. DATA: WA_J_1UF_LINE_DATA_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_1UF_LINE_DATA_STR-NACL_DATE sy-vline
WA_J_1UF_LINE_DATA_STR-HTRANSP sy-vline
WA_J_1UF_LINE_DATA_STR-COR_REASON sy-vline
WA_J_1UF_LINE_DATA_STR-HDSHKZG sy-vline
WA_J_1UF_LINE_DATA_STR-HDWRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-H1WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-H2WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-H3WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-H4WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-VAT14WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-VAT7WRBTR sy-vline
WA_J_1UF_LINE_DATA_STR-H1EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-VAT14EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-VAT7EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-H2EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-H3EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-H4EXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-HDEXTRA sy-vline
WA_J_1UF_LINE_DATA_STR-H1DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-VAT14DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-VAT7DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-H2DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-H3DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-H4DISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-HDDISCNT sy-vline
WA_J_1UF_LINE_DATA_STR-HDSGTXT sy-vline
WA_J_1UF_LINE_DATA_STR-HDSGCODE sy-vline
WA_J_1UF_LINE_DATA_STR-HDSGCODE12 sy-vline
WA_J_1UF_LINE_DATA_STR-HDMATNR sy-vline
WA_J_1UF_LINE_DATA_STR-HDMENGE sy-vline
WA_J_1UF_LINE_DATA_STR-HDTMENGE sy-vline
WA_J_1UF_LINE_DATA_STR-HKMENGE sy-vline
WA_J_1UF_LINE_DATA_STR-HKTMENGE sy-vline
WA_J_1UF_LINE_DATA_STR-HDMEINS sy-vline
WA_J_1UF_LINE_DATA_STR-HDEZENA sy-vline
WA_J_1UF_LINE_DATA_STR-HKEZENA sy-vline
WA_J_1UF_LINE_DATA_STR-MWSKZ sy-vline
WA_J_1UF_LINE_DATA_STR-HDSTUK sy-vline
WA_J_1UF_LINE_DATA_STR-HDSERV sy-vline
WA_J_1UF_LINE_DATA_STR-HDPRC sy-vline
WA_J_1UF_LINE_DATA_STR-HDNO sy-vline
WA_J_1UF_LINE_DATA_STR-R_TYPE sy-vline
WA_J_1UF_LINE_DATA_STR-ERPN sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_VAT sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_14PERC_VAT sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_7PERC_VAT sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_VAT2 sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_1 sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_14PERC sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_7PERC sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_2 sy-vline
WA_J_1UF_LINE_DATA_STR-TOTAL_3 sy-vline
WA_J_1UF_LINE_DATA_STR-ZERO_GROUP sy-vline
WA_J_1UF_LINE_DATA_STR-MEINSTXT sy-vline
WA_J_1UF_LINE_DATA_STR-MEINS sy-vline
WA_J_1UF_LINE_DATA_STR-HDMEINS_DESCR sy-vline
WA_J_1UF_LINE_DATA_STR-MENGE_LONG sy-vline
WA_J_1UF_LINE_DATA_STR-TAX_RATE sy-vline
WA_J_1UF_LINE_DATA_STR-EXEMPTION_CODE sy-vline
WA_J_1UF_LINE_DATA_STR-XML_TI_ITEM_NUM sy-vline
WA_J_1UF_LINE_DATA_STR-SERVICE_CODE sy-vline
WA_J_1UF_LINE_DATA_STR-IMPORT_FLAG sy-vline
WA_J_1UF_LINE_DATA_STR-TAX_AMOUNT sy-vline
WA_J_1UF_LINE_DATA_STR-TAX_RATE4CALC sy-vline
WA_J_1UF_LINE_DATA_STR-GROUP_CORR sy-vline
WA_J_1UF_LINE_DATA_STR-COR_RSN_CODE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.