ABAP Select data from SAP table /PM0/ABD_VDBEPI 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 /PM0/ABD_VDBEPI 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 /PM0/ABD_VDBEPI. 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 /PM0/ABD_VDBEPI 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_/PM0/ABD_VDBEPI TYPE STANDARD TABLE OF /PM0/ABD_VDBEPI,
      WA_/PM0/ABD_VDBEPI TYPE /PM0/ABD_VDBEPI,
      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: </PM0/ABD_VDBEPI> TYPE /PM0/ABD_VDBEPI.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /PM0/ABD_VDBEPI
  INTO TABLE IT_/PM0/ABD_VDBEPI.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /PM0/ABD_VDBEPI
*  INTO TABLE @DATA(IT_/PM0/ABD_VDBEPI2).
*--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_/PM0/ABD_VDBEPI INDEX 1 INTO DATA(WA_/PM0/ABD_VDBEPI2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/PM0/ABD_VDBEPI ASSIGNING </PM0/ABD_VDBEPI>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</PM0/ABD_VDBEPI>-MANDT = 1.
</PM0/ABD_VDBEPI>-BUKRS = 1.
</PM0/ABD_VDBEPI>-RBELKPFD = 1.
</PM0/ABD_VDBEPI>-RPOSNR = 1.
</PM0/ABD_VDBEPI>-SBEWART = 1.

ENDLOOP.

LOOP AT IT_/PM0/ABD_VDBEPI INTO WA_/PM0/ABD_VDBEPI.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/PM0/ABD_VDBEPI-SREFBEW, sy-vline,
  WA_/PM0/ABD_VDBEPI-SBEWZITI, sy-vline,
  WA_/PM0/ABD_VDBEPI-BNWHR, sy-vline,
  WA_/PM0/ABD_VDBEPI-SNWHR, sy-vline,
  WA_/PM0/ABD_VDBEPI-BBWHR, sy-vline,
  WA_/PM0/ABD_VDBEPI-SBWHR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/PM0/ABD_VDBEPI 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_/PM0/ABD_VDBEPI 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_/PM0/ABD_VDBEPI INTO WA_/PM0/ABD_VDBEPI.


*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_/PM0/ABD_VDBEPI_STR, 
MANDT TYPE STRING,
BUKRS TYPE STRING,
RBELKPFD TYPE STRING,
RPOSNR TYPE STRING,
SBEWART TYPE STRING,
SREFBEW TYPE STRING,
SBEWZITI TYPE STRING,
BNWHR TYPE STRING,
SNWHR TYPE STRING,
BBWHR TYPE STRING,
SBWHR TYPE STRING,
BCWHR TYPE STRING,
SCWHR TYPE STRING,
BHWHR TYPE STRING,
PKKURS TYPE STRING,
PRUCK TYPE STRING,
KURS1 TYPE STRING,
KURS2 TYPE STRING,
DVALUT TYPE STRING,
DFAELL TYPE STRING,
DDISPO TYPE STRING,
DBESTAND TYPE STRING,
DBERVON TYPE STRING,
UMSKZ TYPE STRING,
KOSTL TYPE STRING,
SSPESEN TYPE STRING,
SSOLHAB TYPE STRING,
RSOLL TYPE STRING,
RHABEN TYPE STRING,
RZKSOLL TYPE STRING,
RZKHABE TYPE STRING,
SBSLSOLL TYPE STRING,
SBSLZKSO TYPE STRING,
SBSLZKHA TYPE STRING,
SHSLHABEN TYPE STRING,
BUCHTXT TYPE STRING,
RBANKK TYPE STRING,
SFDLEV TYPE STRING,
JFDUPD TYPE STRING,
JONLAEN TYPE STRING,
JZINSBAS TYPE STRING,
JZINSZPT TYPE STRING,
PKOND TYPE STRING,
BBASIS TYPE STRING,
SSORTZIT TYPE STRING,
SWOHER TYPE STRING,
KUNNR TYPE STRING,
BVTYP TYPE STRING,
ZLSCH TYPE STRING,
MABER TYPE STRING,
ZAHLS TYPE STRING,
RPARTNR TYPE STRING,
SROLEXT TYPE STRING,
JEINBEHALT TYPE STRING,
JFIRUECK TYPE STRING,
MWSKZ TYPE STRING,
MWART TYPE STRING,
DBERBIS TYPE STRING,
ATAGE TYPE STRING,
ABASTAGE TYPE STRING,
SZBMETH TYPE STRING,
JSTOCK TYPE STRING,
SBUST TYPE STRING,
DTRANS TYPE STRING,
TTRANS TYPE STRING,
NTRANS TYPE STRING,
GSBER TYPE STRING,
SKOART TYPE STRING,
SEXCLVON TYPE STRING,
SULTVON TYPE STRING,
SINCLBIS TYPE STRING,
SULTBIS TYPE STRING,
SINCL TYPE STRING,
DVERRECH TYPE STRING,
DPKOND TYPE STRING,
SBUCHA TYPE STRING,
ZINKZ TYPE STRING,
SVULT TYPE STRING,
JSOFVERR TYPE STRING,
SINCLVERR TYPE STRING,
SULTVERR TYPE STRING,
SREFZITI TYPE STRING,
STGBASIS TYPE STRING,
STGMETH TYPE STRING,
SBASIS TYPE STRING,
SGTXT TYPE STRING,
SBERFIMA TYPE STRING,
SVORGKZ TYPE STRING,
MANSP TYPE STRING,
DGUEL_KP TYPE STRING,
NSTUFE TYPE STRING,
DBPERIOD TYPE STRING,
SPAEXCL TYPE STRING,
SPAULT TYPE STRING,
DEPERIOD TYPE STRING,
SPEINCL TYPE STRING,
SPEULT TYPE STRING,
SSTCKKZ TYPE STRING,
NORDER TYPE STRING,
RKONT TYPE STRING,
DAUSZ TYPE STRING,
SSOLIST TYPE STRING,
RDARNEHM TYPE STRING,
BKOND TYPE STRING,
SBERECH TYPE STRING,
BKARZINS TYPE STRING,
BTITALK TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
HDN_KUNNR TYPE STRING,
SZART TYPE STRING,
RUZBEL TYPE STRING,
REBZJ TYPE STRING,
REBZG TYPE STRING,
REBZZ TYPE STRING,
S_SSDREF TYPE STRING,
PWKURS TYPE STRING,
DZFEST TYPE STRING,
XPORE TYPE STRING,
SPAYRQ TYPE STRING,
PRKEY TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
VORGTYP TYPE STRING,
ACENV TYPE STRING,
SSIGN TYPE STRING,
SPRSNG TYPE STRING,
UZAWE TYPE STRING,
SPRGRD TYPE STRING,
SCSPAY TYPE STRING,
ZWELS TYPE STRING,
PAYGR TYPE STRING,
JEXPOZINS TYPE STRING,
SREVALEXCL TYPE STRING,
SROUND TYPE STRING,
SKALIDWT TYPE STRING,
JVERF TYPE STRING,
PPAYMENT TYPE STRING,
AMMRHYZV TYPE STRING,
LC_CAPITALS TYPE STRING,
LC_DISBURSE TYPE STRING,
DFAELL_OLD_EXT TYPE STRING,
DDISPO_OLD_EXT TYPE STRING,
RBO_EXT TYPE STRING,
SBEWEGRP2 TYPE STRING,
SUSP_REASON_TYPE TYPE STRING,
BILL_NUMBER TYPE STRING,
BILL_DUE_DATE TYPE STRING,
MNDID TYPE STRING,
REMIT_INFO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/PM0/ABD_VDBEPI_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_/PM0/ABD_VDBEPI_STR-MANDT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BUKRS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RBELKPFD sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RPOSNR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBEWART sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SREFBEW sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBEWZITI sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BNWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SNWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BBWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BCWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SCWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BHWHR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PKKURS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PRUCK sy-vline 
WA_/PM0/ABD_VDBEPI_STR-KURS1 sy-vline 
WA_/PM0/ABD_VDBEPI_STR-KURS2 sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DVALUT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DFAELL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DDISPO sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DBESTAND sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DBERVON sy-vline 
WA_/PM0/ABD_VDBEPI_STR-UMSKZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-KOSTL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSPESEN sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSOLHAB sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RSOLL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RHABEN sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RZKSOLL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RZKHABE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBSLSOLL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBSLZKSO sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBSLZKHA sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SHSLHABEN sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BUCHTXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RBANKK sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SFDLEV sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JFDUPD sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JONLAEN sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JZINSBAS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JZINSZPT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PKOND sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BBASIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSORTZIT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SWOHER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-KUNNR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BVTYP sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ZLSCH sy-vline 
WA_/PM0/ABD_VDBEPI_STR-MABER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ZAHLS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RPARTNR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SROLEXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JEINBEHALT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JFIRUECK sy-vline 
WA_/PM0/ABD_VDBEPI_STR-MWSKZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-MWART sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DBERBIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ATAGE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ABASTAGE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SZBMETH sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JSTOCK sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBUST sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DTRANS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-TTRANS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-NTRANS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-GSBER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SKOART sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SEXCLVON sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SULTVON sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SINCLBIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SULTBIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SINCL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DVERRECH sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DPKOND sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBUCHA sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ZINKZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SVULT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JSOFVERR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SINCLVERR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SULTVERR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SREFZITI sy-vline 
WA_/PM0/ABD_VDBEPI_STR-STGBASIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-STGMETH sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBASIS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SGTXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBERFIMA sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SVORGKZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-MANSP sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DGUEL_KP sy-vline 
WA_/PM0/ABD_VDBEPI_STR-NSTUFE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DBPERIOD sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPAEXCL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPAULT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DEPERIOD sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPEINCL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPEULT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSTCKKZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-NORDER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RKONT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DAUSZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSOLIST sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RDARNEHM sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BKOND sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBERECH sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BKARZINS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BTITALK sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RERF sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DERF sy-vline 
WA_/PM0/ABD_VDBEPI_STR-TERF sy-vline 
WA_/PM0/ABD_VDBEPI_STR-REHER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RBEAR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DBEAR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-TBEAR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RBHER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-HDN_KUNNR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SZART sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RUZBEL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-REBZJ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-REBZG sy-vline 
WA_/PM0/ABD_VDBEPI_STR-REBZZ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-S_SSDREF sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PWKURS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DZFEST sy-vline 
WA_/PM0/ABD_VDBEPI_STR-XPORE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPAYRQ sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PRKEY sy-vline 
WA_/PM0/ABD_VDBEPI_STR-HBKID sy-vline 
WA_/PM0/ABD_VDBEPI_STR-HKTID sy-vline 
WA_/PM0/ABD_VDBEPI_STR-VORGTYP sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ACENV sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SSIGN sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPRSNG sy-vline 
WA_/PM0/ABD_VDBEPI_STR-UZAWE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SPRGRD sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SCSPAY sy-vline 
WA_/PM0/ABD_VDBEPI_STR-ZWELS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PAYGR sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JEXPOZINS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SREVALEXCL sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SROUND sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SKALIDWT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-JVERF sy-vline 
WA_/PM0/ABD_VDBEPI_STR-PPAYMENT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-AMMRHYZV sy-vline 
WA_/PM0/ABD_VDBEPI_STR-LC_CAPITALS sy-vline 
WA_/PM0/ABD_VDBEPI_STR-LC_DISBURSE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DFAELL_OLD_EXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-DDISPO_OLD_EXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-RBO_EXT sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SBEWEGRP2 sy-vline 
WA_/PM0/ABD_VDBEPI_STR-SUSP_REASON_TYPE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BILL_NUMBER sy-vline 
WA_/PM0/ABD_VDBEPI_STR-BILL_DUE_DATE sy-vline 
WA_/PM0/ABD_VDBEPI_STR-MNDID sy-vline 
WA_/PM0/ABD_VDBEPI_STR-REMIT_INFO sy-vline      INTO ld_text SEPARATED BY SPACE.

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