Skip to Content
0
Former Member
Apr 12, 2012 at 07:00 AM

Variation between number of price lists and number of price lists for items

25 Views

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..