Hello everybody,
i try to get some information from my oracle database. I use the SQL code which is attached to get the informatio. Unfortunately, i always get this failure: Oracle database error 923: ORA-00923: FROM keyword not found where expected.
I have no idea what there is missing. Could anyone help me out in this issue? I really dont know where the failure is.... I printed all out but i didnt find it...
It would be awesome! Thank you in advance.
Best regards
Nicole
SELECT mkpf.budat, mkpf.FRBNR, mseg.CPUDT_MKPF, mkpf.mblnr, mkpf.SPE_BUDAT_UHR AS CPUTM_MKPF, mkpf.mjahr as kopfjahr, mkpf.cputm, mseg.matnr, mseg.mjahr as segjahr, mseg.zeile, mseg.mblnr,
mseg.bwart, mseg.werks, mseg.erfmg, mseg.dmbtr, mseg.lgort
ltap.wdatu ,ltap.qdatu, ltap.qzeit, ltap.VLPLA, ltap.NLPLA, ltap.VLTYP, ltap.NLTYP, ltap.VSOLA, ltap.NSOLA, ltap.werks, ltap.wenum, ltap.wepos, ltak.BDATU, ltak.BZEIT, ltap.TANUM, ltak.tanum, ltak.lgnum, ltak.mblnr
FROM (SELECT LOGSYS, MJAHR, MBLNR, FRBNR, BUDAT, CPUTM, SPE_BUDAT_UHR FROM S_TEC_LOGISTICS.V_MKPF
WHERE LOGSYS='SAPP81011' AND MJAHR='2017' AND FRBNR != ' ' AND BUDAT > 20170801) mkpf
INNER JOIN
(SELECT LOGSYS, WERKS, MATNR, MJAHR,
MBLNR, ZEILE ,BWART,
WERKS AS WERK, ERFMG, DMBTR, LGORT FROM S_TEC_LOGISTICS.V_MSEG
WHERE LOGSYS= 'SAPP81011' AND MJAHR = '2017' AND WERKS = '9820'
AND LGORT = '9810' AND CPUDT_MKPF >= 20170801 AND BWART = '101') mseg
ON mkpf.MBLNR = mseg.MBLNR AND mkpf.MJAHR = mseg.MJAHR
INNER JOIN (SELECT LOGSYS, WERKS, QDATU, QZEIT, VLPLA, NLPLA, VLTYP, NLTYP, VSOLA, NSOLA, WENUM, WEPOS, LGNUM, TANUM FROM S_TEC_LOGISTICS.V_LTAP
WHERE LOGSYS = 'SAPP81011' AND WERKS = '9820' AND QDATU >= 20170801 AND LGNUM = '98G' AND VLTYP in ('902','423') AND NLTYP in ('423','424','421')) ltap
ON mseg.MBLNR = ltap.WENUM AND mseg.ZEILE = ltap.WEPOS
INNER JOIN (SELECT LOGSYS, TANUM, LGNUM, MBLNR, BDATU, BZEIT FROM S_TEC_LOGISTICS.V_LTAK WHERE LOGSYS = 'SAPP81011' AND LGNUM = '98G' AND SUBSTR(QDATU,1,4) = '2017') ltak
ON mkpf.LOGSYS = ltak.LOGSYS AND ltap.TANUM = ltak.TANUM AND ltap.LGNUM = ltak.LGNUM