Quotation success rate

[gunesbt]

Hi all,

I need to calculate the number of quotations result in order.The key figure 0ORD_QUOT(Number of orders resulting from quotations) in the cube 0SD_C05 is exactly what I want.But the datasource including this key figure is 2LIS_01_S260 and it is not supported by SAP. And the alternative datasource suggested by help.sap is 2LIS_11_VASCL,2LIS_11_VAHDR and 2LIS_11_VAITM.See the link please:

http://help.sap.com/saphelp_bw/helpdata/en/85/18f23864eec97ae10000000a114084/frameset.htm

Could you tell me how I can find the number of orders resulting from quotations by those datasources ,I could not find any related field about my requierement.Or is there any other standard solution for this problem?

Thanks

[gunesbt · Accepted solution]

Hi,

I want to add that I can find the number of quotations easily from those header and item datasource.What I want to know is whether this quotation is successful.That means whether it is a also an order.I would be able to find it if I could use the datasource that I mentioned above(2LIS_01_S260)

[amine_lamkaissi · Accepted solution]

Hi,

Use datasource 2LIS_11_VAHDR and enhance it with the missing fields.The logic of calculation of No. of order items resulting from quotations would be like this:

DATA: DOC_CATEG LIKE field Preceding document category VALUE 'B'.
DATA: DEB_CRED(2) TYPE C VALUE 'HK'.

CLEAR RESULT.

IF Preceding document category EQ DOC_CATEG.
RESULT = field Sales Document Item.
IF Preceding document category CA DEB_CRED.
RESULT = RESULT * ( -1 ).
ENDIF.

Make some tests before developping. Hope it helps.

Amine

[gunesbt · Accepted solution]

Hi Amine,

Thanks for your valueable answer.

However, I realised that there is no need for enhancement.I am not sure yet but I think referance document(VGBEL) and preeceding documnt type(VGTYP) in 2LIS_11_VAITM is enough to find the number of quotations resulted in order.

Just add those fields(find proper characteristics for them first of course) to ODS 0SD_O01 and then create a calculated key figure counting VGBELs and then create a restricted key figure with number of VGBELs and restrict by VGTYP=quotation.By this method, I count referance documents which is of type quotation.Which is equal to the number of quotations result in order in my opinion.However, this won't work if there is another document type other than "order" whose VGTYP is quotation.

[amine_lamkaissi · Accepted solution]

Hi Gunes,

In fact, 2LIS_11_VAITM is a very complete extractor (good option)

It would be better if you validate your argumentation by a functional consultant at your company and make some tests to be sure that you're calculating the right values.

Let us know if everything is fine with your option in the future.

Thanks.

Amine