on 05-15-2013 6:29 AM
Hi All,
I have deleted and fill the setup tables of 2lis_03_bf data source. When I extracted till PSA using full load, total of some 6+ lakh records got fetched, but there were only 2+ lakh records in MKPF table which is the main source of BF data source. In RSA3 I have got 13k records and in set up tables there were nearly 5k records. I have gone through some threads wherein which I came to know that there will be a light mismatch in between application tables, set up tables and in PSA, but now I came across a situation wherein which there is a huge mismatch in the record count.
Hi
You can perform the data reconcilation at both r/3 and at bw side, If both the results reflect the same then it results the perfect extraction.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In case of inventory, validating data with ECC stock is different .
Let us validate stock with respective to Material/Plant in 0IC_C03 with MC.9.
Down time is mandatory for this activity.
Use 0RECORDTP and restrict with 1 and get sum of Recipts. The same validate with MC.9 or MB5B/MB51.
Otherwise create a query on top of 0IC_C03 and use 0TOTALSTK and validate data with MC.9 or MB5B with Plant and material level.
You can get documents in sdn regarding validating inventory data .
http://www.stechno.net/sap-notes.html?view=sapnote&id=1548125
Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay,
I have just deleted and filled setup tables for particular date range and done the extraction. My query is will setup tables record count match with the RSA3 record count? Also I just want to clear one thing, there is nearly 2lakh records in my application table MKPF for the date range whereas nearly 6lakh records got fetched when I done extraction in BI side with full load and even in RSA3 also.
Thanks Vijay.
Hi karan,
In the ds 2lis_03_bf the various tables present are MSEG,MKPF so when you extract the data the data will be in the combination of the MSEG and MKPF .
It doesn't mean that if the application table has 2 lakhs records then the ds should also contain the same record.
It depends on the combination of records present in the below table.
Hope u got it,
Hi Karan,
2LIS_03_BF gets data from both MSEG & MKPF.
You will get information like Doc Date from MKPF.
This is the reason why you are getting more records.
What I am stressing reagrding Inventory is - dont validate inventory data with respect to data record count.
Validate total stock (closing) of specific Plant/material with ECC report or MSEG table.
Regards,
Vijay
Hi
Have you counted the number of records present in r/3 and in bi.
Please don't count the number of records , instead just verify the data with some plant and keyfigure combination or in material and keyfigure combination.
just go to rsa3 and then give the plant and some keyfigure and then extract the data and then perform the aggregation of that keyfigure ,(select the keyfigure and then click on sigma buton on the top , it will display the sum of that keyfigure corresponding to the given plant).
Note: give the max. number of data packet and no. of records.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karan,
While checking at RSA3, there are extract calls like that, you can increase the number and execute it. you will get all available records.
at info pack check selection tab, is there any selections? While filling setup tables have you filled selectively like plant or any date wise.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raman,
I have increased the extract calls at RSA3 and the record count matched at both RSA3 and PSA level in BI side, but my doubt here is mainly whey there is a huge difference in the record count of set up tables and RSA3, though set up tables are like cluster tables, will there be this much difference?
Thanks Raman.
Hi karan,
Accept with Ravi chandra, when we compare rsa3 records count with base tables, never be the same. because when we pull data into rsa3, we get combination records from source tables. we may get less count reocrds at rsa3 compare to base tables.
Rather than comaring number of rec, you can check record combination data in base tables and at rsa3. that may give clarity.
Thanks
Hi karan,
Please increase the data package size in rsa3 and then view the data in the rsa3 .
and please once check whether any filters are written at bi side.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.