abap for all entries 和read table联用查表用法详解
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/09/23 20:25:44
abap for all entries 和read table联用查表用法详解
用实例最能说明问题:
PARAMETERS p_city TYPE spfli-cityfrom.
TYPES:
BEGIN OF entry_tab_type,
carrid TYPE spfli-carrid,
connid TYPE spfli-connid,
END OF entry_tab_type.
DATA: entry_tab TYPE TABLE OF entry_tab_type,
gwa_sflight TYPE sflight ,
sflight_tab TYPE SORTED TABLE OF sflight
WITH UNIQUE KEY carrid connid fldate.
SELECT carrid connid
FROM spfli
INTO CORRESPONDING FIELDS OF TABLE entry_tab
WHERE cityfrom = p_city.
SELECT carrid connid fldate
FROM sflight
INTO CORRESPONDING FIELDS OF TABLE sflight_tab
FOR ALL ENTRIES IN entry_tab “看这里的效果,能直接与内表的字段进行匹配
WHERE carrid = entry_tab-carrid AND
connid = entry_tab-connid.
至于READ TABLE, 一次只能读取一条记录,最好将结果放入工作区!
例:
READ TABLE sflight_tab INTO gwa_sflight .
.
直接就可以使用用工作区的数据了.
PARAMETERS p_city TYPE spfli-cityfrom.
TYPES:
BEGIN OF entry_tab_type,
carrid TYPE spfli-carrid,
connid TYPE spfli-connid,
END OF entry_tab_type.
DATA: entry_tab TYPE TABLE OF entry_tab_type,
gwa_sflight TYPE sflight ,
sflight_tab TYPE SORTED TABLE OF sflight
WITH UNIQUE KEY carrid connid fldate.
SELECT carrid connid
FROM spfli
INTO CORRESPONDING FIELDS OF TABLE entry_tab
WHERE cityfrom = p_city.
SELECT carrid connid fldate
FROM sflight
INTO CORRESPONDING FIELDS OF TABLE sflight_tab
FOR ALL ENTRIES IN entry_tab “看这里的效果,能直接与内表的字段进行匹配
WHERE carrid = entry_tab-carrid AND
connid = entry_tab-connid.
至于READ TABLE, 一次只能读取一条记录,最好将结果放入工作区!
例:
READ TABLE sflight_tab INTO gwa_sflight .
.
直接就可以使用用工作区的数据了.
abap for all entries 和read table联用查表用法详解
for all entries in 在查询数据后面跟for all entries in +表,
ABAP READ TABLE使用BINARY SEARCH
1.For all entries in什么时候使用?
abap 的BDC用法
ABAP开发中 TYPE TABLE OF
for 的用法 For all i know
英语中如何区别同义词好像:watch,read,look.和see的用法不一样~可以再举例几个出来~用法我自己会查~
all entries may be made in block letters in english
求fell for you “for”的用法详解
all和all of 用法区别
all of和all的用法