BOM - VAlid to date (DATUB)

[Former Member]

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

[former_member197281]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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