Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo,
Store VBAP into D:\VBAP.qvd; // path 1 (want all werks)
Store VBAP into D:\test\VBAP.qvd; // path 2 where werks = '3000' (want only werks 3000)
we load the data from sap. we have 2 different path. in path 1 we load all data but in path 2 we want to load the data only for werks 3000. if i use where werks = '3000' ; than it load the data only for werks 3000 in both path but i want to have all werks in path 1.
what should i do ?
best regards
Kazi
May be Try like:
Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)
Drop Table VBAP;
VBAP:
LOAD *
FROM D:\VBAP.qvd(qvd)
WHERE werks = 3000;
Store VBAP into D:\test\VBAP.qvd(qvd);
Drop Table VBAP;
OR other way is as Mikael suggested using Resident Load like below
Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)
NOCONCATENATE
VBAPTest:
LOAD *
RESIDENT VBAP
WHERE werks = 3000;
Store VBAPTest into D:\test\VBAP.qvd(qvd);
Drop Table VBAP, VBAPTest;
create 2 different tables (with a resident load?) and store them in your 2 locations...
May be Try like:
Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)
Drop Table VBAP;
VBAP:
LOAD *
FROM D:\VBAP.qvd(qvd)
WHERE werks = 3000;
Store VBAP into D:\test\VBAP.qvd(qvd);
Drop Table VBAP;
OR other way is as Mikael suggested using Resident Load like below
Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)
NOCONCATENATE
VBAPTest:
LOAD *
RESIDENT VBAP
WHERE werks = 3000;
Store VBAPTest into D:\test\VBAP.qvd(qvd);
Drop Table VBAP, VBAPTest;
Maybe like
Store VBAP into D:\VBAP.qvd; // path 1 (want all werks)
INNER JOIN (VBAP)
LOAD 3000 as werks
autogenerate 1;
Store VBAP into D:\test\VBAP.qvd; // path 2 where werks = '3000' (want only werks 3000)