topic BOM - VAlid to date (DATUB) in Application Development and Automation Discussions

BOM - VAlid to date (DATUB)

Former Member — Thu, 20 Sep 2007 05:18:03 GMT

Hi All,

Can any one give me the tables from which i can fetch the "Valid To" date (DATUB) of BOM , I find DATUV(VALID From) in STPO but not DATUB .

The requirment is to get the Valid to date for all the Items of BOM of a material .

I tried using 'CSSF_STPOB_READ' Function Module but that did not help me anyways .

Please provide me the tables as well as the links to fetch the Valid to Date .

Thanks a Lot ..

Regard's

Sudheer V

Re: BOM - VAlid to date (DATUB)

Former Member — Thu, 20 Sep 2007 05:29:08 GMT

Hi sudheer,

please check the following tables...

STKO --- BOM HEADER

STPO -

BOM ITEM

MAST

AUFK

or use function module GET_STKO and you will get the valid-to date in the return table WA

<b>Reward points if helpful,</b>

Regards,

jinesh.

Re: BOM - VAlid to date (DATUB)

Former Member — Thu, 20 Sep 2007 05:43:47 GMT

Hi ,

Thanks for the reply ... But I am not finding DATUB (Valid to date) field in eighter of MAST or AUFK table . Also Get_stko FM has importing parameter as DATUV/DATUB , but the requirement is to get the datub field .

Can you brief out like wat values need to be passed to Get_stko Fm to get the DATUB value .

Thanks a lot ....

Regard's

Sudheer V

Re: BOM - VAlid to date (DATUB)

Former Member — Thu, 20 Sep 2007 06:17:03 GMT

Hi Sudheer,

The valid to date for BOMs is not stored in any table - SAP calculates and determines it. So you will not find it in any table.

What you can do is to use FM - GET_STPO. It returns a structure STPOB. This STPOB has DATUB in it, and fortunately it comes populated.

For your info - you can have a look at the code of this FM to know how DATUB is calculated.

Hope it helps.

Re: BOM - VAlid to date (DATUB)

Former Member — Thu, 20 Sep 2007 09:16:10 GMT

Hi Guys,

Thanks a lot for all the pain taken to reply back for the query, Finally I got the solution with "CABM_READ_BOM" FM .

Once again Thanks .....

Regard's

Sudheer V