Hey SD experts
I need to give a solution on transportation planning for the business which is currently planned on excel sheets. Currently they get the sales order list and assign it to a particular route. Each route consists one or more trucks. They also maintain a fixed schedule from mon to sat where they have assigned which customer orders to be delivered. Thus once a sales order is received ( normally when a sales order is created the next day the delivery is created) the employee will look on the customer and check the weekly schedule on when the delivery should happen. Once thats decided on the delivery day truck will be decided depending on the route. How can I satisfy this requirment on SAP. Thanks in advance.