topic operation in Application Development and Automation Discussions

operation

Former Member — Fri, 14 Sep 2007 10:56:53 GMT

I want divide the field KONV-KAWRT BY EXPO-MENGE AND MULTIPLY BY MSEG-MENGE.

RaymondGiuseppi — Fri, 14 Sep 2007 10:59:26 GMT

The result is ( KONV-KAWRT / EKPO-MENGE ) * MSEG-MENGE.

Or could you elaborate any more like "i read material document related to purchase receipt...." if you want the links between tables.

Regards

PS: Please close other post(s)

Former Member — Fri, 14 Sep 2007 11:01:37 GMT

( KONV-KAWRT / EKPO-MENGE ) * MSEG-MENGE.

There is no such table called EXPO, however there is a table named EKPO.

Please be clear with your requirement.

Regards,

Pavan

Former Member — Fri, 14 Sep 2007 11:22:01 GMT

hi,

try this,

tables : konv,

mseg.

data : var type num.

var = ( KONV-KAWRT / mseg-MENGE ) * MSEG-MENGE.

Message was edited by:

Alvaro Tejada Galindo

RaymondGiuseppi — Fri, 14 Sep 2007 11:27:03 GMT

If you want the link between tables

MSEG linked to EKPO and EKKO (needed) via MSEG-EBELN, MSEG-EBELP
EKPO and EKKO linked to KONV via EKKO-KNUMV and EKPO-KPOSN

Also, be aware that KONV is a cluster table.

Regards

Former Member — Sat, 15 Sep 2007 10:19:13 GMT

hi,

Its better to declare var as type p decimals n.

Since it can hold both integers and whole numbers.