Table name where Sort rule of batch search strategy(T code: VCH1/ VCH2 and VCH3) gets stored?

[Former Member]

I need to know the table or any Function module from where we can fetch the value of sort rule maintained against the the condition record. We have a requirement from business where they need to download all the condition record and the sort rule maintained against them.

[former_member204407]

Hi,

check the fields KSCHL & CLASS_SRT in table T685H.

Thanks,

Krishna.

[Former Member]

Hi Krishna,

This is configuration table and I need master data table. I am explaining below in detail:

1) T code for batch search strategy maintenance for sales and distribution VCH1/VCH2

2) Now through KOTH* table, I am to fetch the condition record and the condition record no.

3) Through condition record no., I am able to fetch further data through table KONDH

I am not able to fetch sort rule maintained against condition record and this is my query