Get prices of VK12

[Private_Member_19084]

Hi experts

How can I get the prices of VK12?

I tried the FM BAPI_PRICES_CONDITIONS, but it does not run.

Thx in advance

[Former Member]

Hi,

U can get price in table KONV based on condition type(KSCHL) or conditon number (KNUMV).

Regards,

Ramesh.

[Private_Member_19084]

Thank you for your fast answer

The tables are KONH (header) and KONP (position).

But I don't know, how to get the KNUMH.

Hope you can help me

Thank you

[Former Member]

you can get condition record number

go to se11 and find the tables with A0*

you can find all the tables associated like shown below, based on your requirement you must using the specific table

A000 Condition Table for Pricing $

A001 Not Used in Standard

A002 Country/Customer Classification/Material C

A003 Tax Classification

A004 Material

A005 Customer/Material

A006 Price List Type/Currency/Material

A007 Division/Customer

A008 Plant/Additional selling plant

A009 Additional Selling Plant/EAN

A010 Additional Selling Plant/Material

A011 Country/Country of Dest./Customer Classif.

A012 Additional Selling Plant/Material Group

A013 Overhead Type

A014 Overhead Type/Overhead Key

A015 Not Used in Standard

A016 Contract Item

A017 Material Info Record (Plant-Specific)

A018 Material Info Record

A019 Contract Header

A020 Division/Price Group

A021 Vendor/Material/Unit of Measure

A022 Material/Unit of Measure

A023 Additional Selling Plant/Material/Unit of

A024 Distribution Channel/Material/Unit of Meas

A025 Info Record for Non-Stock Item (Plant-Spec

[Former Member]

HI FRIEND

go to vk12 .

give the condition type for instance PR00 basic price

click the condition information button.

selection screen will be appear .no issue to give any trigger.

execute it.

press the display records in alv icon. ie ctrl+ F8.

there u see the condition table name starting as A305 on above the list.

regards

surender.s

[Private_Member_19084]

Thank you for your answer

But this table is initial!

[Former Member]

hi

what u give in the selection screen of the display records.

for our client a305 is table for basic price.

but i dont know what for u. instead of a305 some other series starts with ' A' letter.

once u verified alert me.

after that there is a knumh field .

u have to link that field with konp-knumh after that u get the price in kbetr field for kschl type .

r u tested in development. ?

if the 'A' series table is initial.

go for production and check it that table.

it will definitely depicts the records.

regards

suren.s

Edited by: SURENDER on May 28, 2009 7:55 PM

Edited by: SURENDER on May 28, 2009 7:56 PM

Edited by: SURENDER on May 28, 2009 7:59 PM

[Former Member]

Hi,

Please follow the following steps to get the VK12 pricing records.

1) Get VBAK-KNUMV for the document number

2) Using this get KONV-KNUMH. This is the condition record number from VK11,12 and 13.

3) Using the condition record number query on KONH and KONP to get the pricing details. KONH will give you the table number also.

Thanks and regards,

Nilesh.

[Private_Member_19084]

Thank you for your answer

But I don't have a VBAK-Record at this time

[Former Member]

Hi,

If you dont have the VBAK record, the you will have to find out the condition table number for your condition type from the configurations and directly query the condition table for the access sequence values. This will give you the KNUMH value. Based on this, you can query on KONH and KONP then.

Thanks and regards,

Nilesh.

[Private_Member_19084]

How can I get the KNUMH-Value?

[Private_Member_19084]

Solved it one my own