Report to be captured sales order item level price

[Former Member]

Hi Gurus,

The below screen is from Sales order Item Level. For one of my Report I need to extract Price 22.00 into my report.

How to  fetch this value to report. any logic will be help full.

Thx,

Seegal

[Former Member · Accepted solution]

Thanks all,

Instead of all turn a round jobs..we did some logic with Client approval... The Price is always same as ZDIF condition type. so we are fetching the Same value to Price of ZDIF,

Regards,

Seegal

[Former Member]

Hello Seegal,

Its not possible to fetch a subtotal from any table for the pricing.

But you can get the required data by doing a little calculation in the report program based  on the step numbers.

E.g. How the subtotal "price" is coming on your pricing procedure by calculating the From to Steps,Same thing you have do in programming and put the value in the report.

Regards

AG.

[former_member184881]

Hi

you can create a report for sale rate by SAP Query Infoset SQ02. use table VBAP, VBAK and Additional fields in SQ02

SALESRATE (Additional fields)  = VBAK-NETWR / VBAP-KWMENG.

or use table field VBAP-NETPR sales price

or use table field VBAP-CMPRE Item credit price

regards

Md. Enayet Hossain

Message was edited by: Md. Enayet Hossain

[Former Member]

Hi Enayet,

Already We have Existing report.. in that we need to fetch this Price value.

no need to create Query...

Thx,

Seegal

[former_member184881]

hi Seegal,

ok, you can mantain above table field in your existing report to calculate  the price.

regards,

Md. Enayet Hossain

Message was edited by: Md. Enayet Hossain

[Former Member]

Hi Seegal,

Check to which subtotal this net price is assigned to in Pricing procedure .

Then you can get the subtotal values from the corresponding subtotal fields in VBAP tables.

in VBAP-KZWI1

   VBAP-KZWI2

   VBAP-KZWI3

   VBAP-KZWI4

   VBAP-KZWI5

   VBAP-KZWI6

Thanks,

Siva.

[former_member184080]

Hi Seegal,

Check your pricing procedure and see if you have not used subtotal 1 to 6. If not, assign any of the numbers for the price step.

Now, create orders and check in VBAP table. That value will be populated and same can be used for the report which you are developing.

Do complete testing after assigning the sub total to Price step in your PP.

Regards, Sai Krishna.

[sivalingeswararao_bhairap]

Hi,

Pass this value to any sub total filed KOMP-KZWI1 to 6 which is not used so far in pricing procedure. Once you assign any filed KOMP-KZWI1 to 6 to sub total column, this value will be stored in VBAP table field sub total 1 to 6 depends on your assignment. You can fetch the value from VBAP table directly.

Warm Regards

Siva B

[Lakshmipathi]

In VBAP table, there will be Subtotal-1 to 6 fields are there.  Check whether this value is flowing in any of those fields.  This will depend on your pricing procedure settings where under the tab Subtotal, check from 1 to 6 any value is assigned against this value.

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

This value is not flowing in any of the Subtotal-1 to 6 fields .....

Thx,

Seegal

[jignesh_mehta3]

Hello Seegal,

Currently the Price of 22 is a Sub Total in your Procing Procedure.

If you change the Pricing Procedure & make it as a condition, then the item-wise condition value can be easily be fetch from KONV Table.

From VBAK get the Document condition number (KNUMV) & pass the same to KONV with Item Number.

Thanks,

Jignesh Mehta

[Former Member]

Hi Jignesh.

Thank you for your Concern.... For report purpose.. changing the Pricing Procedure is not best practice of SAP... it will be a more Turn round Job......Moreover Client Pricing Procudre is Very complex one...ther is no steps left over in PP to insert new Condition in that place.....

Thx,

Seegal

[hark101]

Seegal, it seems that your condition ZDIF also contains the price in the amount column. If this is the case always, then get the KNUMV from VBAK and pass it to KNOV with the item number on KOMV-KPOSN and the condtion "ZDIF" on KONV-KSCHL. There you'll find the amount for the condition ZDIF.

If for some reason you can't use ZDIF, see if there is another condition on your pricing that could be used instead.

Reagards,

Edson

[rahul_vishwakarma2]

Hi Seegal,

  Please find this bapi for your requirement.

BAPI_PRICES_CONDITIONS and BAPI_PRICES_CONDITIONS.

Regards,

Kundan Vishwakarmma

[former_member213975]

Hi Seegal,

I would use BAPI_SALESORDER_GETDETAILBOS (field ORDERCONDITIONS-COND_VALUE)  for this purpose.

Regards,

Maria

[Former Member]

Thank you for your response Maria.

Let me check and get back to you...

Thx,

Seegal