Activities und Opportunities aus SAP CRM extrahieren

Code: Alles auswählen.

SELECT * FROM STXH WHERE TDOBJECT = 'CRM_ORDERH'

Code: Alles auswählen.

form remove_invalid_control_chars
  changing
    text_to_strip.

  types:
    begin of control_char_list_struct,
      hex  type c,
      code type c length 3,
    end of control_char_list_struct.

  data:
    control_char_list       type table of control_char_list_struct,
    control_char_list_entry like line of control_char_list,
    test_string type string,
    white_space type string.

  white_space = cl_abap_conv_in_ce=>uccp( '0020' ).
  control_char_list = value #(
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0000' ) code = 'NUL' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0001' ) code = 'SOH' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0002' ) code = 'STX' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0003' ) code = 'ETX' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0004' ) code = 'EOT' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0005' ) code = 'ENQ' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0006' ) code = 'ACK' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0007' ) code = 'BEL' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0008' ) code = 'BS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0009' ) code = 'HT' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000A' ) code = 'LF' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000B' ) code = 'VT' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000C' ) code = 'FF' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000D' ) code = 'CR' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000E' ) code = 'SO' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '000F' ) code = 'SI' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0010' ) code = 'DLE' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0011' ) code = 'DC1' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0012' ) code = 'DC2' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0013' ) code = 'DC3' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0014' ) code = 'DC4' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0015' ) code = 'NAK' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0016' ) code = 'SYN' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0017' ) code = 'ETB' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0018' ) code = 'CAN' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0019' ) code = 'EM' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001A' ) code = 'SUB' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001B' ) code = 'ESC' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001C' ) code = 'FS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001D' ) code = 'GS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001E' ) code = 'RS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '001F' ) code = 'US' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '007F' ) code = 'DEL' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0080' ) code = 'PAD' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0081' ) code = 'HOP' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0082' ) code = 'BPH' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0083' ) code = 'NBH' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0084' ) code = 'IND' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0085' ) code = 'NEL' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0086' ) code = 'SSA' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0087' ) code = 'ESA' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0088' ) code = 'HTS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0089' ) code = 'HTJ' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008A' ) code = 'VTS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008B' ) code = 'PLD' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008C' ) code = 'PLU' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008D' ) code = 'RI' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008E' ) code = 'SS2' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '008F' ) code = 'SS3' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0090' ) code = 'DCS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0091' ) code = 'PU1' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0092' ) code = 'PU2' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0093' ) code = 'STS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0094' ) code = 'CCH' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0095' ) code = 'MW' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0096' ) code = 'SPA' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0097' ) code = 'EPA' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0098' ) code = 'SOS' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '0099' ) code = 'SGCI' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009A' ) code = 'SCI' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009B' ) code = 'CSI' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009C' ) code = 'ST' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009D' ) code = 'OSC' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009E' ) code = 'PM' )
    ( hex = CL_ABAP_CONV_IN_CE=>uccp( '009F' ) code = 'APC' )
  ).

  loop at control_char_list into control_char_list_entry.
    replace all occurrences of control_char_list_entry-hex in text_to_strip with white_space.
  endloop.
endform.