topic Re: Extraction/Loading depedencies in Application Development and Automation Discussions

Extraction/Loading depedencies

Former Member — Wed, 07 Jun 2006 16:08:20 GMT

Hi,

I need to laod object dependencies in to new system 5.0.

I would like to know from which tables object dependencies data/values should be taken.

and how do we load these object dependencies..?can I load through LSMW..?

Any inputs would be appreciated.

Best Regards,

Satish

Re: Extraction/Loading depedencies

RichHeilman — Wed, 07 Jun 2006 17:07:16 GMT

As I mentioned in your other post, you can get the dependencies from the DB in the following fashion.

<i>You can make the link from your BOM items by linking STPO field KNOBJ to CUOB-KNOBJ. You will use "STPO" for the KNTAB field. Then go to CUKB to get the dependency name.

Here is a quick and dirty sample.</i>



 report zrich_0001.

 data: xmast type mast.
 data: xstpo type stpo.
 data: xcuob type cuob.
 data: xcukb type cukb.

 parameters: p_matnr type mast-matnr,
             p_werks type mast-werks,
             p_idnrk type stpo-idnrk.


 clear xmast.
 select single * from mast into xmast
           where matnr = p_matnr
             and werks = p_werks.


 clear xstpo.
 select single * from stpo into xstpo
        where stlty = 'M'
          and stlnr = xmast-stlnr
          and idnrk = p_idnrk.

 clear xcuob.
 select single * from cuob into xcuob
           where kntab = 'STPO'
             and knobj = xstpo-knobj.

 clear xcukb.
 select single * from cukb into xcukb
           where knnum = xcuob-knnum.


 write:/ xmast-matnr, xmast-werks, xstpo-idnrk, xcukb-knnam.

Regards,

Rich Heilman

Re: Extraction/Loading depedencies

RichHeilman — Wed, 07 Jun 2006 17:15:12 GMT

Maybe you can do a BDC over tranaction CU01. Not sure if it will work good or not.

Regards,

Rich Heilman

Re: Extraction/Loading depedencies

RichHeilman — Wed, 07 Jun 2006 17:17:05 GMT

Maybe you could get away with using the function module CUKD_API_DEP_MAINTAIN

Regards,

Rich heilman

Re: Extraction/Loading depedencies

RichHeilman — Wed, 07 Jun 2006 17:24:50 GMT

You can read existing dependencies using the function module CUKD_API_DEP_READ

Regards,

Rich Heilman