cancel
Showing results for 
Search instead for 
Did you mean: 

2lis_03_bf data source

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

ravi_chandra3
Active Contributor
0 Kudos

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.

former_member182343
Active Contributor
0 Kudos

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.

  • Initial Stock........ 2LIS_03_BX ---- Full update ---  with marker, means not selecting "Without marker checkbox" 
  • Historical movements.......2LIS_03_BF----Init update --without marker, means selecting "Without marker checkbox" 
  • Revaluation .................2LIS_03_UM --------Init update --without marker, means selecting "Without marker checkbox"

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

http://sapedw.blogspot.in/2012/01/trouble-shooting-in-inventory.html#!/2012/01/trouble-shooting-in-i...

Regards,

Vijay

Former Member
0 Kudos

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.

ravi_chandra3
Active Contributor
0 Kudos

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,

former_member182343
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Ravi,

I agree with your point that it fetches combination of records from MSEG and MKPF, but still will there be such a big difference in count. Also can you clear me on setup tables too why it has such a least number of record count, thought its just a cluster table.

Thanks Ravi

Former Member
0 Kudos

Hi Vijay,

Thanks for your reply. Surely will validate with taking plant/material.

Thanks

ravi_chandra3
Active Contributor
0 Kudos

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.

manna_das
Contributor
0 Kudos

This message was moderated.

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Raman,

I have filled the setup tables through date range, anyway I have considered the same date range even in MKPF table to know the exact No of records available in it. Moreover will try the one you suggested by increasing the number.

Thanks Raman.

Former Member
0 Kudos

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.

RamanKorrapati
Active Contributor
0 Kudos

Hi Karan,

While filling setup tables your filling to specific application not for specific data source. but your data source pulls data as per the logic was build in your extract structure.

Other wise you can cross key fig/net amount values ex specific MATNR/material.

Thanks

Former Member
0 Kudos

Hi Raman,

We're filling set up tables for this specific data source(2lis_03_bf) here i.e OLI1BW transaction (Material Mvmts) not for application component and moreover done the extraction for this data source only.

Thanks Raman

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Raman,

I agree with Ravis' input will check by taking some plant/material combination to validate the data.

Thanks

ravi_chandra3
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi Ravi,

There were no filters at BI side as such. Will look into increasing the data package size in rsa3.

Thanks Ravi.