Knowledge Management

Question:
Hi all,
I am in search for a table which contains valid to date for a material.i can find valid from date in mara but not valid to date.field name is datub.i checked with where used list to find the appropriate table,but the listed table where of no use to me.i want to use this field especially for boms.
Any solun to these please.
Thanks,
Guest.
Answer:
The first thing that I would do is check MM03 for a particular material and see whether you can spot the appropriate field. From what you've said it sounds like it should be found on one of the MRP screens.
Once located access the appropriate table.
Dr Sidewalk
_________________
"In the middle of difficulty lies opportunity" - Albert Einstein
"Money isn't everything in life, unless you don't have it". David King
"Fail to plan, plan to fail"
"Success is a journey, not a destination."
Answer:
Hi Dr Sidewalk,
Thanks for your reply, i am not able to see valid to date for a material in MRP screen,only valid from date is their and that to its a validity for plant wise.In transaction CS01,Creation Of BOM,while adding components to BOM, we can see Valid from date and valid to date,valid from date is assigned sydatum and valid to date is assigned 31.12.9999.i am not able to get in which table its being posted and where we have to configure the valid to date.Any idea in this regard,
Thanks,
Guest
Answer:
Okay
BoM information is held in STKO and STPO. In order to get the internal BoM number for a material used table MAST.
The valid date from date is assigned on the front screen of CS01 and is held in STKO in field DATUV. You're correct that it defaults to SY-DATUM, but it can be overwritten before you enter the BoM item overview. Then any items added to the overview will automatically take the overwritten value as their valid from date.
The valid to date is not held on any of the BoM tables, it is calculated on the fly by the program and then output using a structure field in order to display it to the user.
Hope this information helps.
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru
Answer:
Hi RosieBrent,
Thanks a lot for your input.i have to get the valid to date of a material.i am creating a bapi for downloading the material list.it will be great if you could provide me an idea of how to calculate the valid to date of a material with code.
Thanks,
Guest.
Answer:
It is defaulted to 31.12.9999 for the current material's validity.
It is cut off at the day before the previously valid material's valid from date for the valid to date.
I bet you can work that one out for yourself
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru
Answer:
It is defaulted to 31.12.9999 for the current material's validity.
It is cut off at the day before the previously valid material's valid from date for the valid to date.
I bet you can work that one out for yourself
Hi Rosie,
I have a reqmnt. for MRP Run Time, I am getting the MRP Run date from MDKP but I need the run time pls let me know if you have some idea about how to proceed on getting this information.
Thank You
Janis
Answer:
Hi Dr Sidewalk,
Thanks for your reply, i am not able to see valid to date for a material in MRP screen,only valid from date is their and that to its a validity for plant wise.In transaction CS01,Creation Of BOM,while adding components to BOM, we can see Valid from date and valid to date,valid from date is assigned sydatum and valid to date is assigned 31.12.9999.i am not able to get in which table its being posted and where we have to configure the valid to date.Any idea in this regard,
Thanks,
Guest
Hello Dr. Sidewalk
I have read some of your views on MRP especially and feel you might b able to answer my question about MRP Run time and also if there are any developments for a Consolidated MRP Report.
If so I would also like to discuss a couple of more things.
Thank You
Janis1272
Answer:
It is defaulted to 31.12.9999 for the current material's validity.
It is cut off at the day before the previously valid material's valid from date for the valid to date.
I bet you can work that one out for yourself
Hi Rosie,
I have a reqmnt. for MRP Run Time, I am getting the MRP Run date from MDKP but I need the run time pls let me know if you have some idea about how to proceed on getting this information.
Thank You
Janis
I think you might need to use MDVM for this (Entry in MRP File), although I am not sure. Have a look at all the tables which start MD on your system to see if there is somewhere else where the MRP runtime is held.
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru