Error Creating Z table.. Help Needed

[former_member340306]

Hi , We are facing the issue while Creating a Z COPA table. We have successfully inserted the fields , data elements and data types

But when we try to Activate the table it shows us an error and ask to refer to the logs.

Error --- Specify reference table and reference field

We did some research and found out that the reason for that might be our "CURR" data type fields and they need to have a table to reference to:

Problem is that we need to find a table that has a field with CURR Data type that is length 15 with 2 decimal points.

Kindly suggested what table might have it so we an use it as a reference,

Thanks in Advance.

Sheikh Hassan Ayub

<Downgraded the priority>

Edited by: Suhas Saha on Aug 20, 2011 9:01 AM

[Former Member]

Hi,

I think you can use the currency reference field you defined in the same Z COPA table.

Thanks,

Rugmani

[Clemenss]

Hi Sheik,

before creating the first table, you may take a basic training.

In SAP, all dictionary fields of any CURR (currency value) or QUAN (quantity) must have a referring currency key (CUKY) or UNIT field.

Double click on those fields and a popup opens where you can enter the reference table and field (looks like one field, but there are two adjacent input fields). Best way is to have the reference fields in the same table.

Regards

Clemens

[madhu_vadlamani]

Hi Hasan,

In standard table how currency and quantity fields were declared. Check in Bset and Vbap tables for example.Check in Currecny and quantities field tab .

Regards,

Madhu.

[former_member743357]

Hi,

If you are using CURR field in table you should create a field with domain with CUKY domain.

In the currency and quatity tab in table enter the refernce table as same table name and field name should be your CURR field name.

If you dont want to create a field of Domain CUKY datatype then you can use standard table for REF field as TCURC and standard field name.

Thanks and Regards

Abdul

[Former Member]

This has a really easy solution...simply find a table or structure with the data elements/domains you are using and copy the reference field entry from that table/structure to your customer version.

[raymond_giuseppi]

Look via SE11 at tables of the same type, I suggest COSS, COSP or such tables.

Then you can either add a currency code field to your table, or if you have a KOKRS or OBJNR field which identify KOKRS, you can use TKA01-WAERS (*). Also read some documentation like [Reference Fields and Reference Tables|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea5d446011d189700000e8322d00/frameset.htm]

Regards,

Raymond

(*) As I suppose you work with Controlling Area Currency and not Transaction Currency.