SAP table 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