Input to Demand Planning
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,
Klaus Gasch replied
Excuse me, but yes, you can use APO BW just like any Netweaver 2004s BW to directy extract from R/3 using the standard extractors.
I have personally done it several times, you will be looking for extractors starting with 2LIS_11_....., which are pointing at the respective sales order tables of R/3. 2LIS_12_ looks at deliveries.
Requirement is, that the R/3 is defined as a source system for the APO BW. Then, you can use transaction SBIW (BW Customizing) to explore and activate the extractors and delta processing.
It is much easier than uploading files, once it is running, but to get there you will need to have a somewhat experienced BW guy.
Of course, if there is another BW in place, you are well of and connect to this one, if they extract from R/3. Then, you do not have as much work.
Again, I highly recommend NOT to use files uploads!