SAP Tabel T077D  (Customer account groups) 
     
    
        
                SAP table T077D has 2 primary key fields being MANDT,KTOKD.
        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
             
            
                             
         
            
              KTOKD 
            Customer Account Group 
            CHAR  
            4 
            0 
            
                                    
                             
            
                KTOKD
             
            
                             
         
            
            FAUSA 
            Customer master record field status def.for general data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSA_077D
             
            
                             
         
            
            FAUSF 
            Customer master record field status def.for comp.code data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSF_077D
             
            
                             
         
            
            FAUSV 
            Customer master record field status def.for sales fields 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSV_077D
             
            
                             
         
            
            NUMKR 
            Number Range 
            CHAR  
            2 
            0 
            
                                    
                             
            
                NUMKR
             
            
                             
         
            
            XCPDS 
            Indicator: Account Group for One-Time Accounts? 
            CHAR  
            1 
            0 
            
                                    
                             
            
                XCPDS
             
            
                             
         
            
            KALSM 
            Output determination procedure 
            CHAR  
            6 
            0 
            
                                    T683 
                             
            
                KALSMB
             
            
                             
         
            
            DEAR1 
            Indicator: Competitor 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR1
             
            
                             
         
            
            DEAR2 
            Indicator: Sales partner 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR2
             
            
                             
         
            
            DEAR3 
            Indicator: Sales prospect 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR3
             
            
                                    Possible values 
                    
                             
         
            
            DEAR4 
            Indicator for customer type 4 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR4
             
            
                             
         
            
            DEAR5 
            ID for default sold-to party 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR5
             
            
                             
         
            
            FAUS1 
            Customer master record field status def.for general data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSA_077D
             
            
                             
         
            
            FAUSW 
            Field status bar, plant master for IS-R data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSW_077D
             
            
                             
         
            
            FAUSG 
            Customer master record field status def.for comp.code data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSF_077D
             
            
                             
         
            
            DEAR6 
            Indicator: Consumer 
            CHAR  
            1 
            0 
            
                                    
                             
            
                DEAR6
             
            
                             
         
            
            FAUS2 
            Customer master record field status def.for general data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSA_077D
             
            
                             
         
            
            FAUSU 
            Customer master record field status def.for sales fields 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSV_077D
             
            
                             
         
            
            FAUS3 
            Customer master record field status def.for general data 
            CHAR  
            40 
            0 
            
                                    
                             
            
                FAUSA_077D
             
            
                             
         
            
            XCPDADDRCHK 
            Indicator: Skip address check for One-Time Accounts 
            CHAR  
            1 
            0 
            
                                    
                             
            
                XCPDADDRCHK
             
            
                             
         
         
    
     
                
    T077D foreign key relationships 
    
    
    
        
            Table 
            Field 
            Check Table 
             
            Check Field 
         
     
    
                                                    
        
            0 T077D 
            KALSM 
            T683  
            Pricing procedures 
            KAPPL 
         
                    
        
            0 T077D 
            KALSM 
            T683  
            Pricing procedures 
            KALSM 
         
                                                    
        
            1 T077D 
            MANDT 
            T000  
            Clients 
            MANDT