cancel
Showing results for 
Search instead for 
Did you mean: 

FAGLBW03 : FI data source creation for non leading ledger / Memoranda ledger based on FAGLFLEXT table

former_member419358
Participant
0 Kudos
513

Hello Everyone,

I wanted to generate Finance report in BI based on Memoranda Entry ledger (Z1) as mentioned in below screenshot. FAGLFLEXT table is having transaction data for Z1 ledger but 0FI_GL_10 data source doesn't bring Z1 ledger information.

I have gone through certain threads and found out that we will have to generate our own data source for any other ledger. I went to FAGLBW03 t-code in ECC as mentioned in below screenshot but couldn't find Z1 ledger.

Can anyone provide input on how to generate data source based on FAGLFLEXT table based on Z1 Ledger ?

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Repeated post.

Regards,

Sandeep

former_member419358
Participant
0 Kudos

Hi Sandeep,

Thanks for your reply.

I have gone through the link before. I am not getting Z1 Ledger in FAGLBW03 and that is why I am not able to proceed further which I have mentioned above but I see transaction data with resepct to Z1 ledger in FAGLFLEXT table.

How can I get Z1 ledger in FAGLBW03 to create data source for the same ?

Former Member
0 Kudos

Check this whether it is turned on - FIN_GL_CI_1 - Business Function (=> transaction code SFW5)

former_member419358
Participant
0 Kudos

Hi Sandeep,

Yes. I have below two business functions activated.After that I checked FAGLBW03 but still I am not getting Z1 ledger option to create data source for the same.

FIN_GL_CL_1

FIN_GL_CI_2

Also, I just checked table T881 which is ledger master. I didn't see Z1 over there but I can see rest other ledgers which I could see in FAGLBW03.

Thanks once again.

Former Member
0 Kudos

Better if you can open an OSS note now or search it for your SP.

Former Member
0 Kudos

Check if you can entry value in both tables for your ledger.

Tcode SM30 -> view V_T894  or V_FAGL_T881, then create new entries for your ledger.

Regards,

Sandeep

former_member419358
Participant
0 Kudos

Hi Sandeep,

I am working on ECC on HANA with Simple Finance so  I will have to go for ACDOCA table and data source to solve this issue. I have checked 0FI_ACDOCA_10 data source and it gets all ledger details.

Z1 is extension ledger to 0L which is why it's not showing in any view mentioned above table or views.

Thanks once again for your help and input on this.

Former Member
0 Kudos

Glad to hear that... good that you have shared the solution...it will be helpful for the community