Скорее всего в одном запросе не получится.
Надо будет делать двумя.
Code:
SELECT
zp~matnr
zp~kadky
zp~werks
zp~hwaer
zp~poper
zp~kalnr
zs~elemt
zm~maktx
zk~txele
FROM keko AS zp
INNER JOIN tckh3 AS zs ON zs~elehk = zp~elehk
INNER JOIN tckh1 AS zk ON zk~elemt = zs~elemt
INNER JOIN makt AS zm ON zm~matnr = zp~matnr
INTO CORRESPONDING FIELDS OF TABLE it_out_max
WHERE
zp~werks = pa_werks
AND
zp~matnr IN pa_matnr
AND
zp~kadky = ( SELECT MAX( kadky ) FROM keko AS zp_1
INNER JOIN tckh3 AS zs_1 ON zs_1~elehk = zp_1~elehk
INNER JOIN tckh1 AS zk_1 ON zk_1~elemt = zs_1~elemt
INNER JOIN makt AS zm_1 ON zm_1~matnr = zp_1~matnr
WHERE zp_1~werks = zp~werks
AND zp_1~matnr = zp~matnr
AND zp_1~kadky <= pa_per ).
И
Code:
SELECT
zp~matnr
zp~kadky
zp~werks
zp~hwaer
zp~poper
zp~kalnr
zs~elemt
zm~maktx
zk~txele
FROM keko AS zp
INNER JOIN tckh3 AS zs ON zs~elehk = zp~elehk
INNER JOIN tckh1 AS zk ON zk~elemt = zs~elemt
INNER JOIN makt AS zm ON zm~matnr = zp~matnr
INTO CORRESPONDING FIELDS OF TABLE it_out_min
WHERE
zp~werks = pa_werks
AND
zp~matnr IN pa_matnr
AND
zp~kadky = ( SELECT MIN( kadky ) FROM keko AS zp_1
INNER JOIN tckh3 AS zs_1 ON zs_1~elehk = zp_1~elehk
INNER JOIN tckh1 AS zk_1 ON zk_1~elemt = zs_1~elemt
INNER JOIN makt AS zm_1 ON zm_1~matnr = zp_1~matnr
WHERE zp_1~werks = zp~werks
AND zp_1~matnr = zp~matnr
AND zp_1~kadky > pa_per ).
Сначала ищем в it_out_max, затем it_out_min. В случае нахождения в обоих таблицах интересующей записи, определять кто же всё таки ближе.
Но надеюсь я ошибаюсь и всё гораздо проще
Вход
Регистрация
FAQ пользователя
Поиск
