topic Re: problems in creating a data base structure in Application Development and Automation Discussions

problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:34:25 GMT

Hi all,

I am creating a structure and one of the fields is cond_value with component type kbetr (konp-kbetr). When i am trying to activate it its showing an error like

Diagnosis

You must specify reference tables and reference fields for fields containing currency amounts or quantity data. You have specified either only the reference field or the reference table and have not maintained either entry.

Procedure

Add the missing entry. You can do this with the single field maintenance function of the table.

Could somebody please help me with this...

thanks,

kiran.

Re: problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:39:42 GMT

Hi Kiran,

You are trying to create a structure with currency fields. Please note that for Currency and Quantity fields you have to define reference fields.

Please define the following at reference field for Currency :

RV13A-KONWA

Regards,

Lanka

Re: problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:39:59 GMT

Hi Kiran,

When ever you are creating a amount field in your structure(in your case it is kbetr),you need to specify the currency key field also.create another field with component type <b>WAERS</b>.

Re: problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:40:42 GMT

Hi,

Give

reference table RV13A

and Ref. field KONWA

create one more field KONWA data element KONWA

This will solve the problem.

Regards,

GSR.

Re: problems in creating a data base structure

RichHeilman — Mon, 06 Mar 2006 16:40:56 GMT

In SE11, click the currency/quantites tab. Enter the reference table and field there.

Reference table: konp

reference field: KONWA

Regards,

Rich Heilman

Typo

Message was edited by: Rich Heilman

Re: problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:40:57 GMT

Answer Posted Twice.

Lanka

Message was edited by: Lanka Murthy

Re: problems in creating a data base structure

Former Member — Mon, 06 Mar 2006 16:44:05 GMT

Hi kiran,

In the 'currency/quantity fields' tab, enter the reference table 'RV13A' and field 'KONWA'.

This will solve your problem.

Regards,

Raj