Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

error with CURR and QUAN dataelements

anupam_srivastava2
Participant
0 Kudos

Hi All

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.

Please Guide

Regards

AJ

1 ACCEPTED SOLUTION

Former Member
0 Kudos

in SE11, if u create any QUAN or CURR fields --

currency/quantity fields tab will be there in se11

u need to give reference table and field of that particular field

Supose for BMENG we need to give VBAP - VRKME

Madhavi

3 REPLIES 3

Former Member
0 Kudos

in SE11, if u create any QUAN or CURR fields --

currency/quantity fields tab will be there in se11

u need to give reference table and field of that particular field

Supose for BMENG we need to give VBAP - VRKME

Madhavi

Former Member
0 Kudos

Hi,

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 customer’s 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.

Regards,

raymond_giuseppi
Active Contributor
0 Kudos

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).

Regards