In SAP how to find Open GR/IR items from tables

Finding open GR/IR (Goods Receipt/Invoice Receipt) items in SAP involves understanding how these transactions are recorded and cleared. Here's a breakdown of the key tables and considerations:

Key Tables and Concepts:

• EKBE (History per Purchasing Document):
  • This table stores the history of purchasing documents, including goods receipts and invoice receipts. It's crucial for tracing the flow of transactions.
  • You can find information about quantities received, invoiced, and cleared.
• BSEG (Accounting Document Segment):
  • This table contains accounting document line items.
  • It's essential for identifying the financial postings related to GR/IR.
  • You can use fields like KTOSL (Transaction Key) with the value "WRX" (GR/IR clearing) to filter for relevant entries.
  • Also the field AUGDT (Clearing date) is very important. When this field is empty, it means that the document is not cleared.
• BSIS (Accounting: Secondary Index for G/L Accounts):
  • This table holds open items in G/L accounts.
  • It's useful for finding open GR/IR balances in the relevant G/L accounts.
• BSAS (Accounting: Secondary Index for Cleared G/L Accounts):
  • This table holds cleared items in G/L accounts. This table in conjunction with BSIS can be used to determine open items.
• MSEG (Segment Material Document):
  • This table stores material document segments, which are created during goods receipts.
• RSEG (Invoice Document Item):
  • This table stores invoice document items.

Finding Open Items:

• To determine open GR/IR items, you'll generally need to cross-reference data from multiple tables.
• A common approach involves:
  • Identifying GR and IR postings in EKBE.
  • Linking those postings to accounting documents in BSEG.
  • Checking the clearing status of the accounting documents in BSIS and BSAS.
  • If a GR/IR line item exists in BSIS, then it is open. If it is in BSAS, it is cleared.
• Also the Tcode MB5S is a very useful tool to display GR/IR balances.

Important Considerations:

• GR/IR clearing is a complex process, and the specific tables and fields you need may vary depending on your SAP configuration.
• Understanding the clearing rules and accounting postings is essential for accurate analysis.
• Using SAP transaction codes is often easier then going directly to the tables. MB5S is an example of a good transaction code for this purpose.
• When analysing the data, pay close attention to the accounting document clearing date. A blank clearing date generally means the item is open.

I hope this information is helpful.