SAP table TBNK_RULE (Rule definition table)
SAP table TBNK_RULE has 3 primary key fields being MANDT,RULE_ID,PRIORITY.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| RULE_ID | Rule identification number | CHAR | 10 | 0 | BNK_COM_RULE_ID | ||
| PRIORITY | Rule priority | INT4 | 10 | 0 | BNK_COM_RULE_PRIORITY | ||
| BASIS_RUL_STR | Name of a structure | CHAR | 30 | 0 | DD02L | STRUKNAME | |
| SING_PMNT_FLG | Single payment per batch | CHAR | 1 | 0 | BNK_COM_SIN_PYMNT_FLG | ||
| AUT_PMNT_FLG | Automatic Payment(No aprroval) | CHAR | 1 | 0 | BNK_COM_AUT_PMNT_FLG | ||
| DRLDWN_REQ_FLG | Drill down required before approval | CHAR | 1 | 0 | BNK_COM_DRILLDWN_REQ_FLG | ||
| GROUP_FIELD1 | Grouping field 1 | CHAR | 30 | 0 | DD03L | BNK_COM_GRP_FLD1 | |
| GROUP_FIELD2 | Grouping field 2 | CHAR | 30 | 0 | DD03L | BNK_COM_GRP_FLD2 | |
| GROUP_FIELD3 | Grouping field 3 | CHAR | 30 | 0 | DD03L | BNK_COM_GRP_FLD3 | |
| GROUP_FIELD4 | Grouping field 4 | CHAR | 30 | 0 | DD03L | BNK_COM_GRP_FLD4 |
TBNK_RULE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TBNK_RULE | BASIS_RUL_STR | DD02L | SAP Tables | TABNAME |
| 0 TBNK_RULE | BASIS_RUL_STR | DD02L | SAP Tables | AS4LOCAL |
| 0 TBNK_RULE | BASIS_RUL_STR | DD02L | SAP Tables | AS4VERS |
| 1 TBNK_RULE | GROUP_FIELD1 | DD03L | Table Fields | TABNAME |
| 1 TBNK_RULE | GROUP_FIELD1 | DD03L | Table Fields | FIELDNAME |
| 1 TBNK_RULE | GROUP_FIELD1 | DD03L | Table Fields | AS4LOCAL |
| 1 TBNK_RULE | GROUP_FIELD1 | DD03L | Table Fields | AS4VERS |
| 0 TBNK_RULE | GROUP_FIELD2 | DD03L | Table Fields | TABNAME |
| 0 TBNK_RULE | GROUP_FIELD2 | DD03L | Table Fields | FIELDNAME |
| 0 TBNK_RULE | GROUP_FIELD2 | DD03L | Table Fields | AS4LOCAL |
| 0 TBNK_RULE | GROUP_FIELD2 | DD03L | Table Fields | AS4VERS |
| 1 TBNK_RULE | GROUP_FIELD3 | DD03L | Table Fields | TABNAME |
| 1 TBNK_RULE | GROUP_FIELD3 | DD03L | Table Fields | FIELDNAME |
| 1 TBNK_RULE | GROUP_FIELD3 | DD03L | Table Fields | AS4LOCAL |
| 1 TBNK_RULE | GROUP_FIELD3 | DD03L | Table Fields | AS4VERS |
| 0 TBNK_RULE | GROUP_FIELD4 | DD03L | Table Fields | TABNAME |
| 0 TBNK_RULE | GROUP_FIELD4 | DD03L | Table Fields | FIELDNAME |
| 0 TBNK_RULE | GROUP_FIELD4 | DD03L | Table Fields | AS4LOCAL |
| 0 TBNK_RULE | GROUP_FIELD4 | DD03L | Table Fields | AS4VERS |