WERKS & BUKRS Link

[Former Member]

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

abhishek suppal

[andreas_mann3]

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

[Former Member]

hi,

T001W, T001K will be helpful for u.

Cheers,

Sasi

[Former Member]

hi,

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

[RichHeilman]

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