topic Re: Sql query to converting sap abap in Application Development and Automation Discussions

Sql query to converting sap abap

Former Member — Fri, 20 Dec 2019 10:33:39 GMT

select T1.AUART ,T1.f1 , OBJECT, NRRANGENR, FROMNUMBER, TONUMBER , NRLEVEL , bezei from NRIV

inner join

(SELECT tvak.AUART ,NUMKI,'TVAK' as f1, Tvakt.bezei FROM TVAK inner join tvakt on tvakt.auart = tvak.auart and tvakt.spras='E'

union select tvfk.fkart, numki, 'TVFK' as f1, tvfkt.vtext from tvfk inner join tvfkt on tvfkt.fkart = tvfk.fkart and tvfkt.spras='E'

union select tvlk.lfart, numki , 'TVLK' as f1 , tvlkt.vtext from tvlk inner join tvlkt on tvlkt.lfart = tvlk.lfart and tvlkt.spras='E' ) as T1 on T1.numki = NRRANGENR

where OBJECT = 'RV_BELEG' and AUART in ('ZODS','ZSRV','ZPBB','ZCOR','ZCSR',

'ZCR','ZRNT','RE','L2','ZODS','RE','S1','F2','L2','G2','S2','F5','F8',

'ZODS','LF','LR') and nrlevel <> '00000000000000000000'

how use this sql query

Re: Sql query to converting sap abap

former_member1716 — Fri, 20 Dec 2019 14:52:05 GMT

tarunp241,

It would be better if you can tell us what you tried so that we can help you out.

Regards

Re: Sql query to converting sap abap

Sandra_Rossi — Fri, 20 Dec 2019 16:01:23 GMT

1) It's approximately the same thing in ABAP SQL by using WITH (ABAP >= 7.51). What issue do you have?

2) Important: what ABAP release do you use?

Re: Sql query to converting sap abap

Former Member — Sat, 21 Dec 2019 05:00:53 GMT

ABAP 7.6 I Have Create One like Show Upper In Our Program With Sub Query , Union And Inner Join In SE38 In Just One Query.

Re: Sql query to converting sap abap

Sandra_Rossi — Sat, 21 Dec 2019 10:16:56 GMT

It's approximately the same thing in ABAP SQL by using WITH (ABAP >= 7.51).

Example with WITH and UNION:

    WITH +texts AS (
        SELECT trkor, langu
              FROM e07t
              WHERE langu = @language
        UNION
        SELECT trkorr, MIN( langu )
              FROM e07t
              WHERE NOT EXISTS ( 
                    SELECT * FROM e07t AS b 
                    WHERE trkorr = e07t~trkorr and langu = @language )
                     GROUP BY trkorr )
    SELECT e070~trkorr, e070~as4date, e07t~as4text
          FROM e070
            INNER JOIN e07t
              ON e07t~trkorr = e070~trkorr
            INNER JOIN +texts
              ON e07t~trkorr = +texts~trkorr
              AND e07t~langu = +texts~langu
          WHERE e070~trkorr NOT LIKE 'SAP%'
            AND e070~strkorr = ''
    INTO TABLE @requests.