SE11 ABAP Dictionary SE11 NAST

Data SE16 SE16
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

Dictionary Fields Fields

(82 dari 82 kolom)
# 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.