cancel
Showing results for 
Search instead for 
Did you mean: 

valid to date - bom

Former Member
0 Kudos
109

hi.

where i can get datub(valid to date) for every item in the table.

becaz it is not in stpo table.

thanks in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Valid to date by default it is 31.12.9999 if it is not managed by ECN.

Regards

YMREDDY

Former Member
0 Kudos

hi

we maintained ecn for changing bom.

eg.

i created bom

header-change number-valid from date - item - qty

fert - xxxxxxxxx1 -18/03/2008 - roh1 - 10qty

i change bom

header-change number-valid from date - item - qty

fert - xxxxxxxxx2 -21/04/2008 - roh2 - 5qty

and i deleted roh1 in that

now bom detail

header- item - qty - valid from date - valid to date -

fert - roh1 - 10qty - 18/03/2008 - 21/04/2008

- roh2 - 5 qty - 21/04/2008 - 31/12/9999

my question

from which table i get roh1 valid to date(datub)

thanks in advance

Former Member
0 Kudos

When you deleted the bom item roh1 the STPO table will have this bom item with the new change number with valid from date as 21.4.08 but with a deletion indicator. So when you view the bom you would see this deleted item with validity end date as 21.4.08.

Hope this clarifies.

Regards

Ram

Former Member
0 Kudos

hi

from which table i can get this valid end date(21/04/08).

Former Member
0 Kudos

There is no table which stores this valid-end date. Please go through my posts once again.

Regards

Former Member
0 Kudos

Hi,

System will set the valid to date by default as 31.12.9999.

Please letus know about have u changed the BOM with ECN.

Pradeep

Former Member
0 Kudos

hi

thanks for reply

yes . we maintained ECN. we created bom with ecn and changing bom item with change number.

Former Member
0 Kudos

Prakash,

Valid-to date is not maintained in any table. It is determined at run time depending on the valid-from date of the latest change. If you have changed a bom item with ECN then the valid from date of Change number - 1day becomes the valid-to date of the previous change.

Witout change number it is always 31.12.9999

Hope this clarifies.

Regards

Ram