SAP table NAST (Message Status)

SAP table NAST has 9 primary key fields being MANDT,KAPPL,OBJKY,KSCHL,SPRAS,PARNR,PARVW,ERDAT,ERUHR.

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
KAPPL Application for message conditions CHAR 2 0 SNA_KAPPL
OBJKY Object key CHAR 30 0 NA_OBJKEY
KSCHL Message type CHAR 4 0 SNA_KSCHL
SPRAS Message language LANG 1 0 T002 NA_SPRAS
PARNR Message partner CHAR 10 0 NA_PARNR
PARVW Partner function (for example SH for ship-to party) CHAR 2 0 SNA_PARVW
ERDAT Date on which status record was created DATS 8 0 NA_ERDAT
ERUHR Time at which status record was created TIMS 6 0 NA_ERUHR
ADRNR Address Number CHAR 10 0 * AD_ADDRNUM
NACHA Message transmission medium CHAR 1 0 NA_NACHA
1 Print output
2 Fax
4 Telex
5 External send
6 EDI
7 Simple Mail
8 Special function
9 Events (SAP Business Workflow)
A Distribution (ALE)
T Tasks (SAP Business Workflow)
ANZAL Number of messages (original + copies) DEC 2 0 NA_ANZAL
VSZTP Dispatch time CHAR 1 0 NA_VSZTP
1 Send with periodically scheduled job
2 Send with job, with additional time specification
3 Send with application own transaction
4 Send immediately (when saving the application)
VSDAT Requested date for sending message DATS 8 0 NA_VSDAT
VSURA Requested time for sending message (from) TIMS 6 0 NA_VSURA
VSURB Requested time for sending message (to) TIMS 6 0 NA_VSURB
MANUE Message processed manually CHAR 1 0 NA_MANUE
No manual processing
X Message processed manually
DATVR Processing date DATS 8 0 NA_DATVR
UHRVR Processing time TIMS 6 0 NA_UHRVR
DATRE Date of the expected response to a message DATS 8 0 NA_DATRE
USNAM User Name CHAR 12 0 * USNAM
VSTAT Processing status of message CHAR 1 0 NA_VSTAT
0 Not processed
1 Successfully processed
2 Processed with errors
AKTIV Active CHAR 1 0 NA_AKTIV
TCODE Communication strategy CHAR 4 0 TCSTR CSTRATEGY
LDEST Spool: Output device CHAR 4 0 TSP03 RSPOPNAME
DSNAM Spool request: Name CHAR 6 0 RSPO0NAME
DSUF1 Spool request: Suffix 1 CHAR 4 0 RSPO1NAME
DSUF2 Spool request: Suffix 2 CHAR 12 0 RSPO2NAME
DIMME Print immediately CHAR 1 0 TDIMMED
DELET Release after output CHAR 1 0 TDDELETE
TELFX Fax number CHAR 31 0 NA_TELFX
TELX1 Telex number CHAR 30 0 TELX1
TELTX Teletex number CHAR 30 0 TELTX
AENDE Change message flag CHAR 1 0 NA_AENDE
No change message
X Change message
REPET Repeatability of message CHAR 1 0 NA_REPET
Repetition allowed
1 Repetition allowed (dialog step)
2 Repetition not allowed
REPID Unused field CHAR 8 0 NA_OBS008
PFLD1 Unused field CHAR 30 0 NA_OBS030
PFLD2 Unused field CHAR 30 0 NA_OBS030
PFLD3 Unused field CHAR 30 0 NA_OBS030
PFLD4 WFMC: SAPscript form in 30-character field CHAR 30 0 NA_TDFORM
PFLD5 WFMC: Function module for print formatting CHAR 30 0 TFDIR NA_LABEL
PMID1 Unused field CHAR 3 0 NA_OBS003
PMID2 Unused field CHAR 3 0 NA_OBS003
PMID3 Unused field CHAR 3 0 NA_OBS003
PMID4 Unused field CHAR 3 0 NA_OBS003
PMID5 Unused field CHAR 3 0 NA_OBS003
TDNAME Object key (long) CHAR 70 0 NA_OBJKY_L
TDID Text ID CHAR 4 0 TTXID TDID
TDSPRAS Language Key LANG 1 0 T002 SPRAS
EDIKEY Dunning Date (Used in Retail) CHAR 8 0 NA_DUNNING_DATE
EDITRANS Dunning Time (Used in Retail) CHAR 6 0 NA_DUNNING_TIME
SNDDR Send: As disregard CHAR 1 0 SO_SND_DR
SNDEX Unused field CHAR 1 0 NA_OBS001
SNDCP Unused field CHAR 1 0 NA_OBS001
SNDBC Address type (1=Organization, 2=Person, 3=Contact person) CHAR 1 0 AD_ADRTYPE
1 Organization, Company
2 Private address
3 Contact person (in company)
FORFB Requested Status CHAR 1 0 BCS_RQST
A Always
D If sent
E Only if errors occur
N Never
R If read
PRIFB Setting for Which Statuses Are Reported by Mail CHAR 1 0 BCS_STML
A Always
D If sent
E Only if errors occur
N Never
R If read
ACALL Unused field CHAR 1 0 NA_OBS001
OBJAC Unused field CHAR 1 0 NA_OBS001
OBJRR Unused field CHAR 1 0 NA_OBS001
OBJRN Unused field CHAR 1 0 NA_OBS001
OUTFL Unused field CHAR 1 0 NA_OBS001
OBJSNS Unused field CHAR 1 0 NA_OBS001
OBJPRI Unused field CHAR 1 0 NA_OBS001
OBJCP Unused field CHAR 1 0 NA_OBS001
NAUTO Message Determined by Conditions CHAR 1 0 NA_NAUTO
TDRECEIVER Spool Recipient Name CHAR 12 0 SYPRREC
TDDIVISION Spool Department Name CHAR 12 0 SYPRABT
TDOCOVER Print: SAP cover page CHAR 1 0 SYPRSAP
Do not print
D Default (Printer Setting)
X Print
TDCOVTITLE Spool Description CHAR 68 0 SYPRTXT
TDAUTORITY Print: Authorization CHAR 12 0 SYPRBER
TDARMOD Print: Archiving mode CHAR 1 0 SYARMOD
1 Print only
2 Archive only
3 Print and archive
OPTARCNR Archive number for optical archives NUMC 10 0 NA_OPTAR
CMFPNR Error management number NUMC 12 0 NA_CMF_NR
USRNAM WFMC: Address number, 12 characters CHAR 12 0 NA_PERS_12
EVENT Event CHAR 32 0 SWO_EVENT
SORT1 Sort criteria for message status records CHAR 20 0 NAST_SORTK
SORT2 Sort criteria for message status records CHAR 20 0 NAST_SORTK
SORT3 Sort criteria for message status records CHAR 20 0 NAST_SORTK
OBJTYPE Object type CHAR 10 0 TOJTB OJ_NAME
TDSCHEDULE Send time request CHAR 3 0 SKSCHEDULE
IMM Send immediately
NIG Send at night
TLAND Country/Region Key CHAR 3 0 T005 LAND1
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

NAST foreign key relationships

Table Field Check Table Check Field
0 NAST LDEST TSP03 Spool: Printer declaration PADEST
1 NAST MANDT T000 Clients MANDT
0 NAST OBJTYPE TOJTB Business object repository: Basic data NAME
1 NAST PFLD5 TFDIR Function Module FUNCNAME
0 NAST SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 NAST TCODE TCSTR Communication strategy MANDT
1 NAST TCODE TCSTR Communication strategy STRATEGY
0 NAST TDSPRAS T002 Language Keys (Component BC-I18) SPRAS
1 NAST TLAND T005 Countries MANDT
1 NAST TLAND T005 Countries LAND1