ABAP Select data from SAP table WB2_V_BVB_CONTR 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 WB2_V_BVB_CONTR 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 WB2_V_BVB_CONTR. 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 WB2_V_BVB_CONTR 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_WB2_V_BVB_CONTR TYPE STANDARD TABLE OF WB2_V_BVB_CONTR,
      WA_WB2_V_BVB_CONTR TYPE WB2_V_BVB_CONTR,
      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: <WB2_V_BVB_CONTR> TYPE WB2_V_BVB_CONTR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WB2_V_BVB_CONTR
*  INTO TABLE @DATA(IT_WB2_V_BVB_CONTR2).
*--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_WB2_V_BVB_CONTR INDEX 1 INTO DATA(WA_WB2_V_BVB_CONTR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_WB2_V_BVB_CONTR ASSIGNING <WB2_V_BVB_CONTR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<WB2_V_BVB_CONTR>-MANDT = 1.
<WB2_V_BVB_CONTR>-NUM = 1.
<WB2_V_BVB_CONTR>-GUID = 1.
<WB2_V_BVB_CONTR>-FIELDCOMB = 1.
<WB2_V_BVB_CONTR>-INCL_EXCL = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WB2_V_BVB_CONTR-X_LIFNR, sy-vline,
WA_WB2_V_BVB_CONTR-X_KUNNR, sy-vline,
WA_WB2_V_BVB_CONTR-SELECTION_GROUP, sy-vline,
WA_WB2_V_BVB_CONTR-VALID_FROM, sy-vline,
WA_WB2_V_BVB_CONTR-VALID_TO, sy-vline,
WA_WB2_V_BVB_CONTR-_DATAAGING, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WB2_V_BVB_CONTR 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_WB2_V_BVB_CONTR 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_WB2_V_BVB_CONTR INTO WA_WB2_V_BVB_CONTR. *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 NUM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-NUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-NUM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field PMATN CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-PMATN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-PMATN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field SATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-SATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-SATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-PS_PSP_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field SERVICE_DOC_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WB2_V_BVB_CONTR-SERVICE_DOC_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WB2_V_BVB_CONTR-SERVICE_DOC_ID.
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_WB2_V_BVB_CONTR_STR,
MANDT TYPE STRING,
NUM TYPE STRING,
GUID TYPE STRING,
FIELDCOMB TYPE STRING,
INCL_EXCL TYPE STRING,
X_LIFNR TYPE STRING,
X_KUNNR TYPE STRING,
SELECTION_GROUP TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
_DATAAGING TYPE STRING,
FC_GROUP_BVB TYPE STRING,
ORIGIN TYPE STRING,
LIFNR TYPE STRING,
KUNNR TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
BUKRS TYPE STRING,
WERKS TYPE STRING,
LTSNR TYPE STRING,
MATKL TYPE STRING,
MATNR TYPE STRING,
CUSTOMER_LIST TYPE STRING,
VENDOR_LIST TYPE STRING,
PLANT_LIST TYPE STRING,
OFFERID TYPE STRING,
AKTNR TYPE STRING,
WGHIE TYPE STRING,
KUNHIER TYPE STRING,
PRODH TYPE STRING,
MVGR1 TYPE STRING,
MVGR2 TYPE STRING,
MVGR3 TYPE STRING,
MVGR4 TYPE STRING,
MVGR5 TYPE STRING,
CAMPAIGN TYPE STRING,
TG_ID TYPE STRING,
BVB_LIST TYPE STRING,
EKKOL TYPE STRING,
MTART TYPE STRING,
AUGRU TYPE STRING,
MFRNR TYPE STRING,
LIFNR_ROYALTIES TYPE STRING,
LIFNR_COMMISSION TYPE STRING,
BONUS TYPE STRING,
PROVG TYPE STRING,
LAND1 TYPE STRING,
REGIO TYPE STRING,
KONDM TYPE STRING,
KUNWE TYPE STRING,
PMATN TYPE STRING,
SATNR TYPE STRING,
PS_PSP_PNR TYPE STRING,
VKBUR TYPE STRING,
VKGRP TYPE STRING,
KUNRG TYPE STRING,
CONTRACT TYPE STRING,
CONTRACT_PROCESS TYPE STRING,
SERVICE_DOC_TYPE TYPE STRING,
SERVICE_DOC_ID TYPE STRING,
SERVICE_DOC_ITEM_ID TYPE STRING,
BLART TYPE STRING,
KVGR1 TYPE STRING,
KVGR2 TYPE STRING,
KVGR3 TYPE STRING,
KVGR4 TYPE STRING,
KVGR5 TYPE STRING,
KDGRP TYPE STRING,
DUMMY TYPE STRING,
EXT_GUID TYPE STRING,
DEACT TYPE STRING,
DATE_FROM TYPE STRING,
DATE_TO TYPE STRING,
CONTRACT_TYPE TYPE STRING,
COCO_DET_REL TYPE STRING,
COCO_DET_REL_CONTR TYPE STRING,
PROCESS_VARIANT TYPE STRING,END OF T_EKKO_STR. DATA: WA_WB2_V_BVB_CONTR_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_WB2_V_BVB_CONTR_STR-MANDT sy-vline
WA_WB2_V_BVB_CONTR_STR-NUM sy-vline
WA_WB2_V_BVB_CONTR_STR-GUID sy-vline
WA_WB2_V_BVB_CONTR_STR-FIELDCOMB sy-vline
WA_WB2_V_BVB_CONTR_STR-INCL_EXCL sy-vline
WA_WB2_V_BVB_CONTR_STR-X_LIFNR sy-vline
WA_WB2_V_BVB_CONTR_STR-X_KUNNR sy-vline
WA_WB2_V_BVB_CONTR_STR-SELECTION_GROUP sy-vline
WA_WB2_V_BVB_CONTR_STR-VALID_FROM sy-vline
WA_WB2_V_BVB_CONTR_STR-VALID_TO sy-vline
WA_WB2_V_BVB_CONTR_STR-_DATAAGING sy-vline
WA_WB2_V_BVB_CONTR_STR-FC_GROUP_BVB sy-vline
WA_WB2_V_BVB_CONTR_STR-ORIGIN sy-vline
WA_WB2_V_BVB_CONTR_STR-LIFNR sy-vline
WA_WB2_V_BVB_CONTR_STR-KUNNR sy-vline
WA_WB2_V_BVB_CONTR_STR-EKORG sy-vline
WA_WB2_V_BVB_CONTR_STR-EKGRP sy-vline
WA_WB2_V_BVB_CONTR_STR-VKORG sy-vline
WA_WB2_V_BVB_CONTR_STR-VTWEG sy-vline
WA_WB2_V_BVB_CONTR_STR-SPART sy-vline
WA_WB2_V_BVB_CONTR_STR-BUKRS sy-vline
WA_WB2_V_BVB_CONTR_STR-WERKS sy-vline
WA_WB2_V_BVB_CONTR_STR-LTSNR sy-vline
WA_WB2_V_BVB_CONTR_STR-MATKL sy-vline
WA_WB2_V_BVB_CONTR_STR-MATNR sy-vline
WA_WB2_V_BVB_CONTR_STR-CUSTOMER_LIST sy-vline
WA_WB2_V_BVB_CONTR_STR-VENDOR_LIST sy-vline
WA_WB2_V_BVB_CONTR_STR-PLANT_LIST sy-vline
WA_WB2_V_BVB_CONTR_STR-OFFERID sy-vline
WA_WB2_V_BVB_CONTR_STR-AKTNR sy-vline
WA_WB2_V_BVB_CONTR_STR-WGHIE sy-vline
WA_WB2_V_BVB_CONTR_STR-KUNHIER sy-vline
WA_WB2_V_BVB_CONTR_STR-PRODH sy-vline
WA_WB2_V_BVB_CONTR_STR-MVGR1 sy-vline
WA_WB2_V_BVB_CONTR_STR-MVGR2 sy-vline
WA_WB2_V_BVB_CONTR_STR-MVGR3 sy-vline
WA_WB2_V_BVB_CONTR_STR-MVGR4 sy-vline
WA_WB2_V_BVB_CONTR_STR-MVGR5 sy-vline
WA_WB2_V_BVB_CONTR_STR-CAMPAIGN sy-vline
WA_WB2_V_BVB_CONTR_STR-TG_ID sy-vline
WA_WB2_V_BVB_CONTR_STR-BVB_LIST sy-vline
WA_WB2_V_BVB_CONTR_STR-EKKOL sy-vline
WA_WB2_V_BVB_CONTR_STR-MTART sy-vline
WA_WB2_V_BVB_CONTR_STR-AUGRU sy-vline
WA_WB2_V_BVB_CONTR_STR-MFRNR sy-vline
WA_WB2_V_BVB_CONTR_STR-LIFNR_ROYALTIES sy-vline
WA_WB2_V_BVB_CONTR_STR-LIFNR_COMMISSION sy-vline
WA_WB2_V_BVB_CONTR_STR-BONUS sy-vline
WA_WB2_V_BVB_CONTR_STR-PROVG sy-vline
WA_WB2_V_BVB_CONTR_STR-LAND1 sy-vline
WA_WB2_V_BVB_CONTR_STR-REGIO sy-vline
WA_WB2_V_BVB_CONTR_STR-KONDM sy-vline
WA_WB2_V_BVB_CONTR_STR-KUNWE sy-vline
WA_WB2_V_BVB_CONTR_STR-PMATN sy-vline
WA_WB2_V_BVB_CONTR_STR-SATNR sy-vline
WA_WB2_V_BVB_CONTR_STR-PS_PSP_PNR sy-vline
WA_WB2_V_BVB_CONTR_STR-VKBUR sy-vline
WA_WB2_V_BVB_CONTR_STR-VKGRP sy-vline
WA_WB2_V_BVB_CONTR_STR-KUNRG sy-vline
WA_WB2_V_BVB_CONTR_STR-CONTRACT sy-vline
WA_WB2_V_BVB_CONTR_STR-CONTRACT_PROCESS sy-vline
WA_WB2_V_BVB_CONTR_STR-SERVICE_DOC_TYPE sy-vline
WA_WB2_V_BVB_CONTR_STR-SERVICE_DOC_ID sy-vline
WA_WB2_V_BVB_CONTR_STR-SERVICE_DOC_ITEM_ID sy-vline
WA_WB2_V_BVB_CONTR_STR-BLART sy-vline
WA_WB2_V_BVB_CONTR_STR-KVGR1 sy-vline
WA_WB2_V_BVB_CONTR_STR-KVGR2 sy-vline
WA_WB2_V_BVB_CONTR_STR-KVGR3 sy-vline
WA_WB2_V_BVB_CONTR_STR-KVGR4 sy-vline
WA_WB2_V_BVB_CONTR_STR-KVGR5 sy-vline
WA_WB2_V_BVB_CONTR_STR-KDGRP sy-vline
WA_WB2_V_BVB_CONTR_STR-DUMMY sy-vline
WA_WB2_V_BVB_CONTR_STR-EXT_GUID sy-vline
WA_WB2_V_BVB_CONTR_STR-DEACT sy-vline
WA_WB2_V_BVB_CONTR_STR-DATE_FROM sy-vline
WA_WB2_V_BVB_CONTR_STR-DATE_TO sy-vline
WA_WB2_V_BVB_CONTR_STR-CONTRACT_TYPE sy-vline
WA_WB2_V_BVB_CONTR_STR-COCO_DET_REL sy-vline
WA_WB2_V_BVB_CONTR_STR-COCO_DET_REL_CONTR sy-vline
WA_WB2_V_BVB_CONTR_STR-PROCESS_VARIANT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.