cancel
Showing results for 
Search instead for 
Did you mean: 

What table to use for report painter trial balance report by document type?

dan_sullivan
Active Contributor
0 Kudos

We need a trial balance report with columns by document type but cannot find a table for this.

Any help with this is greatly appreciated.

View Entire Topic
former_member184878
Active Contributor
0 Kudos

Hello,

For balance sheet report total tables are relevant:

GLT0 (classical GL)

Faglflext (SAP nGL)

at total tables we do not have document type available.

Developing Z* report might be helpful.

If you just need a total per account you can use:

GLT0 for balance carry forward values

BSEG for current year values

Balance carry forward + current year = total today.

additionally you have to add BKPF table for document type per document/GL account.

br erwin

dan_sullivan
Active Contributor
0 Kudos

Erwin,

Thanks, but GLT0 does not include the document type and we are classic GL so GLAGLFLEXT doesn't help.

Are you suggesting an ABAP program report? If so, we are trying to avoid that by using report painter.

Any further suggestions are greatly appreciated.

Thanks again,

Dan

former_member184878
Active Contributor
0 Kudos

Hello,

So you have to take into account table BKPF

here we have document type, I mentioned above.

You take BSEG table for current year.

For each GL account in BSEG  you can "add" docuemnt type.

speak with ABAP colleague, creating ZBSEG table move data with move corresponding from BSEG to your ZBSEG table, and add colum docuemnt type.

information for this colum you get from BKPF table.

key to read BKPF table - doc+, burks, and gjahr,

I tried drawing a picture about my design, hope it helps.

br erwin

former_member184878
Active Contributor
0 Kudos

Hello,

Let me show you my idea with Tcode FB03.

Here you can see document and document lines = BSEG table.

You als have available document header information = BKPF table.

I think you need document type information per posting line.

Then calculate total per GL account and document type.

Am I right?

br erwin

dan_sullivan
Active Contributor
0 Kudos

Thanks

I already know this but was hoping there was some table or structure I an unaware of that could be used to create report painter report without ABAP or new SPL.

former_member184878
Active Contributor
0 Kudos

Hello,

Thank you very much for your feedback.

Yes, there is no data/table available which might support you.

all the best erwin