Missing documents in Bi

[Former Member]

Hi,

Can any one suggest me on this issue .In R/3 some documents has been closed but in BI system still it showing in open status.

if i comare documentdatewise ,netdue date wise data is matching and if i comapre posting date wise data is not matching .any one suggest me on this issue.

Regards

Rk

[former_member182516]

which report are you referring to for checking the below info.

if you are referring to FBL5N report then

select line item selection --all items

and

type - normal and special ledgers...

[Former Member]

Hi,

Thank you very much for your reply .consultant is saying that document has been closed in r/3 but why it is showing open in BI system . we dont much about in r/3 functnality .

Regards

Rk

[former_member182516]

Try to extract the data today and compare... might be the changed documents are not extracted to BW.

When was the last time data was loaded to BW side... ?

[Former Member]

Hi,

Thank you very much for your reply . Iam comparing the data on the of 31.12.2010. there is no data problem because if compare the documnetdate, netduedate wise data has been matching the only problem is posting date wise data is not matching.

Regards

Rk

[Former Member]

Hi Prasanth,

Do you any other ideas on this issue , so it will helpful us.

Regards

Rk

[former_member182516]

You need to match the records posting date wise... not net due date wise...

I don't understand one thing why the data is not matching when compared with posting date.

the records must be same right when compared to posting date or net due date.

In the report FBL5n you have option closed items in the selection screen select that option and enter the date and check if you can get the closed items...

[Former Member]

Hi,

thank you verymuch for spending time in this issue . Here we have 3 reports like documentdate wise, netduedatewise, posting date wise ageing report . Documentdatewise,netduedatewise data has been matching but only the problem in postingdatewise problem and this report document status is O means open .Do you have any alternate ideas appreciated to you.

Regards

RK

Edited by: kolli sivaraju on Feb 24, 2011 7:56 AM

[former_member182516]

Hi,

Check the report design some thing might be causing the problem....

May i know the report fileds n restrictions... postingdate wise reprot.

Regards

KP

[Former Member]

Hi,

There can be many reasons why some documents are still open in BW.

1. Delta is not captured by extractor, when document is closed

solution:

check in rsa3 (Source system side) if the lates status is captured during full load

check user exit if exist for this extractor

2. Delta is captured but it is not visible in BW

solution:

check in change log table (if you load data to DSO) if status changes are captured

if not debug loading to find the reason

3. Data is correct in BW, but report display wrong information

it must be something wrong with query try to display definition of Key figure, to identify the issue.

It's really hard to give you some clues if we don;t'know details about your flow.

Regards,

DL