topic Re: Select Materials based on Characteristics in Application Development and Automation Discussions

Select Materials based on Characteristics

Former Member — Thu, 14 Sep 2006 12:14:51 GMT

Hello,

I would like to select specific materials (MARA) based on the assigned characteristics and values (AUSP).

My first approach would be the following: select table AUSP with the characteristic and value, then select MARA with MARA-CUOBF = AUSP-OBJEK.

But, the problem is, that there is no index on the field MARA-CUOBF.

Is there another way to select material based on characteristics and values? Does there any index table or reference table exist?

Thank you for your assistance in advance.

Best Regards,

Kurt.

Former Member — Thu, 14 Sep 2006 12:27:29 GMT

Hi,

Create Secondary index for MARA on field CUOBF.

Raveendra Holla

Former Member — Thu, 14 Sep 2006 12:57:28 GMT

Hi,

U can access if there is no index also.

Creating secondary index for standard field is not recommended until through analysis.

Regards

Divakar

Former Member — Thu, 14 Sep 2006 13:40:49 GMT

Hi Kurt,

there is a way if u know the characteristic of the material.

give characteristic in AUSP-ATINN field in AUSP table.

collect all OBJEK's for that characteristics.

then go to table INOB, select objek from inob into itab where cuobj = ausp-objek.

INOB-OBJEK gives u a combination of material number and batch number for that material number. ( there might be different batches for one material).

so collect inob-objek and split into matnr and batch.

there u get all materials according to ur characteristic

and also collect those objeks where ur matnr is there.

and regarding to that matnr and batch in MSEG table u can do rest of the stuff....

reward if it helps

Regards

Message was edited by: srinu k

Former Member — Thu, 14 Sep 2006 21:31:52 GMT

Hello all,

thank you for your hints. Its working fine.

Best regards,

Kurt.