Table for getting pricing data in sales order

[Former Member]

Dear experts

how to get red mark field data for an ZREPORT in KONV i am unable to get this data

Regards

Abhi

[madhu_vadlamani · Accepted solution]

Hi Abhi,

Check Konv

Regards,

Madhu.

[Former Member · Accepted solution]

HI Madhu

Thanks for prompt reply

already checked in KONV but here only pricing condition records available like ZDCM and JASS but i need step value which came on calculation of these conditions

Regards

Abhi

[madhu_vadlamani · Accepted solution]

Hi Abhi,

Can you check other fields if you have the step value ?

Regards,

Madhu.

[Former Member · Accepted solution]

Hi

yes i checked by step no. but step of this value in not available in KONV

like ZDCM is on 125 step value available and JASS is on 170 value is available but

NET EX MILL PRICE is on 160 and this 160 step is not available.

Regards

Abhi

[madhu_vadlamani · Accepted solution]

Hi Abhi,

Can you try this ask them to add these two steps. Have a look at konp.

Regards,

Madhu.

[jpfriends079 · Accepted solution]

For price point/subtotals, without condition type you will not get value in respective tables.

For these sort of requirement, assigning Subtotal always help.

Check in your pricing procedure, if you can see any subtotal assigned against subtotal/price point "NET EX MILL PRICE". Say, you have Subtotal "1 - Carry over value to KOMP-KZWI1" assigned. Therefore that you can get the value of that subtotal/price point in KOMP-KZWI1 for reporting purpose.

Thanks, JP

[former_member182378 · Accepted solution]

JP,

Thanks! Good post!

TW

[Former Member · Accepted solution]

Hello JP Sir

thanks for replying

but there is no subtotal assigned in Pricing Procedure

[jpfriends079 · Accepted solution]

As I already subtotal is best way to get values for pricing subtotal or price point. Further in absence of condition type for a subtotal or price point, it is not possible to retrieve its value.

Therefore, for future sales doc & reports, you can place relevant subtotal to respective condition type.

Also, refer SAP Note 1022966 - FAQ for the 'Subto' column (KZWIW) in the pricing procedure for your reference.

Thanks, JP

[former_member182378 · Accepted solution]

abhi,

As there is no subtotal in the pricing procedure, check (in reverse way), charge FOB and charge Trans. have values referenced from previous steps. Check those steps, what condition type is assigned there?

Probably you can not get the complete value in one shot but you can add various components and arrive at the desired value.

TW

[siva_vasireddy2]

Hi,

To fetch the pricing data in from the sales order you can develope a Simple report by yourself by using

T.cdoe-SQVI and by taking the Logical Database-VAV