I’ve searched the internet where I could possibly find One-time Vendor and One-time Customer data. You know what? I could not find any site telling the best table to find what I am looking.

Most of the sites I visited are mentioning about BSEC, One-Time Account Data Document Segment table. Well, I’ve checked the table and yes it’s a table for One-time vendor/customer transaction data. However, what if the transactions have originated from PO (MM Module)?

Using BSEC table to get one-time vendor/customer data pose a problem for transactions that originate from PO (MM Module).  Because the field that you use to access BSEC is belnr (accounting document number) and gjahr (Fiscal Year). And the belnr that you need is the document number created in accounting not the document number created from PO. To look for the created belnr of a specific PO you need to access table BSEG, and hell it’s cluster table. And worst is, belnr is unknown so it will definitely mess up your program performance because belnr is a key field.

I’d like to share what I’ve just learned as I continue to advance my learning in SAP ERP. You can share it also to your friends through referring SAP Knowledge Database site.

If transactions have originated from FI and SD module, you may use table BSEC. Key fields are satisfied because definitely you know your BELNR and GJAHR you want to access.

Elseif, transactions have originated from PO (MM Module) you can use table RBKP, Document Header: Invoice Receipt table. You can find all the information about the one-time vendor/customer you want to get such; name, address, TIN and etc.

You may also consider reading these:

• Web Hosting
• SAP Financial Accounting Overview
• SAP Controlling Overview
• SAP General Ledger Overview
• Create SAP Transaction Codes