Problem Creating a Table

[Former Member]

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

[Former Member]

hi

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

regards,

Prasant

[Manohar2u]

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.

[Former Member]

Hi Manohar,

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

Thanks and Regards.

Shashikumar.G

[Former Member]

Try using INT4 as Field Type having Error

<b>reward all useful answers </b>

[Former Member]

Int4 should not allow decimal places.

Thanks and Regards,

Shashikumar.g

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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

like

refer this table VBAK

<b>NETWR</b> NETWR_AK CURR 15 2 Net Value of the Sales Order in Document Currency

<b>WAERK</b> WAERK CUKY 5 0 SD document currency

reward if usefull

[Former Member]

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...

[Former Member]

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