SALES UNIT MSR BY ITEMS

[vasileiosfasolis]

Hello experts

i have a question in Item Master Data..

by selecting the saled data tab, there is the sales unit measure field which is filled by somethink like box, meter ar whatever the users have defined

could you pelase tell me how can i find the id of each description?

by running the

select * from cuvv 

i can find the description many times with different indexid and linenum

could you pleqase help me on this way?

[Former Member · Accepted solution]

Hi,

You may try:

SELECT IndexID,LineNum from cuvv WHERE value=$[OITM.SalUnitMsr\]

Thanks,

Gordon

[Former Member]

Hi Fasolis.......

OLGT is for Length and Width UOM \

and OWGT for Weight UOM.......

Regards,

Rahul

[vasileiosfasolis]

Hi Rahul

thanks for your reply!

i didnt say it good..

i want to know which is the id of the value field from the cuvv table and which is the reason i can see some values more than one times by running the above query

[former_member541807]

hi,

OITM - Item Master Data

CUVV - User Validations

this tables are not related.

please check the SDK Documentation

you are asking about Item sales unit of measure but your query is referring to CUVV.

Regards,

Fidel

[vasileiosfasolis]

hi Avelino,

how can i find the id of the measurements?

[former_member541807]

hi Fasolis,

as stated above...

OLGT & OWGT

regards,

Fidel