2lis_03_bf enhancement

[Former Member]

All

I have to bring Manufacturing date and Shelf life from MCH1 table into 0IC_C03. I want to enhance 2LIS_03_BF for this.

Could someone please provide me with the logic? I am thinking that if we take Material and batch combination , we will be able to derive these 2 fields.

[Former Member · Accepted solution]

Do I need to write any code in CMOD for adding HSDAT from MSEG to 2LIS_03_BF.

Also 0IC_C03 is in production , what effect will I have if I enhance 2LIS_03_BF . Do I need to stop the data loads and stuff like that

Thanks

Message was edited by:

BW BW

[Former Member · Accepted solution]

Hi

For getting the field HSDAT to 2lis_03_BF you don't need any code just append the field to MCMSEG and transfer it to extract structure in LBWE but while appending just append it as HSDAT without any ZZ , then you will get the value when you extract.

As you said the cube 0ic_c03 is already in production and you might have the delta going on, here you need to be very carefull becoz if you don't follow the process properly you will loose your delta init.

1. Stop updating to 2LIS_03_BF this can be done from lbwe and then

2. First make sure to delete the setup tables if you have any data and also run your JOB control in LBWE twice so the data in Extraction Queue or Update tables will move to Delta Queue and then empty the delta queue for this you need to request delta twice.

3. Then after doing all these you can import the changes to production.

CAUTION: If anything goes wrong you will loose your delta init and that will lead you to re init, so please search for more documentation in this Forum

Thanks and regards

Sreedhar

[Former Member]

After doing all this , will I get the history for this new added field or will it be only new records .

Thanks

[Former Member]

Hi BW,

You cannot get the history for this new field, it will only have value for the new loads from now onwards.

thanks and regards

Sreedhar

Message was edited by:

Sreedhar M

[Former Member]

Hi BW

If you are looking at the field HSDAT for manufacturing date and total shelf life which is a attribute of 0material_attr...and you can get the HSDAT date from MSEG also which is same as MCH1 so for this HSDAT only u need to add that field to your comm structure in R/3 and the total shelf life field is avaialble in material datasource bring it assign the infoobject to it.

thanks

Sreedhar