Question:
Hi All,
I am finding a little difficult to datamodel the following and hope you would provide me a helping hand and I remain really thankful to you.
I have not used the BC extractor and I am on 2.1C with 2003.1 PI.
Below is the extract of the data model.
PO cube
PO #, Line #, PO date, PO qty, PO value
Inv Cube
PO#, Line #, PO date, Invoice#, Posting date, Inv QTY, inv Value.
Multicube
po#, Line#, PO date, Invoice#, Posting date, PO Qty, PO value, Inv Qty,
Inv Value.
Reporting Requirement:
Give me all PO's for the posting date eg 2005.01.01 - 2005.03.31.
Question?
1. I do not have posting date in PO cube, so does this provide me the right results that I am looking for??. My guess is that it is going to retrieve data from the Inv cube ONLY.
2. Would you think that BC extractor/cube can solve this kind of question?
3. Do you think ODS and ABAP will solve the problem? If so, how are we going to develop delta on this.
4. I am positive that it is very very simple using ABAP report. But, can we create datamodel without this.
5. Well, using ABAP, I could write an extractor and refresh the cube everyday, but, there are not many takers for this solution.
Would really appreciate your thought and any kind of help on this.
regards
Answer:
any help please
Answer:
You may want to create a Custom ODS and load 2LIS_02_ITM into it and 2LIS_02_ITM should have all you need. If not you can enhace 2LIS_02_ITM by adding create date from header tabl EKKO.
Good luck.
Answer:
Hi,
The PO Date is exisitng in the PO Cube but the data is not exisitng is what you are saying.
Sloution is PO date can be populated in the PO cube based on the Po order from the Inv Cube using update rule in the PO cube.
Then the data gets populated with the PO dates in the PO cube.
Report can be generated from the MultiProvider without any issues.
Hope this helps..
lnv
Answer:
I said posting date and not PO date.
Answer:
Hi,
although you're not using the SAP Business Content you should read http://help.sap.com/saphelp_bw33/helpdata/en/c5/a26f37eb997866e10000009b38f8cf/frameset.htm and the other documents regarding PO-data.
The Posting date is (I think) only filled when you have a goods receipt and not just when creating a Purchase Order or getting an invoice.
The way R/3 and the extractor handles this data with Business Content is that the Process Keys are identifying what kind of data is coming from MM.
You will have several lines for each PO-depending on what Process Type you have and then different fields are filled according to this. So the Posting date is blank when you just load a record with a Purchase Order that has been created. Then when there's a good recepit on this Purchase Order, the Posting date is filled but with the unique key of Process Key different from the one when the Purhase Order was created.
Kind regards
/martin