ABAP Select data from SAP table RPROLSTA1 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 RPROLSTA1 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 RPROLSTA1. 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 RPROLSTA1 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_RPROLSTA1 TYPE STANDARD TABLE OF RPROLSTA1, WA_RPROLSTA1 TYPE RPROLSTA1, 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: <RPROLSTA1> TYPE RPROLSTA1. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_RPROLSTA1. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM RPROLSTA1 INTO TABLE IT_RPROLSTA1. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM RPROLSTA1 * INTO TABLE @DATA(IT_RPROLSTA12). *--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_RPROLSTA1 INDEX 1 INTO DATA(WA_RPROLSTA12). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_RPROLSTA1 ASSIGNING <RPROLSTA1>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<RPROLSTA1>-MANDT = 1.
<RPROLSTA1>-BUKRS = 1.
<RPROLSTA1>-SANLF = 1.
<RPROLSTA1>-RKEY1 = 1.
<RPROLSTA1>-DGUEL_KK = 1.
ENDLOOP. LOOP AT IT_RPROLSTA1 INTO WA_RPROLSTA1. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_RPROLSTA1-NLFD_ANG, sy-vline,
WA_RPROLSTA1-SSTATI, sy-vline,
WA_RPROLSTA1-SKOKOART, sy-vline,
WA_RPROLSTA1-STILGRHY, sy-vline,
WA_RPROLSTA1-STILGART, sy-vline,
WA_RPROLSTA1-SDISEIN, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RPROLSTA1 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_RPROLSTA1 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_RPROLSTA1 INTO WA_RPROLSTA1. *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 RSBEAR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RPROLSTA1-RSBEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RPROLSTA1-RSBEAR.
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_RPROLSTA1_STR,
MANDT TYPE STRING,
BUKRS TYPE STRING,
SANLF TYPE STRING,
RKEY1 TYPE STRING,
DGUEL_KK TYPE STRING,
NLFD_ANG TYPE STRING,
SSTATI TYPE STRING,
SKOKOART TYPE STRING,
STILGRHY TYPE STRING,
STILGART TYPE STRING,
SDISEIN TYPE STRING,
KZAHLUNG TYPE STRING,
BZAHLUNG TYPE STRING,
SWHRZHLG TYPE STRING,
BZUSAGE TYPE STRING,
SWHRZUSA TYPE STRING,
PEFFZINS TYPE STRING,
SEFFMETH TYPE STRING,
SZBMETH TYPE STRING,
SDISKO TYPE STRING,
DKUEND TYPE STRING,
SKUEND TYPE STRING,
DKUENDDG TYPE STRING,
DBLFZ TYPE STRING,
DBLFZ_ORIGIN TYPE STRING,
DELFZ TYPE STRING,
DRESAM TYPE STRING,
DRESBIS TYPE STRING,
DANGAM TYPE STRING,
DANGBIS TYPE STRING,
SANGVOR TYPE STRING,
JANNAHME TYPE STRING,
SANNAHME TYPE STRING,
DANNAHME TYPE STRING,
JVERTRAG TYPE STRING,
DVERTRAM TYPE STRING,
DVERTBIS TYPE STRING,
PMANEFFZ TYPE STRING,
SEFFM2 TYPE STRING,
SKUEGL TYPE STRING,
RPNR TYPE STRING,
DEFSZ TYPE STRING,
DGES TYPE STRING,
SGESAUS TYPE STRING,
SZKZ TYPE STRING,
NANGEBOT TYPE STRING,
SINCL TYPE STRING,
ZVRHYEFF TYPE STRING,
PVGLEFFZ TYPE STRING,
SULTEFSZ TYPE STRING,
DABEFFZ TYPE STRING,
DKUENDDN TYPE STRING,
SKUEDN TYPE STRING,
SKUEART TYPE STRING,
DMARKTZINS TYPE STRING,
SKALIDWT TYPE STRING,
EDEFFZINS TYPE STRING,
EDEFFMETH TYPE STRING,
JAHREFFZINS TYPE STRING,
JAHREFFMETH TYPE STRING,
PEFFZINS_ORIGIN TYPE STRING,
PEFFZINS_ADD TYPE STRING,
GROUP_ID TYPE STRING,
VERSION TYPE STRING,
CLUSTER_NO TYPE STRING,
ORIGINAL_TERM TYPE STRING,
OVERALL_RUNTIME TYPE STRING,
ORIG_CREDIT_SUM TYPE STRING,
DATE_REPAYMENT TYPE STRING,
DATE_FIRST_RATE TYPE STRING,
DAY_OF_PAYMENT TYPE STRING,
CLEARING_RATE TYPE STRING,
EFF_INT_L_PYMNP TYPE STRING,
DEFF_INT_L_PYMNP TYPE STRING,
REPAY_DELAY TYPE STRING,
CALCULATED_PARAM TYPE STRING,
CURR_CREDIT_SUM TYPE STRING,
BROUNDUNIT TYPE STRING,
SROUND TYPE STRING,
BOVERLIMIT TYPE STRING,
POVERLIMIT TYPE STRING,
CONTAB TYPE STRING,
CONTAB_VERSION TYPE STRING,
TERM_PAYMENT TYPE STRING,
PAPR_ORIGIN TYPE STRING,
GSART TYPE STRING,
STITEL TYPE STRING,
SBEA TYPE STRING,
FLG_PRO TYPE STRING,
FLG_MEH TYPE STRING,
FLG_ZURGEZ TYPE STRING,
FLG_ZURGEF TYPE STRING,
FLG_UNE TYPE STRING,
FZT TYPE STRING,
SWHR TYPE STRING,
SBWHR TYPE STRING,
SHWHR TYPE STRING,
SWWHR TYPE STRING,
BVKWR TYPE STRING,
BVKW2 TYPE STRING,
BVZWR TYPE STRING,
BVZW2 TYPE STRING,
BZKWR TYPE STRING,
BZKW2 TYPE STRING,
BKKWR TYPE STRING,
BZNWR TYPE STRING,
BAB TYPE STRING,
BRPWR TYPE STRING,
BRPHW TYPE STRING,
BRPW2 TYPE STRING,
BRIWR TYPE STRING,
BRIHW TYPE STRING,
BRIW2 TYPE STRING,
BRVWR TYPE STRING,
BRVHW TYPE STRING,
BMIWR TYPE STRING,
BMIW2 TYPE STRING,
BATWR TYPE STRING,
BATHW TYPE STRING,
BATW2 TYPE STRING,
BATNWR TYPE STRING,
BATZWR TYPE STRING,
BATZHW TYPE STRING,
BATZW2 TYPE STRING,
BPTWR TYPE STRING,
BPTHW TYPE STRING,
BPTW2 TYPE STRING,
BPTZWR TYPE STRING,
BPTZHW TYPE STRING,
BPTZW2 TYPE STRING,
BAVWR TYPE STRING,
BAVHW TYPE STRING,
BAVW2 TYPE STRING,
BAVVWR TYPE STRING,
BVAWR TYPE STRING,
BVAHW TYPE STRING,
BVAIWR TYPE STRING,
BVAIHW TYPE STRING,
BVAW2 TYPE STRING,
BG1WR TYPE STRING,
BG2WR TYPE STRING,
BKAUFWR TYPE STRING,
BKAUFHW TYPE STRING,
BBUCHWR TYPE STRING,
BBUCHHW TYPE STRING,
BAAWR TYPE STRING,
BZVWR TYPE STRING,
BZVHW TYPE STRING,
BZVZWR TYPE STRING,
BZVZHW TYPE STRING,
BKGVWR TYPE STRING,
BKGVHW TYPE STRING,
BAUFWR TYPE STRING,
BAUFHW TYPE STRING,
BTA2WR TYPE STRING,
BTA2HW TYPE STRING,
BTA2ZWR TYPE STRING,
BTA2ZHW TYPE STRING,
BRPNWR TYPE STRING,
BRPNHW TYPE STRING,
BRINWR TYPE STRING,
BRINHW TYPE STRING,
BEURPWR TYPE STRING,
BEUAVWR TYPE STRING,
BZVIWR TYPE STRING,
BZVIHW TYPE STRING,
BVAWRTZ TYPE STRING,
BVAHWTZ TYPE STRING,
BVAIWRTZ TYPE STRING,
BVAIHWTZ TYPE STRING,
BATNHW TYPE STRING,
SONDERWR TYPE STRING,
UMBUCHWR TYPE STRING,
STYP TYPE STRING,
RHORD TYPE STRING,
SVYM TYPE STRING,
SVNR TYPE STRING,
RORD TYPE STRING,
SREG TYPE STRING,
RSBEAR TYPE STRING,
XDNINFO TYPE STRING,END OF T_EKKO_STR. DATA: WA_RPROLSTA1_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_RPROLSTA1_STR-MANDT sy-vline
WA_RPROLSTA1_STR-BUKRS sy-vline
WA_RPROLSTA1_STR-SANLF sy-vline
WA_RPROLSTA1_STR-RKEY1 sy-vline
WA_RPROLSTA1_STR-DGUEL_KK sy-vline
WA_RPROLSTA1_STR-NLFD_ANG sy-vline
WA_RPROLSTA1_STR-SSTATI sy-vline
WA_RPROLSTA1_STR-SKOKOART sy-vline
WA_RPROLSTA1_STR-STILGRHY sy-vline
WA_RPROLSTA1_STR-STILGART sy-vline
WA_RPROLSTA1_STR-SDISEIN sy-vline
WA_RPROLSTA1_STR-KZAHLUNG sy-vline
WA_RPROLSTA1_STR-BZAHLUNG sy-vline
WA_RPROLSTA1_STR-SWHRZHLG sy-vline
WA_RPROLSTA1_STR-BZUSAGE sy-vline
WA_RPROLSTA1_STR-SWHRZUSA sy-vline
WA_RPROLSTA1_STR-PEFFZINS sy-vline
WA_RPROLSTA1_STR-SEFFMETH sy-vline
WA_RPROLSTA1_STR-SZBMETH sy-vline
WA_RPROLSTA1_STR-SDISKO sy-vline
WA_RPROLSTA1_STR-DKUEND sy-vline
WA_RPROLSTA1_STR-SKUEND sy-vline
WA_RPROLSTA1_STR-DKUENDDG sy-vline
WA_RPROLSTA1_STR-DBLFZ sy-vline
WA_RPROLSTA1_STR-DBLFZ_ORIGIN sy-vline
WA_RPROLSTA1_STR-DELFZ sy-vline
WA_RPROLSTA1_STR-DRESAM sy-vline
WA_RPROLSTA1_STR-DRESBIS sy-vline
WA_RPROLSTA1_STR-DANGAM sy-vline
WA_RPROLSTA1_STR-DANGBIS sy-vline
WA_RPROLSTA1_STR-SANGVOR sy-vline
WA_RPROLSTA1_STR-JANNAHME sy-vline
WA_RPROLSTA1_STR-SANNAHME sy-vline
WA_RPROLSTA1_STR-DANNAHME sy-vline
WA_RPROLSTA1_STR-JVERTRAG sy-vline
WA_RPROLSTA1_STR-DVERTRAM sy-vline
WA_RPROLSTA1_STR-DVERTBIS sy-vline
WA_RPROLSTA1_STR-PMANEFFZ sy-vline
WA_RPROLSTA1_STR-SEFFM2 sy-vline
WA_RPROLSTA1_STR-SKUEGL sy-vline
WA_RPROLSTA1_STR-RPNR sy-vline
WA_RPROLSTA1_STR-DEFSZ sy-vline
WA_RPROLSTA1_STR-DGES sy-vline
WA_RPROLSTA1_STR-SGESAUS sy-vline
WA_RPROLSTA1_STR-SZKZ sy-vline
WA_RPROLSTA1_STR-NANGEBOT sy-vline
WA_RPROLSTA1_STR-SINCL sy-vline
WA_RPROLSTA1_STR-ZVRHYEFF sy-vline
WA_RPROLSTA1_STR-PVGLEFFZ sy-vline
WA_RPROLSTA1_STR-SULTEFSZ sy-vline
WA_RPROLSTA1_STR-DABEFFZ sy-vline
WA_RPROLSTA1_STR-DKUENDDN sy-vline
WA_RPROLSTA1_STR-SKUEDN sy-vline
WA_RPROLSTA1_STR-SKUEART sy-vline
WA_RPROLSTA1_STR-DMARKTZINS sy-vline
WA_RPROLSTA1_STR-SKALIDWT sy-vline
WA_RPROLSTA1_STR-EDEFFZINS sy-vline
WA_RPROLSTA1_STR-EDEFFMETH sy-vline
WA_RPROLSTA1_STR-JAHREFFZINS sy-vline
WA_RPROLSTA1_STR-JAHREFFMETH sy-vline
WA_RPROLSTA1_STR-PEFFZINS_ORIGIN sy-vline
WA_RPROLSTA1_STR-PEFFZINS_ADD sy-vline
WA_RPROLSTA1_STR-GROUP_ID sy-vline
WA_RPROLSTA1_STR-VERSION sy-vline
WA_RPROLSTA1_STR-CLUSTER_NO sy-vline
WA_RPROLSTA1_STR-ORIGINAL_TERM sy-vline
WA_RPROLSTA1_STR-OVERALL_RUNTIME sy-vline
WA_RPROLSTA1_STR-ORIG_CREDIT_SUM sy-vline
WA_RPROLSTA1_STR-DATE_REPAYMENT sy-vline
WA_RPROLSTA1_STR-DATE_FIRST_RATE sy-vline
WA_RPROLSTA1_STR-DAY_OF_PAYMENT sy-vline
WA_RPROLSTA1_STR-CLEARING_RATE sy-vline
WA_RPROLSTA1_STR-EFF_INT_L_PYMNP sy-vline
WA_RPROLSTA1_STR-DEFF_INT_L_PYMNP sy-vline
WA_RPROLSTA1_STR-REPAY_DELAY sy-vline
WA_RPROLSTA1_STR-CALCULATED_PARAM sy-vline
WA_RPROLSTA1_STR-CURR_CREDIT_SUM sy-vline
WA_RPROLSTA1_STR-BROUNDUNIT sy-vline
WA_RPROLSTA1_STR-SROUND sy-vline
WA_RPROLSTA1_STR-BOVERLIMIT sy-vline
WA_RPROLSTA1_STR-POVERLIMIT sy-vline
WA_RPROLSTA1_STR-CONTAB sy-vline
WA_RPROLSTA1_STR-CONTAB_VERSION sy-vline
WA_RPROLSTA1_STR-TERM_PAYMENT sy-vline
WA_RPROLSTA1_STR-PAPR_ORIGIN sy-vline
WA_RPROLSTA1_STR-GSART sy-vline
WA_RPROLSTA1_STR-STITEL sy-vline
WA_RPROLSTA1_STR-SBEA sy-vline
WA_RPROLSTA1_STR-FLG_PRO sy-vline
WA_RPROLSTA1_STR-FLG_MEH sy-vline
WA_RPROLSTA1_STR-FLG_ZURGEZ sy-vline
WA_RPROLSTA1_STR-FLG_ZURGEF sy-vline
WA_RPROLSTA1_STR-FLG_UNE sy-vline
WA_RPROLSTA1_STR-FZT sy-vline
WA_RPROLSTA1_STR-SWHR sy-vline
WA_RPROLSTA1_STR-SBWHR sy-vline
WA_RPROLSTA1_STR-SHWHR sy-vline
WA_RPROLSTA1_STR-SWWHR sy-vline
WA_RPROLSTA1_STR-BVKWR sy-vline
WA_RPROLSTA1_STR-BVKW2 sy-vline
WA_RPROLSTA1_STR-BVZWR sy-vline
WA_RPROLSTA1_STR-BVZW2 sy-vline
WA_RPROLSTA1_STR-BZKWR sy-vline
WA_RPROLSTA1_STR-BZKW2 sy-vline
WA_RPROLSTA1_STR-BKKWR sy-vline
WA_RPROLSTA1_STR-BZNWR sy-vline
WA_RPROLSTA1_STR-BAB sy-vline
WA_RPROLSTA1_STR-BRPWR sy-vline
WA_RPROLSTA1_STR-BRPHW sy-vline
WA_RPROLSTA1_STR-BRPW2 sy-vline
WA_RPROLSTA1_STR-BRIWR sy-vline
WA_RPROLSTA1_STR-BRIHW sy-vline
WA_RPROLSTA1_STR-BRIW2 sy-vline
WA_RPROLSTA1_STR-BRVWR sy-vline
WA_RPROLSTA1_STR-BRVHW sy-vline
WA_RPROLSTA1_STR-BMIWR sy-vline
WA_RPROLSTA1_STR-BMIW2 sy-vline
WA_RPROLSTA1_STR-BATWR sy-vline
WA_RPROLSTA1_STR-BATHW sy-vline
WA_RPROLSTA1_STR-BATW2 sy-vline
WA_RPROLSTA1_STR-BATNWR sy-vline
WA_RPROLSTA1_STR-BATZWR sy-vline
WA_RPROLSTA1_STR-BATZHW sy-vline
WA_RPROLSTA1_STR-BATZW2 sy-vline
WA_RPROLSTA1_STR-BPTWR sy-vline
WA_RPROLSTA1_STR-BPTHW sy-vline
WA_RPROLSTA1_STR-BPTW2 sy-vline
WA_RPROLSTA1_STR-BPTZWR sy-vline
WA_RPROLSTA1_STR-BPTZHW sy-vline
WA_RPROLSTA1_STR-BPTZW2 sy-vline
WA_RPROLSTA1_STR-BAVWR sy-vline
WA_RPROLSTA1_STR-BAVHW sy-vline
WA_RPROLSTA1_STR-BAVW2 sy-vline
WA_RPROLSTA1_STR-BAVVWR sy-vline
WA_RPROLSTA1_STR-BVAWR sy-vline
WA_RPROLSTA1_STR-BVAHW sy-vline
WA_RPROLSTA1_STR-BVAIWR sy-vline
WA_RPROLSTA1_STR-BVAIHW sy-vline
WA_RPROLSTA1_STR-BVAW2 sy-vline
WA_RPROLSTA1_STR-BG1WR sy-vline
WA_RPROLSTA1_STR-BG2WR sy-vline
WA_RPROLSTA1_STR-BKAUFWR sy-vline
WA_RPROLSTA1_STR-BKAUFHW sy-vline
WA_RPROLSTA1_STR-BBUCHWR sy-vline
WA_RPROLSTA1_STR-BBUCHHW sy-vline
WA_RPROLSTA1_STR-BAAWR sy-vline
WA_RPROLSTA1_STR-BZVWR sy-vline
WA_RPROLSTA1_STR-BZVHW sy-vline
WA_RPROLSTA1_STR-BZVZWR sy-vline
WA_RPROLSTA1_STR-BZVZHW sy-vline
WA_RPROLSTA1_STR-BKGVWR sy-vline
WA_RPROLSTA1_STR-BKGVHW sy-vline
WA_RPROLSTA1_STR-BAUFWR sy-vline
WA_RPROLSTA1_STR-BAUFHW sy-vline
WA_RPROLSTA1_STR-BTA2WR sy-vline
WA_RPROLSTA1_STR-BTA2HW sy-vline
WA_RPROLSTA1_STR-BTA2ZWR sy-vline
WA_RPROLSTA1_STR-BTA2ZHW sy-vline
WA_RPROLSTA1_STR-BRPNWR sy-vline
WA_RPROLSTA1_STR-BRPNHW sy-vline
WA_RPROLSTA1_STR-BRINWR sy-vline
WA_RPROLSTA1_STR-BRINHW sy-vline
WA_RPROLSTA1_STR-BEURPWR sy-vline
WA_RPROLSTA1_STR-BEUAVWR sy-vline
WA_RPROLSTA1_STR-BZVIWR sy-vline
WA_RPROLSTA1_STR-BZVIHW sy-vline
WA_RPROLSTA1_STR-BVAWRTZ sy-vline
WA_RPROLSTA1_STR-BVAHWTZ sy-vline
WA_RPROLSTA1_STR-BVAIWRTZ sy-vline
WA_RPROLSTA1_STR-BVAIHWTZ sy-vline
WA_RPROLSTA1_STR-BATNHW sy-vline
WA_RPROLSTA1_STR-SONDERWR sy-vline
WA_RPROLSTA1_STR-UMBUCHWR sy-vline
WA_RPROLSTA1_STR-STYP sy-vline
WA_RPROLSTA1_STR-RHORD sy-vline
WA_RPROLSTA1_STR-SVYM sy-vline
WA_RPROLSTA1_STR-SVNR sy-vline
WA_RPROLSTA1_STR-RORD sy-vline
WA_RPROLSTA1_STR-SREG sy-vline
WA_RPROLSTA1_STR-RSBEAR sy-vline
WA_RPROLSTA1_STR-XDNINFO sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.