cancel
Showing results for 
Search instead for 
Did you mean: 

Record Missing out from PSA to DSO

Former Member
0 Kudos

Hi All,

We have a data flow that used 0FIGL_C20 cube and 0FI_GL_20 data source. We have to do full loads every day becuase there is not DSO in the data flow. Now, i have created a custom DSO and inserted in the data flow, but a lot of records are left out from the PSA.

Here are the Keys of my DSO:

Version

Company code

Fiscal year / period

G/L Account

Cost Center

Value Type

Profit Center

Partner profit center

Segment for Segmental Reporting

Partner Segment for Segmental Reporting

Fiscal year variant

Currency Type

Valuation View

Currency key

Ledger

Debit/credit indicator

I initially thought that the keys might be the issue but i have see in debug mode that for two records with same keys only one was loaded. The difference was only the credit amount.

Becuase a lot of the records are not loaded our balances do not match. Please share your thoughts, any help is appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Please compare the data extracted in PSA and that in the SAP tables.

If the data in the PSA is correct then :-

1. check the KF aggregation type.

2. Also check the total based on the credit debit indicator.

Regards,

Rahul

Former Member
0 Kudos

Hi..

In the transformation please check the aggregation type for the keyfigure....

If it is summation then for the same key combination the keyfigure value will get summed up...

But if it is overwritten then for the same key comnination only the last value will get updated.......because the previous one will get overwritten by the next one....

may be due to this it seems to you that some values are missing...

Regards,

Debjani....

Former Member
0 Kudos

Hi ,

Please have a look into the transformation - > KF . Are they Summation or Over-write ??

If they are over-write , you can understand why only one record is loaded for the same key combination .

Hope this helps .

--Neha