ABAP Select data from SAP table FMBLCOREIN 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 FMBLCOREIN 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 FMBLCOREIN. 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 FMBLCOREIN 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_FMBLCOREIN TYPE STANDARD TABLE OF FMBLCOREIN,
      WA_FMBLCOREIN TYPE FMBLCOREIN,
      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: <FMBLCOREIN> TYPE FMBLCOREIN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FMBLCOREIN
*  INTO TABLE @DATA(IT_FMBLCOREIN2).
*--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_FMBLCOREIN INDEX 1 INTO DATA(WA_FMBLCOREIN2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FMBLCOREIN ASSIGNING <FMBLCOREIN>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FMBLCOREIN>-OBJ_TYPE = 1.
<FMBLCOREIN>-OBJ_SYS = 1.
<FMBLCOREIN>-REF_ORG_UN = 1.
<FMBLCOREIN>-REFDOCNR = 1.
<FMBLCOREIN>-OBJ_POS = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FMBLCOREIN-OBJ_ID, sy-vline,
WA_FMBLCOREIN-COMP_CODE, sy-vline,
WA_FMBLCOREIN-FMBLAREA, sy-vline,
WA_FMBLCOREIN-GL_ACCOUNT, sy-vline,
WA_FMBLCOREIN-GL_ACCOUNT_OFFSET, sy-vline,
WA_FMBLCOREIN-VALUE_TYPE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FMBLCOREIN 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_FMBLCOREIN 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_FMBLCOREIN INTO WA_FMBLCOREIN. *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 OBJ_SYS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FMBLCOREIN-OBJ_SYS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FMBLCOREIN-OBJ_SYS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit FMCIL, internal->external for field CMMT_ITEM CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT' EXPORTING input = WA_FMBLCOREIN-CMMT_ITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FMBLCOREIN-CMMT_ITEM.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ABPSP, internal->external for field WBS_ELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FMBLCOREIN-WBS_ELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FMBLCOREIN-WBS_ELEMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit IMKEY, internal->external for field IMKEY CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT' EXPORTING input = WA_FMBLCOREIN-IMKEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FMBLCOREIN-IMKEY.
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_FMBLCOREIN_STR,
OBJ_TYPE TYPE STRING,
OBJ_SYS TYPE STRING,
REF_ORG_UN TYPE STRING,
REFDOCNR TYPE STRING,
OBJ_POS TYPE STRING,
OBJ_ID TYPE STRING,
COMP_CODE TYPE STRING,
FMBLAREA TYPE STRING,
GL_ACCOUNT TYPE STRING,
GL_ACCOUNT_OFFSET TYPE STRING,
VALUE_TYPE TYPE STRING,
TRANSAC TYPE STRING,
AMT_TYPE TYPE STRING,
LEDGER TYPE STRING,
FM_AREA TYPE STRING,
CARRYFWD_LEVEL TYPE STRING,
CFSTAT TYPE STRING,
BL_DOC_TYPE TYPE STRING,
LOCAL_AMT TYPE STRING,
TRANS_AMT TYPE STRING,
LOCAL_AMT2 TYPE STRING,
LOCAL_AMT3 TYPE STRING,
CURR_KEY TYPE STRING,
BDGT_SUBTYPE TYPE STRING,
VBUND_FLG TYPE STRING,
TRADE_ID TYPE STRING,
FISC_YEAR TYPE STRING,
PSTNG_PERIOD TYPE STRING,
PSTNG_DATE TYPE STRING,
DOC_DATE TYPE STRING,
CMMT_ITEM TYPE STRING,
FUNDS_CTR TYPE STRING,
FUND TYPE STRING,
FUNC_AREA TYPE STRING,
MEASURE TYPE STRING,
USER_DIM TYPE STRING,
OBJECT_NO TYPE STRING,
COST_CTR TYPE STRING,
ORDER_NUM TYPE STRING,
WBS_ELEMENT TYPE STRING,
ENTRY_USER TYPE STRING,
ENTRY_DATE TYPE STRING,
ENTRY_TIME TYPE STRING,
COHORT TYPE STRING,
PUBLAW TYPE STRING,
LEGIS TYPE STRING,
BUS_AREA TYPE STRING,
PROFIT_CTR TYPE STRING,
FLG_COLLECT TYPE STRING,
FLG_COLLECT_OFFSET TYPE STRING,
NEG_POSTNG TYPE STRING,
TRANSAC_REFRESH TYPE STRING,
LINE_TYPE TYPE STRING,
AC_DOC_NO TYPE STRING,
DOC_TYPE TYPE STRING,
REFBT TYPE STRING,
VREFBT TYPE STRING,
VREFBN TYPE STRING,
VRFPOS TYPE STRING,
VRFKNT TYPE STRING,
VRFTYP TYPE STRING,
VRFSYS TYPE STRING,
VRFORG TYPE STRING,
FMVOR TYPE STRING,
STAT_IND TYPE STRING,
VENDOR_NO TYPE STRING,
CUSTOMER TYPE STRING,
FMCMMTSTR TYPE STRING,
CASH_YEAR TYPE STRING,
FLG_COVERED TYPE STRING,
FLG_CUSTODIAL TYPE STRING,
FLG_ENTITY TYPE STRING,
FLG_EXCHANGE TYPE STRING,
FLG_FEDERAL TYPE STRING,
FLG_APPORT TYPE STRING,
FLG_AVAIL TYPE STRING,
FLG_BORROW TYPE STRING,
FLG_DEFINITE TYPE STRING,
FLG_PARTNER TYPE STRING,
FLG_REIMBUR TYPE STRING,
FLG_AUTHOR TYPE STRING,
FLG_BEA TYPE STRING,
FUND_TYPE TYPE STRING,
FM_FINUSE TYPE STRING,
TRANSFER_AGENCY TYPE STRING,
TRANSFER_ACCOUNT TYPE STRING,
RCOMP TYPE STRING,
BUD_PROCESS TYPE STRING,
ASSSETTRTYP TYPE STRING,
BUDGET_PD TYPE STRING,
FLG_NO_DELETE TYPE STRING,
FMFGUS_KEY TYPE STRING,
IMKEY TYPE STRING,
INTRENO TYPE STRING,END OF T_EKKO_STR. DATA: WA_FMBLCOREIN_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_FMBLCOREIN_STR-OBJ_TYPE sy-vline
WA_FMBLCOREIN_STR-OBJ_SYS sy-vline
WA_FMBLCOREIN_STR-REF_ORG_UN sy-vline
WA_FMBLCOREIN_STR-REFDOCNR sy-vline
WA_FMBLCOREIN_STR-OBJ_POS sy-vline
WA_FMBLCOREIN_STR-OBJ_ID sy-vline
WA_FMBLCOREIN_STR-COMP_CODE sy-vline
WA_FMBLCOREIN_STR-FMBLAREA sy-vline
WA_FMBLCOREIN_STR-GL_ACCOUNT sy-vline
WA_FMBLCOREIN_STR-GL_ACCOUNT_OFFSET sy-vline
WA_FMBLCOREIN_STR-VALUE_TYPE sy-vline
WA_FMBLCOREIN_STR-TRANSAC sy-vline
WA_FMBLCOREIN_STR-AMT_TYPE sy-vline
WA_FMBLCOREIN_STR-LEDGER sy-vline
WA_FMBLCOREIN_STR-FM_AREA sy-vline
WA_FMBLCOREIN_STR-CARRYFWD_LEVEL sy-vline
WA_FMBLCOREIN_STR-CFSTAT sy-vline
WA_FMBLCOREIN_STR-BL_DOC_TYPE sy-vline
WA_FMBLCOREIN_STR-LOCAL_AMT sy-vline
WA_FMBLCOREIN_STR-TRANS_AMT sy-vline
WA_FMBLCOREIN_STR-LOCAL_AMT2 sy-vline
WA_FMBLCOREIN_STR-LOCAL_AMT3 sy-vline
WA_FMBLCOREIN_STR-CURR_KEY sy-vline
WA_FMBLCOREIN_STR-BDGT_SUBTYPE sy-vline
WA_FMBLCOREIN_STR-VBUND_FLG sy-vline
WA_FMBLCOREIN_STR-TRADE_ID sy-vline
WA_FMBLCOREIN_STR-FISC_YEAR sy-vline
WA_FMBLCOREIN_STR-PSTNG_PERIOD sy-vline
WA_FMBLCOREIN_STR-PSTNG_DATE sy-vline
WA_FMBLCOREIN_STR-DOC_DATE sy-vline
WA_FMBLCOREIN_STR-CMMT_ITEM sy-vline
WA_FMBLCOREIN_STR-FUNDS_CTR sy-vline
WA_FMBLCOREIN_STR-FUND sy-vline
WA_FMBLCOREIN_STR-FUNC_AREA sy-vline
WA_FMBLCOREIN_STR-MEASURE sy-vline
WA_FMBLCOREIN_STR-USER_DIM sy-vline
WA_FMBLCOREIN_STR-OBJECT_NO sy-vline
WA_FMBLCOREIN_STR-COST_CTR sy-vline
WA_FMBLCOREIN_STR-ORDER_NUM sy-vline
WA_FMBLCOREIN_STR-WBS_ELEMENT sy-vline
WA_FMBLCOREIN_STR-ENTRY_USER sy-vline
WA_FMBLCOREIN_STR-ENTRY_DATE sy-vline
WA_FMBLCOREIN_STR-ENTRY_TIME sy-vline
WA_FMBLCOREIN_STR-COHORT sy-vline
WA_FMBLCOREIN_STR-PUBLAW sy-vline
WA_FMBLCOREIN_STR-LEGIS sy-vline
WA_FMBLCOREIN_STR-BUS_AREA sy-vline
WA_FMBLCOREIN_STR-PROFIT_CTR sy-vline
WA_FMBLCOREIN_STR-FLG_COLLECT sy-vline
WA_FMBLCOREIN_STR-FLG_COLLECT_OFFSET sy-vline
WA_FMBLCOREIN_STR-NEG_POSTNG sy-vline
WA_FMBLCOREIN_STR-TRANSAC_REFRESH sy-vline
WA_FMBLCOREIN_STR-LINE_TYPE sy-vline
WA_FMBLCOREIN_STR-AC_DOC_NO sy-vline
WA_FMBLCOREIN_STR-DOC_TYPE sy-vline
WA_FMBLCOREIN_STR-REFBT sy-vline
WA_FMBLCOREIN_STR-VREFBT sy-vline
WA_FMBLCOREIN_STR-VREFBN sy-vline
WA_FMBLCOREIN_STR-VRFPOS sy-vline
WA_FMBLCOREIN_STR-VRFKNT sy-vline
WA_FMBLCOREIN_STR-VRFTYP sy-vline
WA_FMBLCOREIN_STR-VRFSYS sy-vline
WA_FMBLCOREIN_STR-VRFORG sy-vline
WA_FMBLCOREIN_STR-FMVOR sy-vline
WA_FMBLCOREIN_STR-STAT_IND sy-vline
WA_FMBLCOREIN_STR-VENDOR_NO sy-vline
WA_FMBLCOREIN_STR-CUSTOMER sy-vline
WA_FMBLCOREIN_STR-FMCMMTSTR sy-vline
WA_FMBLCOREIN_STR-CASH_YEAR sy-vline
WA_FMBLCOREIN_STR-FLG_COVERED sy-vline
WA_FMBLCOREIN_STR-FLG_CUSTODIAL sy-vline
WA_FMBLCOREIN_STR-FLG_ENTITY sy-vline
WA_FMBLCOREIN_STR-FLG_EXCHANGE sy-vline
WA_FMBLCOREIN_STR-FLG_FEDERAL sy-vline
WA_FMBLCOREIN_STR-FLG_APPORT sy-vline
WA_FMBLCOREIN_STR-FLG_AVAIL sy-vline
WA_FMBLCOREIN_STR-FLG_BORROW sy-vline
WA_FMBLCOREIN_STR-FLG_DEFINITE sy-vline
WA_FMBLCOREIN_STR-FLG_PARTNER sy-vline
WA_FMBLCOREIN_STR-FLG_REIMBUR sy-vline
WA_FMBLCOREIN_STR-FLG_AUTHOR sy-vline
WA_FMBLCOREIN_STR-FLG_BEA sy-vline
WA_FMBLCOREIN_STR-FUND_TYPE sy-vline
WA_FMBLCOREIN_STR-FM_FINUSE sy-vline
WA_FMBLCOREIN_STR-TRANSFER_AGENCY sy-vline
WA_FMBLCOREIN_STR-TRANSFER_ACCOUNT sy-vline
WA_FMBLCOREIN_STR-RCOMP sy-vline
WA_FMBLCOREIN_STR-BUD_PROCESS sy-vline
WA_FMBLCOREIN_STR-ASSSETTRTYP sy-vline
WA_FMBLCOREIN_STR-BUDGET_PD sy-vline
WA_FMBLCOREIN_STR-FLG_NO_DELETE sy-vline
WA_FMBLCOREIN_STR-FMFGUS_KEY sy-vline
WA_FMBLCOREIN_STR-IMKEY sy-vline
WA_FMBLCOREIN_STR-INTRENO sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.