| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | No | TNCST | CMSTD | Allow NULL? |
| 2 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | No | TNCST | STDVER | Allow NULL? |
| 3 | SGOWNERCDE | IS-HCM: Message Segment Owner Code | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SGOWNERCDE | Allow NULL? |
| 4 | SGNR | IS-HCM: Message Segment Number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | SGNR | Allow NULL? |
| 5 | SGKRZ | IS-HCM: Segment ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SGKRZ | Allow NULL? |
| 6 | SGPAR1 | IS-HCM: Segment parameters for retrieving data from ISH-DB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SGPAR | Allow NULL? |
| 7 | SGPAR2 | IS-HCM: Segment parameters for retrieving data from ISH-DB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SGPAR | Allow NULL? |
| 8 | SGPAR3 | IS-HCM: Segment parameters for retrieving data from ISH-DB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SGPAR | Allow NULL? |
| 9 | SGPAR4 | IS-HCM: Segment parameters for retrieving data from ISH-DB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SGPAR | Allow NULL? |
| 10 | SGPAR5 | IS-HCM: Segment parameters for retrieving data from ISH-DB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SGPAR | Allow NULL? |
| 11 | SGPRIDB | IS-HCM: Segment Primary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGPRIDB | Allow NULL? |
| 12 | SGSECDB1 | IS-HCM: Segment Secondary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGSECDB | Allow NULL? |
| 13 | SGMXLDB1 | IS-HCM: Max. Number of Entries in Secondary Table per Segmt | char | 1 | 0 | CHAR | (N' ') | Yes | | SGMXLDB | Allow NULL? |
| 14 | SGSECDB2 | IS-HCM: Segment Secondary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGSECDB | Allow NULL? |
| 15 | SGMXLDB2 | IS-HCM: Max. Number of Entries in Secondary Table per Segmt | char | 1 | 0 | CHAR | (N' ') | Yes | | SGMXLDB | Allow NULL? |
| 16 | SGSECDB3 | IS-HCM: Segment Secondary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGSECDB | Allow NULL? |
| 17 | SGMXLDB3 | IS-HCM: Max. Number of Entries in Secondary Table per Segmt | char | 1 | 0 | CHAR | (N' ') | Yes | | SGMXLDB | Allow NULL? |
| 18 | SGSECDB4 | IS-HCM: Segment Secondary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGSECDB | Allow NULL? |
| 19 | SGMXLDB4 | IS-HCM: Max. Number of Entries in Secondary Table per Segmt | char | 1 | 0 | CHAR | (N' ') | Yes | | SGMXLDB | Allow NULL? |
| 20 | SGSECDB5 | IS-HCM: Segment Secondary DB Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SGSECDB | Allow NULL? |
| 21 | SGMXLDB5 | IS-HCM: Max. Number of Entries in Secondary Table per Segmt | char | 1 | 0 | CHAR | (N' ') | Yes | | SGMXLDB | Allow NULL? |
| 22 | FRMDBT | IS-HCM Name of respective form DB table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | FRMDBT | Allow NULL? |
| 23 | INPOOL | IS-HCM: FORM Routine Pool for Inbound Message Formatting | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | TRDIR | INPOOL | Allow NULL? |
| 24 | INPROC | IS-HCM: FORM routine for inbound formats | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | INPROC | Allow NULL? |
| 25 | OUTPOOL | IS-HCM: FORM Routine Pool for Outbound Msg. Formatting | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | TRDIR | OUTPOOL | Allow NULL? |
| 26 | OUTPROC | IS-HCM: FORM routine for outbound msg. formatting | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | OUTPROC | Allow NULL? |
| 27 | AUTOFILL | IS-HCM: Automatic Data Retrieval Parameter | char | 1 | 0 | CHAR | (N' ') | Yes | | AUTOFILL | Allow NULL? |
| 28 | REPEAT | IS-HCM: Max. Repetition Factor Msg. Segment in Msg. Type | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | REPEAT | Allow NULL? |
| 29 | SGSTAT | IS-HCM: Status of Message Segment | char | 1 | 0 | CHAR | (N' ') | Yes | | SGSTAT | Allow NULL? |
| 30 | UPMANDT | IS-HCM: Client of Last Person to Have Made Changes | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | T000 | UPMANDT | Allow NULL? |
| 31 | SGAEU | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 32 | SGADT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 33 | FBSEGM | IS-H: Name of SAP Function Module for Segment Determination | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | FBSEGM | Allow NULL? |
| 34 | ADDFIELDS | IS-HCM: Indicator for Additional Fields in Customer Segment | char | 1 | 0 | CHAR | (N' ') | Yes | | NADDFIELDS | Allow NULL? |
| 35 | HEADERSIGN | IS-HCM: Indicator for Header Segment | char | 1 | 0 | CHAR | (N' ') | Yes | | HEADERSIGN | Allow NULL? |
| 36 | ENDSGMSIGN | IS-HCM: Indicator for trailer | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDSGMSIGN | Allow NULL? |
| 37 | LGRSGMSIGN | Indicator for Logical Group Segment | char | 1 | 0 | CHAR | (N' ') | Yes | | NLGRSGMIND | Allow NULL? |
