topic Re: WERKS & BUKRS Link in Application Development and Automation Discussions

WERKS & BUKRS Link

Former Member — Wed, 14 Sep 2005 10:51:51 GMT

Which table/ FM can i get the link bet. WERKS and BUKRS.

abhishek suppal

Re: WERKS & BUKRS Link

andreas_mann3 — Wed, 14 Sep 2005 11:23:58 GMT

Hi,

you've to analyze 3 tables : t001, t001k and t001w

-> a help could be to create a join like help-view H_T001W_BUKRS (SE11)

regards Andreas

Re: WERKS & BUKRS Link

Former Member — Wed, 14 Sep 2005 12:58:12 GMT

hi,

T001W, T001K will be helpful for u.

Cheers,

Sasi

Re: WERKS & BUKRS Link

Former Member — Wed, 14 Sep 2005 13:01:31 GMT

hi,

T001k is the correct one i guess. awkey is the werks

Re: WERKS & BUKRS Link

RichHeilman — Wed, 14 Sep 2005 13:07:46 GMT



report zrich_0002
       no standard page heading.



data: begin of itab occurs 0,
      bukrs type t001k-bukrs,
      bwkey type t001k-bwkey,
      werks type t001w-werks,
      end of itab.


select t001k~bukrs t001k~bwkey t001w~werks
      into corresponding fields of table itab
         from t001w
               inner join t001k
                   on t001k~bwkey = t001w~bwkey.


loop at itab.

  write:/ itab-bukrs, itab-bwkey, itab-werks.

endloop.

Regards,

Rich Heilman