Query for batch search strategy characteristics

[Former Member]

Hello,

We have   batch search strategy conditions maintained in VCH1/VCH2.  I am trying to build a query (wtihout ABAPing)  to extract  conditions characteristics values :

1. conditions are maintained in KOTH* tables.  From these table I can  find condition record number in  KNUMH field.

2. Having this condition number I can extract condition values from KONDH table.

3. From KONDH table I get "internal object number"  in CUOBJ_CH field.

4. Having this  internal number I can go to AUSP table and extract values I need by OBJEK field.

However when I tried to build a query SAP doesn't allow to join  KONDH-CUOBJ_CH -> AUSP-OBJEK ( says that joint is illegal).  As I understand there is some missing table  which converts  internal object number from KONDH-CUOBJ_CH  to normal object number.   How can I link it ?

So in short :

KOTH**-KNUMH--->KONDH-KNUM

KONDH-CUOBJ_CH ----> missing link

missing link -------> AUSP-OBJEK

[Former Member]

I'm using SE16N to go from KOTH### to AUSP and it's working just as you outlined.

KOTH995-KNUMH  --> KONDH-KNUMH

KONDH-CUOBJ_CH --> AUSP-OBJEK

and I see the values in AUSP-ATFLV .... I do have to supply the leading zeros with SE16N.\

Also I'm using LS51 as the maintenance transaction ...

[Former Member]

I did explain that going through tables in se16 is not a problem. 

Problem appears when you try to build  SAP queary in SQ01/sQ02 tranzactios - it doesn't allow to connect those fields.

[former_member205178]

Hi,

Try - CUCO - Additional Data for Configurable Objects

Tell me if you need anything more.

Thanks.

[Former Member]

CUCO table doesn't work.  It doesn't even have any entries in it in our system

[former_member205178]

Hi,

Thanks for the update. Apologies!

I dont have SAP System in front of me and I just told from my memory which obviously did not serve me right in this case .

Let me get back to you on this.

Thanks.

[Former Member]

Anyone has an answer for this ?