Hi All,
Having a bit of trouble with an error message that keeps getting throw up when trying to filter data from two tables using WHERE NOT EXISTS.
I load the first table fine:
vbup:
LOAD VBELN&':'&POSNR as EXCSalesOrder,
LFSTA
where LFSTA = 'C'
;
SELECT VBELN,
POSNR,
LFSTA
FROM VBUP;
// STORE * FROM [VBUP] INTO [LIB://FolderConnection/VBUP.qvd];
// DROP TABLE [VBUP];
Then i go to load the second table which is where i have the WHERE NOT EXISTS:
[OOH]:
LOAD
VERKAUFORG as Plant,
REPORTJAHR as [Reporting Year],
REPMONAT as [Reporting Month],
VBELN&':'&POSNR as [Sales Order],
MATNR as [Material Number],
SOLDTO as [Customer ID],
SOLDTO_NAME as [Customer Name],
PSTLZ as [Customer Postcode],
MAKTX as [Material Description],
GEKLA as [Material Group],
BESKZ as [Proc Type],
PROFCTR as [Profit Center],
ZBSTR as [Business Stream],
NETWR as [Sales Value],
MENGE as Quanitity,
AUDAT as [Order date],
KDWT as [Customer required date],
WADAT as [GI Date],
ZUSA as [Promise Date]
where BESKZ = 'E' /
and
NOT EXISTS (EXCSalesOrder,VBELN&':'&POSNR)
;
SELECT VERKAUFORG,
REPORTJAHR,
REPMONAT,
VBELN,
POSNR,
MATNR,
SOLDTO,
SOLDTO_NAME,
PSTLZ,
MAKTX,
GEKLA,
BESKZ,
PROFCTR,
ZBSTR,
NETWR,
MENGE,
AUDAT,
KDWT,
WADAT,
ZUSA
FROM ZSOOH
;
// STORE * FROM [ZSOOH] INTO [LIB://FolderConnection/ZSOOH.qvd];
// DROP TABLE [ZSOOH];
DROP Table vbup
And i get this error message:
16:15:27
Script error: Qvx file read error on line 1, too many columns
16:15:27
Qvx file read error on line 1, too many columns: SELECT VERKAUFORG, REPORTJAHR, REPMONAT, VBELN, POSNR, MATNR, SOLDTO, SOLDTO_NAME, PSTLZ, MAKTX, GEKLA, BESKZ, PROFCTR, ZBSTR, NETWR, MENGE, AUDAT, KDWT, WADAT, ZUSA FROM ZSOOH
Not sure how why its saying i have too many columns, when i havent added or removed anything?
What i trying to achieve is to cross reference the first table which has a list of order that have been despatch to the second table which it a total list of orders, so i will only load 'Live' orders.
