SAP table T5F99K2 (Customer values for configuration options)
SAP table T5F99K2 has 5 primary key fields being MANDT,MOLGA,OPTIO,MODCO,ENDDA.
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 | |
| MOLGA | HCM Localization | CHAR | 2 | 0 | T500L | MOLGA | |
| OPTIO | Possible Confituration Options | CHAR | 5 | 0 | T5F99K0 | P_99SOPTIO | |
| MODCO | Modificator for configuration option | CHAR | 2 | 0 | T5F99KM | P_99SMODCO | |
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| OPTVA | Value for configuration option | CHAR | 10 | 0 | T5F99K1 | P_99SOPTVA |
T5F99K2 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5F99K2 | MODCO | T5F99KM | Modificators for configuration options | MANDT |
| 0 T5F99K2 | MODCO | T5F99KM | Modificators for configuration options | MOLGA |
| 0 T5F99K2 | MODCO | T5F99KM | Modificators for configuration options | OPTIO |
| 0 T5F99K2 | MODCO | T5F99KM | Modificators for configuration options | MODCO |
| 1 T5F99K2 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| 0 T5F99K2 | OPTIO | T5F99K0 | Possible configuration options | MANDT |
| 0 T5F99K2 | OPTIO | T5F99K0 | Possible configuration options | MOLGA |
| 0 T5F99K2 | OPTIO | T5F99K0 | Possible configuration options | OPTIO |
| 1 T5F99K2 | OPTVA | T5F99K1 | Configuration values for configuration options | MANDT |
| 1 T5F99K2 | OPTVA | T5F99K1 | Configuration values for configuration options | MOLGA |
| 1 T5F99K2 | OPTVA | T5F99K1 | Configuration values for configuration options | OPTIO |