We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] Formula for calculating total lenght of wires for query using characteristics (AUSP)

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by Jotako
on May 24 at 2:05 PM
Hi Louis,
The infoset has no join with AUSP because unable to connect it with VBAP table.
I've tried to insert code in data processing but it doen't seem to work neither.
It seems in the formula KMP it just gets the first carchteristic (AUSP-ATFLV) it founds for the first material (VBAP-MATNR) it founds.
Have you any other suggestion maybe a Loop?
Thanks for your risponse

---------------Original Message---------------
From: Jotako
Sent: Tuesday, May 24, 2011 4:40 AM
Subject: Formula for calculating total lenght of wires for query using characteristics (AUSP)

Hi,
I premess that I'm not an abapist, and I would need same help for a formula for calculating the length of a cable.

To calculate the Length of couples (AUSP-ATFLV - feature 506 - number of wires inside the cable) of a cable you must multiply it by the quantity ordered (VBAP-KWMENG), I did the following:

data: float type f,
quan type p.
clear kmp.
Select single * into AUSP from AUSP where
OBJEK = VBAP-MATNR and ATINN = 0000000506.
float = AUSP-ATFLV.
quan = float.
KMP = quan * VBAP-KWMENG.

The result is giving me always zero, in debug i see for example passing values 224 (quan) and 50 (KWMENG).

The problem in my opinion are the types of fields, I have defined KMP as KWMENG (length), but atflv is a floating number, so I converted it to numeric.

Do I have to define KMP as another kind of field for making it work? or quan?
What am I doing wrong in your opinion?
Thank you very much, I've searched for answers but can't solve my problem.

Regards from Italy,
Giuseppe

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language