SAP table AT80 (Treasury: Correspondence Control MM, FX, DE, SE)

SAP table AT80 has 7 primary key fields being MANDT,BUKRS,SGSART,SFHAART,SFGZUSTT,SFUNKTL,CORTYP.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
SGSART Product Type CHAR 3 0 TZPA VVSART
SFHAART Financial Transaction Type CHAR 3 0 AT10 TB_SFHAART
SFGZUSTT Transaction Activity Category NUMC 2 0 AT02 TB_SFGZUTY
SFUNKTL Latest Function Used in Editing Activity CHAR 4 0 AT60 TB_SFUNKTL_CORR
CORTYP Correspondence Type CHAR 3 0 AT81 TB_CORTYP
FORMULAR Form Name CHAR 16 0 TB_PDF_FORM
AUTOMATIC Indicator: Automatic Correspondence Required? CHAR 1 0 TB_AUTO
SOBLRECONF Counterconfirmation required? CHAR 1 0 TB_OBLRECO
TDCOPIES Number of copies INT1 3 0 RSPOCOPIES
TDDEST Spool: Output device CHAR 4 0 TSP03 RSPOPNAME
TDPREVIEW Print preview CHAR 1 0 TDPREVIEW
TDNOPRINT No printing from print preview CHAR 1 0 TDNOPRINT
TDNEWID New Spool Request CHAR 1 0 SYPRNEW
TDDATASET Spool request: Name CHAR 6 0 RSPO0NAME
TDSUFFIX1 Spool request: Suffix 1 CHAR 4 0 RSPO1NAME
TDSUFFIX2 Spool request: Suffix 2 CHAR 12 0 RSPO2NAME
TDIMMED Immediate Spool Print CHAR 1 0 SYPRIMM
TDDELETE Immediate Spool Deletion CHAR 1 0 SYPRREL
TDLIFETIME Spool Retention Period NUMC 1 0 SYPEXPI
TDSCHEDULE Send time request CHAR 3 0 SKSCHEDULE
IMM Send immediately
NIG Send at night
TDSENDDATE Requested send date DATS 8 0 SKDATE
TDSENDTIME Requested send time TIMS 6 0 SKTIME
TDTITLE Title in dialog box CHAR 50 0 TDTITLE
TDCOVER Print: SAP cover page CHAR 1 0 SYPRSAP
Do not print
D Default (Printer Setting)
X Print
TDCOVTITLE Spool Description CHAR 68 0 SYPRTXT
TDARMOD Print: Archiving mode CHAR 1 0 SYARMOD
1 Print only
2 Archive only
3 Print and archive
FDCOPIES Number of copies INT1 3 0 RSPOCOPIES
FDDEST Spool: Output device CHAR 4 0 TSP03 RSPOPNAME
FDPREVIEW Print preview CHAR 1 0 TDPREVIEW
FDNOPRINT No printing from print preview CHAR 1 0 TDNOPRINT
FDNEWID New Spool Request CHAR 1 0 SYPRNEW
FDDATASET Spool request: Name CHAR 6 0 RSPO0NAME
FDSUFFIX1 Spool request: Suffix 1 CHAR 4 0 RSPO1NAME
FDSUFFIX2 Spool request: Suffix 2 CHAR 12 0 RSPO2NAME
FDIMMED Immediate Spool Print CHAR 1 0 SYPRIMM
FDDELETE Immediate Spool Deletion CHAR 1 0 SYPRREL
FDLIFETIME Spool Retention Period NUMC 1 0 SYPEXPI
FDSCHEDULE Send time request CHAR 3 0 SKSCHEDULE
IMM Send immediately
NIG Send at night
FDSENDDATE Requested send date DATS 8 0 SKDATE
FDSENDTIME Requested send time TIMS 6 0 SKTIME
FDTITLE Title in dialog box CHAR 50 0 TDTITLE
FDCOVER Print: SAP cover page CHAR 1 0 SYPRSAP
Do not print
D Default (Printer Setting)
X Print
FDCOVTITLE Spool Description CHAR 68 0 SYPRTXT
FDARMOD Print: Archiving mode CHAR 1 0 SYARMOD
1 Print only
2 Archive only
3 Print and archive
SFORMCT Form Category NUMC 1 0 TB_FRMCAT

AT80 foreign key relationships

Table Field Check Table Check Field
0 AT80 BUKRS T001 Company Codes BUKRS
1 AT80 FDDEST TSP03 Spool: Printer declaration PADEST
0 AT80 MANDT T000 Clients MANDT
1 AT80 SFGZUSTT AT02 Transaction Activity Category SANLFOR
1 AT80 SFGZUSTT AT02 Transaction Activity Category SFGTYP
1 AT80 SFGZUSTT AT02 Transaction Activity Category SFGZUSTT
0 AT80 SFHAART AT10 Transaction Types SGSART
0 AT80 SFHAART AT10 Transaction Types SFHAART
1 AT80 SGSART TZPA Financial Assets Management Product Types MANDT
1 AT80 SGSART TZPA Financial Assets Management Product Types GSART
0 AT80 TDDEST TSP03 Spool: Printer declaration PADEST