topic Re: Problem Creating a Table in Application Development and Automation Discussions

Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:29:18 GMT

Hi Gurus,

I created a ztable with zdataelements.

I created quantity data element with two decimals and currency data elements.

while Activating table it is showing no reference tables and fields.

how to solve this problem.

Regards,

Shashikumar.G

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:31:36 GMT

may be the data element is not actuivated.chk that.

regards,

Prasant

Re: Problem Creating a Table

Manohar2u — Wed, 29 Aug 2007 10:33:16 GMT

Goto Currency/Quantity fields tab in SE11 and give reference table and ref. field values.

Refer to MSEG-DMBTR and MSEG-MENGE fields for currency and quantity fields.

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:39:02 GMT

Go to SE11 .

Enter table's name and press change.

Check the field which have data type as 'CURR'.

incase of data typ 'CURR' ,press tab 'Currency/Quantity Field'.

Reference table and Reference field is required.

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:39:17 GMT

Hi Manohar,

but my ztable zdata elements having different length and different decimal places.

Thanks and Regards.

Shashikumar.G

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:40:08 GMT

Hi,

You need to maintain the Referecne fields and the Reference tables. Goto Currency and Quantity Tab in SE11

For Quantity fields --> Tabel is MARA and field is GEWEI

For Currency fields --> table is T001and field is WAERS

Regards

Sudheer

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:40:56 GMT

when ever your trying to creat a currency field yo need to creat a reference field for that

refer this table VBAK

NETWR NETWR_AK CURR 15 2 Net Value of the Sales Order in Document Currency

WAERK WAERK CUKY 5 0 SD document currency

reward if usefull

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:41:22 GMT

Try using INT4 as Field Type having Error

reward all useful answers

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 10:43:36 GMT

hi shashi,

For Quantity & currency data type we must give reference fields.

U must select the tab called currency/quantity fields in the table

there in the place, where u have used quantity u must type TVTK in reference table,& DTMEG in Reference Fields.

there in the place, where u have used Currency u must type KONV in reference table,& WAERS in Reference Fields.

With Regards

Nigesh

If help full reward Points...

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 11:01:41 GMT

hi,

If you are creating ztable containing zfields .... then you have to specify referance field for those fields ....to specify those referance field just double click on that field name ....it will open its date element attributes...there u will find place to enter referance field and referance table.....so in first column enter tab name eg maseg & in second column enter waers....same in the case of Qty fields just enter mseg & waers.....if u still face same problem then delete those added qty & currancy fields ....and add them again one by one along with entering ref tab & field.

I hope this will solve your problem....

Deepak

Re: Problem Creating a Table

Former Member — Wed, 29 Aug 2007 11:15:38 GMT

Int4 should not allow decimal places.

Thanks and Regards,

Shashikumar.g