I want to create a view based on the following conditions between tables - MKPF , MSEG , AFPO , AFKO
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.