• 内表重复字段如何删除


    *----------------------------------------------------------------------*
    * 作成者   : 張玉剛
    * 作成日   : 2009/07/24
    *----------------------------------------------------------------------*
    * 処理概要:
    *    内表重复字段如何删除

    *   开始的数据如下:

      f1            f2               f3                              f4                   f5

    -----------------------------------------------------------------------

     a              100          2009-01-01                   20                 2009-01-01

     a              100          2009-01-01                   30                 2009-01-03

    a              100          2009-01-01                    50                 2009-01-04

     a             30            2009-01-12                    30                 2009-01-14

     b             20            2009-01-03                    10                 2009-01-22

    最后得到的结果数格式为:

    f1            f2               f3                              f4                   f5

    -----------------------------------------------------------------------

     a              100          2009-01-01                   20                 2009-01-01

                                        30                 2009-01-03

                                          50                 2009-01-04

                 30            2009-01-12                    30                 2009-01-14

     b             20            2009-01-03                    10                 2009-01-22

    *----------------------------------------------------------------------*
    * 使用テーブル:
    *    IT_TABLE
    *   
    *----------------------------------------------------------------------*

    *----------------------------------------------------------------------*
    *                                                           方法一
    *----------------------------------------------------------------------*

    REPORT  Z_TEST5 .

    *----------------------------------------------------------------------*
    * 类型定义
    *----------------------------------------------------------------------*
    TYPES:
      BEGIN OF T_STR_CLASS,
        f1(1)    TYPE C,
        f2(5)    TYPE C,
        f3(12)   TYPE C,
        f4(10)   TYPE C,
        f5(12)   TYPE C,
    END OF T_STR_CLASS,

    T_IT_TABLE   TYPE STANDARD TABLE OF T_STR_CLASS.

    *----------------------------------------------------------------------*
    * 变量定义
    *----------------------------------------------------------------------*

    DATA:
      STR_CLASS   TYPE  T_STR_CLASS,
      IT_TABLE    TYPE  T_IT_TABLE.

    *----------------------------------------------------------------------*
    * 主处理
    *----------------------------------------------------------------------*

    "内表中写入数据

    STR_CLASS-f1 = 'a'.
    STR_CLASS-f2 = '100'.
    STR_CLASS-f3 = '2009-1-1'.
    STR_CLASS-f4 = '20'.
    STR_CLASS-f5 = '2009-1-1'.
    APPEND STR_CLASS TO IT_TABLE.
    CLEAR STR_CLASS.

    "内表中写入数据

    STR_CLASS-f1 = 'a'.
    STR_CLASS-f2 = '100'.
    STR_CLASS-f3 = '2009-1-1'.
    STR_CLASS-f4 = '30'.
    STR_CLASS-f5 = '2009-1-3'.
    APPEND STR_CLASS TO IT_TABLE.
    CLEAR STR_CLASS.

    "内表中写入数据

    STR_CLASS-f1 = 'a'.
    STR_CLASS-f2 = '100'.
    STR_CLASS-f3 = '2009-1-1'.
    STR_CLASS-f4 = '50'.
    STR_CLASS-f5 = '2009-1-4'.
    APPEND STR_CLASS TO IT_TABLE.
    CLEAR STR_CLASS.

    STR_CLASS-f1 = 'a'.
    STR_CLASS-f2 = '30'.
    STR_CLASS-f3 = '2009-1-12'.
    STR_CLASS-f4 = '30'.
    STR_CLASS-f5 = '2009-1-14'.
    APPEND STR_CLASS TO IT_TABLE.
    CLEAR STR_CLASS.

    "内表中写入数据

    STR_CLASS-f1 = 'b'.
    STR_CLASS-f2 = '20'.
    STR_CLASS-f3 = '2009-1-3'.
    STR_CLASS-f4 = '10'.
    STR_CLASS-f5 = '2009-1-22'.
    APPEND STR_CLASS TO IT_TABLE.
    CLEAR STR_CLASS.

    "对内表按照f1,f2,f3这三个字段进行排序

    SORT IT_TABLE BY f1 f2 f3.

    "输出列头
    WRITE: /1 'F1', 5 'F2', 12 'F3', 26 'F4', 38 'F5'.

    "遍历内表数据显示
    LOOP AT IT_TABLE INTO STR_CLASS.

    "对于f1列内容改变时,显示到屏幕,不改变不显示(*AT NEW的用法见最后)

     AT NEW f1.
       WRITE: /1 STR_CLASS-f1.
     ENDAT.

    "对于f2列内容改变时,显示到屏幕,不改变不显示

     AT NEW f2.
       WRITE: 5 STR_CLASS-f2.
     ENDAT.

    "对于f3列内容改变时,显示到屏幕,不改变不显示

     AT NEW f3.
       WRITE: 12 STR_CLASS-f3.
     ENDAT.

    "对于f4,f5列内容显示到屏幕

     WRITE: 26 STR_CLASS-f4, 38 STR_CLASS-f5.

    "换新行
     NEW-LINE.

    ENDLOOP.

    *----------------------------------------------------------------------*
    *                                                           方法二
    *----------------------------------------------------------------------*

      Z_TEST5 .

    *----------------------------------------------------------------------*
    * 变量定义
    *----------------------------------------------------------------------*

    "定义一个具有列结构的内表

    DATA: BEGIN OF IT_TABLE OCCURS 10,
          f1(1)     TYPE  C,
          f2(5)     TYPE  C,
          f3(12)    TYPE  C,
          f4(10)    TYPE  C,
          f5(12)    TYPE  C,
        END OF IT_TABLE.

    "定义一个和该内表含有相同结构的内表

    DATA IT_TEST LIKE IT_TABLE.

    "定义一个和该内表含有相同结构的字段符号

    FIELD-SYMBOLS <FS> LIKE IT_TABLE.

    "向内表中放入数据

    IT_TABLE-f1 = 'a'.
    IT_TABLE-f2 = '100'.
    IT_TABLE-f3 = '2009-1-1'.
    IT_TABLE-f4 = '20'.
    IT_TABLE-f5 = '2009-1-1'.
    APPEND IT_TABLE.

    "向内表中放入数据

    IT_TABLE-f1 = 'a'.
    IT_TABLE-f2 = '100'.
    IT_TABLE-f3 = '2009-1-1'.
    IT_TABLE-f4 = '30'.
    IT_TABLE-f5 = '2009-1-3'.
    APPEND IT_TABLE.

    "向内表中放入数据

    IT_TABLE-f1 = 'a'.
    IT_TABLE-f2 = '100'.
    IT_TABLE-f3 = '2009-1-1'.
    IT_TABLE-f4 = '50'.
    IT_TABLE-f5 = '2009-1-4'.
    APPEND IT_TABLE.

    "向内表中放入数据

    IT_TABLE-f1 = 'a'.
    IT_TABLE-f2 = '30'.
    IT_TABLE-f3 = '2009-1-12'.
    IT_TABLE-f4 = '30'.
    IT_TABLE-f5 = '2009-1-14'.
    APPEND IT_TABLE.

    "向内表中放入数据

    IT_TABLE-f1 = 'b'.
    IT_TABLE-f2 = '20'.
    IT_TABLE-f3 = '2009-1-3'.
    IT_TABLE-f4 = '10'.
    IT_TABLE-f5 = '2009-1-22'.
    APPEND IT_TABLE.

    "对内表按照f1,f2,f3三列进行排序

    SORT IT_TABLE BY f1 f2 f3.

    "把内表列付给字段符号,这样字段符号,就指向了内表的那一列的值

    LOOP AT IT_TABLE ASSIGNING <FS> .

    "这句话的意思我不是很懂,大家有清楚的告诉我下。是一个值还是一列还是整个表?
        IT_TABLE = <FS>.

    "比较IT_TEST内表中的f1字段的值与<fs>指向的f1的值是不是相同
     IF IT_TEST-F1 = <FS>-F1 .

    "相同的话清空
        CLEAR <FS>-F1.
        IF IT_TEST-F2 = <FS>-F2.
        CLEAR <FS>-F2.
           IF IT_TEST-F3 = <FS>-F3.
             CLEAR <FS>-F3.
           ENDIF.
        ENDIF.

     ENDIF.
       IT_TEST = IT_TABLE.
    ENDLOOP.

    "显示到屏幕

    LOOP AT IT_TABLE.
      WRITE : / IT_TABLE-F1,IT_TABLE-F2,IT_TABLE-F3,IT_TABLE-F4.
    ENDLOOP.

  • 相关阅读:
    查看MySQL数据库版本
    PHP如何查找一列有序数组是否包含某值(二分查找)
    TP数据查询给sql给查询加一个虚拟字段值
    TP SQL统计查询语法
    PHP如何对一组数进行重新排列(冒泡算法)
    python入门及数字、字符串类型
    GitHub及Git及GitHub搭建个人网站
    Editplus的扩展程序的删除
    50个SQL语句(MySQL版) 问题十五
    50个SQL语句(MySQL版) 问题十四
  • 原文地址:https://www.cnblogs.com/wequst/p/1530265.html
Copyright © 2020-2023  润新知