Skip to Content
Former Member
Oct 26, 2009 at 06:38 AM

Price column zero in hierarchy and expansion


Discount for some items was defined by a certain user by using hierarchy and expansion form in SAP. the valid period is defined, quantity too is defined for that period. but, suddenly the 'price' column from table SPP2 has zero values for all items. even for those items for which I was previously able to fetch proper discounted price by SQL query.

Strange thing is, it does show correct value in front end (price after discount column).

the original price is not changed for any item.

Is there any condition for which the 'price' column can have zero value? or this is database corruption? no special price for business partner is defined for any item. and if today I add new items for discount in hierarchy and expansion, it does carry non-zero value in database. what could have happen? anybody has any idea of how can I make those values non-zero(with discount in effect)?

Thanks in advance,