Fetch country of origin from batch classification tab in tcode msc3n

[former_member218781]

Hi,

i have a requirement where i need to fetch the country of origin from batch classification tab.

currently it is picking the same data from basic data 1  tab in MCHA table.

we have checked all the relevant tables for batch management. below is the screenshot for change batch screen.

please help.

[former_member201529]

Dear Loganathan,

Kindly pass the material and Batch into INOB-OBJEK and find the object no CUOBJ and pass the object no into AUSB- OBJEK and take the value from field Characteristic Value ATWRT.

For more information refer below tables

KLAH

CABN

MCHA

CAWN

KSML

KSSK

Regards,

Karna J

[Prasoon]

Hi,

  If the class type is with "Mult Obj allowed" indicator, you may proceed as below:

1. Go to INOB table and pass the material number and batch number combination to the field INOB - OBJEK. Get AUSP - CUOBJ

   In this example, material number is B12 and batch number is 118

2. Go to AUSP table and pass the CUOBJ (INOB - CUOBJ  which is 1814 in the above example) to AUSP - OBJEK. Now, the system will display all the characteristic values for the batch in AUSP. The value will be available in AUSP - ATWRT

Refer the KBA: 1547034 - How are characteristic values updated in table AUSP?

for additional details.

Regards,

AKPT