Home SAP Development ABAP Statements Help Docs SAP Tables S4Hana Tables T-Code List FM's

ABAP Select data from SAP table N0FDBS0000000003 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 N0FDBS0000000003 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 N0FDBS0000000003. 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 N0FDBS0000000003 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_N0FDBS0000000003 TYPE STANDARD TABLE OF N0FDBS0000000003,
      WA_N0FDBS0000000003 TYPE N0FDBS0000000003,
      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: <N0FDBS0000000003> TYPE N0FDBS0000000003.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM N0FDBS0000000003
*  INTO TABLE @DATA(IT_N0FDBS00000000032).
*--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_N0FDBS0000000003 INDEX 1 INTO DATA(WA_N0FDBS00000000032).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_N0FDBS0000000003 ASSIGNING <N0FDBS0000000003>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<N0FDBS0000000003>-MANDT = 1.
<N0FDBS0000000003>-DOKAR = 1.
<N0FDBS0000000003>-DOKNR = 1.
<N0FDBS0000000003>-DOKVR = 1.
<N0FDBS0000000003>-DOKTL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_N0FDBS0000000003-MUSEQ, sy-vline,
  WA_N0FDBS0000000003-ISHMDIALFN, sy-vline,
  WA_N0FDBS0000000003-ISHMDIATXT, sy-vline,
  WA_N0FDBS0000000003-ISHMDIALTX, sy-vline,
  WA_N0FDBS0000000003-ISHMDIAFTX, sy-vline,
  WA_N0FDBS0000000003-ISHMDIAEIN, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_N0FDBS0000000003 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_N0FDBS0000000003 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_N0FDBS0000000003 INTO WA_N0FDBS0000000003.


*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 DOKNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_N0FDBS0000000003-DOKNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_N0FDBS0000000003-DOKNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ISHMDIAFPA
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_N0FDBS0000000003-ISHMDIAFPA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_N0FDBS0000000003-ISHMDIAFPA.
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_N0FDBS0000000003_STR, 
MANDT TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKVR TYPE STRING,
DOKTL TYPE STRING,
MUSEQ TYPE STRING,
ISHMDIALFN TYPE STRING,
ISHMDIATXT TYPE STRING,
ISHMDIALTX TYPE STRING,
ISHMDIAFTX TYPE STRING,
ISHMDIAEIN TYPE STRING,
ISHMDIABEH TYPE STRING,
ISHMDIAAUF TYPE STRING,
ISHMDIAENT TYPE STRING,
ISHMDIAFAH TYPE STRING,
ISHMDIAKHH TYPE STRING,
ISHMDIAOPE TYPE STRING,
ISHMDIASPR TYPE STRING,
ISHMDIAARB TYPE STRING,
ISHMDIAPRO TYPE STRING,
ISHMDIATUR TYPE STRING,
ISHMDIABEZ TYPE STRING,
ISHMDIAKAT TYPE STRING,
ISHMDIAKEY TYPE STRING,
ISHMDIATYP TYPE STRING,
ISHMDIAKTX TYPE STRING,
ISHMDIAKT2 TYPE STRING,
ISHMDIAKY2 TYPE STRING,
ISHMDIATY2 TYPE STRING,
ISHMDIARKT TYPE STRING,
ISHMDIARKY TYPE STRING,
ISHMDIARTY TYPE STRING,
ISHMDIADAT TYPE STRING,
ISHMDIAZET TYPE STRING,
ISHMDIAPER TYPE STRING,
ISHMDIAPRI TYPE STRING,
ISHMDIAGEW TYPE STRING,
ISHMDIAZUS TYPE STRING,
ISHMDIABEM TYPE STRING,
ISHMDIABKZ TYPE STRING,
ISHMDIABTX TYPE STRING,
ISHMDIABEW TYPE STRING,
ISHMDIALOK TYPE STRING,
ISHMDIAEXT TYPE STRING,
ISHMDIAFPA TYPE STRING,
ISHMDIAANZ TYPE STRING,
ISHMDIACAT TYPE STRING,
ISHMDIACCL TYPE STRING,
ISHMDIAREL TYPE STRING,
ISHMDIALK1 TYPE STRING,
ISHMDIAINF TYPE STRING,END OF T_EKKO_STR.
DATA: WA_N0FDBS0000000003_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_N0FDBS0000000003_STR-MANDT sy-vline 
WA_N0FDBS0000000003_STR-DOKAR sy-vline 
WA_N0FDBS0000000003_STR-DOKNR sy-vline 
WA_N0FDBS0000000003_STR-DOKVR sy-vline 
WA_N0FDBS0000000003_STR-DOKTL sy-vline 
WA_N0FDBS0000000003_STR-MUSEQ sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIALFN sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIATXT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIALTX sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAFTX sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAEIN sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABEH sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAAUF sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAENT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAFAH sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKHH sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAOPE sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIASPR sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAARB sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAPRO sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIATUR sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABEZ sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKAT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKEY sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIATYP sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKTX sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKT2 sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAKY2 sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIATY2 sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIARKT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIARKY sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIARTY sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIADAT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAZET sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAPER sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAPRI sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAGEW sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAZUS sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABEM sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABKZ sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABTX sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIABEW sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIALOK sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAEXT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAFPA sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAANZ sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIACAT sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIACCL sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAREL sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIALK1 sy-vline 
WA_N0FDBS0000000003_STR-ISHMDIAINF sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.