Hi Experts,
In the below query .... charg(batch) field value which has no value those rows are not fetched in the query.
How I can modify the query that it will also take those rows which charg (batch) field has no value.
Below I am attaching an image of db table
Query is working fine but since in some rows of Database table charg field has no values but has stock and matnr So I also need to fetch those rows.
SELECT
a~werks,
a~lgort,
a~matnr,
* a~ersda,
a~kalab,
a~kains,
a~kaspe,
a~sobkz,
a~vbeln,
a~posnr,
a~charg,
b~maktx,
c~meins,
c~mtart,
c~matkl,
d~licha,
concat( a~matnr, a~charg ) AS merge
FROM mska AS a
INNER JOIN mara AS c ON a~matnr = c~matnr
INNER JOIN makt AS b ON a~matnr = b~matnr
INNER JOIN mch1 AS d ON ( a~matnr = d~matnr AND a~charg = d~charg )
WHERE
a~lgort = @p_store AND a~werks = @p_plant AND
a~matnr IN @s_matnr AND
( a~charg IN @s_batch OR a~charg eq @space ) AND
a~vbeln IN @s_so AND
( a~kalab > 0 OR a~kains > 0 OR a~kaspe > 0 ) AND
c~mtart IN @range_table_material AND
c~matkl IN @s_matgrp AND
d~licha IN @v_batch
INTO TABLE @DATA(it_mska2).