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.

Accepted Solutions (1)

Accepted Solutions (1)

venkat_dasigi4
Explorer
0 Kudos

Hi Dan,

Since document type is not included in the standard ledger, you may have to define a custom ledger (kind of a SPL solution) and include Document type and other fields you would like to have. That may be an alternative.

Thanks,

Venkat

Answers (2)

Answers (2)

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

Former Member
0 Kudos

I have not seen that kind of wish on the report painter. report painter isusing faglflext tables for this  kind of reports and these tables is the totals table so in you requirement you want to summerize the documents based on the document type instead of account or you want to see the document posting during a period. Maybe journal canhelp you

try reports :

S_ALR_87012282  AND   S_ALR_87012287

dan_sullivan
Active Contributor
0 Kudos

Mustafa,

Thanks for your reply. We are using classic GL and have existing trial balance using table GLT0.

However due to recently converted new companies using a unique document type, we would like a trial balance report that separates the conversion data from new transactional data for all other document types.

The trial balance are the cumulative balances by account.

Any help with this would be greatly appreciated.

Thanks again,

Dan

Former Member
0 Kudos

I am not familiar with GLT0