SAP table TF110 (Subitem Categories)
SAP table TF110 has 2 primary key fields being MANDT,SITYP.
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
Client
CLNT
3
0
T000
MANDT
Subitem Category
CHAR
3
0
FC_SITYP
SIGNIND
Debit/credit sign allowed
CHAR
1
0
FC_SIGNIND
TTYIND
Carry Forward to Subitem (Transaction Type)
CHAR
1
0
FC_TTYIND
FMLIND
Formula allowed
CHAR
1
0
FC_FMLIND
CFDIND
Treatment balance forward
CHAR
1
0
FC_CFDIND
CYAIND
Only current year for treating year of acquisition
CHAR
1
0
FC_CYAIND
RETIND
Subitems for Acquisitions and Divestitures
CHAR
1
0
FC_RETIND
FNUMB
Number of fields used
NUMC
1
0
FC_FNUMB
FLG1
Length of field 1
NUMC
2
0
FC_FLG1
FLG2
Length of field 2
NUMC
2
0
FC_FLG2
FLG3
Length of field 3
NUMC
2
0
FC_FLG3
FLG4
Length of field 4
NUMC
2
0
FC_FLG4
FLG5
Length of field 5
NUMC
2
0
FC_FLG5
FLG6
Length of field 6
NUMC
2
0
FC_FLG6
FLG7
Length of field 7
NUMC
2
0
FC_FLG7
FLG8
Length of field 8
NUMC
2
0
FC_FLG8
FLG9
Length of field 9
NUMC
2
0
FC_FLG9
SIDEF
Default Subitem
CHAR
10
0
TF115
FC_SIDEF
SITEM_SEND
SAP Consolidation Integration: Sender Field for Subitem
NUMC
2
0
FC_SITEMSD
Possible values
01
Transaction type
02
Functional area
03
Business area
04
Customer country
05
Cost center
06
General ledger account
07
Profit Center
08
Segment
90
Custom (user-defined)
TF110 foreign key relationships
Table
Field
Check Table
Check Field
0 TF110
SIDEF
TF115 Subitems
MANDT
0 TF110
SIDEF
TF115 Subitems
SITYP
0 TF110
SIDEF
TF115 Subitems
SITEM