| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | VNNR | IS-HCM: Dispatch Message Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VNNR | Allow NULL? |
| 4 | FOLGENR | IS-HCM: Disp. Message Sequence No. for Extremely Long Msgs. | nvarchar | 3 | 0 | NUMC | (N'000') | No | | VNFOLGENR | Allow NULL? |
| 5 | ABSENDER | IS-HCM Sending org. unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ABSORGEH | Allow NULL? |
| 6 | SENDSYSTEM | IS-HCM: Sending system | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ABSSYSTEM | Allow NULL? |
| 7 | DESTSYSTEM | Receiving System (Target System) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TN02S | RCVSYSTEM | Allow NULL? |
| 8 | XCOMDEST | IS-HCM: Name of the Communication Partner in Table TXCOM | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | XCOMNAME | Allow NULL? |
| 9 | VANR | IS-HCM: Dispatch Order Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | VANR | Allow NULL? |
| 10 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TNCST | CMSTD | Allow NULL? |
| 11 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNCST | STDVER | Allow NULL? |
| 12 | NTOWNERCDE | IS-HCM: Message Type Owner Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NTOWNERCDE | Allow NULL? |
| 13 | NTNR | IS-HCM: Message Type Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNCT0 | NTNR | Allow NULL? |
| 14 | SENDDATUM | IS-HCM: Date when message was sent (successfully) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SENDEDAT | Allow NULL? |
| 15 | SENDUZEIT | IS-HCM: Time of day when message was sent | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SENDETIM | Allow NULL? |
| 16 | BUILDDATUM | IS-HCM: Date when Message Ready to Send Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FERTIGDAT | Allow NULL? |
| 17 | BUILDUZEIT | IS-HCM: Creation time of message ready for dispatch | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FERTIGTIM | Allow NULL? |
| 18 | TESTMSGSGN | IS-HCM: Indicator test message | char | 1 | 0 | CHAR | (N' ') | Yes | | TESTMSGSGN | Allow NULL? |
| 19 | GESAMTANZ | IS-HCM: Total Length of HCM Message (in Charcters) | int | 10 | 0 | INT4 | ((0)) | Yes | | WHOLELEN | Allow NULL? |
| 20 | ANZ | IS-HCM Length of HCM message (in character) | smallint | 5 | 0 | INT2 | ((0)) | Yes | | LENMAIL | |
| 21 | MAIL | IS-HCM Contents of HCM message | nvarchar | 1024 | 0 | LCHR | | Yes | | MAILDATA | Allow NULL? |
