syntax error for reference table/field

[Former Member]

Hi all,

I am getting syntax error for the 'z' table Z3AFKO1 for the field VFMNG( it is a Quantity field) and having reference field VFMNG in the table AFKO.

The error is

'Z3AFKO1-VFMNG (combination reference table/field

AFKO-VFMNG does not exist').

can anyone tell me what is the solution for this?

thanks

-Rakesh

[Former Member · Accepted solution]

Hello Rakesh,

U have give like this.

Ref. Table Ref. table

AFKO GMEIN

If useful reward.

Vasanth

[Former Member]

Hi,

While specifying the reference field to a Currency/Quantity field, we have to check whether teh data type of the reference field is CUKY if it is a currency field and UNIT in case of a quantity field.

For the field VFMNG of Z table, specify the reference field of VFMNG of AFKO table.

Reference fields need not be in the same table, they can be from different table also.

Regards,

Sailaja.

[Former Member]

The reference is for currency and units. For quantity field you must supply a unit (unit of measure) field as reference.

Hope it helps.

Raj

Reward points if helpful

[Former Member]

Hi ,

You have to refer MEINS also from the same table.

Regards,

Raghav

[RichHeilman]

Please use GMEIN of AFKO for your reference field. Then this will work.

REgards,

RIch HEilman

[Former Member]

I assume you are referring to the reference field on the Currency/Quantity Fields tab. If so, look at the entry in AFKO for VFMNG. It is using AFKO/GMEIN. The reference field is a UoM reference for the qty.