ABAP Select data from SAP table PA0778 into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP PA0778 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 PA0778. 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 PA0778 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_PA0778 TYPE STANDARD TABLE OF PA0778,
      WA_PA0778 TYPE PA0778,
      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: <PA0778> TYPE PA0778.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PA0778
*  INTO TABLE @DATA(IT_PA07782).
*--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_PA0778 INDEX 1 INTO DATA(WA_PA07782).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PA0778>-MANDT = 1.
<PA0778>-PERNR = 1.
<PA0778>-SUBTY = 1.
<PA0778>-OBJPS = 1.
<PA0778>-SPRPS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PA0778-ENDDA, sy-vline,
  WA_PA0778-BEGDA, sy-vline,
  WA_PA0778-SEQNR, sy-vline,
  WA_PA0778-AEDTM, sy-vline,
  WA_PA0778-UNAME, sy-vline,
  WA_PA0778-HISTO, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PA0778 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_PA0778 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_PA0778 INTO WA_PA0778.


*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_PA0778_STR, 
MANDT TYPE STRING,
PERNR TYPE STRING,
SUBTY TYPE STRING,
OBJPS TYPE STRING,
SPRPS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
SEQNR TYPE STRING,
AEDTM TYPE STRING,
UNAME TYPE STRING,
HISTO TYPE STRING,
ITXEX TYPE STRING,
REFEX TYPE STRING,
ORDEX TYPE STRING,
ITBLD TYPE STRING,
PREAS TYPE STRING,
FLAG1 TYPE STRING,
FLAG2 TYPE STRING,
FLAG3 TYPE STRING,
FLAG4 TYPE STRING,
RESE1 TYPE STRING,
RESE2 TYPE STRING,
GRPVL TYPE STRING,
KAZAT TYPE STRING,
KZTAR TYPE STRING,
KZSAT TYPE STRING,
ISTDN TYPE STRING,
KZEIS TYPE STRING,
KZBLM TYPE STRING,
KZIBS TYPE STRING,
SAHT1 TYPE STRING,
SAHT2 TYPE STRING,
SAHAD TYPE STRING,
HASAR TYPE STRING,
WAERS TYPE STRING,
TANM1 TYPE STRING,
TANM2 TYPE STRING,
TANM3 TYPE STRING,
TANM4 TYPE STRING,
BAYAD TYPE STRING,
ADRES TYPE STRING,
KYUZV TYPE STRING,
YRSK1 TYPE STRING,
MSTUR TYPE STRING,
TSTRH TYPE STRING,
SPTSK TYPE STRING,
KZSBP TYPE STRING,
KSISG TYPE STRING,
CLORT TYPE STRING,
CLCEV TYPE STRING,
KAYGF TYPE STRING,
KOYOF TYPE STRING,
OFKMT TYPE STRING,
SSBMT TYPE STRING,
YSBMT TYPE STRING,
TMYKA TYPE STRING,
TMYIL TYPE STRING,
TMYIC TYPE STRING,
TMYYE TYPE STRING,
TMYTR TYPE STRING,
TMYSA TYPE STRING,
TMBIT TYPE STRING,
TMBIS TYPE STRING,
TMYAP TYPE STRING,
KGIBT TYPE STRING,
KSIYD TYPE STRING,
YAKTC TYPE STRING,
MEGTA TYPE STRING,
ISGEA TYPE STRING,
KZSDR TYPE STRING,
ISBRT TYPE STRING,
ISBRS TYPE STRING,
KDISK TYPE STRING,
KZYER TYPE STRING,
KZORT TYPE STRING,
BHZTC TYPE STRING,
BHZAD TYPE STRING,
BHZSY TYPE STRING,
BHZTL TYPE STRING,
BHZFX TYPE STRING,
BHZEP TYPE STRING,
KZILI TYPE STRING,
KZILC TYPE STRING,
KZADR TYPE STRING,
MSETK TYPE STRING,
MSETS TYPE STRING,
MSIGS TYPE STRING,
MSBLT TYPE STRING,
MSBLS TYPE STRING,
MSTAN TYPE STRING,
MSTTR TYPE STRING,
ADRIC TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PA0778_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_PA0778_STR-MANDT sy-vline 
WA_PA0778_STR-PERNR sy-vline 
WA_PA0778_STR-SUBTY sy-vline 
WA_PA0778_STR-OBJPS sy-vline 
WA_PA0778_STR-SPRPS sy-vline 
WA_PA0778_STR-ENDDA sy-vline 
WA_PA0778_STR-BEGDA sy-vline 
WA_PA0778_STR-SEQNR sy-vline 
WA_PA0778_STR-AEDTM sy-vline 
WA_PA0778_STR-UNAME sy-vline 
WA_PA0778_STR-HISTO sy-vline 
WA_PA0778_STR-ITXEX sy-vline 
WA_PA0778_STR-REFEX sy-vline 
WA_PA0778_STR-ORDEX sy-vline 
WA_PA0778_STR-ITBLD sy-vline 
WA_PA0778_STR-PREAS sy-vline 
WA_PA0778_STR-FLAG1 sy-vline 
WA_PA0778_STR-FLAG2 sy-vline 
WA_PA0778_STR-FLAG3 sy-vline 
WA_PA0778_STR-FLAG4 sy-vline 
WA_PA0778_STR-RESE1 sy-vline 
WA_PA0778_STR-RESE2 sy-vline 
WA_PA0778_STR-GRPVL sy-vline 
WA_PA0778_STR-KAZAT sy-vline 
WA_PA0778_STR-KZTAR sy-vline 
WA_PA0778_STR-KZSAT sy-vline 
WA_PA0778_STR-ISTDN sy-vline 
WA_PA0778_STR-KZEIS sy-vline 
WA_PA0778_STR-KZBLM sy-vline 
WA_PA0778_STR-KZIBS sy-vline 
WA_PA0778_STR-SAHT1 sy-vline 
WA_PA0778_STR-SAHT2 sy-vline 
WA_PA0778_STR-SAHAD sy-vline 
WA_PA0778_STR-HASAR sy-vline 
WA_PA0778_STR-WAERS sy-vline 
WA_PA0778_STR-TANM1 sy-vline 
WA_PA0778_STR-TANM2 sy-vline 
WA_PA0778_STR-TANM3 sy-vline 
WA_PA0778_STR-TANM4 sy-vline 
WA_PA0778_STR-BAYAD sy-vline 
WA_PA0778_STR-ADRES sy-vline 
WA_PA0778_STR-KYUZV sy-vline 
WA_PA0778_STR-YRSK1 sy-vline 
WA_PA0778_STR-MSTUR sy-vline 
WA_PA0778_STR-TSTRH sy-vline 
WA_PA0778_STR-SPTSK sy-vline 
WA_PA0778_STR-KZSBP sy-vline 
WA_PA0778_STR-KSISG sy-vline 
WA_PA0778_STR-CLORT sy-vline 
WA_PA0778_STR-CLCEV sy-vline 
WA_PA0778_STR-KAYGF sy-vline 
WA_PA0778_STR-KOYOF sy-vline 
WA_PA0778_STR-OFKMT sy-vline 
WA_PA0778_STR-SSBMT sy-vline 
WA_PA0778_STR-YSBMT sy-vline 
WA_PA0778_STR-TMYKA sy-vline 
WA_PA0778_STR-TMYIL sy-vline 
WA_PA0778_STR-TMYIC sy-vline 
WA_PA0778_STR-TMYYE sy-vline 
WA_PA0778_STR-TMYTR sy-vline 
WA_PA0778_STR-TMYSA sy-vline 
WA_PA0778_STR-TMBIT sy-vline 
WA_PA0778_STR-TMBIS sy-vline 
WA_PA0778_STR-TMYAP sy-vline 
WA_PA0778_STR-KGIBT sy-vline 
WA_PA0778_STR-KSIYD sy-vline 
WA_PA0778_STR-YAKTC sy-vline 
WA_PA0778_STR-MEGTA sy-vline 
WA_PA0778_STR-ISGEA sy-vline 
WA_PA0778_STR-KZSDR sy-vline 
WA_PA0778_STR-ISBRT sy-vline 
WA_PA0778_STR-ISBRS sy-vline 
WA_PA0778_STR-KDISK sy-vline 
WA_PA0778_STR-KZYER sy-vline 
WA_PA0778_STR-KZORT sy-vline 
WA_PA0778_STR-BHZTC sy-vline 
WA_PA0778_STR-BHZAD sy-vline 
WA_PA0778_STR-BHZSY sy-vline 
WA_PA0778_STR-BHZTL sy-vline 
WA_PA0778_STR-BHZFX sy-vline 
WA_PA0778_STR-BHZEP sy-vline 
WA_PA0778_STR-KZILI sy-vline 
WA_PA0778_STR-KZILC sy-vline 
WA_PA0778_STR-KZADR sy-vline 
WA_PA0778_STR-MSETK sy-vline 
WA_PA0778_STR-MSETS sy-vline 
WA_PA0778_STR-MSIGS sy-vline 
WA_PA0778_STR-MSBLT sy-vline 
WA_PA0778_STR-MSBLS sy-vline 
WA_PA0778_STR-MSTAN sy-vline 
WA_PA0778_STR-MSTTR sy-vline 
WA_PA0778_STR-ADRIC sy-vline      INTO ld_text SEPARATED BY SPACE.

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