topic Re: Table for Batch Charecteristic value ? in Application Development and Automation Discussions

Table for Batch Charecteristic value ?

Former Member — Thu, 12 Dec 2013 13:54:01 GMT

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

Re: Table for Batch Charecteristic value ?

Former Member — Thu, 12 Dec 2013 14:15:09 GMT

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

Re: Table for Batch Charecteristic value ?

Former Member — Thu, 12 Dec 2013 17:19:18 GMT

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

Re: Table for Batch Charecteristic value ?

former_member235395 — Thu, 12 Dec 2013 17:29:48 GMT

Hi Anoop,

Try using this BAPI: BAPI_BATCH_CHANGE.

Regards.

Re: Table for Batch Charecteristic value ?

atul_mohanty — Fri, 13 Dec 2013 07:30:19 GMT

Hi Anoop -

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

Thank you.

Regards,

Atu Mohanty

Re: Table for Batch Charecteristic value ?

Former Member — Fri, 13 Dec 2013 12:25:56 GMT

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

Re: Table for Batch Charecteristic value ?

Former Member — Fri, 13 Dec 2013 12:40:08 GMT

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

Re: Table for Batch Charecteristic value ?

bastinvinoth — Fri, 13 Dec 2013 12:53:30 GMT

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

Re: Table for Batch Charecteristic value ?

atul_mohanty — Fri, 13 Dec 2013 13:16:30 GMT

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

Re: Table for Batch Charecteristic value ?

Former Member — Fri, 13 Dec 2013 14:31:18 GMT

Hi,

Always remember to call BAPI_TRANSACTION_COMMIT afterwards.

Martin

Re: Table for Batch Charecteristic value ?

Former Member — Mon, 16 Dec 2013 13:25:03 GMT

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

Re: Table for Batch Charecteristic value ?

atul_mohanty — Tue, 17 Dec 2013 08:08:26 GMT

Hi -

Below are the tables for Class and Class types.

KLAH (Class Header Data)

TCLA ( Class Types)

Regards,

Atul Mohanty