SAP table TF115 (Subitems)

SAP table TF115 has 3 primary key fields being MANDT,SITYP,SITEM.

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
SITYP Subitem Category CHAR 3 0 TF110 FC_SITYP
SITEM Subitem CHAR 10 0 FC_SITEM
SIGN Debit/credit sign (+/-) CHAR 1 0 FC_SIGN
+ Debit (increase)
- Credit (decrease)
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

TF115 foreign key relationships

Table Field Check Table Check Field
0 TF115 SITYP TF110 Subitem Categories MANDT
0 TF115 SITYP TF110 Subitem Categories SITYP
1 TF115 UPACQ TF115 Subitems MANDT
1 TF115 UPACQ TF115 Subitems SITYP
1 TF115 UPACQ TF115 Subitems SITEM
0 TF115 UPCFO TF115 Subitems MANDT
0 TF115 UPCFO TF115 Subitems SITYP
0 TF115 UPCFO TF115 Subitems SITEM
1 TF115 UPMER TF115 Subitems MANDT
1 TF115 UPMER TF115 Subitems SITYP
1 TF115 UPMER TF115 Subitems SITEM
0 TF115 UPRET TF115 Subitems MANDT
0 TF115 UPRET TF115 Subitems SITYP
0 TF115 UPRET TF115 Subitems SITEM