Chart of Accounts

[Former Member]

Dear Experts,

I Have one clarification,

I want to export Chart of Accounts Split Up & Segregate Level Wise.

For Example Export Chart of Accounts in Excel.

All the ledger get in to single sheet.

I want to export as level wise?

Level 1: Asset                      Level 2 : Current Asset             Level 3 : Stocks                   Level 4 : WIP            Level 5 : Work in Progress

Like that i Want to segregate & Export

Please help me ??

[Former Member · Accepted solution]

Hi Mohamed,

Generate a Query and Export the same to Excel.

"SELECT T0.[AcctCode], T0.[AcctName] FROM OACT T0"

You can do the same using Query Generator.

Then export to Excel format...

JO

[Former Member · Accepted solution]

Hai Jo,

Thanks for the reply,

But My Requirement

If Asset Drawer,

Level 1: Asset                      Level 2 : Current Asset             Level 3 : Stocks          Level 4 : WIP         Level 5 : Work in Progress

If Liability Drawer :

Level 1:                                Level 2:                        Level 3:                     Level 4:                             Level 5:

If Equity Drawer :

Level 1:                                Level 2:                        Level 3:                     Level 4:                             Level 5:

If Revenue Drawer :

Level 1:                                Level 2:                        Level 3:                     Level 4:                             Level 5:

If Expense Drawer :

Level 1:                                Level 2:                        Level 3:                     Level 4:                             Level 5:

Not Continuous & All the Drawer together & Export

I want Export Drawer wise as well as level wise.

[Former Member · Accepted solution]

Try clicking on "Excel" Icon in Chart of Accounts.

However, you can export to excel drawer-wise only.

[Former Member · Accepted solution]

Hai Jo,

All the drawer Ledger Need to export Single Excel not a drawer wise exporting more number of Excel..

[Former Member · Accepted solution]

Hai,

SELECT T0.[Fixed], T0.[AcctCode], T0.[AcctName], T0.[GroupMask] FROM OACT T0 ORDER BY T0.[Levels]

[Former Member · Accepted solution]

Good Job, You figured out yourself.

[former_member212181 · Accepted solution]

Hi Yousuf, Please try below query . this will work if all your GL Accounts are level 5. Thanks Unnikrishnan Select E.AcctCode[Level1Code], E.AcctName[Level1Name] ,D.AcctCode[Level2Code], D.AcctName[Level2Name] ,C.AcctCode[Level3Code], C.AcctName[Level3Name] ,B.AcctCode[Level4Code], B.AcctName[Level4Name] ,A.AcctCode[Level5Code], A.AcctName[Level5Name] From OACT A Left Outer Join OACT B on A.FatherNum =  B.AcctCode Left Outer Join OACT C on B.FatherNum =  C.AcctCode Left Outer Join OACT D on C.FatherNum =  D.AcctCode Left Outer Join OACT E on D.FatherNum =  E.AcctCode Where A.Postable='Y'

[Former Member · Accepted solution]

Hai Unni,

In Your Query Equity,Revenue & Expenses Fetching Wrong  Level..

Can u ??

[Former Member · Accepted solution]

Hai Unni,

Instead of Level 1 fetching as Level 2 like that...Please can u??

[former_member212181 · Accepted solution]

Hi Yousuf As I said earlier this query will works only if you maintain all active GL accounts in one level. I made changes in query, now it will work in concept of your all active GL accounts are in level 4. Select --E.AcctCode[Level0Code], E.AcctName[Level0Name], D.AcctCode[Level1Code], D.AcctName[Level1Name] ,C.AcctCode[Level2Code], C.AcctName[Level2Name] ,B.AcctCode[Level3Code], B.AcctName[Level3Name] ,A.AcctCode[Level4Code], A.AcctName[Level4Name] From OACT A Left Outer Join OACT B on A.FatherNum =  B.AcctCode Left Outer Join OACT C on B.FatherNum =  C.AcctCode Left Outer Join OACT D on C.FatherNum =  D.AcctCode --Left Outer Join OACT E on D.FatherNum =  E.AcctCode Where A.Postable='Y' Thanks

[Former Member · Accepted solution]

Hai Unni,

Query Can not execute in SAP Query manager Getting Error as " [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'Select'. 'Received Alerts' (OAIB)"

[former_member212181 · Accepted solution]

Hi Yousuf

Please try now

Select

  D.AcctCode[Level1Code], D.AcctName[Level1Name]

  ,C.AcctCode[Level2Code], C.AcctName[Level2Name]

  ,B.AcctCode[Level3Code], B.AcctName[Level3Name]

  ,A.AcctCode[Level4Code], A.AcctName[Level4Name]

From OACT A

  Left Outer Join OACT B on A.FatherNum =  B.AcctCode

  Left Outer Join OACT C on B.FatherNum =  C.AcctCode

  Left Outer Join OACT D on C.FatherNum =  D.AcctCode

Where A.Postable='Y'

thanks

Unnikrishnan

[Former Member]

Dear Experts,

Its Very Urgent Basis. Please help me