on 04-24-2017 12:41 PM
Hello Everyone,
I have stored procedure in which I need to pass two parameters as below:
a.) IPMATERIAL(Material No) as single value
b.) IPBATCH(Batch) as multiple value
Suppose user will enter Material = 100 and batch = B1 , B2 and B3, So I have concatenate MATNR with each BATCH say 100 B1 , 100 B2 and 100 B3 and these concatenated values in my select query..
Existing Code: This is working for single value for material and batch
MSEG_TT = SELECT :IPBATCH||:IPMATERIAL AS "REC_BATCH" FROM DUMMY;
MSEG_TT1 = SELECT DISTINCT A.REC_BATCH FROM (SELECT DISTINCT REC_BATCH FROM :MSEG_TT WHERE SUBSTR(REC_BATCH,0,10) = '1000000000') AS A INNER JOIN "_SYS_BIC"."kgm.global_attributes.material/CA_DIM_MATERIAL_GRA_001" AS B ON SUBSTR(A.REC_BATCH,11,18) = B.MATERIAL WHERE B.MATL_TYPE NOT IN ('ZFRT', 'HALB');
Now in above code I need to pass concatenated single MATNR and multiple BATCHES in above query instead of single batch like 100 B1 , 100 B2 and 100 B3.
Can someone give me the right direction how to achieve this?
Br
sd
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.