SLED Date format to MM/DD/YYYY with Period Indicator M - Possible?

[former_member556123]

Hello Experts!

We have a requirement to display the SLED in MM/DD/YYYY format. We need to use the period indicator M in the plant data storage view of the material master.

When we use this is indicator, the SLED date changes to MM/YYYY format. I can get the full (MM/DD/YYYY) as a part of characteristics, but business does not want that.

Is there a standard way to change the SLED date? Note :We cannot use period indicator "D".

Please advise.

Thanks,

Parth

[former_member556123]

Craig,I have been pushing it back with logical alternatives since couple of years. However, its a highly customized environment with lot of Z programs where the SLED conditions which would have to be met for the product to be shipped/

I don't see any standard way other than using an user-exit and I cannot bring a developer till end of the year. I guess we'll have to wait.

Again, I appreciate you taking the time to respond to my query.

Thank you!

[former_member42743]

No. In this case you can't have your cake and eat it too,

You can use the D indicator with a rounding rule that will round the date either to the beginning or end of the month. If you do something really weird you can create your own rounding rule and add it to the system. You don't mention if or how you are using a rounding rule or if that has been looked at and presented as a solution.

Anyway, can you elaborate on why they can't use the period indicator as D? I usually find this is because they have label requirements that are regulated and require a specific format that's filed with an agency. But they do expiration by month in procedures. This doesn't necessarily mean they can't use D. It might just mean that some SOP's need to be modified and I find there is often a push back then. They want SAP to do 100% of the adoption. Anyway, if it's a labelling thing, you should be able to modifythe date format easily in any smart forms or sapscripts you have as well as any idocs or interfaces you have.

[former_member556123]

Thank you for your response.

We are not using the rounding rule as we need the expiration date to be an exact date and can't use either at the beginning or end of the month. Also, I was under the impression that only the period indicator was configurable and not the rounding rule.

Its not labeling thing. For few of the material codes, we do not want to account for leap year. I cannot change my plant calendar as it affect other areas.

[former_member42743]

Ok. I'd really work with your client. From what you described this is because someone is saying they want it to always be exactly xxx long with no deviations. A material never expires EXACTLY on a date. Even in the pharmaceutical area, one of the most controlled areas you don't have to be EXACT. Anymore these are now "Best used by" dates and not actually expiration dates. Being conservative and setting an expiration date a few days shorter, thus getting rid of the leap year is not a bad practice. Normally, your shelf life value shouldn't be reached. With some exceptions for course, material should be consumed long before the data calculated is ever reached.

In any case, you can use the exit EXIT_SAPLVBMD_001 from enhancement SAPLMHD1 to check/change your SLED. I'm assuming you use the Date of manufacturing. Just take that and add the number of years from the material master SLED information.