How to find table for condition types (KSCHL) Field

[Former Member]

Hi SDNers,

I maintain Condition Types in me47 , but i am unable to find the table for condition types and which table this data will be store?

i followed like , i got structure name but i didn't get table name.

press F1 on filed--->technical info

here shows structure name and field name etc... but didn't show any table name.

If you anybody knows please give me navigation, how to find Table name  for this field.

Thanks in Advance

SBK

[Former Member]

Use table: KONV

[Former Member]

Thanks shambu,

can u give navigation?

how to find table name.

[former_member16553]

Hi

     Check tables:

                          KONV

                          KONP

                           KONC

[RaymondGiuseppi]

- From F1 double-click on data element and then on where-used select database tables.

- You can also execute ME47 via SE30 and then analyze the result (FM called, database tables updated)

- You could also use the scn search tool to find documents like Pricing in MM-PUR

Regards,

Raymond

[Former Member]

Thanks Raymond,

i found table for KSCHL field via F1 double-click on data element and then on where-used select database tables but i want to know how to find via SE30. i tried but i didn't get, please give me some navigation.

[RaymondGiuseppi]

Run transaction SE30, in this transaction execute ME47,

after ME47 execution, display the result via Evaluate

Here you will get a log of the execution, with FM, form names and database statements.

Regards,

Raymond

[former_member230486]

Hi,

Where we can find the Log after evaluation?

[RaymondGiuseppi]

At the bottom of the SE30 screen. If you leave SE30, you can select the log file.

[former_member230486]

Could you please send me the screen shot for Log file?

[Former Member]

Based on the Sales Document (VBELN), you can fetch Number of the document condition (KNUMV) from the table VBAK.

This Number of the document condition (KNUMV) can be passed to the table KONV – for finding the Condition type (KSCHL).

[yogendra_bhaskar]

Hi,

Go to se38 enter the program name SAPMM06E for t-code ME47

Press SHIFT + F4 , you will have environment analysis , select fields what u need and execute..

[itamar_melo]

Hi sbk sdn,

My friend, you tried to use this function: ME_GET_CONDITIONS_TO_SEARCH
If the above function does not help you please detail the scenario that you are with difficulty that I will try to help you.

I look back.

good luck.

[Former Member]

Thank you so much!

[venkateswaran_k]

Table :  T685  and T685T

[Former Member]

use table T685T.
it has a field VTEXT which contains the condition type text.