cancel
Showing results for 
Search instead for 
Did you mean: 

DSO Problem

Former Member
0 Kudos

Hi Guys

i have activated 0fi_GL_10 to get closing balance

i activated 0FIGL_o10 DSO and i displayed data in it but balances are not correct

some transaction in the ECC not found in the DSO

i created a Cube and extracted the data from the data source 0fi_gl_10 to the cube directly without DSO and displayed the data

it looks fine

so the problem seems to be with the DSO

View Entire Topic
Former Member
0 Kudos

Hi Elhoussiny,

You can check the structure of your DSO because with AIE delta type we need to use the DSO, directly extracting data to cube is not the right approach.

If possible, you can share which fields you used as data fields and key fields in DSO.

BR,

Rashi

Former Member
0 Kudos

Hi Rashi

I am using The standard DSO 0FIGL_O10

I didnt change anything in it

former_member186399
Active Contributor
0 Kudos

Dear Elhoussiny

If you are using the standard 0FIGL_O10 and you have mapped the keyfigures as overwrite then the balances has to be match.

You will have to do a little bit of exercise here. Find out which GL account is having mismatch. What is the difference of balance that you are getting in ECC and in the DSO. Check the value in PSA as well.

Based on that arrive where the issue is

Regards

Gajesh

Former Member
0 Kudos

HI Gajesh

all balances are wrong

even P/L GL

there is some transaction in the ECC not reflected in the DSO side

seems like some transaction are overwritten

so how to solve it

i mean when i loaded data directly to the cube all balances were correct

so how can i discover the issue with DSO

one more thing i am using the standard DSO 0FIGL_O10

former_member186399
Active Contributor
0 Kudos

Hi Elhoussiny,

Do one thing, 0FI_GL_10 supports loading for a particular period for a particular GL account. Clear all the data from PSA.  Load for one period and for one GL. Check the PSA data and then check the data in DSO after loading .  Make sure the 0Balance key figure mapping is overwrite and not summation in the transformation. Also make sure the currency type is not overwriting the data.

Also let me know the key fields that you are using in 0FIGL_O10.

Regards

Gajesh

Former Member
0 Kudos

Hello,

Check this link for the structure of DSO 0FIGL_O10

General Ledger (New): Transaction Figures (SAP Library - General Ledger Accounting (New))

You can first check the data in PSA before loading to DSO if it is correct or not.

Former Member
0 Kudos

Hi Gajesh

i am using

Key Field

Description

0VERSION

Version

0COMP_CODE

Company code

0FISCPER

Fiscal year/period

0GL_ACCOUNT

G/L account

0FUNC_AREA

Functional area

0COSTCENTER

Cost center

0VTYPE

Reporting value type

0PROFIT_CTR

Profit center

0SEGMENT

Segment for segment reporting

0FISCVARNT

Fiscal year variant

0CURTYPE

Currency type

0VALUATION

Valuation view

0CURKEY_TC

Currency key: Transaction currency

0UNIT

Unit of measure

and i have added the 0move_type as a key field

i have checked only 1 period and only 1 GL

i found that there is a debit transaction in the ecc not reflected in DSO side

i changed the period and checked the same GL

i found that the difference increased which mean that some other transactions not reflected in the DSO side

former_member186399
Active Contributor
0 Kudos

Hi

Your DSO seems to be right. Can you confirm the mapping for your key figures are overwrite. For the same GL can you check in PSA what is the scheme of entries. And please note 0FI_GL_10 bring both currency types so hope that is not creating a confusion here.

How are you check in ECC. What is the tcode you are checking.

Regards

Gajesh

former_member182599
Active Participant
0 Kudos

Can you list the fields in the Data Field section.

Thanks

-Sid