ABAP Select data from SAP table IFMBDGECDOCS 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 IFMBDGECDOCS 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 IFMBDGECDOCS. 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 IFMBDGECDOCS 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_IFMBDGECDOCS TYPE STANDARD TABLE OF IFMBDGECDOCS, WA_IFMBDGECDOCS TYPE IFMBDGECDOCS, 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: <IFMBDGECDOCS> TYPE IFMBDGECDOCS. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_IFMBDGECDOCS. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM IFMBDGECDOCS INTO TABLE IT_IFMBDGECDOCS. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM IFMBDGECDOCS * INTO TABLE @DATA(IT_IFMBDGECDOCS2). *--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_IFMBDGECDOCS INDEX 1 INTO DATA(WA_IFMBDGECDOCS2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_IFMBDGECDOCS ASSIGNING <IFMBDGECDOCS>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<IFMBDGECDOCS>-MANDT = 1.
<IFMBDGECDOCS>-BUDGETCHANGEDOCUMENT = 1.
<IFMBDGECDOCS>-FINMGMTAREAFISCALYEAR = 1.
<IFMBDGECDOCS>-FINANCIALMANAGEMENTAREA = 1.
<IFMBDGECDOCS>-BUDGETCATEGORY = 1.
ENDLOOP. LOOP AT IT_IFMBDGECDOCS INTO WA_IFMBDGECDOCS. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_IFMBDGECDOCS-BUDGETCHANGEDOCUMENTITEM, sy-vline,
WA_IFMBDGECDOCS-BUDGETDOCUMENTYEAR, sy-vline,
WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENT, sy-vline,
WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENTITEM, sy-vline,
WA_IFMBDGECDOCS-BUDGETEDFUND, sy-vline,
WA_IFMBDGECDOCS-BUDGETEDFUNDSCENTER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IFMBDGECDOCS 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_IFMBDGECDOCS 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_IFMBDGECDOCS INTO WA_IFMBDGECDOCS. *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 BUDGETCHANGEDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETCHANGEDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETCHANGEDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field FINMGMTAREAFISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-FINMGMTAREAFISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-FINMGMTAREAFISCALYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUDGETCATEGORY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETCATEGORY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETCATEGORY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field BUDGETDOCUMENTYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETDOCUMENTYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETDOCUMENTYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUDGETENTRYDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit FMCIL, internal->external for field BUDGETEDCOMMITMENTITEM CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETEDCOMMITMENTITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETEDCOMMITMENTITEM.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUDGETEDGRANTID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETEDGRANTID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETEDGRANTID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field BDGTCASHEFFECTIVITYFISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BDGTCASHEFFECTIVITYFISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BDGTCASHEFFECTIVITYFISCALYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUDGETVERSION CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETVERSION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETVERSION.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUDGETENTRYDOCUMENTFAMILY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENTFAMILY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-BUDGETENTRYDOCUMENTFAMILY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field REVERSALREFBUDGETENTRYDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-REVERSALREFBUDGETENTRYDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-REVERSALREFBUDGETENTRYDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LOGICALSYSTEM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-LOGICALSYSTEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-LOGICALSYSTEM.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PARTNERCOMPANY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-PARTNERCOMPANY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-PARTNERCOMPANY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field REFERENCEDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-REFERENCEDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-REFERENCEDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field REFERENCEDOCUMENTFISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IFMBDGECDOCS-REFERENCEDOCUMENTFISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IFMBDGECDOCS-REFERENCEDOCUMENTFISCALYEAR.
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_IFMBDGECDOCS_STR,
MANDT TYPE STRING,
BUDGETCHANGEDOCUMENT TYPE STRING,
FINMGMTAREAFISCALYEAR TYPE STRING,
FINANCIALMANAGEMENTAREA TYPE STRING,
BUDGETCATEGORY TYPE STRING,
BUDGETCHANGEDOCUMENTITEM TYPE STRING,
BUDGETDOCUMENTYEAR TYPE STRING,
BUDGETENTRYDOCUMENT TYPE STRING,
BUDGETENTRYDOCUMENTITEM TYPE STRING,
BUDGETEDFUND TYPE STRING,
BUDGETEDFUNDSCENTER TYPE STRING,
BUDGETEDCOMMITMENTITEM TYPE STRING,
BUDGETEDFUNCTIONALAREA TYPE STRING,
BUDGETEDGRANTID TYPE STRING,
BUDGETEDFUNDEDPROGRAM TYPE STRING,
BUDGETEDBUDGETPERIOD TYPE STRING,
BUDGETEDFUNDSMGMTCUSTOMERFIELD TYPE STRING,
TRANSACTIONCURRENCY TYPE STRING,
FINANCIALMANAGEMENTAREACRCY TYPE STRING,
BUDGETAMOUNTINTRANSACTIONCRCY TYPE STRING,
BUDGETAMOUNTINFMACRCY TYPE STRING,
COMMITMENTITEMCATEGORY TYPE STRING,
BDGTCASHEFFECTIVITYFISCALYEAR TYPE STRING,
BUDGETVALUETYPE TYPE STRING,
BUDGETWORKFLOWSTATUS TYPE STRING,
INTERNALBUDGETINGPROCESS TYPE STRING,
BUDGETTYPE TYPE STRING,
BUDGETVERSION TYPE STRING,
BUDGETCHANGEDOCCREATIONDATE TYPE STRING,
BUDGETENTRYDOCUMENTTYPE TYPE STRING,
BUDGETENTRYDOCUMENTFAMILY TYPE STRING,
ORIGINALBUDGETINGAPPLICATION TYPE STRING,
CREATEDBYUSER TYPE STRING,
LASTCHANGEDBYUSER TYPE STRING,
CREATIONDATE TYPE STRING,
LASTCHANGEDATE TYPE STRING,
BUDGETENTRYDOCUMENTDATE TYPE STRING,
BUDGETENTRYDOCUMENTDESCRIPTION TYPE STRING,
BUDGETENTRYDOCUMENTSTATUS TYPE STRING,
BDGTENTRYDOCREVERSALSTATUS TYPE STRING,
REVERSALREASON TYPE STRING,
REVERSALREFBUDGETENTRYDOCUMENT TYPE STRING,
LOGICALSYSTEM TYPE STRING,
FISCALTREASURYLOANCOHORT TYPE STRING,
PUBLICLAW TYPE STRING,
FISCALTREASURYLEGISLATIONTYPE TYPE STRING,
FISCALTREASURYAGENCY TYPE STRING,
FISCALTREASURYBUDGETACCOUNT TYPE STRING,
PARTNERCOMPANY TYPE STRING,
BUDGETENTRYDOCDISTRIBUTIONKEY TYPE STRING,
BUDGETENTRYDOCITEMISADDITIONAL TYPE STRING,
BUDGETENTRYDOCITEMDESCRIPTION TYPE STRING,
REFERENCEDOCUMENT TYPE STRING,
REFERENCEDOCUMENTFISCALYEAR TYPE STRING,
REFERENCEDOCUMENTITEM TYPE STRING,
REFERENCEDOCUMENTTYPE TYPE STRING,
REFERENCEDOCUMENTCONTEXT TYPE STRING,
FINMGMTAREAFISCALYEARENDDATE TYPE STRING,
COMMITMENTITEMAUTHZNGRP TYPE STRING,
GRANTAUTHZNGRP TYPE STRING,
FUNDAUTHZNGRP TYPE STRING,
FUNCTIONALAREAAUTHZNGRP TYPE STRING,
FUNDEDPGMFINMGMTAREAFORAUTHZN TYPE STRING,
BUDGETPERIODAUTHZNGRP TYPE STRING,
BUDGETCATEGORYNAME TYPE STRING,
BUDGETENTRYDOCUMENTSTATUSNAME TYPE STRING,
INTERNALBUDGETINGPROCESSNAME TYPE STRING,
BUDGETTYPENAME1 TYPE STRING,
BUDGETVALUETYPENAME TYPE STRING,
FUNCTIONALAREASUBDIVISIONID TYPE STRING,
FUNCTIONALAREA1SUBDIVISION TYPE STRING,
FUNCTIONALAREA2SUBDIVISION TYPE STRING,
FUNCTIONALAREA3SUBDIVISION TYPE STRING,END OF T_EKKO_STR. DATA: WA_IFMBDGECDOCS_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_IFMBDGECDOCS_STR-MANDT sy-vline
WA_IFMBDGECDOCS_STR-BUDGETCHANGEDOCUMENT sy-vline
WA_IFMBDGECDOCS_STR-FINMGMTAREAFISCALYEAR sy-vline
WA_IFMBDGECDOCS_STR-FINANCIALMANAGEMENTAREA sy-vline
WA_IFMBDGECDOCS_STR-BUDGETCATEGORY sy-vline
WA_IFMBDGECDOCS_STR-BUDGETCHANGEDOCUMENTITEM sy-vline
WA_IFMBDGECDOCS_STR-BUDGETDOCUMENTYEAR sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENT sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTITEM sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDFUND sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDFUNDSCENTER sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDCOMMITMENTITEM sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDFUNCTIONALAREA sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDGRANTID sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDFUNDEDPROGRAM sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDBUDGETPERIOD sy-vline
WA_IFMBDGECDOCS_STR-BUDGETEDFUNDSMGMTCUSTOMERFIELD sy-vline
WA_IFMBDGECDOCS_STR-TRANSACTIONCURRENCY sy-vline
WA_IFMBDGECDOCS_STR-FINANCIALMANAGEMENTAREACRCY sy-vline
WA_IFMBDGECDOCS_STR-BUDGETAMOUNTINTRANSACTIONCRCY sy-vline
WA_IFMBDGECDOCS_STR-BUDGETAMOUNTINFMACRCY sy-vline
WA_IFMBDGECDOCS_STR-COMMITMENTITEMCATEGORY sy-vline
WA_IFMBDGECDOCS_STR-BDGTCASHEFFECTIVITYFISCALYEAR sy-vline
WA_IFMBDGECDOCS_STR-BUDGETVALUETYPE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETWORKFLOWSTATUS sy-vline
WA_IFMBDGECDOCS_STR-INTERNALBUDGETINGPROCESS sy-vline
WA_IFMBDGECDOCS_STR-BUDGETTYPE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETVERSION sy-vline
WA_IFMBDGECDOCS_STR-BUDGETCHANGEDOCCREATIONDATE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTTYPE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTFAMILY sy-vline
WA_IFMBDGECDOCS_STR-ORIGINALBUDGETINGAPPLICATION sy-vline
WA_IFMBDGECDOCS_STR-CREATEDBYUSER sy-vline
WA_IFMBDGECDOCS_STR-LASTCHANGEDBYUSER sy-vline
WA_IFMBDGECDOCS_STR-CREATIONDATE sy-vline
WA_IFMBDGECDOCS_STR-LASTCHANGEDATE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTDATE sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTDESCRIPTION sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTSTATUS sy-vline
WA_IFMBDGECDOCS_STR-BDGTENTRYDOCREVERSALSTATUS sy-vline
WA_IFMBDGECDOCS_STR-REVERSALREASON sy-vline
WA_IFMBDGECDOCS_STR-REVERSALREFBUDGETENTRYDOCUMENT sy-vline
WA_IFMBDGECDOCS_STR-LOGICALSYSTEM sy-vline
WA_IFMBDGECDOCS_STR-FISCALTREASURYLOANCOHORT sy-vline
WA_IFMBDGECDOCS_STR-PUBLICLAW sy-vline
WA_IFMBDGECDOCS_STR-FISCALTREASURYLEGISLATIONTYPE sy-vline
WA_IFMBDGECDOCS_STR-FISCALTREASURYAGENCY sy-vline
WA_IFMBDGECDOCS_STR-FISCALTREASURYBUDGETACCOUNT sy-vline
WA_IFMBDGECDOCS_STR-PARTNERCOMPANY sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCDISTRIBUTIONKEY sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCITEMISADDITIONAL sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCITEMDESCRIPTION sy-vline
WA_IFMBDGECDOCS_STR-REFERENCEDOCUMENT sy-vline
WA_IFMBDGECDOCS_STR-REFERENCEDOCUMENTFISCALYEAR sy-vline
WA_IFMBDGECDOCS_STR-REFERENCEDOCUMENTITEM sy-vline
WA_IFMBDGECDOCS_STR-REFERENCEDOCUMENTTYPE sy-vline
WA_IFMBDGECDOCS_STR-REFERENCEDOCUMENTCONTEXT sy-vline
WA_IFMBDGECDOCS_STR-FINMGMTAREAFISCALYEARENDDATE sy-vline
WA_IFMBDGECDOCS_STR-COMMITMENTITEMAUTHZNGRP sy-vline
WA_IFMBDGECDOCS_STR-GRANTAUTHZNGRP sy-vline
WA_IFMBDGECDOCS_STR-FUNDAUTHZNGRP sy-vline
WA_IFMBDGECDOCS_STR-FUNCTIONALAREAAUTHZNGRP sy-vline
WA_IFMBDGECDOCS_STR-FUNDEDPGMFINMGMTAREAFORAUTHZN sy-vline
WA_IFMBDGECDOCS_STR-BUDGETPERIODAUTHZNGRP sy-vline
WA_IFMBDGECDOCS_STR-BUDGETCATEGORYNAME sy-vline
WA_IFMBDGECDOCS_STR-BUDGETENTRYDOCUMENTSTATUSNAME sy-vline
WA_IFMBDGECDOCS_STR-INTERNALBUDGETINGPROCESSNAME sy-vline
WA_IFMBDGECDOCS_STR-BUDGETTYPENAME1 sy-vline
WA_IFMBDGECDOCS_STR-BUDGETVALUETYPENAME sy-vline
WA_IFMBDGECDOCS_STR-FUNCTIONALAREASUBDIVISIONID sy-vline
WA_IFMBDGECDOCS_STR-FUNCTIONALAREA1SUBDIVISION sy-vline
WA_IFMBDGECDOCS_STR-FUNCTIONALAREA2SUBDIVISION sy-vline
WA_IFMBDGECDOCS_STR-FUNCTIONALAREA3SUBDIVISION sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.