Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

keyfigure datatypes

Hi guys,

I am creating some keyfigures.I found different types of keyfigures and also different datatypes for keyfigures.I have doubts about following things.It would be great if anybody can explain these things.

1.whats the difference between DEC and FLTP data types?

2.whats the difference between Amount and Number keyfigure types?when do we use amount and when do we use number as I have seen in our BW they used Amount some times and Number sometimes?

3.Whats the difference between Quantity and Number keyfigure types?When do we use Quantity and when do we use Number keyfigure types?

4.When do we use INTEGER as keyfigure type when compared to Number?

Thanks alot.

Tags:
Former Member
Former Member replied

Hi,

1: DEC: Counter or amount field with decimal point, sign, and commas separating thousands. A DEC field has a maximum length of 31 places.

FLTP: Floating point number. The length (including decimal places) is set to 16 places for this data type.

2: Amount KF always has Currency associated with it while Number doesn't. When you need to store KF's like balance you would use Amount and if you need to store say count use Number.

3:Similarly Qty Kf always has Unit associated with it. When you need to store Qty field like KG, LB you will use Qty KF.

4:Integer is used when you need to store values as whole number.

Hope this explains. Please don't forget to assign points if you find it useful/ answers your question.

MM.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question