06-18-2010 11:01 AM
Hi,
how can i get Cumulative quantity which is the field of TCode: VA43 (Contract order) as Order Quantity.
I saw the table VBAP and its field KWMENG but it has '0' Value.
from where i can get the value of Order Quantity
is there any table or function Module to get its answer
pleaze tell me
Thak You,
Jahnavee
06-18-2010 11:10 AM
06-18-2010 11:20 AM
Hi,
Check VBAP - ZMENG .
You can use in this way,:
IF vbap-kwmeng IS NOT INITIAL.
itab-kwmeng = vbap-kwmeng.
Move zmeng
ELSE.
itab-kwmeng = vbap-zmeng.
ENDIF.
Thanks!
06-18-2010 11:40 AM
VBAP-ZMENG is my target quantity
I have to formulate (VBAP-ZMENG) - (VBAP-KWMENG).
means Target Qty - Order Qty = Pending Qty
06-18-2010 11:45 AM
Hi,
Get the order quantity from document flow(VBFA).
Select rfmng from vbfa
where vbelv = <contract no>
and posnv = <contract line item>
and vbtyp_n = 'C'
and vbtyp_v = 'G'.
Deduct total of vbfa-rfmng from vbap-zmeng to get pending quantity.
Regards
Vinod
06-18-2010 11:49 AM
Hi,
I would rather say get the req clear from your functional counter part ,
So that instead of finding it by yourself.You would be in a better state to know what they actually want when KWMENG is 0.
Thanks!
06-18-2010 12:20 PM
In VBFA rmeng becomes '0'.
My functional person show me the document in VA43
where Target Qty is 200 & Order Qty is 101.700
but the value of Order Qty is not reflecting in the table VBAP or VBFA
Jahnavee
06-18-2010 12:23 PM
Do one thing,Check the F1 help by keeping cursor on the field where he showed you the values and go for technical settings .
You will get the table and field name( if any ).
Thanks!
06-18-2010 12:27 PM
I already saw the technical settings it has structure name RV45A and field name KWMENG.
Jahnavee
06-18-2010 12:30 PM
Hi,
Check whether the schedule line details are available for the contract line item (VBEP).
See the documentation for the field KWMENG.
If there is more than one schedule line for the item, the total order quantity
is taken from the rounded quantity of the total of all the schedule lines.
If no rounding is carried out, then the order required quantity corresponds to
a schedule line of the rounded quantity.
Regards
Vinod
06-18-2010 12:37 PM