ABAP Select data from SAP table BAPICCBVB 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 BAPICCBVB 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 BAPICCBVB. 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 BAPICCBVB 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_BAPICCBVB TYPE STANDARD TABLE OF BAPICCBVB,
      WA_BAPICCBVB TYPE BAPICCBVB,
      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: <BAPICCBVB> TYPE BAPICCBVB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BAPICCBVB
*  INTO TABLE @DATA(IT_BAPICCBVB2).
*--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_BAPICCBVB INDEX 1 INTO DATA(WA_BAPICCBVB2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BAPICCBVB>-ORDER_KEY = 1.
<BAPICCBVB>-FIELDCOMBINATION = 1.
<BAPICCBVB>-INCLUDE_EXCLUDE = 1.
<BAPICCBVB>-VENDOR_NO_KEY = 1.
<BAPICCBVB>-CUSTOMER_KEY = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BAPICCBVB-PURCH_ORG_KEY, sy-vline,
  WA_BAPICCBVB-PUR_GROUP_KEY, sy-vline,
  WA_BAPICCBVB-SALESORG_KEY, sy-vline,
  WA_BAPICCBVB-DISTR_CHAN_KEY, sy-vline,
  WA_BAPICCBVB-DIVISION_KEY, sy-vline,
  WA_BAPICCBVB-COMP_CODE_KEY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BAPICCBVB 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_BAPICCBVB 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_BAPICCBVB INTO WA_BAPICCBVB.


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

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

*Conversion exit MATN5, internal->external for field MATERIAL_KEY
CALL FUNCTION 'CONVERSION_EXIT_MATN5_OUTPUT'
  EXPORTING
    input =                      WA_BAPICCBVB-MATERIAL_KEY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPICCBVB-MATERIAL_KEY.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit MATN5, internal->external for field MATERIAL_NEW
CALL FUNCTION 'CONVERSION_EXIT_MATN5_OUTPUT'
  EXPORTING
    input =                      WA_BAPICCBVB-MATERIAL_NEW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPICCBVB-MATERIAL_NEW.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field SERVICE_DOC_ID_NEW
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_BAPICCBVB-SERVICE_DOC_ID_NEW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPICCBVB-SERVICE_DOC_ID_NEW.
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_BAPICCBVB_STR, 
ORDER_KEY TYPE STRING,
FIELDCOMBINATION TYPE STRING,
INCLUDE_EXCLUDE TYPE STRING,
VENDOR_NO_KEY TYPE STRING,
CUSTOMER_KEY TYPE STRING,
PURCH_ORG_KEY TYPE STRING,
PUR_GROUP_KEY TYPE STRING,
SALESORG_KEY TYPE STRING,
DISTR_CHAN_KEY TYPE STRING,
DIVISION_KEY TYPE STRING,
COMP_CODE_KEY TYPE STRING,
PLANT_KEY TYPE STRING,
VEND_PART_KEY TYPE STRING,
MATL_GROUP_KEY TYPE STRING,
MATERIAL_KEY TYPE STRING,
VENDOR_NO_NEW TYPE STRING,
CUSTOMER_NEW TYPE STRING,
PURCH_ORG_NEW TYPE STRING,
PUR_GROUP_NEW TYPE STRING,
SALESORG_NEW TYPE STRING,
DISTR_CHAN_NEW TYPE STRING,
DIVISION_NEW TYPE STRING,
COMP_CODE_NEW TYPE STRING,
PLANT_NEW TYPE STRING,
VEND_PART_NEW TYPE STRING,
MATL_GROUP_NEW TYPE STRING,
MATERIAL_NEW TYPE STRING,
CUST_LIST_KEY TYPE STRING,
VENDOR_LIST_KEY TYPE STRING,
CUST_LIST_NEW TYPE STRING,
VENDOR_LIST_NEW TYPE STRING,
EXTERNAL_GUID TYPE STRING,
SELECTION_GROUP TYPE STRING,
MATERIAL_KEY_LONG TYPE STRING,
MATERIAL_NEW_LONG TYPE STRING,
MATGRHIER_KEY TYPE STRING,
MATGRHIER_NEW TYPE STRING,
CUST_HIER_KEY TYPE STRING,
CUST_HIER_NEW TYPE STRING,
PROMOTION_KEY TYPE STRING,
PROMOTION_NEW TYPE STRING,
OFFER_ID_KEY TYPE STRING,
OFFER_ID_NEW TYPE STRING,
PLANT_LIST_KEY TYPE STRING,
PLANT_LIST_NEW TYPE STRING,
PROD_HIER_KEY TYPE STRING,
PROD_HIER_NEW TYPE STRING,
PRC_GROUP1_KEY TYPE STRING,
PRC_GROUP1_NEW TYPE STRING,
PRC_GROUP2_KEY TYPE STRING,
PRC_GROUP2_NEW TYPE STRING,
PRC_GROUP3_KEY TYPE STRING,
PRC_GROUP3_NEW TYPE STRING,
PRC_GROUP4_KEY TYPE STRING,
PRC_GROUP4_NEW TYPE STRING,
PRC_GROUP5_KEY TYPE STRING,
PRC_GROUP5_NEW TYPE STRING,
CAMPAIGN_KEY TYPE STRING,
CAMPAIGN_NEW TYPE STRING,
TARGET_GROUP_ID_KEY TYPE STRING,
TARGET_GROUP_ID_NEW TYPE STRING,
VALID_FROM_KEY TYPE STRING,
VALID_TO_KEY TYPE STRING,
VALID_FROM_NEW TYPE STRING,
VALID_TO_NEW TYPE STRING,
BVB_LIST_KEY TYPE STRING,
BVB_LIST_NEW TYPE STRING,
COND_GROUP_KEY TYPE STRING,
COND_GROUP_NEW TYPE STRING,
MATL_TYPE_KEY TYPE STRING,
MATL_TYPE_NEW TYPE STRING,
ORD_REASON_KEY TYPE STRING,
ORD_REASON_NEW TYPE STRING,
MFR_NO_KEY TYPE STRING,
MFR_NO_NEW TYPE STRING,
ROYALTIES_REC_KEY TYPE STRING,
ROYALTIES_REC_NEW TYPE STRING,
COMMISSION_REC_KEY TYPE STRING,
COMMISSION_REC_NEW TYPE STRING,
REBATE_GRP_KEY TYPE STRING,
REBATE_GRP_NEW TYPE STRING,
COMM_GROUP_KEY TYPE STRING,
COMM_GROUP_NEW TYPE STRING,
COUNTRY_KEY TYPE STRING,
COUNTRY_NEW TYPE STRING,
COUNTRYISO_KEY TYPE STRING,
COUNTRYISO_NEW TYPE STRING,
REGION_KEY TYPE STRING,
REGION_NEW TYPE STRING,
MAT_PR_GRP_KEY TYPE STRING,
MAT_PR_GRP_NEW TYPE STRING,
SHIP_TO_KEY TYPE STRING,
SHIP_TO_NEW TYPE STRING,
PR_REF_MAT_KEY TYPE STRING,
PR_REF_MAT_NEW TYPE STRING,
CONF_MATL_KEY TYPE STRING,
CONF_MATL_NEW TYPE STRING,
WBS_ELEM_KEY TYPE STRING,
WBS_ELEM_NEW TYPE STRING,
FIELDCOMBINATION_GROUP TYPE STRING,
SALES_OFF_KEY TYPE STRING,
SALES_OFF_NEW TYPE STRING,
SALES_GRP_KEY TYPE STRING,
SALES_GRP_NEW TYPE STRING,
PAYER_KEY TYPE STRING,
PAYER_NEW TYPE STRING,
CONDITION_CONTRACT_NUMBER_KEY TYPE STRING,
CONDITION_CONTRACT_NUMBER_NEW TYPE STRING,
PROCESS_VARIANT_KEY TYPE STRING,
PROCESS_VARIANT_NEW TYPE STRING,
SERVICE_DOC_TYPE_KEY TYPE STRING,
SERVICE_DOC_TYPE_NEW TYPE STRING,
SERVICE_DOC_ID_KEY TYPE STRING,
SERVICE_DOC_ID_NEW TYPE STRING,
SERVICE_DOC_ITEM_ID_KEY TYPE STRING,
SERVICE_DOC_ITEM_ID_NEW TYPE STRING,
CUST_GRP1_KEY TYPE STRING,
CUST_GRP2_KEY TYPE STRING,
CUST_GRP3_KEY TYPE STRING,
CUST_GRP4_KEY TYPE STRING,
CUST_GRP5_KEY TYPE STRING,
CUST_GROUP_KEY TYPE STRING,
CUST_GRP1_NEW TYPE STRING,
CUST_GRP2_NEW TYPE STRING,
CUST_GRP3_NEW TYPE STRING,
CUST_GRP4_NEW TYPE STRING,
CUST_GRP5_NEW TYPE STRING,
CUST_GROUP_NEW TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BAPICCBVB_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_BAPICCBVB_STR-ORDER_KEY sy-vline 
WA_BAPICCBVB_STR-FIELDCOMBINATION sy-vline 
WA_BAPICCBVB_STR-INCLUDE_EXCLUDE sy-vline 
WA_BAPICCBVB_STR-VENDOR_NO_KEY sy-vline 
WA_BAPICCBVB_STR-CUSTOMER_KEY sy-vline 
WA_BAPICCBVB_STR-PURCH_ORG_KEY sy-vline 
WA_BAPICCBVB_STR-PUR_GROUP_KEY sy-vline 
WA_BAPICCBVB_STR-SALESORG_KEY sy-vline 
WA_BAPICCBVB_STR-DISTR_CHAN_KEY sy-vline 
WA_BAPICCBVB_STR-DIVISION_KEY sy-vline 
WA_BAPICCBVB_STR-COMP_CODE_KEY sy-vline 
WA_BAPICCBVB_STR-PLANT_KEY sy-vline 
WA_BAPICCBVB_STR-VEND_PART_KEY sy-vline 
WA_BAPICCBVB_STR-MATL_GROUP_KEY sy-vline 
WA_BAPICCBVB_STR-MATERIAL_KEY sy-vline 
WA_BAPICCBVB_STR-VENDOR_NO_NEW sy-vline 
WA_BAPICCBVB_STR-CUSTOMER_NEW sy-vline 
WA_BAPICCBVB_STR-PURCH_ORG_NEW sy-vline 
WA_BAPICCBVB_STR-PUR_GROUP_NEW sy-vline 
WA_BAPICCBVB_STR-SALESORG_NEW sy-vline 
WA_BAPICCBVB_STR-DISTR_CHAN_NEW sy-vline 
WA_BAPICCBVB_STR-DIVISION_NEW sy-vline 
WA_BAPICCBVB_STR-COMP_CODE_NEW sy-vline 
WA_BAPICCBVB_STR-PLANT_NEW sy-vline 
WA_BAPICCBVB_STR-VEND_PART_NEW sy-vline 
WA_BAPICCBVB_STR-MATL_GROUP_NEW sy-vline 
WA_BAPICCBVB_STR-MATERIAL_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_LIST_KEY sy-vline 
WA_BAPICCBVB_STR-VENDOR_LIST_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_LIST_NEW sy-vline 
WA_BAPICCBVB_STR-VENDOR_LIST_NEW sy-vline 
WA_BAPICCBVB_STR-EXTERNAL_GUID sy-vline 
WA_BAPICCBVB_STR-SELECTION_GROUP sy-vline 
WA_BAPICCBVB_STR-MATERIAL_KEY_LONG sy-vline 
WA_BAPICCBVB_STR-MATERIAL_NEW_LONG sy-vline 
WA_BAPICCBVB_STR-MATGRHIER_KEY sy-vline 
WA_BAPICCBVB_STR-MATGRHIER_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_HIER_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_HIER_NEW sy-vline 
WA_BAPICCBVB_STR-PROMOTION_KEY sy-vline 
WA_BAPICCBVB_STR-PROMOTION_NEW sy-vline 
WA_BAPICCBVB_STR-OFFER_ID_KEY sy-vline 
WA_BAPICCBVB_STR-OFFER_ID_NEW sy-vline 
WA_BAPICCBVB_STR-PLANT_LIST_KEY sy-vline 
WA_BAPICCBVB_STR-PLANT_LIST_NEW sy-vline 
WA_BAPICCBVB_STR-PROD_HIER_KEY sy-vline 
WA_BAPICCBVB_STR-PROD_HIER_NEW sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP1_KEY sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP1_NEW sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP2_KEY sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP2_NEW sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP3_KEY sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP3_NEW sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP4_KEY sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP4_NEW sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP5_KEY sy-vline 
WA_BAPICCBVB_STR-PRC_GROUP5_NEW sy-vline 
WA_BAPICCBVB_STR-CAMPAIGN_KEY sy-vline 
WA_BAPICCBVB_STR-CAMPAIGN_NEW sy-vline 
WA_BAPICCBVB_STR-TARGET_GROUP_ID_KEY sy-vline 
WA_BAPICCBVB_STR-TARGET_GROUP_ID_NEW sy-vline 
WA_BAPICCBVB_STR-VALID_FROM_KEY sy-vline 
WA_BAPICCBVB_STR-VALID_TO_KEY sy-vline 
WA_BAPICCBVB_STR-VALID_FROM_NEW sy-vline 
WA_BAPICCBVB_STR-VALID_TO_NEW sy-vline 
WA_BAPICCBVB_STR-BVB_LIST_KEY sy-vline 
WA_BAPICCBVB_STR-BVB_LIST_NEW sy-vline 
WA_BAPICCBVB_STR-COND_GROUP_KEY sy-vline 
WA_BAPICCBVB_STR-COND_GROUP_NEW sy-vline 
WA_BAPICCBVB_STR-MATL_TYPE_KEY sy-vline 
WA_BAPICCBVB_STR-MATL_TYPE_NEW sy-vline 
WA_BAPICCBVB_STR-ORD_REASON_KEY sy-vline 
WA_BAPICCBVB_STR-ORD_REASON_NEW sy-vline 
WA_BAPICCBVB_STR-MFR_NO_KEY sy-vline 
WA_BAPICCBVB_STR-MFR_NO_NEW sy-vline 
WA_BAPICCBVB_STR-ROYALTIES_REC_KEY sy-vline 
WA_BAPICCBVB_STR-ROYALTIES_REC_NEW sy-vline 
WA_BAPICCBVB_STR-COMMISSION_REC_KEY sy-vline 
WA_BAPICCBVB_STR-COMMISSION_REC_NEW sy-vline 
WA_BAPICCBVB_STR-REBATE_GRP_KEY sy-vline 
WA_BAPICCBVB_STR-REBATE_GRP_NEW sy-vline 
WA_BAPICCBVB_STR-COMM_GROUP_KEY sy-vline 
WA_BAPICCBVB_STR-COMM_GROUP_NEW sy-vline 
WA_BAPICCBVB_STR-COUNTRY_KEY sy-vline 
WA_BAPICCBVB_STR-COUNTRY_NEW sy-vline 
WA_BAPICCBVB_STR-COUNTRYISO_KEY sy-vline 
WA_BAPICCBVB_STR-COUNTRYISO_NEW sy-vline 
WA_BAPICCBVB_STR-REGION_KEY sy-vline 
WA_BAPICCBVB_STR-REGION_NEW sy-vline 
WA_BAPICCBVB_STR-MAT_PR_GRP_KEY sy-vline 
WA_BAPICCBVB_STR-MAT_PR_GRP_NEW sy-vline 
WA_BAPICCBVB_STR-SHIP_TO_KEY sy-vline 
WA_BAPICCBVB_STR-SHIP_TO_NEW sy-vline 
WA_BAPICCBVB_STR-PR_REF_MAT_KEY sy-vline 
WA_BAPICCBVB_STR-PR_REF_MAT_NEW sy-vline 
WA_BAPICCBVB_STR-CONF_MATL_KEY sy-vline 
WA_BAPICCBVB_STR-CONF_MATL_NEW sy-vline 
WA_BAPICCBVB_STR-WBS_ELEM_KEY sy-vline 
WA_BAPICCBVB_STR-WBS_ELEM_NEW sy-vline 
WA_BAPICCBVB_STR-FIELDCOMBINATION_GROUP sy-vline 
WA_BAPICCBVB_STR-SALES_OFF_KEY sy-vline 
WA_BAPICCBVB_STR-SALES_OFF_NEW sy-vline 
WA_BAPICCBVB_STR-SALES_GRP_KEY sy-vline 
WA_BAPICCBVB_STR-SALES_GRP_NEW sy-vline 
WA_BAPICCBVB_STR-PAYER_KEY sy-vline 
WA_BAPICCBVB_STR-PAYER_NEW sy-vline 
WA_BAPICCBVB_STR-CONDITION_CONTRACT_NUMBER_KEY sy-vline 
WA_BAPICCBVB_STR-CONDITION_CONTRACT_NUMBER_NEW sy-vline 
WA_BAPICCBVB_STR-PROCESS_VARIANT_KEY sy-vline 
WA_BAPICCBVB_STR-PROCESS_VARIANT_NEW sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_TYPE_KEY sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_TYPE_NEW sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_ID_KEY sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_ID_NEW sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_ITEM_ID_KEY sy-vline 
WA_BAPICCBVB_STR-SERVICE_DOC_ITEM_ID_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GRP1_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GRP2_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GRP3_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GRP4_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GRP5_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GROUP_KEY sy-vline 
WA_BAPICCBVB_STR-CUST_GRP1_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GRP2_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GRP3_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GRP4_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GRP5_NEW sy-vline 
WA_BAPICCBVB_STR-CUST_GROUP_NEW sy-vline      INTO ld_text SEPARATED BY SPACE.

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