SAP Table
TF110 Subitem Categories
SAP table TF110 has 2 primary key fields being MANDT,SITYP.
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
TF110 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||
| KeySITYP | 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 | ||||||||||||||||||||
|
|||||||||||||||||||||||||