0FC_OP_01 extractor issues- DFFKKOPBW data not matching with

[Former Member]

Hi All

We have an issue with the extractor 0FC_OP_01. Our business is comparing the values in

R/3 report u2013 G/L Account Balance Display (t-code S_ALR_87012277) with the

Open Items by GL Account report in BW .(actually these values in the BW report are coming from DFKKOPBW table in R/3) .

But since august, the R/3 G/L account balance report is not matching with the DFKKOPBW table balances. So bottom line the extractor 0FC_OP_01 is doing something wrong when populating the DFKKOPBW table which is causing these two reports to be out of balance

Did anybody face this kind of issue before? Please Advise.

FYI : We are following the same procedure to populate the DFKKOPBW table as in the below article.

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a9996115-0b01-0010-b2b2-d9de0170a...

Thanks

KPK

[mr_v · Accepted solution]

Since R/3 and BW report data is not matching, take couple of G/L Accounts into consideration and try to compare R/3 report (G/L Account Balance Display (t-code S_ALR_87012277)) with the PSA / Infocube data for a same G/L Accounts.. If PSA/cube data NOT matching with R/3 reports (for those G/L Accounts), then u should look into extractor...

If Cube data (for those G/L Accounts), matching with r/3 report, then u should look at filters (company code etc) that are using in BI... Another possibility at report level is, if that reports uses any hierarchy (G/L Account, FSV etc) and you filter unassigned nodes, then some data gets filtered.

[Former Member]

In my case the Cube/PSA data itself is not matching with the R/3 report data.

Basically we run a job in R/3 in t-code FPBW with a Date id and Indentification. This job will pull the entries from base table DFKKOP into DFKKOPBW table .Then FRom this DFKKOPBW table data is loaded into PSA/Cube.

Here in my case the data in table DFKKOPBW itself is not matching with the R/3 report - G/L Account Balance Display (t-code S_ALR_87012277)) .

I am following the same procedure to run the JOb in T-code FPBW to populate the DFKKOPBW table as listed in the document at the above link. Moreover this difference in balances is occuring only starting from August ..Till July the balances in DFKKOPBW tally with the R/3report.

Please advise ..

Thanks

KPK

[former_member208595]

Hi,

Table - DFKKOPBW will have all open items data, it wont have any GL- Accounts data.

In R/3 , use this tcode for GL balance display - FAGLB03 ( Balance Display ). Use datasource- 0FI_GL_10 for GL balance display reporting in BW.

[Former Member]

Hi,

Do you found a solution for this issue , I also tried to compare DFKKOP and DFKKOPW for a key date after running the Mass transaction, Both are also not matching for me?

Any help on this will be appreciable.

Deepak