topic Re: Function module to replace CSAP_MAT_BOM_READ in Application Development and Automation Discussions

Function module to replace CSAP_MAT_BOM_READ

Former Member — Sat, 16 Oct 2004 06:52:19 GMT

I have a requirement in which I use the function module CSAP_MAT_BOM_READ to read the material BOM. The problem is that there is a huge chunk of data and for each record it calls the function module which is causing a performance issue.

I tried to replace the funtion module with a join on STKO, STPO . But the problem is that in the funtion module there is some logic in which it checks the validity date which comes from Change Number.

Is there any function module which I can replace the existing one or any logic which can be implemented in the join condition?

Regards,

Ajith

Re: Function module to replace CSAP_MAT_BOM_READ

Former Member — Sun, 17 Oct 2004 14:17:51 GMT

Hi Ajith,

I'm not sure if this helps but here's a suggestion:-

Table MAST (Material to BOM Link) contains the BOM number for each material.

Tables STPO and STKO gives the information regarding BOM components.

Consequently:

Table STKO (BOM Header) can be linked to

Table STAS (BOMs - Item Selection) via:

STLNR (Bill of material) and

STLAL (Alternative BOM).

From this join you can then connect to the relevant entry in Table STPO (BOM item) via:

STLNR (Bill of material) and

STLKN (BOM item node number).

Within table STKO there is a field DATUV (Valid-from date) that can be used if you want to restrict the values based on validity date.

I hope this helps.

Hafeez

Re: Function module to replace CSAP_MAT_BOM_READ

Former Member — Sun, 17 Oct 2004 14:29:28 GMT

Hi Ajith,

Just to add to my previous mail:-

I've suddenly come across the following function module that you may find useful:

CS_BOM_EXPL_MAT_V2 (BOM explosion for material).

Again, I hope this helps.

Hafeez