SAP table NACH (Detailed output data)

SAP table NACH has 2 primary key fields being MANDT,KNUMH.

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
KNUMH Number of output condition record CHAR 10 0 NNUMH
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KOTABNR Number of the Condition Table CHAR 3 0 T681 KOTABNR
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHL_OC
DATAB Valid-From Date DATS 8 0 DATAB
DATBI Valid To Date DATS 8 0 DATBI
KOSRT Search term for conditions CHAR 10 0 KOSRT
PARVW Partner Function CHAR 2 0 TPAR PARVW
PARNR Message partner CHAR 10 0 NA_PARNR_OC
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)
TCODE Communication strategy CHAR 4 0 TCSTR CSTRATEGY
AENDE Change message flag CHAR 1 0 NA_AENDE
No change message
X Change message
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 Smart Forms: Form Name CHAR 30 0 TDSFNAME
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
SPRAS Language Key LANG 1 0 T002 SPRAS
SNDDR Unused field CHAR 1 0 NA_OBS001
SNDEX Unused field CHAR 1 0 NA_OBS001
SNDCP Unused field CHAR 1 0 NA_OBS001
SNDBC Unused field CHAR 1 0 NA_OBS001
FORFB Requested Status CHAR 1 0 BCS_RQST_OC
PRIFB Setting for Which Statuses Are Reported by Mail CHAR 1 0 BCS_STML_OC
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
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_OC
DELET Release after output CHAR 1 0 TDDELETE_OC
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
ACOUT ToDo: To Be Completed Outside SAPoffice CHAR 1 0 SO_ACOUT
SKIPS Unused field CHAR 1 0 NA_OBS001
ACMEM Process: memory ID CHAR 32 0 SO_ACMEM
ACNAM Execute: Name of report, FM, DB, T-Codes (old length) CHAR 30 0 SNA_ACNAM
EVENT Event CHAR 32 0 SWO_EVENT
OBJTYPE Object type CHAR 10 0 OBJ_NAME_OC
TDSCHEDULE Send time request CHAR 3 0 SKSCHEDULE_OC
TDARMOD Print: Archiving mode CHAR 1 0 SYARMOD_OC

NACH foreign key relationships

Table Field Check Table Check Field
0 NACH KAPPL T681A Conditions: Applications KAPPL
1 NACH KOTABNR T681 Conditions: Structures KOTABNR
0 NACH KSCHL T685 Conditions: Types KAPPL
0 NACH KSCHL T685 Conditions: Types KSCHL
1 NACH KVEWE T681V Conditions: Usages KVEWE
0 NACH LDEST TSP03 Spool: Printer declaration PADEST
1 NACH MANDT T000 Clients MANDT
0 NACH PARVW TPAR Business Partner: Functions PARVW
1 NACH PFLD5 TFDIR Function Module FUNCNAME
0 NACH SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 NACH TCODE TCSTR Communication strategy MANDT
1 NACH TCODE TCSTR Communication strategy STRATEGY