| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | GUID_LEGMES | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/POBJT | Allow NULL? |
| 4 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/POBJ_GUID_16 | |
| 5 | PROCS | Process Template | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLEPS | /SAPSLL/PROCS | Allow NULL? |
| 6 | PROSS | Process | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLEPR | /SAPSLL/PROSS | Allow NULL? |
| 7 | PROSA | Process Activity | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLEPRA | /SAPSLL/PROSA | Allow NULL? |
| 8 | PROSN | Activity Message | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLEACM | /SAPSLL/PROSN | Allow NULL? |
| 9 | PNFCT | Counter for Message within Activity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /SAPSLL/PNFCT | Allow NULL? |
| 10 | PFACT | Counter for Follow-up Activities | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | /SAPSLL/PFACT | Allow NULL? |
| 11 | NACST | Status of a Message | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/NACST | Allow NULL? |
| 12 | GUID_PPF_TRIGG | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 13 | MOBJT | Type of Main Object | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MOBJT | Allow NULL? |
| 14 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/MOBJ_GUID_16 | |
| 15 | ACTPA | Responsibility for Activity Message | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/ACTPA | Allow NULL? |
| 16 | NATYP | Message Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/NATYP | Allow NULL? |
| 17 | EDI_MESTYP | Message Type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EDMSG | EDI_MESTYP | Allow NULL? |
| 18 | SEMES | Procedure for Electronic Messages | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLESEM | /SAPSLL/SEMES | Allow NULL? |
| 19 | EMESS | Identification of Electronic Messages | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLEEME | /SAPSLL/EMESS | Allow NULL? |
| 20 | EDITN | Technical Name of EDI Message | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/EDITN | Allow NULL? |
| 21 | MSVER | Message Version | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MSVER | Allow NULL? |
| 22 | MESGR | Message Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MESGR | Allow NULL? |
| 23 | EDINR | Identification/Message Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/EDINR | Allow NULL? |
| 24 | CREDAT | IDoc Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EDI_CCRDAT | Allow NULL? |
| 25 | CRETIM | IDoc Created at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | EDI_CCRTIM | Allow NULL? |
| 26 | QALCOM | Qualifier for Communication Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/QALCOM | Allow NULL? |
| 27 | REFNO | Reference Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/REFNO | Allow NULL? |
| 28 | NOVER | Version of Reference Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/NOVER | Allow NULL? |
| 29 | DOCNUM | IDoc number | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | EDI_DOCNUM | Allow NULL? |
| 30 | VERSI | Version Number of Message | smallint | 5 | 0 | INT2 | ((0)) | Yes | | /SAPSLL/VERSI | |
| 31 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 32 | EDIFCT | EDIFACT Message Function | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/EDIFCT | Allow NULL? |
| 33 | MSGCH | Change Message | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MSGCH | Allow NULL? |
| 34 | MSGOB | Message is completed due to communication restart | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MSGOB | Allow NULL? |
| 35 | EDIASS | EDI Message Assigned | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/EDIASS | Allow NULL? |
| 36 | FILEID | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 37 | GUID_TSHD | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 38 | LRNNO | Local Reference Number of Message | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/LRNNO | Allow NULL? |