所以我能用delect count(*) into lv_count from 语法,查询同账号状态为 1004的多条数据并将有多条数据的抽取到内表吗?
时间: 2024-03-12 15:47:55 浏览: 35
是的,你可以使用以下代码来实现该功能:
```
DATA: lt_account TYPE STANDARD TABLE OF table_name,
ls_account LIKE LINE OF lt_account,
lv_count TYPE i.
SELECT account_number COUNT(*) INTO CORRESPONDING FIELDS OF TABLE lt_account
FROM table_name
WHERE account_status = '100400'
GROUP BY account_number
HAVING COUNT(*) > 1.
IF sy-subrc = 0 AND lt_account IS NOT INITIAL.
LOOP AT lt_account INTO ls_account.
SELECT * FROM table_name INTO TABLE result_tab
WHERE account_number = ls_account-account_number
AND account_status = '100400'.
ENDLOOP.
ENDIF.
```
其中,`table_name`是你要抽取数据的表名,`account_status`是账号状态字段名,`100400`是账号状态的取值,`account_number`是账号字段名。这段代码会按照账号字段进行分组,然后只选择账号状态为`100400`且有多条数据的账号。然后,通过循环遍历这些账号,并再次使用SELECT语句抽取这些账号的所有数据,最后将结果存储到内表`result_tab`中。