I have a requirement where I am printing a sticker of medicine and two names come up while printing that is the first name is the product name and the below name is the generic name. Now the issue is that the name already comes as the generic name is from a table name TVM2T while the generic name I want is from the table T023T and the field name is WGBEZ. How can I join the T023T table? The tables used in the initialization are AFPO, STXH, MVKE, TVM2T, TVM5T, MAKT, MCH1, MARA, and T143T.
So, you are talking about material pricing groups (TVM2T) and material groups (T023T).
You want to join T023T.
Are you asking which table refers to the material group among AFPO, STXH, MVKE, TVM2T, TVM5T, MAKT, MCH1, MARA, and T143T?
Are you looking for MARA-MATKL to be "joined" with T023T-MATKL?
(of course, better not joining T023T because it's a buffered table)