We are currently setting up the demand planning in APO. R/3 needs to produce flatfiles for Sales Open Orders for different countries and customer --> this one is okay and I understood it correctly..
what confuses me now is that they are also asking for Goods Issue data.... and I confirmed with them that is it a Goods Issue which is of purchase orders... or sales orders... as per I am a technical person..
The structure of the flat file should contain the ship-to and sold-to customers and and loading date for that flatfile for the Goods Issue theyre saying... but what I assume is that they needed the deliveries data which is under sales documents.. because all of the fields they were asking can be retrieve from deliveries (LIKP and LIPS)...
They have existing programs before which doesnt used for APO but for other system... when i check the programs I just noticed that they're extracting data from purchase orders with open receipts items... and check it with the scheduling line aggrement (EKET).
Now its confuses me alot... should it be deliveries from sales documents
goods issue.. purchase orders with open receipts item... --> if this is the case... how can i retrieve the sold-to customer and ship-to customers?
Thanks and regards,
Murali Mohan replied
There are two types of deliveries
1.Outbound deliveries -->These will from sales order to create this deliveysales order will be taken as reference document
2.Inbound deliveries --> These will from PO to create this delivey PO will be taken as reference document
Transaction to create outbound deliveries is VL01N
Transaction to create inbound deliveries is VL31N
Both the deliveries data will be stored in the LIKP and LIPS tables.
So finally what you need to under stand is delivery data means you need to consider both.
I hope this will help you,