topic Re: Packed Integer in Application Development and Automation Discussions

Packed Integer

Former Member — Wed, 02 Nov 2005 10:11:53 GMT

Hi Everybody,

I want to know what is the date type at Dictionary level for Packed Integer.

I mean i am defining a field that stores amount value and it will have decimal values so what should be the data type for it in data dictionary.

Regards,

Aima

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 10:13:08 GMT

Hi,

Use data element WERTV8 (this can store +/-) OR use data element WERT8 if you dont want to store negative amounts

OR if you want your own field labels then you can use

domains WERTV8 or WERT8 and create your own data element using these..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 10:16:09 GMT

Hi aima,

Try the following

Data Type AMUNT

Domain: BETRG

Thanks,

Ravi

Re: Packed Integer

andreas_mann3 — Wed, 02 Nov 2005 10:16:29 GMT

Hi,

data type is CURR.

example : bseg-wrbtr with domain WERT7

regards Andreas

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 10:17:05 GMT

Hi,

You can use data type CURR for currency fields.

There are different data elements existing in ABAP for these. You should probably check out domains that start with CURR. For eg: CURR12 is 12 characters + 2 decimal places.

Regards,

Sudha

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 10:30:40 GMT

You can check out the data types at dictionary level in DD03L table.

specify Table name - VBAK , fieldname - Netwr

then you get the data types at dictionary level.

inttype - P

intlen - 8

Datatype - CURR

length - 15

decimals - 2

This may help you out.

Regards,

Sailaja.

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 10:59:41 GMT

Hi Sudha,

If i am defining Curr as my data type in my domain then it is asking me the Check Table ,so could any one say me the check table for the data type CURR.

Regards,

Aima.

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 11:09:31 GMT

Hi Aima,

When you assign a CURR type to any field, SAP expects that field to be linked with a currency type (USD, GBP,..). Any currency you enter in this field will take on the currency defined in the currency type. SAP maintains currencies in the table TCURC.

I suggest you create another field in the table, of data type CUKY, which will hold the currency type. The reference table and field for the CURR field will be this CUKY field, and the CUKY field will in turn refer to the TCURC table.

Hope this makes sense.

Sudha

Message was edited by: Sudha Mohan

Re: Packed Integer

andreas_mann3 — Wed, 02 Nov 2005 11:50:46 GMT

Hi,

if you have not a field from type cuky in your table,

just use bkpf-waers as reference field for currency amount

Andreas

Re: Packed Integer

Former Member — Wed, 02 Nov 2005 12:02:25 GMT

Note, be careful with SAP: to store an amount of 5 USD into a field with 2 decimals, you store it 5.00 (no problem), but if you store 5 ADP you must store it 0.05. It's the way SAP manages currencies. Table TCURX contains number of decimals by currency.