Select Materials based on Characteristics

[Former Member]

Hello,

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

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

But, the problem is, that there is no index on the field <b>MARA-CUOBF</b>.

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]

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]

Hi,

Create Secondary index for MARA on field CUOBF.

Raveendra Holla

[Former Member]

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]

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]

Hello all,

thank you for your hints. Its working fine.

Best regards,

Kurt.