Finding access sequence used for pricing for a sales order

[Former Member]

Hello Gurus,

I have a requirement to create a custom report to display the condition value of a certain condition type and the access sequence which was used of it ,for a sales order.I can obtain condition value from KONV table. But how do i know which access sequence was used for the pricing.

Is there an FM for table from where I can fetch this information. Is it possible?

Thank you.

[sez41 · Accepted solution]

Hi,

1- In KONV there is a field, KOLNR, which stores the access number of the relevant access sequence which has been assigned to your condition type.

2- You can select KOZGF from table T685 where KSCHL = KONV-KSCHL.

3- You can select KOTABNR (condition table) from T682I where KOZGF = T685-KOZGF and KOLNR = KONV-KOLNR.

[Former Member]

Thank you both for the quick response.

[Lakshmipathi]

From KONV, you will have KNUMH which will have interlinked with KONH and this KONH will show which access sequence (KOTABNR) is used.

G. Lakshmipathi