Pricing details of sales order

[Former Member]

Hi SAP GURUs,

I want to make report of pricing details of sales orders.

From which table i should get the pricing details. I know tables KONH and KONP...but i dont know how to get details in these tables for perticuler sales order.

Please help me out ...

Thanks,

Tarpan

[Former Member · Accepted solution]

hi

Table: VBAK

get Doc. Condition from VBAK for sales order ( VBAK - KNUMV)

pass this KNUMV to KONV table you will get details

[former_member183879]

Hi,

You have to make use of the tables VBAK, VBAP and KONV

VBAK-KNUMV = KONV-KNUMV

VBAP-POSNR = KONV-KPOSN

For this combination, you can fetch the following fields from KONV

KONV-KSCHL (Condition type)

KONV-KWERT ( Value of the condition type)

KONV-KBETR (Rate for % condition types)

[Former Member]

Hi Tarpan,

You can create a pricing report besides standard pricing table by using V/LA t-code. in V/LA, you can add if which fields are needed for your report.

Additionally, you need new table and need a new t-code for this report.

Please explore this t-code and try it. please share further issue for this requirement with us.

Regards,

[aramsum]

Hi Tarpan.

If you want the net value, you can get it IN "vbap-cmpre". Kindly please let me know If you need any more information on this.

Regards.

Ram Pedarla

[Former Member]

Hi,

In table VBAP, you already can get the price unit and net price, please do check.

Thanks.