ABAP Select data from SAP table UCF_S_METHOD_UPLOAD_LP 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 UCF_S_METHOD_UPLOAD_LP 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 UCF_S_METHOD_UPLOAD_LP. 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 UCF_S_METHOD_UPLOAD_LP 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_UCF_S_METHOD_UPLOAD_LP TYPE STANDARD TABLE OF UCF_S_METHOD_UPLOAD_LP,
WA_UCF_S_METHOD_UPLOAD_LP TYPE UCF_S_METHOD_UPLOAD_LP,
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: <UCF_S_METHOD_UPLOAD_LP> TYPE UCF_S_METHOD_UPLOAD_LP.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_UCF_S_METHOD_UPLOAD_LP.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM UCF_S_METHOD_UPLOAD_LP
INTO TABLE IT_UCF_S_METHOD_UPLOAD_LP.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM UCF_S_METHOD_UPLOAD_LP
* INTO TABLE @DATA(IT_UCF_S_METHOD_UPLOAD_LP2).
*--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_UCF_S_METHOD_UPLOAD_LP INDEX 1 INTO DATA(WA_UCF_S_METHOD_UPLOAD_LP2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_UCF_S_METHOD_UPLOAD_LP ASSIGNING <UCF_S_METHOD_UPLOAD_LP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<UCF_S_METHOD_UPLOAD_LP>-SUMIND = 1.
<UCF_S_METHOD_UPLOAD_LP>-METHTYPE = 1.
<UCF_S_METHOD_UPLOAD_LP>-METHID = 1.
<UCF_S_METHOD_UPLOAD_LP>-METHOD_TXT = 1.
<UCF_S_METHOD_UPLOAD_LP>-UPL_METHTYPE = 1.
ENDLOOP. LOOP AT IT_UCF_S_METHOD_UPLOAD_LP INTO WA_UCF_S_METHOD_UPLOAD_LP. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_UCF_S_METHOD_UPLOAD_LP-UPL_FIELDNAME, sy-vline,
WA_UCF_S_METHOD_UPLOAD_LP-BPS_PLAREA, sy-vline,
WA_UCF_S_METHOD_UPLOAD_LP-BPS_PLEVEL, sy-vline,
WA_UCF_S_METHOD_UPLOAD_LP-BPS_METHOD, sy-vline,
WA_UCF_S_METHOD_UPLOAD_LP-BPS_PARAM, sy-vline,
WA_UCF_S_METHOD_UPLOAD_LP-BPS_METHOD_TEXT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_UCF_S_METHOD_UPLOAD_LP 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_UCF_S_METHOD_UPLOAD_LP 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_UCF_S_METHOD_UPLOAD_LP INTO WA_UCF_S_METHOD_UPLOAD_LP. *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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_UCF_S_METHOD_UPLOAD_LP_STR,
SUMIND TYPE STRING,
METHTYPE TYPE STRING,
METHID TYPE STRING,
METHOD_TXT TYPE STRING,
UPL_METHTYPE TYPE STRING,
UPL_FIELDNAME TYPE STRING,
BPS_PLAREA TYPE STRING,
BPS_PLEVEL TYPE STRING,
BPS_METHOD TYPE STRING,
BPS_PARAM TYPE STRING,
BPS_METHOD_TEXT TYPE STRING,
BPS_PARAM_TEXT TYPE STRING,
BCS_AREA TYPE STRING,
BCS_METHOD TYPE STRING,
FILETYPE TYPE STRING,
SUBLIST TYPE STRING,
SUBLIST1 TYPE STRING,
SUBLIST2 TYPE STRING,
SUBLIST3 TYPE STRING,
SUBLIST4 TYPE STRING,
SUBLIST5 TYPE STRING,
RFCDEST TYPE STRING,
INFOPROVIDER TYPE STRING,
COLUMN_WIDTH TYPE STRING,
COLUMN_FIX TYPE STRING,
COLUMN_VAR TYPE STRING,
SEPARATOR TYPE STRING,
LINETYPE TYPE STRING,
LINETYPE_INDICATORS TYPE STRING,
LINETYPE_DATA TYPE STRING,
COMMENTLINE TYPE STRING,
DIGITS TYPE STRING,
UPDATEMODE TYPE STRING,
DATAENTRY TYPE STRING,
READ_PRIPERIOD TYPE STRING,
DATAENTRY_RESTAT TYPE STRING,
FIELDCAT TYPE STRING,
FIELDNAME TYPE STRING,
TXTMI TYPE STRING,
LENGTH TYPE STRING,
USE_FIELDCAT_EXT TYPE STRING,
USE_FCAT_EXT_TXT TYPE STRING,
DATABASIS_SOURCE TYPE STRING,
SIGN_HANDLING TYPE STRING,
FIELDNAME_TEXT TYPE STRING,
BADI_FILTER TYPE STRING,
AREA_SOURCE TYPE STRING,
SEQNR TYPE STRING,
SRC_FIELDNAME_TXT TYPE STRING,
SRC_VALUE TYPE STRING,
TGT_FIELDNAME_TXT TYPE STRING,
TGT_VALUE TYPE STRING,
METHOD_CTR TYPE STRING,
MAP_TGT_FIELDNAME_SEQNR TYPE STRING,
MAP_TGT_FIELDNAME TYPE STRING,
MAP_TGT_FIELDNAME_TXT TYPE STRING,
MAP_MAPRULE TYPE STRING,
MAP_MAPRULE_TXT TYPE STRING,
MAP_MAPRULE_STATUS TYPE STRING,
MAP_MAPRULE_STATUS_TXT TYPE STRING,
MAP_SEQNR TYPE STRING,
MAP_OPERATOR_IF TYPE STRING,
MAP_IF_MOVE TYPE STRING,
MAP_OPERATOR_MOVE TYPE STRING,
MAP_MOVE_CONCAT_FLG TYPE STRING,
MAP_MOVE_CONCAT_FLG_TXT TYPE STRING,
MAP_MOVE_SEQNR TYPE STRING,
MAP_MOVE_CONSTANT TYPE STRING,
MAP_MOVE_SRC_FIELDNAME TYPE STRING,
MAP_MOVE_SRC_ATTRIBUTE TYPE STRING,
MAP_MOVE_CONVEXT TYPE STRING,
MAP_MOVE_CONVEXT_TXT TYPE STRING,
MAP_MOVE_SPLIT_OFFSET TYPE STRING,
MAP_MOVE_SPLIT_LENGTH TYPE STRING,
MAP_MOVE_SPLIT_SEPARATOR TYPE STRING,
MAP_MOVE_SPLIT_INDEX TYPE STRING,
MAP_IF_REAS TYPE STRING,
MAP_OPERATOR_REAS TYPE STRING,
MAP_REAS_SEQNR TYPE STRING,
MAP_REAS_VALUE TYPE STRING,
MAP_REAS_SELID TYPE STRING,
MAP_IF_APPL TYPE STRING,
MAP_OPERATOR_APPL TYPE STRING,
MAP_APPL_AMAPRULE TYPE STRING,
MAP_APPL_AMAPRULE_TXT TYPE STRING,
MAP_APPL_AMAPRULE_STATUS TYPE STRING,
MAP_APPL_AMAPRULE_STATUS_TXT TYPE STRING,
MAP_APPL_SEQNR TYPE STRING,
MAP_APPL_ORIG_FIELDNAME TYPE STRING,
MAP_APPL_ORIG_ATTRIBUTE TYPE STRING,
MAP_APPL_SUBST_FIELDNAME TYPE STRING,
MAP_APPL_SUBST_ATTRIBUTE TYPE STRING,
SEL_FIELDNAME TYPE STRING,
SEL_FIELD_TXT TYPE STRING,
SEL_LOW TYPE STRING,
SEL_LOW_TXT TYPE STRING,
SEL_HIGH TYPE STRING,
SEL_HIGH_TXT TYPE STRING,
SEL_AREA TYPE STRING,
SEL_SISEL TYPE STRING,
SEL_SET_TXT TYPE STRING,
SEL_SETLINE_TXT TYPE STRING,
SEL_ICON TYPE STRING,
SEL_ATTR TYPE STRING,
SEL_ATTR_TXT TYPE STRING,
SEL_NODE TYPE STRING,
SEL_NODE_TXT TYPE STRING,
SEL_SEQNR TYPE STRING,
SEL_SISEL_SEQNR TYPE STRING,
SEL_CROSS_FLG TYPE STRING,
SEL_SELID TYPE STRING,
ECC_FIELDNAME TYPE STRING,
EXT_FIELDNAME TYPE STRING,
ECC_CHECKTABLE TYPE STRING,
ECC_TEXTTABLE TYPE STRING,
AS4LOCAL TYPE STRING,END OF T_EKKO_STR. DATA: WA_UCF_S_METHOD_UPLOAD_LP_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_UCF_S_METHOD_UPLOAD_LP_STR-SUMIND sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-METHTYPE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-METHID sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-METHOD_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-UPL_METHTYPE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-UPL_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_PLAREA sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_PLEVEL sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_METHOD sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_PARAM sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_METHOD_TEXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BPS_PARAM_TEXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BCS_AREA sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BCS_METHOD sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-FILETYPE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST1 sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST2 sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST3 sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST4 sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SUBLIST5 sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-RFCDEST sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-INFOPROVIDER sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-COLUMN_WIDTH sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-COLUMN_FIX sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-COLUMN_VAR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEPARATOR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-LINETYPE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-LINETYPE_INDICATORS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-LINETYPE_DATA sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-COMMENTLINE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-DIGITS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-UPDATEMODE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-DATAENTRY sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-READ_PRIPERIOD sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-DATAENTRY_RESTAT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-FIELDCAT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-TXTMI sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-LENGTH sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-USE_FIELDCAT_EXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-USE_FCAT_EXT_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-DATABASIS_SOURCE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SIGN_HANDLING sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-FIELDNAME_TEXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-BADI_FILTER sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-AREA_SOURCE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SRC_FIELDNAME_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SRC_VALUE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-TGT_FIELDNAME_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-TGT_VALUE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-METHOD_CTR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_TGT_FIELDNAME_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_TGT_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_TGT_FIELDNAME_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MAPRULE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MAPRULE_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MAPRULE_STATUS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MAPRULE_STATUS_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_OPERATOR_IF sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_IF_MOVE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_OPERATOR_MOVE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_CONCAT_FLG sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_CONCAT_FLG_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_CONSTANT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SRC_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SRC_ATTRIBUTE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_CONVEXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_CONVEXT_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SPLIT_OFFSET sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SPLIT_LENGTH sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SPLIT_SEPARATOR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_MOVE_SPLIT_INDEX sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_IF_REAS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_OPERATOR_REAS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_REAS_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_REAS_VALUE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_REAS_SELID sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_IF_APPL sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_OPERATOR_APPL sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_AMAPRULE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_AMAPRULE_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_AMAPRULE_STATUS sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_AMAPRULE_STATUS_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_ORIG_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_ORIG_ATTRIBUTE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_SUBST_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-MAP_APPL_SUBST_ATTRIBUTE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_FIELD_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_LOW sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_LOW_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_HIGH sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_HIGH_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_AREA sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SISEL sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SET_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SETLINE_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_ICON sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_ATTR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_ATTR_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_NODE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_NODE_TXT sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SISEL_SEQNR sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_CROSS_FLG sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-SEL_SELID sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-ECC_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-EXT_FIELDNAME sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-ECC_CHECKTABLE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-ECC_TEXTTABLE sy-vline
WA_UCF_S_METHOD_UPLOAD_LP_STR-AS4LOCAL sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
