FMSPLIT_RULE SAP (Distribution Rule for Rule-Based Account Distributions) Table details
Description: Distribution Rule for Rule-Based Account Distributions
Table field list including key, data, relationships and ABAP select examples
FMSPLIT_RULE is a standard SAP Table which is used to store Distribution Rule for Rule-Based Account Distributions data and is available within R/3 SAP systems depending on the version and release level.
The FMSPLIT_RULE table consists of various fields, each holding specific information or linking keys about Distribution Rule for Rule-Based Account Distributions data available in SAP. These include SPLIT_RULE (Identifier for Rule-Based Acct Asst Distributions Rule), GROUP_ID (Group ID for Rule-Based Account Asst Distributions), STATUS (Activation status for Rule-Based Acct Asst Distributions), FPROF_ID (Field Profile ID for Rule-Based Account Asst Distributions).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = FMSPLIT_RULET
SAP FMSPLIT_RULE table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| SPLIT_RULE | Identifier for Rule-Based Acct Asst Distributions Rule | FMSP_RULE_ID | CHAR | 12 | FMSP_RULE_ID | ||||
| GROUP_ID | Group ID for Rule-Based Account Asst Distributions | FMSP_GROUP_ID | CHAR | 4 | FMSPLIT_GROUP | FMSP_GROUP_ID | FM_SPLIT_GROUP | ||
| STATUS | Activation status for Rule-Based Acct Asst Distributions | FMSP_STATUS | CHAR | 1 | FMSP_STATUS | ||||
| FPROF_ID | Field Profile ID for Rule-Based Account Asst Distributions | FMSP_FPROF_ID | CHAR | 12 | FMSPLIT_FPROF | FMSP_FPROF_ID | |||
| APROF_ID | Rule-Based Account Assignment Distbtns Action Profile ID | FMSP_APROF_ID | CHAR | 12 | FMSPLIT_APROF | FMSP_APROF_ID | |||
| RULE_TYPE | Rule Type for Rule-Based Account Assignment Distributions | FMSP_RULE_TP | CHAR | 4 | FMSPLIT_RULETP | FMSP_RULE_TP | |||
| BINDING_TYPE | Controls whether rule results are binding or may be changed | FMSP_BINDING_TP | CHAR | 1 | FMSP_BINDING_TP | ||||
| CREATED_BY | FIFM: Created by | FM_ERFNAME | CHAR | 12 | USNAM | ||||
| CREATED_ON | FIFM: Entry Date | FM_ERFDAT | DATS | 8 | DATUM | ||||
| MODIFIED_BY | FIFM: Name of Last Person to Make a Change | FM_AENNAME | CHAR | 12 | USNAM | ||||
| MODIFIED_ON | FIFM: Changed on | FM_AENDAT | DATS | 8 | DATUM | ||||
| REMAINDER_TYPE | Remainder Handling for Partial Allocation by Distribution | FMSP_REMAINDER_TYPE | CHAR | 1 | FMSP_REMAINDER_TYPE |
| Key field | Non-key field |
How do I retrieve data from SAP table FMSPLIT_RULE using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMSPLIT_RULE to SELECT all data from the tableDATA: WA_FMSPLIT_RULE TYPE FMSPLIT_RULE.
SELECT SINGLE *
FROM FMSPLIT_RULE
INTO CORRESPONDING FIELDS OF WA_FMSPLIT_RULE
WHERE...
How to access SAP table FMSPLIT_RULE
Within an ECC or HANA version of SAP you can also view further information about FMSPLIT_RULE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects