Kuranov.Dmitry написал(а):
Ну к примеру, ваш пост:
viewtopic.php?p=572971#p572971Вы по синтаксис со скобочками вообще не поняли?
вроде все понятно, кроме селекта для меня
затрудняюсь, у меня сложный селект с left join, с двумя таблицами
Code:
SELECT SINGLE * INTO CORRESPONDING FIELDS OF gs_record FROM (g_tabname) WHERE pernr = '12345678'.
+ не совсем понял Where pernr = '12345678'
мы копируем все записи таблицы gs_record в (g_tabname) (ее мы указываем в case), где pernr - .... это поле ? и что за значение
Code:
SELECT zppmrp5~matnr_1
zppmrp5~datuv
zppmrp5~matnr_2
zppmrp5~matnr
zppmrp5~werks
zppmrp5~arbpl_1
zppmrp5~arbpl_2
zppmrp5~seqnr
zppmrp5~elevel
zppmrp5~pbdnr
zppmrp5~zbesk
zppmrp5~IA
* zppmrp5~ENTMG
zppmrp5~gamng AS gamng_td
zppmrp5~gamng_1 AS gamng_1_td
zppmrp5_tmp1~gamng AS gamng_ld
zppmrp5_tmp1~gamng_1 AS gamng_1_ld
INTO CORRESPONDING FIELDS OF TABLE gt_result_tab
FROM zppmrp5
LEFT
JOIN zppmrp5_tmp1 ON zppmrp5_tmp1~matnr = zppmrp5~matnr
AND zppmrp5_tmp1~matnr_1 = zppmrp5~matnr_1
AND zppmrp5_tmp1~matnr_2 = zppmrp5~matnr_2
AND zppmrp5_tmp1~arbpl_1 = zppmrp5~arbpl_1
AND zppmrp5_tmp1~arbpl_2 = zppmrp5~arbpl_2
AND zppmrp5_tmp1~seqnr = zppmrp5~seqnr
AND zppmrp5_tmp1~werks = zppmrp5~werks
AND zppmrp5_tmp1~pbdnr = zppmrp5~pbdnr
AND zppmrp5_tmp1~elevel = zppmrp5~elevel
WHERE "zppmrp5~elevel = 1 AND
zppmrp5~elevel in r_elevel AND
zppmrp5~matnr_1 IN so_mat1 AND
zppmrp5~matnr_2 IN so_mat2 AND
zppmrp5~matnr IN so_matnr AND
zppmrp5~arbpl_1 IN so_arb1 AND
zppmrp5~arbpl_2 IN so_arb2 AND
zppmrp5~ZBESK IN so_ZBESK.
SELECT zppmrp5_tmp1~matnr_1
zppmrp5_tmp1~matnr_2
zppmrp5_tmp1~werks
zppmrp5_tmp1~matnr
zppmrp5_tmp1~arbpl_1
zppmrp5_tmp1~arbpl_2
zppmrp5_tmp1~datuv
zppmrp5_tmp1~seqnr
zppmrp5_tmp1~elevel
zppmrp5_tmp1~pbdnr
zppmrp5_tmp1~gamng AS gamng_ld
zppmrp5_tmp1~gamng_1 AS gamng_1_ld
zppmrp5_tmp1~zbesk
zppmrp5_tmp1~IA
zppmrp5~gamng AS gamng_td
zppmrp5~gamng_1 AS gamng_1_td
APPENDING CORRESPONDING FIELDS OF TABLE gt_result_tab
FROM zppmrp5_tmp1
LEFT
JOIN zppmrp5 ON zppmrp5~matnr = zppmrp5_tmp1~matnr
AND zppmrp5~matnr_1 = zppmrp5_tmp1~matnr_1
AND zppmrp5~matnr_2 = zppmrp5_tmp1~matnr_2
AND zppmrp5~arbpl_1 = zppmrp5_tmp1~arbpl_1
AND zppmrp5~arbpl_2 = zppmrp5_tmp1~arbpl_2
AND zppmrp5~seqnr = zppmrp5_tmp1~seqnr
AND zppmrp5~werks = zppmrp5_tmp1~werks
AND zppmrp5~pbdnr = zppmrp5_tmp1~pbdnr
AND zppmrp5~elevel = zppmrp5_tmp1~elevel
WHERE "zppmrp5_tmp1~elevel = 1 AND
zppmrp5_tmp1~elevel in r_elevel AND
zppmrp5_tmp1~matnr_1 IN so_mat1 AND
zppmrp5_tmp1~matnr_2 IN so_mat2 AND
zppmrp5_tmp1~matnr IN so_matnr AND
zppmrp5_tmp1~arbpl_1 IN so_arb1 AND
zppmrp5_tmp1~arbpl_2 IN so_arb2 AND
zppmrp5_tmp1~ZBESK IN so_ZBESK.
попробую поискать примеры динамической выборки еще, чтобы сравнить...
да и ошибка
Цитата:
The field "G_TABNAME" is unknown, but there is a field with the similar name "G_TABMANE" . . . .
как говорит один из популярных когда-то мемов "сложнааааааа"