Stock Report with batch number and its Charactristc values

[Former Member]

Our material are batch managed and Char values are entered at the time of GR. We need to prepare stock report showing batches for the material, their stock and characteristics values.

Like to know what tables we should use to find the char values. I could not find value in table CAWN

[dheeraj_vaishampayan]

Hi,

For characteristcis link and values use below tables:

Characteristics :

CABN Characteristics ( o.a. batch/vendor)

CABNT Characteristics description

CAWN Characteristics ( o.a. material)

CAWNT Characteristics description

AUSP Characteristic Values

Class types and objects :

TCLAO Several class types for object

TCLA Class types ( vb. lfa1 => v10 en 010)

TCLAT Class type text

TCLT Classifiable objects

TCLC Classification status

Links :

INOB Link between Internal Number and Object

KLAH Class header data

KSSK Allocation Table: Object (vb.matnr) to Class

KSML Characteristics for a class (internal number)

for batch stock 0 use tables ilken MCHB, MCHA etc,

hope this helps

Reg

Dheeraj

[Former Member]

Thanks for the list of Tables, however I could not found the value of the Char. in Table AUSP. Please note that I have not maintained any default values in Charactristics. I enter its value only at GR. The AUSP table showing value 0 for the corresponding Object Number of the Batch.

[raviraj_sharma]

Try report BMBC.

[Former Member]

Thanks, WE have to build stock report showing all the char values for each batch in the stock. From BMBC I can find the batch with specific char values.

[former_member329706]

Hi,

Try with the report CL30N..............................for bacth char values goto table AUSP.....................

[Former Member]

No, In AUSP table the Value for the Char is showing 0. i.e value of the char which I have passed is not recorded there.

Please note I have not maintained any value while creating the charactristic I enter char value only at the GR stage.