GR/IR open Items and CDS views

Yes, you're absolutely right. SAP S/4HANA introduces significant enhancements to GR/IR item analysis, primarily through Fiori apps and CDS views. Let's update the information to reflect these changes:

Finding Open GR/IR Items in SAP S/4HANA

Table of Contents

1. Introduction: S/4HANA Enhancements
2. Using Standard Fiori Apps
   • 2.1. "Display Line Items in General Ledger" (F2217)
   • 2.2. "Monitor GR/IR Account Reconciliation" (F2227)
   • 2.3. "GR/IR Monitor" (F0997)
3. Using CDS Views for Open GR/IR Reporting
   • 3.1. I_GRIRClearingOpenItems
   • 3.2. I_PurchaseOrderItemAPI01
   • 3.3. I_GLAccountLineItem
4. Using SAP Query or Custom CDS Views
5. Traditional Transactions (FBL3N, FAGLL03, MB5S, FBL1N)
6. Summary

1. Introduction: S/4HANA Enhancements

SAP S/4HANA revolutionizes GR/IR item analysis with real-time reporting, Fiori apps, and CDS views. While traditional transactions like FBL3N and FAGLL03 remain functional, SAP recommends leveraging the new capabilities for improved performance and user experience.

2. Using Standard Fiori Apps

• 2.1. "Display Line Items in General Ledger" (App ID: F2217)
  • Replaces FBL3N and FAGLL03 for G/L account analysis.
  • Offers enhanced drill-down capabilities and a user-friendly interface.
• 2.2. "Monitor GR/IR Account Reconciliation" (App ID: F2227)
  • A dedicated Fiori app for analyzing open GR/IR items.
  • Provides a comprehensive overview of GR/IR balances and discrepancies.
• 2.3. "GR/IR Monitor" (App ID: F0997)
  • Helps in GR/IR clearing and matching issues.
  • Provides tools to resolve GR/IR differences.

3. Using CDS Views for Open GR/IR Reporting

• 3.1. I_GRIRClearingOpenItems
  • Provides detailed information about open GR/IR items.
  • Can be used for custom reporting and analysis.
• 3.2. I_PurchaseOrderItemAPI01
  • Tracks pending receipts and can be combined with GR/IR clearing views.
  • Provides purchase order details.
• 3.3. I_GLAccountLineItem
  • Offers detailed line-item level reporting, similar to FAGLL03.
  • Can be used to analyze financial postings.

These CDS views can be utilized in SAP Analytics Cloud (SAC) or SAP Analysis for Office (AO) for advanced reporting and data visualization.

4. Using SAP Query or Custom CDS Views

For custom reporting needs, you can:

• Create custom CDS views by combining I_GRIRClearingOpenItems and I_GLAccountLineItem, linking them with purchasing documents and material movements.
• Use SAP Query to create custom reports.

5. Traditional Transactions (FBL3N, FAGLL03, MB5S, FBL1N)

These transactions remain available in S/4HANA but are considered legacy. They still function for basic GR/IR analysis.

6. Summary

SAP S/4HANA significantly enhances GR/IR item analysis through Fiori apps and CDS views. Fiori apps like "Display Line Items in General Ledger," "Monitor GR/IR Account Reconciliation," and "GR/IR Monitor" offer user-friendly interfaces and improved performance. CDS views like I_GRIRClearingOpenItems, I_PurchaseOrderItemAPI01, and I_GLAccountLineItem provide powerful data extraction capabilities for custom reporting. While traditional transactions remain available, SAP recommends leveraging the new S/4HANA capabilities for optimal efficiency and accuracy in GR/IR reconciliation.

Finding Open GR/IR Items

Finding Open GR/IR Items in SAP

Table of Contents

1. Introduction
2. Using FBL3N (G/L Account Line Item Display)
3. Using FAGLL03 (G/L Line Item Display - New G/L)
4. Using MB5S (GR/IR Balances for Purchase Orders)
5. Using FBL1N (Vendor Line Item Display) for Vendor-Specific GR/IR
6. Refining Reports
7. Summary

1. Introduction

Open Goods Receipt/Invoice Receipt (GR/IR) items represent discrepancies between goods received and invoices processed, indicating potential financial inaccuracies. This document outlines how to find these open items in SAP using various standard transactions.

2. Using FBL3N (G/L Account Line Item Display)

• Purpose: To directly view open GR/IR items within the relevant G/L clearing account.
• Steps:
  • Go to transaction code FBL3N.
  • Enter the GR/IR clearing G/L account number (e.g., 191000).
  • Filter by relevant document types (e.g., WE for Goods Receipt, RE for Invoice Receipt) if needed.
  • Select "Open Items" under the "Status" filter.
  • Execute the report.
• Result: Displays all open GR/IR line items for the specified G/L account.

3. Using FAGLL03 (G/L Line Item Display - New G/L)

• Purpose: Similar to FBL3N, but for systems using the New General Ledger.
• Steps:
  • Go to transaction code FAGLL03.
  • Enter the GR/IR G/L account.
  • Enter the relevant company code and fiscal year.
  • Select "Open Items" and specify a "Key Date."
  • Execute the report.
• Result: Shows open GR/IR items based on the New G/L configuration.

4. Using MB5S (GR/IR Balances for Purchase Orders)

• Purpose: To identify GR/IR discrepancies at the purchase order level.
• Steps:
  • Go to transaction code MB5S.
  • Enter the company code.
  • Optionally, enter a vendor code for vendor-specific results.
  • Execute the report.
• Result: Provides a list of unmatched GR/IR transactions related to purchase orders, highlighting potential discrepancies.

5. Using FBL1N (Vendor Line Item Display) for Vendor-Specific GR/IR

• Purpose: To find GR/IR items associated with a specific vendor.
• Steps:
  • Go to transaction code FBL1N.
  • Enter the vendor account number.
  • Select "Open Items."
  • Execute the report.
• Result: Displays pending GR/IR items linked to the specified vendor.

6. Refining Reports

You can refine these reports further using various filters:

• Purchasing Document: Filter by specific purchase order numbers.
• Material: filter by material numbers.
• Date Ranges: Restrict results to specific posting or document dates.
• Company Code: Limit the search to a particular company code.
• Vendor: Limit the search to a specific Vendor.
• Document Type: Limit to specific document types (GR, IR).

7. Summary

Finding open GR/IR items in SAP is crucial for maintaining accurate financial records. This document has outlined four key transaction codes—FBL3N, FAGLL03, MB5S, and FBL1N—that can be used to identify these discrepancies. FBL3N and FAGLL03 provide a direct view of open items in the GR/IR G/L account, while MB5S focuses on purchase order-level discrepancies, and FBL1N shows vendor related GR/IR items. Furthermore, reports can be refined using various filters like purchasing document, material, and date ranges to pinpoint specific issues. By leveraging these tools, users can efficiently manage and reconcile GR/IR balances, ensuring financial integrity.

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.