New GL Tables for GL accounts not open item managed

[Former Member]

Hi Experts,

I'm creating a billing statement report for customers, and I'm looking into the line item postings of the document. Is there another table where I can view it aside from BSEG? The GL accounts are not open item managed nor enables line item display based the master record. However, since were using New GL, line item display is possible. Thank you.

[Former Member]

Thank you for your reply Shashi.

But what I'd like too see are the other line item postings, In this case the credit postings, not the customer line items. What I'm doing now is to search in BSEG for the document to get the GL line items. Are there other tables I could look into? Thank you.

Regards,

Reiko

[former_member193516]

Hi,

check BSIS for open GL items, BSAS for cleared items.

Regards

Hein

[Former Member]

Hi Reiko,

Along with customer the line items will be posted to GL Accounts.

The GL account tables are BSIS & BSAS.

BSEG Table is a cluster table, its not recommended to use this table for the developments. So its always suggested to use the individual tables.

Thanks & Regards,

Shashi Kanth.

[Former Member]

Hi Hein,

I have tried looking into BSIS and/or BSAS, but the document I'm looking for can't be found there. I suppose its because the GL accounts were not enabled for line item display/open item management. Any other suggestions? Thanks.

Regards,

Reiko

[Former Member]

Hi,

Customer Open Items Table (FI) - BSID (Open Invoices/Billing Documents)

Customer Cleared Items Table (FI) - BSAD ( Cleared/paid Invoices/Billing Documents)

Billing Documents Header Table (SD) - VBRK

Billing Documents Item data Table (SD) - VBRP

Please look into above tables.

Thanks & Regards,

Shashi Kanth.