Link Between Material Document and Accounting Document Tables

[Former Member]

Hi Abapers,

Can u pls tell me, How can i link Material Document Tables (MSEG and MKPF) and FI tables (BSEG and BKPF)?

The actual scenerio is when we confirm order in Production Planning. I want to pickup value from FI tables.

Thanx in advance.

Regards,

S.GUNA

[Former Member]

Check out the below ones

http://www.allsaplinks.com/tables.html

http://www.erpgenie.com/abap/tables.html

Regards,

Santosh

[Former Member]

Hi

BSEG and MSEG will have PO no and Item no EBELN and EBELP fields in common

but I suggest not to use BSEG and BKPF

better to use the BSIK and BSAK tables

Take LIFNR,EBELN and EBELP fields and enter in BSIK and BSAK table and take the BELNR field which is nothing but the acc doc and you can use it further to fetch from other tables

Regards

Anji

[Former Member]

hi

good

There is a link between BKPF and MKPF

BKPF-AWTYP = 'MKPF'

BKPF-AWKEY = MKPF-MBKLR + MKPF-MJAHR

Then you have to match lines of BSEG and MSEG on other criteria (quantity, MATNR, amount, etc.)

thanks

mrutyun^

[Former Member]

Hi Guna,

you can always use "Environmental Analysis" of the tcode where you are confirming the order., for finding the underying tables.

1. Get the main program of the Tcode (order), by system status menu facility.

2. Goto se38 and give the main program name and click the

Environmental Analysis button, the icon adjacent to where-used three pegged icon.

this will list the tables . narrow down to FI segment and find out.

Wishes,

Rajagopalan

[Former Member]

Thank u to all

[Former Member]

Thank u to all