cancel
Showing results for 
Search instead for 
Did you mean: 

SIS updated for sales order and Invoices but not for Outbound delivery

solomon_macwan
Active Contributor
0 Kudos

hi Guys,

We have one custom info structure as S901 and it is having all the data for sales order, delivery and invoices. this info structure is having one characteristic as Product hierarchy. and now we want to update this info structure.

I am able to create a new version with OLI7 & OLI9. but could not update SIS for OLI8(Delivery) for new version. but the original version(000) is correctly updated for sales order, delivery and invoices.

it means when it updates the original version automatically than the values are coming correctly. but when i manually try to create new version, than it is not updating.

When I check the MCVT for delivery it shows that -  Period is displaying as 00000. and other values are coming correclty for delivery.

please see the screenshots.

MC23-----

MC26 ------

MC26 LOG ----

MCVT -----

I can understand that it is not updating because of the date value. but how this is fetching? do anybody have idea. please let me know.

Accepted Solutions (0)

Answers (2)

Answers (2)

Jelena
Active Contributor
0 Kudos

It does show in your screenshot that date for period is MCLIPS-APERDAT. Not sure why it would have zeros in the period - maybe wrong date is in the field or maybe there is something wrong with the period determination. I've never used periods with SIS, so can't really tell.

I'd suggest to do some debugging. You could run "where used" for the field in SE11 and go from there.

Also keep in mind that when key figure value is 0 update does not occur because it would make no difference. So make sure there actually is any data to be updated.

solomon_macwan
Active Contributor
0 Kudos

Hi Jelena,

The value is there in LIPS-ERDAT but it is not fetching as for sales order and invoices. the main problem is that the value is coming in 000 version. but when I run it in OLI8 it is not fetching.

have you worked on updating group?

regards,

Solomon

Jelena
Active Contributor
0 Kudos

Well, naturally value is in LIPS, but is it getting transferred correctly to the communication structure (MCLIPS)? Also to define period we would also need plant and corresponding calendar, so maybe something is missing there?

Sorry, I'm not quite following that story with version 000... Are you saying that you had data OK in 000 before and now you are trying to rebuild the infostructure but data is not filled in correctly? If so, then obviously some changes occurred that broke something, I guess...

solomon_macwan
Active Contributor
0 Kudos

Hi Jelena,

yes, the data is correct in LIPS and also other tables.

Also currently the value is correctly updating in 000 version. but when i try to update it, it is not working. and when i see the MCVT, the period value is not there.

Jelena
Active Contributor
0 Kudos

Solomon, not sure you understood me - info structures are updated from the so called communication structures (MC...). There could be some issue with transferring the data to those communication structures. You won't see it anywhere in the database.

From your original post it seems that you've changed the info structure and need to update the historic data. But after making the change have you confirmed with at least one document that it is working correctly? If it worked before but does not work after your update then, unless there is a data issue (is fiscal period actually maintained for the date in question?), it's a no-brainer that change is the problem.

If you change the info structure then you need to re-build the update definitions and generate everything. Then test just a few documents. Only after that you'd go to mass update.

Make sure to regenerate everything and make sure your data is correct. If there is still an issue have someone to debug it. I doubt SCN can help with such odd issues.

Lakshmipathi
Active Contributor
0 Kudos

Since it is a customized table, you have to check with your technical team who have done the coding.

G. Lakshmipathi

solomon_macwan
Active Contributor
0 Kudos

hi,

the problem is with the date only.

do you have any idea about it.

regards,

Solomon

Shiva_Ram
Active Contributor
0 Kudos

Can you check OSS  64636 - Procedure for setting up statistical data in the Logistics Information System (LIS).and other notes given in it for identifying the issue?

Regards,