- Home
 
        - Resources
 
        - SAP Tables
 
        - TF110 - Subitem Categories
 
    
    
    SAP Table TF110
    Subitem Categories
    
    TF110 (Subitem Categories) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
    Additionally we provide an overview of foreign key relationships, if any, that link TF110 to other SAP tables.
    
     
	
	Source: TF110 (Subitem Categories)
    TF110 table fields
    
        
            
            
                | Field | 
                Data element | 
                Checktable | 
                Datatype | 
                Length | 
                Decimals | 
                 | 
                
            
            
            
                                                
                                    | MANDT | 
                    Client | 
                    MANDT | 
                    
                                            T000
                                         | 
                    CLNT | 
                     | 
                    3 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | SITYP | 
                    Subitem category | 
                    FC_SITYP | 
                    
                                         | 
                    CHAR | 
                     | 
                    3 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | SIGNIND | 
                    Debit/credit sign allowed | 
                    FC_SIGNIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | TTYIND | 
                    Carry forward to subitem (transaction type) | 
                    FC_TTYIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | FMLIND | 
                    Formula allowed | 
                    FC_FMLIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | CFDIND | 
                    Treatment balance forward | 
                    FC_CFDIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | CYAIND | 
                    Only current year for treating year of acquisition | 
                    FC_CYAIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | RETIND | 
                    Subitems for acquisitions and divestitures | 
                    FC_RETIND | 
                    
                                         | 
                    CHAR | 
                     | 
                    1 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  NULL  | 
                                    Not Selected | 
                                 
                                                                
                                    |  X  | 
                                    Selected | 
                                 
                                                                 
                                 
                                             | 
                
                                                
                                    | FNUMB | 
                    Number of fields used | 
                    FC_FNUMB | 
                    
                                         | 
                    NUMC | 
                     | 
                    1 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG1 | 
                    Length of field 1 | 
                    FC_FLG1 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG2 | 
                    Length of field 2 | 
                    FC_FLG2 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG3 | 
                    Length of field 3 | 
                    FC_FLG3 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG4 | 
                    Length of field 4 | 
                    FC_FLG4 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG5 | 
                    Length of field 5 | 
                    FC_FLG5 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG6 | 
                    Length of field 6 | 
                    FC_FLG6 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG7 | 
                    Length of field 7 | 
                    FC_FLG7 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG8 | 
                    Length of field 8 | 
                    FC_FLG8 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | FLG9 | 
                    Length of field 9 | 
                    FC_FLG9 | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | SIDEF | 
                    Default subitem | 
                    FC_SIDEF | 
                    
                                            TF115
                                         | 
                    CHAR | 
                     | 
                    10 | 
                    0 | 
                    
                                             | 
                
                                                
                                    | SITEM_SEND | 
                    SAP Cons Integration: Sender field for subitem | 
                    FC_SITEMSD | 
                    
                                         | 
                    NUMC | 
                     | 
                    2 | 
                    0 | 
                    
                                                                                Possible values
                            
                                
                                                                
                                    |  01  | 
                                    Transaction type | 
                                 
                                                                
                                    |  02  | 
                                    Functional area | 
                                 
                                                                
                                    |  03  | 
                                    Business area | 
                                 
                                                                
                                    |  04  | 
                                    Customer country | 
                                 
                                                                
                                    |  05  | 
                                    Cost center | 
                                 
                                                                
                                    |  06  | 
                                    General ledger account | 
                                 
                                                                
                                    |  07  | 
                                    Profit Center | 
                                 
                                                                
                                    |  90  | 
                                    Custom (user-defined) | 
                                 
                                                                 
                                 
                                             | 
                
                        
        
     
        TF110 foreign key relationships
    
        
            
                
                    | Table | 
                    Field | 
                    Foreign key table | 
                    Foreign key field | 
                    Check table | 
                    Check field | 
                
            
                        
            
            
                                                                        
                                      | TF110 | 
                    MANDT | 
                    TF110 | 
                    MANDT | 
                    T000 | 
                    Clients | 
                    MANDT | 
                
            
                                                                        
                                      | TF110 | 
                    SIDEF | 
                    TF110 | 
                    MANDT | 
                    TF115 | 
                    Subitems | 
                    MANDT | 
                
            
                
                                      | TF110 | 
                    SIDEF | 
                    TF110 | 
                    SITYP | 
                    TF115 | 
                    Subitems | 
                    SITYP | 
                
            
                
                                      | TF110 | 
                    SIDEF | 
                    TF110 | 
                    SIDEF | 
                    TF115 | 
                    Subitems | 
                    SITEM |