SE11 ABAP Dictionary SE11 NAST

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

NAST

Message Status

SAP SAP Transparent Table 82 Fields

Primary Key:

MANDT KAPPL OBJKY KSCHL SPRAS PARNR PARVW ERDAT ERUHR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	KAPPL	KEY	Applicat.	CHAR	2	-	-	Application for message conditions
3	OBJKY	KEY	Object key	CHAR	30	-	-	Object key
4	KSCHL	KEY	Msg.type	CHAR	4	-	-	Message type
5	SPRAS	KEY	Language	LANG	1	-	T002	Message language
6	PARNR	KEY	Partner	CHAR	10	-	-	Message partner
7	PARVW	KEY	Role	CHAR	2	-	-	Partner function (for example SH for ship-to party)
8	ERDAT	KEY	Created on	DATS	8	-	-	Date on which status record was created
9	ERUHR	KEY	Time	TIMS	6	-	-	Time at which status record was created
10	ADRNR	-	Addr. no.	CHAR	10	-	-	Address number
11	NACHA	-	Medium	CHAR	1	-	-	Message transmission medium
12	ANZAL	-	Number	DEC	2	-	-	Number of messages (original + copies)
13	VSZTP	-	Date/Time	CHAR	1	-	-	Dispatch time
14	VSDAT	-	Date	DATS	8	-	-	Requested date for sending message
15	VSURA	-	Time from	TIMS	6	-	-	Requested time for sending message (from)
16	VSURB	-	To	TIMS	6	-	-	Requested time for sending message (to)
17	MANUE	-	Msg.manual	CHAR	1	-	-	Message processed manually
18	DATVR	-	Date	DATS	8	-	-	Processing date
19	UHRVR	-	Time	TIMS	6	-	-	Processing time
20	DATRE	-	Resp.date	DATS	8	-	-	Date of the expected response to a message
21	USNAM	-	User	CHAR	12	-	-	User Name
22	VSTAT	-	Status	CHAR	1	-	-	Processing status of message
23	AKTIV	-	Active	CHAR	1	-	-	Active
24	TCODE	-	Strategy	CHAR	4	-	-	Communication strategy
25	LDEST	-	OutputDev.	CHAR	4	-	-	Spool: Output device
26	DSNAM	-	Name	CHAR	6	-	-	Spool request: Name
27	DSUF1	-	Suffix 1	CHAR	4	-	-	Spool request: Suffix 1
28	DSUF2	-	Suffix 2	CHAR	12	-	-	Spool request: Suffix 2
29	DIMME	-	Immediate	CHAR	1	-	-	Print immediately
30	DELET	-	Release	CHAR	1	-	-	Release after output
31	TELFX	-	Fax	CHAR	31	-	-	Fax number
32	TELX1	-	Telex	CHAR	30	-	-	Telex number
33	TELTX	-	Teletex	CHAR	30	-	-	Teletex number
34	AENDE	-	Change	CHAR	1	-	-	Change message flag
35	REPET	-	Repeatable	CHAR	1	-	-	Repeatability of message
36	REPID	-	Not used	CHAR	8	-	-	Unused field
37	PFLD1	-	Not used	CHAR	30	-	-	Unused field
38	PFLD2	-	Not used	CHAR	30	-	-	Unused field
39	PFLD3	-	Not used	CHAR	30	-	-	Unused field
40	PFLD4	-	Form	CHAR	30	-	-	WFMC: SAPscript form in 30-character field
41	PFLD5	-	Module	CHAR	30	-	-	WFMC: Function module for print formatting
42	PMID1	-	Not used	CHAR	3	-	-	Unused field
43	PMID2	-	Not used	CHAR	3	-	-	Unused field
44	PMID3	-	Not used	CHAR	3	-	-	Unused field
45	PMID4	-	Not used	CHAR	3	-	-	Unused field
46	PMID5	-	Not used	CHAR	3	-	-	Unused field
47	TDNAME	-	Obj.key	CHAR	70	-	-	Object key (long)
48	TDID	-	ID	CHAR	4	-	-	Text ID
49	TDSPRAS	-	Language	LANG	1	-	-	Language Key
50	EDIKEY	-	Dunn. Date	CHAR	8	-	-	Dunning Date (Used in Retail)
51	EDITRANS	-	Dunn. Time	CHAR	6	-	-	Dunning Time (Used in Retail)
52	SNDDR	-	Disregard	CHAR	1	-	-	Send: As disregard
53	SNDEX	-	Not used	CHAR	1	-	-	Unused field
54	SNDCP	-	Not used	CHAR	1	-	-	Unused field
55	SNDBC	-	Addr. type	CHAR	1	-	-	Address type (1=Organization, 2=Person, 3=Contact person)
56	FORFB	-	Requested Status	CHAR	1	-	-	Requested Status
57	PRIFB	-	Setting for Which Statuses Are Reported by Mail	CHAR	1	-	-	Setting for Which Statuses Are Reported by Mail
58	ACALL	-	Not used	CHAR	1	-	-	Unused field
59	OBJAC	-	Not used	CHAR	1	-	-	Unused field
60	OBJRR	-	Not used	CHAR	1	-	-	Unused field
61	OBJRN	-	Not used	CHAR	1	-	-	Unused field
62	OUTFL	-	Not used	CHAR	1	-	-	Unused field
63	OBJSNS	-	Not used	CHAR	1	-	-	Unused field
64	OBJPRI	-	Not used	CHAR	1	-	-	Unused field
65	OBJCP	-	Not used	CHAR	1	-	-	Unused field
66	NAUTO	-	Automatic	CHAR	1	-	-	Message determined via conditions
67	TDRECEIVER	-	Recipient	CHAR	12	-	-	Recipient (Print Parameters)
68	TDDIVISION	-	Department	CHAR	12	-	-	Department on Cover Page (Print Parameters)
69	TDOCOVER	-	SAP cover	CHAR	1	-	-	Print: SAP cover page
70	TDCOVTITLE	-	Text	CHAR	68	-	-	Text for Cover Page (Print Parameters)
71	TDAUTORITY	-	Auth.	CHAR	12	-	-	Print: Authorization
72	TDARMOD	-	Arch.Mode	CHAR	1	-	-	Print: Archiving mode
73	OPTARCNR	-	ArchiveNo.	NUMC	10	-	-	Archive number for optical archives
74	CMFPNR	-	No.	NUMC	12	-	-	Error management number
75	USRNAM	-	Address	CHAR	12	-	-	WFMC: Address number, 12 characters
76	EVENT	-	Event	CHAR	32	-	-	Event
77	SORT1	-	Sort Order	CHAR	20	-	-	Sort criteria for message status records
78	SORT2	-	Sort Order	CHAR	20	-	-	Sort criteria for message status records
79	SORT3	-	Sort Order	CHAR	20	-	-	Sort criteria for message status records
80	OBJTYPE	-	Obj.type	CHAR	10	-	-	Object type
81	TDSCHEDULE	-	Time plan	CHAR	3	-	-	Send time request
82	TLAND	-	Country	CHAR	3	-	-	Country Key

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk NAST.

Interactive ERD Diagrams

SAP SD - Billing Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

NACE VV13 VV33 MN06

Related Tables

T002 VBRK VBRP VRKPA VRPMA VKDFS VBSK VBSS

ANSI SQL Query

SELECT a.KAPPL,
       a.OBJKY,
       a.KSCHL,
       a.SPRAS,
       a.PARNR,
       a.PARVW,
       a.ERDAT
FROM NAST AS a
WHERE a.KAPPL = '0001'
  AND a.OBJKY = '0001';

ABAP OpenSQL (7.40+)

SELECT a~kappl,
       a~objky,
       a~kschl,
       a~spras,
       a~parnr,
       a~parvw,
       a~erdat
  FROM nast AS a
  WHERE a~kappl = '0001'
  and a~objky = '0001'
  INTO TABLE @DATA(lt_nast)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 NAST

NAST

Dictionary Fields Fields

Related References & SQL