| 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 | DAS301 | Data Collection Point for EDI Message Transmission | nvarchar | 10 | 0 | CHAR | (N' ') | No | NC301P | ISH_DAS301 | Allow NULL? |
| 4 | NINOUTSIGN | IS-HCM: Outbound - Inbound Message(s) Indicator | char | 1 | 0 | CHAR | (N' ') | No | | NINOUTSIGN | Allow NULL? |
| 5 | LF301M | IS-HCM: Seq. File Number (Data Cllct. Point-Specific) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ISH_LF301M | Allow NULL? |
| 6 | LF301 | IS-H: Message Number | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | * | ISH_LF301 | Allow NULL? |
| 7 | LF301F | IS-HCM: Sequence Number of EDI Message Record | nvarchar | 3 | 0 | NUMC | (N'000') | No | | ISH_LF301F | Allow NULL? |
| 8 | ERRSGM | IS-H: EDI Segment Description | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | N_301SGM | Allow NULL? |
| 9 | ERRSGMPOS | IS-H: Number of EDI segment (for repetition segments) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N_301SPOS | Allow NULL? |
| 10 | ERRFLDPOS | Number of Field in EDI Segment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | N_301FPOS | Allow NULL? |
| 11 | ECODE | IS-H: Error Code of EDI Messages (External) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_301ECODE | Allow NULL? |
| 12 | MSGTY | Message type (E, I, W, ...) | char | 1 | 0 | CHAR | (N' ') | Yes | | MSGTY_CO | Allow NULL? |
| 13 | ARBGB | Application Area | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | T100A | ARBGB | Allow NULL? |
| 14 | MSGNR | Message number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | MSGNR | Allow NULL? |
| 15 | MSGV1 | Message variable 01 | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | MSGV1 | Allow NULL? |
| 16 | MSGV2 | Message variable 02 | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | MSGV2 | Allow NULL? |
| 17 | MSGV3 | Message variable 03 | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | MSGV3 | Allow NULL? |
| 18 | MSGV4 | Message variable 04 | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | MSGV4 | Allow NULL? |
| 19 | RSTATUS | IS-H: Internal Status of EDI Inbound Message | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N_301ERRST | Allow NULL? |
| 20 | ERRTXT | IS-H: EDI Error Text | nvarchar | 73 | 0 | CHAR | (N' ') | Yes | | N_301ERRTX | Allow NULL? |