Price column zero in hierarchy and expansion

[Former Member]

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,

Binita

[Former Member · Accepted solution]

In this case, you may only find a value being calculated phenomena. That would rarely happen but there are slim chances. Nothing need to be worried about. The 0 value is not a true result anyway.

[Former Member]

Binita,

I am afraid some of your user may wrongly execute DELETE function under Update Special Price Globally. The reason you could see Price after Discount might be from the documents that already copied before this action.

You may have to find out the backup and restore your db.

Thanks,

Gordon

[Former Member]

Thank you for replying Gordon. User thankfully does not know the special prices global update feature. and even if someone changed it, it must show zero value in front end also. the case is, special prices do have valid non-zero values in front end, whereas when i see in spp2 table, or when I use DI API object to fetch special price, it shows 0.00 which is something I don't understand.

[Former Member]

Have you checked SPP1 and OSPP in the same time?

[Former Member]

Yup. OSPP and SPP1 do have matching non-zero price values. only when i see in spp2, the price column is zero. one more thing is, when I again update the quantity or discount in 'define hierarchy for price list' , the new price in spp2 table (which was zero earlier) changes correctly.