I am creating a custom database, with some fields with CURR and QUAN, but its gives error message--
with the curr and quan field, the msg says.. ....specify reference table and reference field.
Is it we can create a table with CURR and QUAN field.
it may help u.
You must specify a reference table for fields containing quantities (data type QUAN) or currency amounts (data type CURR).
This reference table must contain a field with the format for the currency key (data type CUKY) or unit of measure (data type UNIT). This field is called the reference field of the output field. The reference field can also reside in the table itself.
A field is only assigned to the reference field at program runtime. For example, if a field is filled with currency amounts, the corresponding currency is determined from the assigned reference field, that is the value entered in this field at the moment defines the currency.
Table SBOOK in the flight model contains all the flight bookings made by customers. Field FORCURAM contains the price of the booking in the customers currency. Field FORCURKEY of table SBOOK contains the corresponding currency key for this price. SBOOK is therefore the reference table for field FORCURAM and FORCURKEY is the reference field for field FORCURAM.
When defining QUAN and CURR fields in a table, you should go to the "Currency/quant. fioelds" tab to give the CUCY or UNIT field that is needed to handle formatting, conversion and sums.
The unit or currency can be in any table, usually on the table itself, on an header table or on a table used in foreign keys.
Look at [BC - ABAP Dictionary|http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf]
>Reference field and reference table [Page 15]: You must specify the table field in which the corresponding unit of measure or currency can be found for fields containing quantities (data type QUAN) or currency amounts (data type CURR).