Skip to Content
0
Former Member
Oct 18, 2007 at 04:51 AM

DB View on MSEG , AFPO and AFKO

304 Views

I want to create a view based on the following conditions between tables - MKPF , MSEG , AFPO , AFKO

CONDITION -

1. Get the date based on the movement types ( tables mkpf and mseg )

2.I NEED TO LINK SALES ORDER AND SALES ORDER LINE ITEM field FROM MSEG and AFPO.

3. THEN AFTER DETERMINING THE PO FROM THE ABOVE CONDITION , LINK THE Production Order (AFPO) TO AFKO TABLE.

HOW CAN THIS BE DONE. PLZ HELP MATTER URGENT.