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

Answer: 
`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`
example:p\_name, p\_description . In cores-item.xml file: 

```
 <itemtype code="Product"
              extends="GenericItem"
              jaloclass="de.hybris.platform.jalo.product.Product"
              autocreate="true"
              generate="true">
        <deployment table="Products" typecode="1" propertytable="ProductProps"/>
        <attributes>
            <attribute autocreate="true" qualifier="code" type="java.lang.String" generate="true">
                <persistence type="property"/>
                <modifiers read="true" write="true" search="true" initial="true" optional="false" unique="true"/>
                <custom-properties>
                    <property name="hmcIndexField">
                        <value>"thefield"</value>
                    </property>
                </custom-properties>
            </attribute>
            <attribute autocreate="true" qualifier="name" type="localized:java.lang.String">
                <modifiers read="true" write="true" search="true" optional="true"/>
                <persistence type="property"/>
                <custom-properties>
                    <property name="hmcIndexField">
                        <value>"thefield"</value>
                    </property>
                </custom-properties>
            </attribute>
            <attribute autocreate="true" qualifier="unit" type="Unit" generate="true">
                <persistence type="property"/>
                <modifiers read="true" write="true" search="true" optional="true"/>
            </attribute>
            <attribute autocreate="true" qualifier="description" type="localized:java.lang.String">
                <modifiers read="true" write="true" search="true" optional="true"/>
                <persistence type="property">
                    <columntype database="oracle">
                        <value>CLOB</value>
                    </columntype>
                    <columntype database="sap">
                        <value>NCLOB</value>
                    </columntype>
                    <columntype>
                        <value>HYBRIS.LONG_STRING</value>
                    </columntype>
                </persistence>
                <custom-properties>
                    <property name="hmcIndexField">
                        <value>"thefield"</value>
                    </property>
                </custom-properties>
            </attribute>
            <attribute autocreate="true" qualifier="thumbnail" type="Media">
                <persistence type="property"/>
                <modifiers read="true" write="true" search="true" optional="true"/>
            </attribute>
            <attribute autocreate="true" qualifier="picture" type="Media">
                <persistence type="property"/>
                <modifiers read="true" write="true" search="true" optional="true"/>
            </attribute>
        </attributes>
        <indexes>
            <index name="Product_Code">
                <key attribute="code"/>
            </index>
        </indexes>
    </itemtype>

```

I see attributes defined obove.but not see it in table products. note:

```
<deployment table="Products"...>

```

What is meaning?