ABAP Select data from SAP table JBIUBOW 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 JBIUBOW 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 JBIUBOW. 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 JBIUBOW 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_JBIUBOW TYPE STANDARD TABLE OF JBIUBOW, WA_JBIUBOW TYPE JBIUBOW, 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: <JBIUBOW> TYPE JBIUBOW. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_JBIUBOW. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM JBIUBOW INTO TABLE IT_JBIUBOW. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM JBIUBOW * INTO TABLE @DATA(IT_JBIUBOW2). *--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_JBIUBOW INDEX 1 INTO DATA(WA_JBIUBOW2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_JBIUBOW ASSIGNING <JBIUBOW>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<JBIUBOW>-BUKRS = 1.
<JBIUBOW>-RPORTB = 1.
<JBIUBOW>-RANLW = 1.
<JBIUBOW>-RLDEPO = 1.
<JBIUBOW>-WBWAER = 1.
ENDLOOP. LOOP AT IT_JBIUBOW INTO WA_JBIUBOW. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_JBIUBOW-SSHLNG, sy-vline,
WA_JBIUBOW-GSART, sy-vline,
WA_JBIUBOW-DBSTND, sy-vline,
WA_JBIUBOW-ABMENG, sy-vline,
WA_JBIUBOW-ABMENGV, sy-vline,
WA_JBIUBOW-ABKNTK, sy-vline.
ENDLOOP. *Add any further fields from structure WA_JBIUBOW 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_JBIUBOW 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_JBIUBOW INTO WA_JBIUBOW. *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 RANLW CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_JBIUBOW-RANLW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_JBIUBOW-RANLW.
WRITE:/ 'New Value:', ld_input.
*Conversion exit EXCRT, internal->external for field KGLDKU CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_JBIUBOW-KGLDKU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_JBIUBOW-KGLDKU.
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_JBIUBOW_STR,
BUKRS TYPE STRING,
RPORTB TYPE STRING,
RANLW TYPE STRING,
RLDEPO TYPE STRING,
WBWAER TYPE STRING,
SSHLNG TYPE STRING,
GSART TYPE STRING,
DBSTND TYPE STRING,
ABMENG TYPE STRING,
ABMENGV TYPE STRING,
ABKNTK TYPE STRING,
ABKNTKV TYPE STRING,
BBBETR TYPE STRING,
BBBETRV TYPE STRING,
BPGLDKU TYPE STRING,
BGLDKU TYPE STRING,
KGLDKU TYPE STRING,
NGLDKU TYPE STRING,
SMODE TYPE STRING,
EGLDKU TYPE STRING,
DLBWRT TYPE STRING,
SERROR TYPE STRING,
RBESTO TYPE STRING,
SANLF TYPE STRING,
OBJNR TYPE STRING,
ORG_INDEX TYPE STRING,END OF T_EKKO_STR. DATA: WA_JBIUBOW_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_JBIUBOW_STR-BUKRS sy-vline
WA_JBIUBOW_STR-RPORTB sy-vline
WA_JBIUBOW_STR-RANLW sy-vline
WA_JBIUBOW_STR-RLDEPO sy-vline
WA_JBIUBOW_STR-WBWAER sy-vline
WA_JBIUBOW_STR-SSHLNG sy-vline
WA_JBIUBOW_STR-GSART sy-vline
WA_JBIUBOW_STR-DBSTND sy-vline
WA_JBIUBOW_STR-ABMENG sy-vline
WA_JBIUBOW_STR-ABMENGV sy-vline
WA_JBIUBOW_STR-ABKNTK sy-vline
WA_JBIUBOW_STR-ABKNTKV sy-vline
WA_JBIUBOW_STR-BBBETR sy-vline
WA_JBIUBOW_STR-BBBETRV sy-vline
WA_JBIUBOW_STR-BPGLDKU sy-vline
WA_JBIUBOW_STR-BGLDKU sy-vline
WA_JBIUBOW_STR-KGLDKU sy-vline
WA_JBIUBOW_STR-NGLDKU sy-vline
WA_JBIUBOW_STR-SMODE sy-vline
WA_JBIUBOW_STR-EGLDKU sy-vline
WA_JBIUBOW_STR-DLBWRT sy-vline
WA_JBIUBOW_STR-SERROR sy-vline
WA_JBIUBOW_STR-RBESTO sy-vline
WA_JBIUBOW_STR-SANLF sy-vline
WA_JBIUBOW_STR-OBJNR sy-vline
WA_JBIUBOW_STR-ORG_INDEX sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.