SAP Table
TF115 Subitems
SAP table TF115 has 3 primary key fields being MANDT,SITYP,SITEM.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TF115 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeySITYP | Subitem Category | CHAR | 3 | 0 | TF110 | FC_SITYP | |||||
| KeySITEM | Subitem | CHAR | 10 | 0 | FC_SITEM | ||||||
| SIGN | Debit/credit sign (+/-) | CHAR | 1 | 0 | FC_SIGN | ||||||
|
|||||||||||
| UPCFO | Carryforward Subitem (Transaction Type) | CHAR | 10 | 0 | TF115 | FC_UPCFO | |||||
| FMLIND | Formula | CHAR | 1 | 0 | FC_SITFML | ||||||
| CFIND | Carryforward subitem | CHAR | 1 | 0 | FC_CFIND | ||||||
| SDEIND | Subitem blocked against posting and entry | CHAR | 1 | 0 | FC_SDEIND | ||||||
| CYIND | Entry of acquisition subitem only current year | CHAR | 1 | 0 | FC_CYIND | ||||||
| UPRET | Subitem for retirements/divestitures | CHAR | 10 | 0 | TF115 | FC_UPRET | |||||
| UPACQ | Acquisition subitem | CHAR | 10 | 0 | TF115 | FC_UPACQ | |||||
| UPMER | Merger Subitem | CHAR | 10 | 0 | TF115 | FC_UPMER | |||||
/ Relationships
TF115 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TF115 | SITYP | TF110 | Subitem Categories | MANDT |
| TF115 | SITYP | TF110 | Subitem Categories | SITYP |
| TF115 | UPACQ | TF115 | Subitems | MANDT |
| TF115 | UPACQ | TF115 | Subitems | SITYP |
| TF115 | UPACQ | TF115 | Subitems | SITEM |
| TF115 | UPCFO | TF115 | Subitems | MANDT |
| TF115 | UPCFO | TF115 | Subitems | SITYP |
| TF115 | UPCFO | TF115 | Subitems | SITEM |
| TF115 | UPMER | TF115 | Subitems | MANDT |
| TF115 | UPMER | TF115 | Subitems | SITYP |
| TF115 | UPMER | TF115 | Subitems | SITEM |
| TF115 | UPRET | TF115 | Subitems | MANDT |
| TF115 | UPRET | TF115 | Subitems | SITYP |
| TF115 | UPRET | TF115 | Subitems | SITEM |