How to Fix MM/FI Field Status Errors - QSandS

1 0 2008 SCM Expert Reproduction prohibited. All rights why Field Status Errors occur for Materials Management (MM) transactions. Understand the relationship between MM and Financial Accounting Field Status . Discover the steps required to correct Field Status group Errors and the special considerations for configuring Field Status to Fix MM/FI Field Status Errors by Rohana Gunawardena, SAP Practice Director, Quality Software & Systemsentry per special stock indicator is active for each movement type. Double-click on the appropriate entry to see the Field Status group overview (Figure 2).The Field Status groups break the individual fields in the MM document into logically related groups. Double-click on a group to see the full Field details (Figure 3). If the Field Status group name is in blue it means at least one Field in the group is optional or required; if it is black then all fields are suppressed.

2 The text (FI only) refers to fields that are only used in FI, but you may need to update these settings if you run into the error messages I have Field Status group detail shows the settings for individual fields such as Profit Center. The options Suppress, Req. Entry, and Opt. Entry control the Field Status during MM document entry for the specific movement type. You can differs for Profit Center (042). Note 042 indicates the profit center fields are con-trolled by the forty-second position in the raw data display of Field should your next step as an analyst be? To resolve this message you need to know the Field selection for a movement type. First I ll explain what MM Field Status is and how it interacts with FI Field Status . Then I ll show you how to quickly identify and correct any Field Status When you post an MM document certain information is required to process the transaction, such as plant, storage loca-tion, and material.

3 Additional information can be required of an MM transaction ( , movement type 201 requires a cost center). The Field Status group controls what information is required to complete an MM transaction. To configure MM Field Status , use transac-tion OMJJ and select the sub-dialog Field selection (from 201)/Batch search proce-dure (Figure 1). The text (from 201) means it applies to movement types from 201 to 999 only, not to the purchasing goods receipt transactions 101 to 199. One When you post Materials Management (MM) transactions that have a Financial Accounting (FI) impact, you may receive the error message M7 093 Different Field selection for movement type 501/account 400020 differs from Profit Center 042 or F5 808 Field Cost Center is a required Field for G/L account 3000 792000. These error messages are caused by an inconsis-tency in the Field Status group for the MM movement type and the FI G/L account to which you are posting.

4 Common MM transactions such as MB01, MB1A, MB1B, MB1C, and VL01 and SAP Enjoy transactions such as MIGO and MIRO can trigger these configuring a movement type using transaction OMJJ to set the Field Status group, you miss the similar Field Status group for the G/L account configured using transaction OBC4. To help resolve these issues, SAP provides standard report RM07 CUFA to help analyze the inconsis-tencies. I ll show you how to use this report to update Field selections, and also explain in greater detail the considerations you need to take into account when adjusting the configuration. Consider the following scenario: The Finan-cial Accounting (FI) General Ledger (G/L) team has decided that profit center should be a compulsory account for material con-sumption accounts. When a user performs a goods receipt using movement type 501, goods issue (GI) receipt without purchase order (PO), they receive error message Fld selectn for mvmt type 501/acct 400020 A Materials Management (MM) movement type and a general ledger (G/L) account both have Field selec-tion strings.

5 Field selection strings need to be consistent between Financial Accounting and MM. For example, it is inconsistent for an MM movement type to suppress a profit center, but for the G/L account to require a profit Concept>>Transaction OMJJ for movement type Field selection updateFigure 105 SCMx 206/17/2008 12:23:30 PMJune 2008 For group rates on electronic access, call 1-781-751-8799 1FI Configuration Now that I have discussed the configura-tion for MM Field Status group, you know the error messages occur due to an incon-sistency between MM and FI Field Status groups. FI has two Field Status groups, one for the G/L account and one for the posting key (Table 1).OBC4: G/L Account Field Status Group Each G/L account is assigned a Field Status group. You can display the Field Status group assignment with transaction FS03 (Figure 5 on the next page).An FI Field Status group is not unique. You need to know its Field Status variant.

6 Click on the drop-down arrow next to Field Status group G003 or press F4 for help. Then the Field Status variant 1000 is dis-played at the top of the selection list (Figure 6 on the next page).You can find the details of the FI Field Status groups with transaction OBC4. Sel-ect the correct Field Status name and then double-click on the Field Status groups folder in the Dialog Structure to display the Change View Field Status groups: Overview screen (Figure 7 on the next page). From there you can drill down to a screen similar to Figure 2, then proceed to Figure 3 to set the options for suppressed, required, or optional entry : Posting Key Field Status In FI there is also a Field Status setting for each posting key, which is configured using transaction OB41 (Figure 8 on the next page). The FI posting keys relevant for MM transactions are 80 to 99. In this transaction double-click on the posting key to go to the detail screen.

7 In the detail screen click on the Maintain Field Status button to see a screen similar to the MM Maintain Field Status Group: Over- view screen in Figure 2. From there you can drill down to set the options for sup-pressed, required, or optional entry con- Profit center PRCTR added as a required Field for SAP Enjoy transactionsFigure Transaction OMJJ Field Status group update for Additional account assignments groupFigure Transaction OMJJ detail after you double-click on the move-ment typeFigure Sometimes a single row in the Field Status group can refer to more than one Field in the MM document ( , the Sales order option controls the sales order document and sales order item fields). Use the Field check button in Figure 3 to see which fields a single setting controls. The settings in the OMJJ sub-dialog Field selection (from 201)/Batch search proce-dure do not apply to SAP Enjoy transaction MIGO (goods receipt with a purchase order).

8 Instead you need to enter the Field for which you want to change the Status in the sub-dialog Field selection (Enjoy) shown in Figure 4. Note the SAP Enjoy logic applies to all movement types from 101 to 999. It has no special text, as opposed to Figure 1, which says from of the two types of Field Status group settings in FITable 1 Configuration objectAssignmentConfiguration transactionCommentsG/L accountField Status group assigned to G/L account has configura-tion, display link using transaction FS03 OBC4: configu-ration by Field Status groupThe M7 093 and F5 808 error messages compare MM Field Status to this FI Field statusPosting keyDirectly part of posting key configurationOB41: con-figuration by posting keyNearly all fields are defined as optional for material related posting keys 80 to 99. Usually you do not need to adjust the page up and page down keys to navigate between pages. 05 SCMx 216/17/2008 12:23:31 PM 2008 SCM Expert Reproduction prohibited.

9 All rights , similar to the MM Maintain Field Status Group: Detail screen in Figure you need to review the settings at a more technical level, see Table 2, which shows the tables where the three Field Status group settings I have introduced earlier are stored. When the raw data in these tables is dis-played using transactions SE16, SE16N, or SE17, the Field selection string appears as a set of plus (+), minus (-) and period (.) characters (Figure 9). You can interpret the raw data characters using the descrip-tions in Table 3. Invalid Combinations I have discussed the configuration for MM Field Status group and error messages that occur due to an inconsistency between MM and FI Field Status groups. Table 4 shows the logic SAP applies to the comparison of the MM movement type and FI G/L account Field Status group settings. Table 5 provides additional detail on the four com-binations that cause Errors . Analyze your own business scenarios before proceeding with the possible corrections Report Now I will introduce a report to quickly identify and correct any inconsistencies.

10 You can use report RM07 CUFA ( Field Selection Comparison: Movement Type G/L Account) to identify the Field selection string Errors . See SAP Note 9281for more information. Enter the data from the error message Fld selectn for mvmt type 501/acct 400020 differs for Profit Center (042) into the selection screen of the report and it highlights con-flicts between MM and FI Field Status groups (Figure 10). To execute the report, populate the selection screen and click on the execute icon. To change the Field Status group with trans-action OMJJ or OBC4, click on the Find the Field Status variant for a Field Status groupFigure Transaction OBC4 Field Status group overviewFigure List of configuration tables where Field Status group settings are storedTable Configuration objectConfiguration transactionTableTable descriptionMM movement typeOMJJT156 BMovement types: screen selectionFI G/L Field Status groupOBC4T004 FField Status definition groupsFI posting keyOB41 TBSLP osting keyField Status symbolsTable SymbolDescriptionComment Suppressed+Required entrySpaceDisplay entryRarely usedTransaction OB41 configures FI posting keysFigure Raw data display of Field selection stringFigure Field Status group assignment for a G/L accountFigure 05 SCMx 226/17/2008 12:23:32 PMJune 2008 For group rates on electronic access, call 1-781-751-8799 group.