| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID_LEGMES | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 3 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | | | | |
| 5 | PROCS | Process Template | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | PROSS | Process | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | PROSA | Process Activity | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | PROSN | Activity Message | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | PNFCT | Counter for Message within Activity | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | PFACT | Counter for Follow-up Activities | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | NACST | Status of a Message | char | 1 | 0 | | | | Allow NULL? |
| 12 | GUID_PPF_TRIGG | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 13 | MOBJT | Type of Main Object | char | 1 | 0 | | | | Allow NULL? |
| 14 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | | | | |
| 15 | ACTPA | Responsibility for Activity Message | char | 1 | 0 | | | | Allow NULL? |
| 16 | NATYP | Message Type | char | 1 | 0 | | | | Allow NULL? |
| 17 | EDI_MESTYP | Message Type | nvarchar | 30 | 0 | | | | Allow NULL? |
| 18 | SEMES | Procedure for Electronic Messages | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | EMESS | Identification of Electronic Messages | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | EDITN | Technical Name of EDI Message | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | MSVER | Message Version | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | MESGR | Message Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | EDINR | Identification/Message Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 24 | CREDAT | IDoc Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | CRETIM | IDoc Created at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | QALCOM | Qualifier for Communication Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | REFNO | Reference Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 28 | NOVER | Version of Reference Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | DOCNUM | IDoc number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 30 | VERSI | Version Number of Message | smallint | 5 | 0 | | | | |
| 31 | UNAME | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 32 | EDIFCT | EDIFACT Message Function | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | MSGCH | Change Message | char | 1 | 0 | | | | Allow NULL? |
| 34 | MSGOB | Message is completed due to communication restart | char | 1 | 0 | | | | Allow NULL? |
| 35 | EDIASS | EDI Message Assigned | char | 1 | 0 | | | | Allow NULL? |
| 36 | FILEID | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 37 | GUID_TSHD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 38 | LRNNO | Local Reference Number of Message | nvarchar | 40 | 0 | | | | Allow NULL? |
