Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I am having the following code
I am Extracting data from SAP .
Custom read Failed Error
V_OBJID:
LOAD Distinct
Concat(DISTINCT Chr(39) & OBJECTID & Chr(39), ',') as V_OBJECTID
FROM
(qvd) where match(OBJECTCLAS ,'MATERIAL','MATERIAL_H','MATERIAL_N','MAT_FULL');
LET VMATNR = peek('V_OBJECTID',0,'V_OBJID');
MARD_NEW:
SQL SELECT MATNR FROM MBEW WHERE MATNR IN ($(VMATNR));
Note :-
for example
the variable VMATNR contains '20FTHEAVYDUTY','20FTIMCO-HAZ','20FTMAFI','20FTOPENTOPIG','20FTOPENTOPOOG','20FTREEFER'
Can anyone help me in this .
Thanks in advance
Concat() must need Group By