SAP Table AT80
Treasury: Correspondence Control MM, FX, DE, SE
AT80 (Treasury: Correspondence Control MM, FX, DE, SE) 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 AT80 to other SAP tables.
AT80 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 | 0 | ||||||||
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 | 0 | ||||||||
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | AT02 | NUMC | 2 | 0 | ||||||||
| SFUNKTL | Latest function used in editing activity | TB_SFUNKTL_CORR | AT60 | CHAR | 4 | 0 | ||||||||
| CORTYP | Correspondence type | TB_CORTYP | AT81 | CHAR | 3 | 0 | ||||||||
| FORMULAR | Form Name | TB_PDF_FORM | CHAR | 16 | 0 | |||||||||
| AUTOMATIC | Indicator: Automatic Correspondence Required? | TB_AUTO | CHAR | 1 | 0 |
Possible values
|
||||||||
| SOBLRECONF | Counterconfirmation required? | TB_OBLRECO | CHAR | 1 | 0 |
Possible values
|
||||||||
| TDCOPIES | Number of copies | RSPOCOPIES | INT1 | 3 | 0 | |||||||||
| TDDEST | Spool: Output device | RSPOPNAME | TSP03 | CHAR | 4 | 0 | ||||||||
| TDPREVIEW | Print preview | TDPREVIEW | CHAR | 1 | 0 |
Possible values
|
||||||||
| TDNOPRINT | No printing from print preview | TDNOPRINT | CHAR | 1 | 0 |
Possible values
|
||||||||
| TDNEWID | New Spool Request | SYPRNEW | CHAR | 1 | 0 | |||||||||
| TDDATASET | Spool request: Name | RSPO0NAME | CHAR | 6 | 0 | |||||||||
| TDSUFFIX1 | Spool request: Suffix 1 | RSPO1NAME | CHAR | 4 | 0 | |||||||||
| TDSUFFIX2 | Spool request: Suffix 2 | RSPO2NAME | CHAR | 12 | 0 | |||||||||
| TDIMMED | Immediate Spool Print | SYPRIMM | CHAR | 1 | 0 | |||||||||
| TDDELETE | Immediate Spool Deletion | SYPRREL | CHAR | 1 | 0 | |||||||||
| TDLIFETIME | Spool Retention Period | SYPEXPI | NUMC | 1 | 0 | |||||||||
| TDSCHEDULE | Send time request | SKSCHEDULE | CHAR | 3 | 0 |
Possible values
|
||||||||
| TDSENDDATE | Requested send date | SKDATE | DATS | 8 | 0 | |||||||||
| TDSENDTIME | Requested send time | SKTIME | TIMS | 6 | 0 | |||||||||
| TDTITLE | Title in dialog box | TDTITLE | CHAR | 50 | 0 | |||||||||
| TDCOVER | Print: SAP cover page | SYPRSAP | CHAR | 1 | 0 |
Possible values
|
||||||||
| TDCOVTITLE | Spool Description | SYPRTXT | CHAR | 68 | 0 | |||||||||
| TDARMOD | Print: Archiving mode | SYARMOD | CHAR | 1 | 0 |
Possible values
|
||||||||
| FDCOPIES | Number of copies | RSPOCOPIES | INT1 | 3 | 0 | |||||||||
| FDDEST | Spool: Output device | RSPOPNAME | TSP03 | CHAR | 4 | 0 | ||||||||
| FDPREVIEW | Print preview | TDPREVIEW | CHAR | 1 | 0 |
Possible values
|
||||||||
| FDNOPRINT | No printing from print preview | TDNOPRINT | CHAR | 1 | 0 |
Possible values
|
||||||||
| FDNEWID | New Spool Request | SYPRNEW | CHAR | 1 | 0 | |||||||||
| FDDATASET | Spool request: Name | RSPO0NAME | CHAR | 6 | 0 | |||||||||
| FDSUFFIX1 | Spool request: Suffix 1 | RSPO1NAME | CHAR | 4 | 0 | |||||||||
| FDSUFFIX2 | Spool request: Suffix 2 | RSPO2NAME | CHAR | 12 | 0 | |||||||||
| FDIMMED | Immediate Spool Print | SYPRIMM | CHAR | 1 | 0 | |||||||||
| FDDELETE | Immediate Spool Deletion | SYPRREL | CHAR | 1 | 0 | |||||||||
| FDLIFETIME | Spool Retention Period | SYPEXPI | NUMC | 1 | 0 | |||||||||
| FDSCHEDULE | Send time request | SKSCHEDULE | CHAR | 3 | 0 |
Possible values
|
||||||||
| FDSENDDATE | Requested send date | SKDATE | DATS | 8 | 0 | |||||||||
| FDSENDTIME | Requested send time | SKTIME | TIMS | 6 | 0 | |||||||||
| FDTITLE | Title in dialog box | TDTITLE | CHAR | 50 | 0 | |||||||||
| FDCOVER | Print: SAP cover page | SYPRSAP | CHAR | 1 | 0 |
Possible values
|
||||||||
| FDCOVTITLE | Spool Description | SYPRTXT | CHAR | 68 | 0 | |||||||||
| FDARMOD | Print: Archiving mode | SYARMOD | CHAR | 1 | 0 |
Possible values
|
||||||||
| SFORMCT | Form Category | TB_FRMCAT | NUMC | 1 | 0 |
Possible values
|
||||||||
AT80 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| AT80 | BUKRS | AT80 | MANDT | T001 | Company Codes | MANDT |
| AT80 | BUKRS | AT80 | BUKRS | T001 | Company Codes | BUKRS |
| AT80 | CORTYP | AT80 | CORTYP | AT81 | Correspondence type | CORTYP |
| AT80 | CORTYP | AT80 | MANDT | AT81 | Correspondence type | MANDT |
| AT80 | FDDEST | AT80 | FDDEST | TSP03 | Spool: Printer declaration | PADEST |
| AT80 | MANDT | AT80 | MANDT | T000 | Clients | MANDT |
| AT80 | SFGZUSTT | AT80 | SFGZUSTT | AT02 | Transaction Activity Category | SFGZUSTT |
| AT80 | SFGZUSTT | * | AT02 | Transaction Activity Category | SANLFOR | |
| AT80 | SFGZUSTT | * | AT02 | Transaction Activity Category | SFGTYP | |
| AT80 | SFHAART | AT80 | MANDT | AT10 | Transaction Types | MANDT |
| AT80 | SFHAART | AT80 | SGSART | AT10 | Transaction Types | SGSART |
| AT80 | SFHAART | AT80 | SFHAART | AT10 | Transaction Types | SFHAART |
| AT80 | SFUNKTL | AT80 | SFUNKTL | AT60 | Definition of Treasury Functions for Activity Processing | SFUNKTION |
| AT80 | SGSART | AT80 | MANDT | TZPA | Financial Assets Management Product Types | MANDT |
| AT80 | SGSART | AT80 | SGSART | TZPA | Financial Assets Management Product Types | GSART |
| AT80 | TDDEST | AT80 | TDDEST | TSP03 | Spool: Printer declaration | PADEST |
