Table for batch classification

[Former Member]

Hi,

I have linked batch with classification. Can you tell me in which tables are stored classification of batch records ?

thanks

Beto

[Former Member]

Please check to table AUSP,KSSK ,KSML,KLAH

[Former Member]

Thanks for your advice.

In these tables can I see information about classification.

But where can I see link between: material - batch - classification?

Beto

[Former Member]

Can you please specify,what value do you want?do you mean the characteristic value?

[Former Member]

Prerequisite:

In Classification for class HM exists class type - 023 batch with attributes : internal_number, length, width, certificate.

In goods receipt specify material, batch number(external) and characteristic value for classification(internal_number, length, width, certificate) .

In conclusion I can see all information about stock (not only in MMBE), but I would like create query for stock overview direct with these information.

[Former Member]

This is an example,please check if you can use it:

If your material use class type 001 and you want fetch data for Class No, you can find in table of KSSK join KLAH with key KSSK-CLINT = KLAH-CLINT and KSSK-OBJEK = material no.

For characteristic value of the material, you can find in table AUSP, with key AUSP-OBJEK = material no and AUSP-KLART = '001'

in KSSK-OBJEK dont forget:if the mat.number is not 18digit, Try to put the leading 0 until 18digit(including material number)

[Former Member]

OK,

but I have class type 023 (batch) and in KSSK-OBJEK is not material number, but other digit.

Do you have example with class typ 023, or is possible use class type 001 for recording of batch ?

[Former Member]

I think that for batch the class is 022, the link also similiar with material.