
et_data =
SELECT edid4seg.*, a.MANDT AS MANDT_S, a.DOCNUM AS DOCNUM_S, a.LOGDAT , a.LOGTIM , a.COUNTR , a.CREDAT AS CREDAT_S, a.CRETIM AS CRETIM_S,
a.STATUS as STATUS_S, a.UNAME , a.REPID , a.ROUTID , a.STACOD , a.STATXT , a.SEGNUM AS SEGNUM_S , a.SEGFLD ,
a.STAPA1 , a.STAPA2 , a.STAPA3 , a.STAPA4 , a.STATYP , a.STAMQU , a.STAMID , a.STAMNO ,
a.TID , a.APPL_LOG
FROM "EDIDS" AS a INNER JOIN (
SELECT loc_edidc.MANDT AS MANDT, loc_edidc.DOCNUM AS DOCNUM, COUNTER, SEGNUM , SEGNAM , PSGNUM , HLEVEL ,
DOCREL , STATUS , DOCTYP , DIRECT , RCVPOR ,
RCVPRT , RCVPRN , RCVSAD , RCVSMN , RCVSNA , RCVSCA , RCVSDF ,
RCVSLF , RCVLAD , STD , STDVRS , STDMES , MESCOD , MESFCT ,
OUTMOD , SNDPOR , SNDPRT , SNDPRN , SNDSAD , SNDSMN , SNDSNA ,
SNDSCA , SNDSDF , SNDSLF , SNDLAD , REFINT , REFGRP , REFMES , ARCKEY ,
CREDAT , CRETIM , MESTYP , IDOCTP , CIMTYP , RCVPFC , SNDPFC , SERIAL ,
EXPRSS , UPDDAT , UPDTIM , MAXSEGNUM, TEST, SDATA
FROM :lt_edid4 AS loc_edid4, :lt_edidc AS loc_edidc
WHERE loc_edid4.docnum = loc_edidc.docnum
AND loc_edid4.mandt = loc_edidc.mandt
AND loc_edidc.mandt = SESSION_CONTEXT('CLIENT') limit :i_lines )
AS edid4seg ON a.mandt = edid4seg.mandt AND a.docnum = edid4seg.docnum
WHERE countr = (SELECT MAX(countr) FROM "EDIDS" WHERE mandt = SESSION_CONTEXT('CLIENT') AND docnum = a.docnum)
ORDER BY a.docnum;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |