topic Re: error creating table in Application Development and Automation Discussions

error creating table

Former Member — Thu, 21 May 2009 15:06:12 GMT

Hello,

I am creating a table with the field vsolm and field type is ltap-vsolm but getting an error "specify reference table and reference field."

plz advise..

thanks

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on May 21, 2009 11:29 AM

Re: error creating table

former_member194669 — Thu, 21 May 2009 15:12:44 GMT

In "Currency/Quantity Fields" tab against the field VSOLM give LTAP and MEINS and activate

a®

Re: error creating table

Former Member — Thu, 21 May 2009 15:15:17 GMT

hi there,

I did the same and its not working

Re: error creating table

former_member194669 — Thu, 21 May 2009 15:17:08 GMT

is VSOLM is the only field with type QUAN ? Is any other field that of CURR or QUAN ?

a®

Re: error creating table

Former Member — Thu, 21 May 2009 15:18:47 GMT

thats the only field

Re: error creating table

former_member194669 — Thu, 21 May 2009 15:19:25 GMT

And also try create a MEINS field and give that field as reference field in VSOLM field giving your table name as reference table and reference field as MEINS

a®

Re: error creating table

Former Member — Thu, 21 May 2009 15:20:18 GMT

Hi,

It is LTAP_VSOLM not LTAP-VSOLM. You giving the hyphen it is underscore.

Re: error creating table

Former Member — Thu, 21 May 2009 15:21:45 GMT

but meins is unit of measure and vsolm is quantity field

Re: error creating table

Former Member — Thu, 21 May 2009 15:22:21 GMT

it is ltap_vsolm

Re: error creating table

former_member194669 — Thu, 21 May 2009 15:23:58 GMT

Please check the LTAP table and field VSOLM

a®

Re: error creating table

Former Member — Thu, 21 May 2009 15:24:26 GMT

Hi,

For every Quan and Curr fields you need to provide the refference field and refference table name

QUAN - ref type is UNIT

CURR - ref type is CUKY

Re: error creating table

Former Member — Thu, 21 May 2009 15:33:24 GMT

I am creating a new table in that ,used field VSOLM and referenced it by LTAP_VSOLM and rest is history

Re: error creating table

Former Member — Thu, 21 May 2009 18:59:15 GMT

Click the reference tab and check all the reference fld you gave the information.

Give the appropriate Curr and Quantity reference fld name. then this error will rectified.

Re: error creating table

Former Member — Fri, 22 May 2009 07:40:06 GMT

thanks for all your replies..if i take off the field vsolm the table is fine if vsolm is added im getting this error ? any help?

Re: error creating table

Former Member — Fri, 22 May 2009 07:47:33 GMT

I have created new fieldtype with char and its working fine..No clue why its not working for quantity data type.anywayz my problem is solved for now

Re: error creating table

Former Member — Fri, 22 May 2009 10:09:31 GMT

character data type will work fine. Currency and Quantity fields refereence fileds have to be maintained.

Re: error creating table

jayanthi_jayaraman — Fri, 22 May 2009 10:20:50 GMT

Hi,

As already suggested, currency/Quantity fields needs reference.

Maintain the follg. field values in the table.

Field VSOLM

Data element LTAP_VSOLM

Ref.table LTAP (To view it, needs to click Currency/Quantity fields button)

Ref. Field MEINS(To view it, needs to click Currency/Quantity fields button)