topic Connecting tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907466#M378084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Can anyone tell me how to connect bseg to mseg. </P><P></P><P>Thanks,</P><P>Amit.</P></BODY></HTML> Sun, 11 Feb 2007 06:32:52 GMT Former Member 2007-02-11T06:32:52Z Connecting tables https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907466#M378084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Can anyone tell me how to connect bseg to mseg. </P><P></P><P>Thanks,</P><P>Amit.</P></BODY></HTML> Sun, 11 Feb 2007 06:32:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907466#M378084 Former Member 2007-02-11T06:32:52Z Re: Connecting tables https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907467#M378085 <HTML><HEAD></HEAD><BODY><P>Amit BSEG is accounting document line item whereas MSEG is material document. Have a check in table GLPCA if you can link them (offcourse via BKPF and MKPF)</P></BODY></HTML> Sun, 11 Feb 2007 08:00:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907467#M378085 Former Member 2007-02-11T08:00:32Z Re: Connecting tables https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907468#M378086 <HTML><HEAD></HEAD><BODY><P>There is no direct field you can join on, but you could connect them using the field BKPF-AWKEY. </P><P></P><P>If BKPF-AWTYP = 'MKPF', </P><P>BKPF-AWKEY = MSEG-MBLNR concatenated with MSEG-MJAHR.</P></BODY></HTML> Sun, 11 Feb 2007 17:08:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connecting-tables/m-p/1907468#M378086 Former Member 2007-02-11T17:08:33Z