SAP Table: How get Document number list (BELNR) using as a filter the Profit Center (PRCTR)

[Former Member]

Hi community, I have lists of Profit Centers (PRCTR) and Company Codes (BUKRS) and I need get the Document numbers (BELNR) related of these information.

Someone know if exists a SAP table that have as a Key these filters?

[akshatrander1990]

Hi,

You can make use of these Tables as per your requirement. :

A  for Cleared Items

I  for Open iteems         

BSAD            Accounting: Secondary Index for Customers  "(Cleared Items)

BSAK            Accounting: Secondary Index for Vendors  "(Cleared Items)

BSAS            Accounting: Secondary Index for G/L Account  "(Cleared Items)

BSID            Accounting: Secondary Index for Customers

BSIK            Accounting: Secondary Index for Vendors

BSIS            Accounting: Secondary Index for G/L Accounts

Regards

Akshat

[Former Member]

Thanks for the reply. I tried those; but takes too much time to gather the information. I been looking for a table that use as index / key the Profit Center and the Company Code.

[Former Member]

Try GLPCA-REFDOCNR.

(with GLPCA-RBUKRS).

Rob

Message was edited by: Rob Burbank

[Former Member]

Thanks Rob. But when I'm using GLPCA and using as filter the profit center list in REFDOCNR; doesn't show any data. The REFDOCNR field is not even the Key/Index field of this table (I'm also tried filter by GU_RECID field without any result).

[Former Member]

REFDOCNR is the FI document number, not the profit center. RPRCTR is the profit center. You can use that to get the Profit center document from GLPCA and from that the FI document number.

And there is a secondary index on the profit center.

Rob

Message was edited by: Rob Burbank