Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Activation problem with Z table.

Former Member

‎2007 Sep 05 12:02 PM

0 Likes
1,140

I have created a Z table with 5 fileds out of that 1 field is "Currency Field". When i'm trying to activate its showing error and not getting activated. I heard that whenever currency field is there we can't activate with normally, for that we need to follow some other mechanism. can any one guide me what is that and how to solve that...

Regards

Vamsi.

I have created a Z table with 5 fileds out of that 1 field is "Currency Field". When i'm trying to activate its showing error and not getting activated. I heard that whenever currency field is there we can't activate with normally, for that we need to follow some other mechanism. can any one guide me what is that and how to solve that...

Regards

Vamsi.

Reply
7 REPLIES 7
Read only

Former Member

‎2007 Sep 05 12:06 PM

0 Likes
926

Hi,

You need to mention the Reference table and reference fields for the Currency field, then Activate the table, if it still giving the problem, then goto SE14 and give the table then Press Adjust and Activate button

Regards

Sudheer

Read only

Former Member

‎2007 Sep 05 12:07 PM

0 Likes
926

Hi,

If you are using any currency fields, you should give reference table name and reference field in Currency/Quantity fields tab.

For example in your case you give BSIS in reference table name and WAERS in reference field name. If it is a table make sure that there should be a primary key should be ticked. And then save and activate.

Thanks,

Sriram Ponna.

Message was edited by:

Sriram Ponna

Read only

Former Member

‎2007 Sep 05 12:08 PM

0 Likes
926

I think you dint assign any reference currency key for your currency field...

just check the tab Currency/ Quantity fields there in ref field give WAERS or any currency key field name and ref table give EKKO or any table name which contains that currency key field...

If after that also if you get problem go to SE14 and adjust the table.

regards

shiba dutta

Read only

Former Member

‎2007 Sep 05 12:09 PM

0 Likes
926

Hi Vamsi,

Yes. Whenever we have currency or quantity fields, we need to give reference table / field.

In the table definition, go to fourth tab names "Currency/Quantity fields". Here, you need to specify the Reference table & Reference fields.

FOr ex. for DMBTR you can give table: T001 & field:WAERS.

Reward helpful answers.

Regards,

Siddhesh sanghvi.

Read only

Former Member

‎2007 Sep 05 12:10 PM

0 Likes
926

Hi,

Provide a reference field for that currency field and try again.

What is the error message?

Regards,

Savitha

Read only

Former Member

‎2007 Sep 05 12:14 PM

0 Likes
926

hi,

when ever you are using curency field in a table then u should provide the reference table and field fot it. click on reference tab and give table name and reference field name ?( data element name] -> save -> activate.

if error comes again -> goto utilities-> database utility -> adjust and activate.

if helpful reward some points.

with regards,

Suresh Aluri.

Read only

Former Member

‎2007 Sep 05 12:28 PM

0 Likes
926

Hi vamsi,

Plz verify below things your problem got solved.

  • Provide reference field for QUAN, CURR fields

  • Make sure all your Domains, Data elements that you have used are in

ACTIVE position.

  • Make sure you have given the technical settings for your table.

  • Perform the syntax check, If it is giving warning messages plz ignore it

and activate the table.

  • I hope this will get your job done.

<i><b>Reward me points without fail...</b></i>

Regards

Sreenivasa K.