Hello I have problem to add new Item in master Data, i run the following Query
Select * FROM ITM1 T0
Left JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
Where T1.ItemCode is NULL
And T0.Itemcode not in (Select itemcode from OINM)
the result shows as follows
Item Code Price list & many more field
CGNSK010 1
CGNSK010 2
CGNSK010 3
CGNSK010 4
CGNSK010 5
CGNSK010 6
CGNSK010 7
CGNSK010 8
CGNSK010 9
CGNSK010 10
But the Item "CGNSK010" is allready remove from the master Data.
So what i do to add new Item
please give me urgent help..