How to use fiscal year and fiscal period in 0FIGL_V10?

[wen-wei_chuang2]

Dear experts,

I tried to create a query based on 0FIGL_V10.

In rows I restricted fiscal year(0FISCYEAR) so that I can get this year and last year.

(I want to compare the difference between two years.)

In columns, first I put fiscal period (0FISCPER3) because I need to show 12 months in columns.

Then I created a structure to restrict 0GLACCEXT to some accounts and drag the standard CKF "Balance sheet value".

The result is incorrect.

I found that in note 801313 SAP said I can only use 0FISCPER.

It would be incorrect if I use 0FISCYEAR and 0FISCPER3.

But I need to compare two years and also need to show all months in my report.

What should I do??

Any suggestions??

Please help. Points would be given.

Thanks.

[sven_mader2 · Accepted solution]

Hi,

I don't know this data modell. But the sap node describes your problem.

- Insert 0fiscper in your query

- select this charateristic in your query.

=> for excample with a customer exit variable. there you can implement from 001. last fiscal year to 016. actual fiscal year.

Sven

[wen-wei_chuang2 · Accepted solution]

Hi, Sven,

Thanks for your reply.

However, I can't put 0fiscper in my query.

The requirement is to have a report like this:

            1    2     3     4     5    6    7     8    9   10   11   12
2010
2009

So, you see, that's why I put fiscal year in rows and fiscal period in columns.

I can't put 0fiscper in either row or column.

Any other suggestions??

Thanks in advance.

[wen-wei_chuang2 · Accepted solution]

Please, any suggestions for me??

Does anyone ever bump into this problem??

[Former Member · Accepted solution]

Dear,

sorry to interupt this chain.

Can you explain me how you solved "Actual cost component split not active for plant EQPE" error for datasource 0CO_PC_ACT_10, what is the way to get the detail as per CKM3N

How to get all the data as per Material Ledger - CKM3N

Thanks in Advance