list all pricing condition tables which have a particular field

[former_member182378]

I have a field, I want to know all the pricing condition tables which have this field in them. How to perform this search? What is the table I can use?

Thanks in advance

[Lakshmipathi · Accepted solution]

Yes for that first of all, you need to list out what are such of those tables where the field is available which you can see via SE11 where-used-list.

[VeselinaPeykova]

I'd use SQVI for such things, because I already have one for general search of fields in tables:

Let's sa,y I want to see where I have incoterms (I do not have the improvement for additional customer ranges for tables here):

I hope you got the idea. There are probably easier and more efficient ways to do that, but I am getting old and lazy...

[former_member633299]

thank you. I tried it is possible to find the tables. Therefor, we dont simply create new tables for an new access sequence, we use existing table.

[former_member789032]

You can achieve this with table DD03VV, just put a A* in TABNAME and search for the field that you want - FIELDNAME

[former_member182378]

E.g.

I have field name = KUNNR, I want to know all the condition tables (e.g. A869, A920 etc. etc.) which have one field as KUNNR in them.

It is not about condition records.

[Lakshmipathi]

Assuming that you were asking about pricing condition details, normally, all pricing condition records would be stored in KONP and you should have added the said field here in which case, while executing KONP via SE16N, you have to maintain the said field as "not equal to blank"