topic Re: ZTABLE in Application Development and Automation Discussions

ZTABLE

Former Member — Wed, 10 Oct 2007 09:50:04 GMT

Hello All

I couldn't activate my ZTable because of the Error

ZTable (specify reference table AND reference field) for all those fields that contain QUAN as data type.

Thanks & Regards

Re: ZTABLE

Former Member — Wed, 10 Oct 2007 09:52:29 GMT

in se11 go to Currency/Quantity Fields tab...

there mention reference table and reference fields... same as that of the standard field which has same data element as your field.....

Re: ZTABLE

Former Member — Wed, 10 Oct 2007 09:52:52 GMT

You need to specify reference table & field....

The reference field is used for the output, the output/input format of a currency field depends on the value of its reference field.

For example if you create a screen using the field KONV-KBETR :

the reference field is RV61A-AWEI1:

if you set RV61A-AWEI1 = 3

the value in KONV-KBETR is beeing shown with 3 decimals

So you could see 3,000 but this value is automatically stored as 30.00

if you set RV61A-AWEI1 = 2

the value in KONV-KBETR is beeing shown with 2 decimals

All this convertions are automatically made in according to the value setted in reference field.

You can see this using the statament WRITE with options CURRENCY, try this:

PARAMETERS P_KBETR LIKE KONV-KBETR.

WRITE: P_KBETR CURRENCY '3'.

WRITE: / P_KBETR CURRENCY '2'.

WRITE: / P_KBETR CURRENCY '1'.

Based on the Currency field that we specify there, the input/output formatting(What character is to be used for thousands separator and decimals separator etc) would be decided for that amount field.

edit your table and select the Currency/Quantity tab. Here, you must enter the respective reference fields and tables for your new fields.

All quantity fields must have a referenced unit field in the same table or in another one. The same thing about currency ones.

Go to the "Currency/quant" tab and put those corresponding fields. I will advice you to add the units/coin fields to the same table, and fill them.

If you want to save some space, just add those unit/coin fields to the header table and use the appropiate reference in the pointed tab

Regards

vasu

Re: ZTABLE

Former Member — Wed, 10 Oct 2007 09:53:19 GMT

hi,

in se11 goto tab currency\quantity field and there give the reference field name and reference table name for currency fields and quantity fields in ur ZTable.

thanks,

Re: ZTABLE

Former Member — Wed, 10 Oct 2007 09:53:26 GMT

Hi,

You have to maintain the technical settings.

Then in Currency/Quantity field you shold give the Ref.Table & Ref.field.

Thanks.

Re: ZTABLE

Former Member — Wed, 10 Oct 2007 09:53:29 GMT

While declaring QUAN fields use reference like specifying data element as NTGEW..etc.

Check MARA table QUAN fields for example.

For giving F4 help and entering only valid values.. the system restricts these fields.