Question: Why product `attribute` defined in `Product` itemtype not show in `products` table but `productslp` table ?

Answer: 
\*lp files for localization. Your attribute has localized option.
`PRODUCTSLP` is lang table for Product Item, If any localized attributes defines in item those data will be stored against LP table. This table creation and join will be done by hybris internally.

Note : you can find each attribute with prefix `p_` in respective table.
`name` will store in `p_name`