SAP table T078D (Trans.-dependent screen selection for cust.master)
SAP table T078D has 2 primary key fields being MANDT,TCODE.
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 | |
| TCODE | Transaction Code | CHAR | 20 | 0 | TSTC | TCODE | |
| 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 | ||
| 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 | ||
| 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 |
T078D foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T078D | MANDT | T000 | Clients | MANDT |
| 1 T078D | TCODE | TSTC | SAP Transaction Codes | TCODE |