Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to link BUZEI of BSEG with ZEILE of MSEG

Former Member
0 Kudos

Hi all,

We have an urgent requirement where in we need to read from my BSEG table (BUZEI) the corresponding item in the mseg table (ZEILE). the MSEG table have the BELNR and BUZEI fields , but they are empty.

Thanks in advance

Sanju

2 REPLIES 2

Former Member
0 Kudos

hi sanju,

since your belnr and buzie fields is empty so now u can use matnr as alternative but avoid to use inner join you should use ' for all entries' for joing the two table.

regards

vijay dwivedi.

rewards if answer is usefull to you*

Former Member
0 Kudos

Hi

Generally we don't use the BSEG table for linkups with MM related data

Use BSIK or BSAK tables instead of BSEG

link the MSEG-EBELN and the BSIK-EBELn or BSAK-EBELN field and get the BELNR and BUZEI fields from BSIK and BSAK.

Reward points if useful

Regards

Anji