Material ledger documents are used to record changes resulting from valuation-relevant business transactions. These transactions include goods movements, invoice receipts, and material price changes. To uniquely identify each material ledger document in the system, SAP assigns them to specific number ranges. This ensures proper tracking and organization of all transactions. The configuration to Maintain Number Ranges for Material Ledger Documents can be accessed through transaction code OXM4.
Maintain Number Ranges for Material Ledger Documents
- Each business transaction in the material ledger is linked to a document type and a unique number range.
- SAP provides predefined groups for material ledger documents based on transaction types. Each group is assigned a specific number range.
- In most cases, the standard groups provided by SAP are sufficient, and new groups do not need to be created. However, if new groups are created, they must be assigned to the correct number range.
Predefined Groups and Their Transaction Types
| Group Number | Group Name |
|---|---|
| 01 | Material Ledger Update |
| 02 | Material Ledger Closing |
| 03 | Material Ledger Price Changes |
| 04 | Single-Level Material Ledger Settlement |
| 05 | Multilevel Material Ledger Settlement |
| 06 | Material Ledger Repair |
| 07 | Material Ledger Closing Cumulative Valuation |
Each group is allocated a number range of 100,000,000 document numbers.
Steps to Maintain Number Ranges for Material Ledger Documents
- Access the Configuration:
- Use transaction code OXM4 or navigate to:
Controlling → Product Cost Controlling → Actual Costing/Material Ledger → Maintain Number Ranges for Material Ledger Documents.
- Use transaction code OXM4 or navigate to:
- Select the Option for Number Range Maintenance:
- From the main screen, you will see three options:
- Number Ranges for Material Ledger Documents
- Maintain Financial Accounting Document Types
- Accounting Document Number Ranges
- Select Number Ranges for Material Ledger Documents to begin.
- From the main screen, you will see three options:
- Update or Assign Number Ranges:
- A new screen opens where you can manage the number ranges.
- Press the GROUPS button (or press F6) to display the predefined groups.
- Update the number range and description for each group as needed.
- View or Modify Number Range Intervals:
- To view all number range intervals, return to the main screen and select Intervals.
- Ensure the intervals are correctly defined, typically starting with 47, which is reserved for material ledger documents in Financial Accounting (FI).
Verification and Maintenance Steps
- Verify Document Type for Material Ledger in FI:
- Go back to the main menu and select Maintain Financial Accounting Document Types.
- Check that the document type ML (Material Ledger) is assigned to the correct number range (e.g., 47).
- Check Number Range for Your Company Code:
- Select Accounting Document Number Ranges from the main menu.
- Enter your company code and click the Intervals button.
- Update the number range, ensuring it is within the range 4700000000 to 4799999999, which is standard for material ledger documents.
Important Considerations
- Standard Number Ranges:
- SAP reserves document type ML and number ranges starting with 47 specifically for material ledger documents.
- Customizations to number ranges should align with your organization’s document management policies.
- Consistency Across Groups:
- Ensure that the number ranges assigned to material ledger document groups do not overlap with other transaction types or areas in the system.
- Company Code Configuration:
- Each company code must have the number range for material ledger documents appropriately maintained to avoid processing errors.
Benefits of Proper Number Range Management
- Unique Identification: Ensures every material ledger document has a distinct identifier, facilitating accurate transaction tracking.
- System Integrity: Properly assigned number ranges prevent conflicts between different document types or transaction groups.
- Compliance: Helps maintain consistency in financial accounting and reporting across the organization.
By following these steps, you can effectively manage number ranges for material ledger documents, ensuring seamless integration and consistency across valuation-relevant transactions in SAP.