Question

SAP ABAP 里用select 从三个相关联的表同时取数到一个TABLE里怎么写。

Answer 1

"定义内表:gt_data
data:begin of wa_data,
werks type afpo-werks,
aufnr type afpo-aufnr,
vornr type afru-vornr,
auart type aufk-auart,
end of wa_data,
gt_data like table of wa_data.
SELECT A~dwerk as werks
a~aufnr "工单号码
b~vornr "作业
c~auart "订单类型
FROM afpo as a
INNER JOIN afru as b ON a~aufnr = b~aufnr
inner join AUFK as c on a~aufnr = c~aufnr
INTO CORRESPONDING FIELDS OF TABLE gt_data
WHERE a~dwerk = '工厂' .

Answer 2

首先定义一个内表
DATA: BEGIN OF GWA_OUT,
MATNR LIKE MARA-MATNR,
WERKS LIKE MARC-WERKS,
LABST LIKE MARD-LABST,
END OF GWA_OUT.
DATA: GT_OUT LIKE TABLE OF GWA_OUT.
现在我从MARA里面取物料号从MARC里面取工厂从MRAD里面取库存
select a~matnr c~werks d~labst
into table gt_out
form mara as a
inner join marc as c on a~matnr = c~matnr
inner join mard as d on c-matnr = d~matnr
and c~werks = d~werks
where a~matnr = p_matnr

Answer 3

data:begin of wa_data,
werks type afpo-werks,
aufnr type afpo-aufnr,
vornr type afru-vornr,
auart type aufk-auart,
end of wa_data,
gt_data like table of wa_data.
SELECT A~dwerk as werks
a~aufnr "工单号码
b~vornr "作业
c~auart "订单类型
FROM afpo as a
INNER JOIN afru as b ON a~aufnr = b~aufnr
inner join AUFK as c on a~aufnr = c~aufnr
INTO CORRESPONDING FIELDS OF TABLE gt_data
WHERE a~dwerk = '工厂' .

Answer 4

顶楼上