Skip to Content
author's profile photo Former Member
Former Member

Record Missing out from PSA to DSO

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2011 at 10:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2011 at 11:21 AM

    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....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 05:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.