Table for Batch Charecteristic value ?

[Former Member]

Hi Experts,

I need to change the "Effective country of origin" in tcode MSC3N.  (See the first image below)

Currently the vue is In and i want to change this.

Actually this is the charecteristic value of batches.

How can I change this value ?

Thanks,

Anoop S

[martin_roldan]

Hi,

The best way to retrieve the value is using FM BAPI_OBJCL_GETDETAIL.

The best way to change the value is using FM BAPI_OBJCL_CHANGE.

I think that value is stored in table AUSP, but you'd better use the FMs.

To read the charecteristics of a batch you would use it with this parameters:

OBJECTKEY: MATNR + BATCH

OBJECTTABLE: MCH1

CLASSNUM and CLASSTYPE: from your classification of batch.

Martin

[Former Member]

Hi Martin,

Thanks for your reply...

The Fm you have given is correct.. It is reading correctly. But when I change the COO using that second FM, it is not updating the DB.

Please advise..

Tahnks,

Anoop S

[martin_roldan]

Hi,

Always remember to call BAPI_TRANSACTION_COMMIT afterwards.

Martin

[Former Member]

Hi Anoop,

If it is the one time activity, LSMW with recording is the best activity!

Check the information of batch characteristic :

Class type is 22

class :      'MATERIAL'

TABLES:  INOB, CABN

BATCH MASTER TABLE : mcha,mch1

better to use the BAPI's to update the origin of country.

Rg, Kiran

[former_member235395]

Hi Anoop,

Try using this BAPI: BAPI_BATCH_CHANGE.

Regards.

[atul_mohanty]

Hi Anoop -

How do you want to change it through any transaction or custom program ? Please let us know.

Thank you.

Regards,

Atu Mohanty

[Former Member]

Through Custom program...
Actually in the above reply Martin gave 2 BAPI names.  That READ BAPI is correct... BUt CHANGE is not working...

Actually what is Class? Where can find that value ?

Thansk,

Anoop S

[bastinvinoth]

Anoop Satheesan

for each material they will assign class , class is purely depends on variant configuration .

pass material no to  INOB , KSSK tables there you will get object number OBJEK material type KLART

After that you need to pass OBJEK and KLART to KLAH table or fm 'CLAF_CLASSIFICATION_OF_OBJECTS'

there you will get all the required values

if you want to know the meaning of class means ask your FC , he can explain with your business scenario so that you can easily learn , also study about Variant configuration.

simple example Computer has been classified into many types  desktop, laptop,

here computer is class, characteristics is desktop, laptop

[atul_mohanty]

Hi Anoop -

For Class, Check the table KLAH (Class Header Data), CABN (Characteristic) which will help you.

Also the other two tables which are related to your scenario is MCHA, MCH1 and AUSP.

Let us know, if it helps.

Regards,

Atul Mohanty

[Former Member]

Hello,

Thanks for the reply....

Actualy I am able to change the values using the BAPI. But now my problem is I am unable to get the CLASS and CLASS TYPE in tables. So taht I can pass that variable to the BAPI..

I checked all the tables mentioned above AUSP, KLAH, CABN , MCHA, MCH1 etc..

Kindly help me ...

Thanks,

Anoop

[atul_mohanty]

Hi -

Below are the tables for Class and Class types.

KLAH (Class Header Data)

TCLA ( Class Types)

Regards,

Atul Mohanty