on 10-30-2013 5:18 PM
Hi,
I need to extract the costs of maintenance orders that are analyzed in the transaction MCI8.
I saw that in there DataSource 2LIS_17_I3HDR information quantity of orders as well as the transaction MCI8 but has no costs.
What better way to extract this information?
Extending the DataSource 2LIS_17_I3HDR looking for information from the S115?
Is there any datasource that make extraction data of table S115?
Thank´s
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vitor,
You can get the cost values using the data source :0COORDER_ATTR. Check this data source once.
Check the screen shot of the extract structure of this data source attached below.
Try to explore the data using this data soruce and see if this suffice your need.
I don't see any link between the tables used in the data source and the table which holds the Cost field.
try to analyze more in details with the help of functional person and check how to extract the cost values to BW.
@Martin Grob: S115 is a table which holds Cost Evaluation
Regards
KP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
I would enhance 2LIS_17_I3HDR rather than trying to pull S115. The LIS structures based on the S tables is old while the LO extraction is the new way to go.
hope that helps
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vitor,
Enhancing the standard data source will be good.
1. You can add required field to your extract structure
.2. At RSA6 Unhide it.
3. Maintain required logic to pull data form S115 at CMOD, EXIT_SAPLRSAP_001, RSAP00001, INCLUDE ZXRSAU01.
4. Test at RSA3 and replicate into bw.
5. If your data source was already in active then need to think about reloading data for added field if needs history data.
6. For LO data source, need to delete and refill set up tables(if need to load full load.)
pls refer the below link. it might be useful.
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/ef/bffe19adc041d18db0448983a5fba4/content.htm
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.