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.
deployment element used for item type save table name on db. localized value in type attribute meaning of this attribute need localization by language. So hybris create another table with suffix lp automatically.