Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Link between MM anf FI table

Former Member

‎2007 Dec 14 6:46 AM

0 Likes
836

Dear All,

i have fetched (MBLNR MJAHR ZEILE MATNR WERKS LIFNR MENGE ERFMG BPMNG BPRME EBELN EBELP LFBNR SMBLN AUFNR BELNR BELUM LSMNG MWSKZ) from MSEG table now i want to link it with FI table RBKP (Document Header: Invoice Receipt) table but i dont have a link which is primary key from one table to another the only field common is LIFNR which is not a primary key can anyone plz giv me link between mseg and rbkp via any ther table

Dear All,

i have fetched (MBLNR MJAHR ZEILE MATNR WERKS LIFNR MENGE ERFMG BPMNG BPRME EBELN EBELP LFBNR SMBLN AUFNR BELNR BELUM LSMNG MWSKZ) from MSEG table now i want to link it with FI table RBKP (Document Header: Invoice Receipt) table but i dont have a link which is primary key from one table to another the only field common is LIFNR which is not a primary key can anyone plz giv me link between mseg and rbkp via any ther table

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Dec 14 6:56 AM

0 Likes
627

Hi,

Please check that MBLNR of MSEG is equal to BELNR of RBKP.

Reward points, if helpful,

sandeep kaushik

Read only

Former Member

‎2007 Dec 14 7:05 AM

0 Likes
627

Dear Sandeep,

the two u mentioned above are not equal

Read only

Former Member

‎2007 Dec 14 12:37 PM

0 Likes
627

Hi

Try RBKP XBLNR field. It might work.

Cordially

Shankar Narayanan.