Reference Table

[Former Member]

Hi,

I am creating a purchase header and item table(With same fields as in the standard table) in SE11. But when iam creating the Purchase item, it is giving error that

ZPURI-MENGE (specify reference table AND reference field)

ZPURI-NETPR (specify reference table AND reference field)

ZPURI-NETWR (specify reference table AND reference field)

Table ZPURI must be created in the database

Check on table ZPURI resulted in errors.

Why Iam getting the error when iam creating the purchase item table only?

[VXLozano · Accepted solution]

(edition: I hate this forum has no "ENQUEUE_THREAD" options... it will save us a lot of time preventing "double-posting" like this one :P)

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

Message was edited by:

Vicenç Lozano

[ninad18 · Accepted solution]

not understand ur answer

[FredericGirod · Accepted solution]

Alex D in SE11, for quantity and amount field, you have to go in another tab to specify what is the reference of the quantity or amount.

an amount should refered to a currency field

a quantity should refered to a unit of quantity field

[former_member208856]

Hi,

your table is Z table, you have to give the reference table and reference field at the Tab : currency / quantity fields of your table ZPURI

field ref. table ref. field

give for Menge : EKPO MEINS

Netpr : EKKO WAERS

Netwr : EKKO WAERS

at the tab currency / quantity fields of your table and activate it before making any entry.

Reward points, if helpful,

Sandeep Kaushik

[Former Member]

Hi Ram,

Its a must to give the Refrence field and Table names for the All currency and Quantity fields in the tables

Use VBAK-WAERS field field for Currency and EKPO-MEINS like field for the Qty fields

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

HI,

IF you use the currency fields you have to specify the reference table name.

In SE11 under currency/Qty tab you have to derfine reference table name.

Thanks,

CSR.

****Reward if helpful.

[Former Member]

Hi ram,

1. Since menge, netpr , netwr are quantity/currency fields,

they need the UNIT field also.

2. ie, if u observe, there must be one more field

MEINS or WAERS

for which some REFERENCE has to be given

in se11,

<b>in the 5th TAB</b> (Currency Quantity Fields)

3. For each such field,

u will see the table name and field name.

4. Just give that and it will be ok.

regards,

amit m.

[JayR]

Hi Ram,

You have to give UOM for the Qty & Currency field. Check out mbew for ref. Before the Currency field, UOM will be given in the Reference.

Jai

[Former Member]

Hi,

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

Regards,

Alexandros.