topic Re: SAP Table: How get Document number list (BELNR) using as a filter the Profit Center (PRCTR) in Application Development and Automation Discussions

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

Former Member — Thu, 23 Apr 2015 15:39:31 GMT

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?

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

akshatrander1990 — Thu, 23 Apr 2015 15:51:41 GMT

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

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

Former Member — Thu, 23 Apr 2015 16:00:26 GMT

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.

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

Former Member — Thu, 23 Apr 2015 16:12:07 GMT

Try GLPCA-REFDOCNR.

(with GLPCA-RBUKRS).

Rob

Message was edited by: Rob Burbank

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

Former Member — Thu, 23 Apr 2015 17:39:14 GMT

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).

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

Former Member — Thu, 23 Apr 2015 17:49:20 GMT

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