Limiting SAP table loads

[bmalkows]

I am just starting to understand the load script syntax for bringing in data to Qlik Sense Desktop from SAP.

In this case, I would like to limit the Material Group selections (MATKL) to 30080600, and this part works.

Next, I load from MAKT (Material Description), but I only want load material descriptions for the material group of 30080600 - not the entire data set.

Here is what I have - appreciate any assistance:

[MARA]:
LOAD MATNR as ProdKey,
MSTAE as LifeCycle,
MATKL as MaterialGroup where MATKL = '30080600';

SELECT MATNR,
MATKL,
MSTAE

FROM MARA;
// STORE * FROM [MARA] INTO [LIB://FolderConnection/MARA.qvd];
// DROP TABLE [MARA];

[MAKT]:
LOAD MATNR as ProdKey,
MAKTX as MatlDesc;

SELECT MATNR,
MAKTX

FROM MAKT;
// STORE * FROM [MAKT] INTO [LIB://FolderConnection/MAKT.qvd];
// DROP TABLE [MAKT];

[bmalkows · Accepted solution]

I did some digging and found the left join to work - although the syntax took some time to figure out:

[MARA]:
LOAD MATNR as ProdKey,
MSTAE as LifeCycle,
MATKL as MaterialGroup where MATKL = '30080600';

SELECT MATNR,
MSTAE,
MATKL

FROM MARA;
// STORE * FROM [MARA] INTO [LIB://FolderConnection/MARA.qvd];
// DROP TABLE [MARA];

// // NoConcatenate
[MAKT]:
LOAD MATNR as ProdKey,
// MANDT as MandtKey,
MAKTX as MatlDesc;

SELECT MATNR,
// MANDT,
MAKTX

FROM MAKT;
// STORE * FROM [MAKT] INTO [LIB://FolderConnection/MAKT.qvd];
// DROP TABLE [MAKT];

// join descriptions
Left join (MARA)
Load * Resident MAKT;
Drop table MAKT;