SAP Table
T077D Customer account groups
SAP table T077D has 2 primary key fields being MANDT,KTOKD.
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
T077D columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeyKTOKD | 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 | ||||||
|
|||||||||||
| 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 | ||||||