cancel
Showing results for 
Search instead for 
Did you mean: 

Expected Order Value in Qt

Former Member
0 Kudos

Hello Sap people ..

Need some input here ...

Does anyone know where this field EWERT ( Expected Ord.val ) pulling from.

It is found in the Item overview of the Quotation but always shows 0 in my Qt .

Where is the value pulled from and can I use it as an open field to key in my own expected value ...

It also does not seem like a normal sales field in VBAK - any comments ?

Thanks

Moon

Accepted Solutions (0)

Answers (3)

Answers (3)

Shiva_Ram
Active Contributor

It looks the system pulls the data from the sales document type definition. Go to t.code VOV8, select the quotation document type and inside details you can find the field probability. This will gets copied to quotation header and in the quotation item level, it looks, you can change the value for each line item.

Regards,

Former Member
0 Kudos

Hi

Thanks .... Is this value captured in any table at all ? How am I to pull this value in a report ?

cant do it with VBAK ( header ) .

Thanks

Moon

Former Member
0 Kudos

The calculation happens dynamically in FV45KF0V_VBAK-AWAHR_ERMITTELN. It will be not possible to pull the value from a table without developing it yourself.

  • statt *

----


FORM VBAK-AWAHR_ERMITTELN.

  • Berechnen der Auftragswahrscheinlichkeit

  • Nur bei Anfragen und Angeboten

CHECK: VBAK-VBTYP CA 'AB'.

DATA: DA_EWERT TYPE F.

  • Positionen nach Grundpositionen sortiert

IF VBAK-NETWR > 0.

LOOP AT XVBAP WHERE UPDKZ NE UPDKZ_DELETE

AND ABGRU EQ SPACE

AND PVPOS IS INITIAL.

PERFORM TVAP_SELECT(SAPMV45A) USING XVBAP-PSTYV

SPACE

SY-SUBRC.

IF TVAP-KOWRR = SPACE.

DA_EWERT = DA_EWERT + XVBAP-NETWR * XVBAP-AWAHR / 100.

IF DA_EWERT < 0.

DA_EWERT = 0.

ENDIF.

ENDIF.

ENDLOOP.

VBAK-AWAHR = DA_EWERT / VBAK-NETWR * 100.

RV45A-EWERT = DA_EWERT.

ELSE.

VBAK-AWAHR = 0.

RV45A-EWERT = 0.

ENDIF.

RV45A-WAERZ = VBAK-WAERK.

ENDFORM.

This is the main formual for calculating the value yourself: DA_EWERT = DA_EWERT + XVBAP-NETWR * XVBAP-AWAHR / 100.

Edited by: SAPSD1000 on Dec 21, 2011 2:37 PM

Shiva_Ram
Active Contributor
0 Kudos

Since it looks it is dynamically calculated, you need to write coding to pull the value from RV45A-EWERT structure field.

Regards,

Former Member
0 Kudos

Thanks

Former Member
0 Kudos

Hi,

F1 help is always a good starting point:

"Expected value

The expected value of all the items in the sales document.

Use

The system calculates the expected order value for each item by multiplying the net value by the probability factor and totals value for all items.

Example

A quotation contains two items:

Item 1 has a value of $100 and a probability of 100%

Item 2 has a value of $200 and a probability of 25%

The system calculates the total probability as follows:

($100 x 100% + $200 x 25%) divided by $300 = 50%

In this case, the probability of this quotation resulting in a sales order is 50%. The expected order value is $150."

Order Probability field (VBAP-AWAHR):

F1 help:

"Order probability of the item

The probability (expressed as a percentage) of the customer confirming the inquiry or quotation item as part of a sales order.

Use

The system combines the probability factors from the sales document type and from the customer master record of the sold-to party.

Example

If probability is 80% for the sales document type and 50% in the customer master record, the system combines the two values. In this case, the system takes 50% of 80% and proposes 40% for the item.

Procedure

The system proposes the probability. You can change the value manually for the item.

Dependencies

You can generate requirements from quotations. Accordingly, the probability of quotation items affects how requirements are passed on. For example, a quotation for 100 pieces and a probability of 50% will generate requirements for 50 pieces."

Hope that answers all questions. I am a big fan of F1 help!