| 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 | VANR | IS-HCM: Dispatch Message Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VNNR | Allow NULL? |
| 4 | APPLK | Application (Always N for IS-H) | char | 1 | 0 | CHAR | (N' ') | Yes | | APPKL | Allow NULL? |
| 5 | EVENT | IS-H: Event for Triggering Messages, Forms | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | N_EVENT | Allow NULL? |
| 6 | DESTSYSTEM | Receiving System (Target System) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | RCVSYSTEM | Allow NULL? |
| 7 | XCOMNAME | IS-HCM: Name of the Communication Partner in Table TXCOM | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | XCOMNAME | Allow NULL? |
| 8 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TNCST | CMSTD | Allow NULL? |
| 9 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNCST | STDVER | Allow NULL? |
| 10 | SPECHARS | IS-HCM: Special Characters Agreed (Standard-Dependent) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | SPECHARS | Allow NULL? |
| 11 | NTOWNERCDE | IS-HCM: Message Type Owner Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NTOWNERCDE | Allow NULL? |
| 12 | NTNR | IS-HCM: Message Type Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | NTNR | Allow NULL? |
| 13 | KEY1 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 14 | KEY2 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 15 | KEY3 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 16 | KEY4 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 17 | KEY5 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 18 | KEY6 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KEYARG | Allow NULL? |
| 19 | DATUM | IS-HCM: Date when Order Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUFTRDAT | Allow NULL? |
| 20 | UZEIT | IS-HCM Time of request creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AUFTRTIM | Allow NULL? |
| 21 | SNDUSER | User who Created Dispatch Order (USER ID) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AUFTRUSR | Allow NULL? |
| 22 | TESTORDSGN | IS-HCM: Indicator test dispatch order | char | 1 | 0 | CHAR | (N' ') | Yes | | TESTORDSGN | Allow NULL? |
| 23 | DESTLU | IS-HCM: Logical Unit of Communication Partner | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | NLU | Allow NULL? |
| 24 | SUBKEY1 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
| 25 | SUBKEY2 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
| 26 | SUBKEY3 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
| 27 | SUBKEY4 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
| 28 | SUBKEY5 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
| 29 | SUBKEY6 | IS-H: Additional key value for single event processing | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SUBKEYARG | Allow NULL? |
