| 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 | FVNR | IS-M: Number of Shipping Problem Message | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | JVTFEHLER | FVNR | Allow NULL? |
| 3 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | LAND1 | Allow NULL? |
| 4 | ARTPOSTE | IS-M: Type of Postal Unit | nvarchar | 2 | 0 | NUMC | (N'00') | No | | ARTPOSTE | Allow NULL? |
| 5 | PSTEIN | IS-M: Postal unit number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | PSTEIN | Allow NULL? |
| 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | GUELTIGVON | Allow NULL? |
| 7 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | GUELTIGBIS | Allow NULL? |
| 8 | HNRKENN | IS-M: Identifier for House Number Range | char | 1 | 0 | CHAR | (N' ') | No | | HNRKENN | Allow NULL? |
| 9 | HAUSNRVON | IS-M: First House Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | HAUSNRVON | Allow NULL? |
| 10 | HAUSNRBIS | IS-M: Last House Number in Range | nvarchar | 10 | 0 | CHAR | (N' ') | No | | HAUSNRBIS | Allow NULL? |
| 11 | HNRZUSVON | IS-M/SD: First House Number Affix | nvarchar | 8 | 0 | CHAR | (N' ') | No | | HNRZUSVON | Allow NULL? |
| 12 | HNRZUSBIS | IS-M/SD: Last House Number Affix | nvarchar | 8 | 0 | CHAR | (N' ') | No | | HNRZUSBIS | Allow NULL? |
| 13 | ADRZUSATZ | IS-M: Further Address Affix | nvarchar | 6 | 0 | CHAR | (N' ') | No | | ADRZUSATZ2 | Allow NULL? |
| 14 | STOCKWERK | IS-M: Floor | nvarchar | 6 | 0 | CHAR | (N' ') | No | | STOCKWERK | Allow NULL? |
| 15 | XDETAIL | IS-M: Further details recorded | char | 1 | 0 | CHAR | (N' ') | Yes | | XDETAIL | Allow NULL? |
| 16 | HNVONG | IS-M: First House Number in Area Not Delivered (Even) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | HNVONG | Allow NULL? |
| 17 | HZVONG | IS-M: Affix at Start of Undelivered Area (Even) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | HZVONG | Allow NULL? |
| 18 | HNBISG | IS-M: Last House Number in Area Not Delivered (Even) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | HNBISG | Allow NULL? |
| 19 | HZBISG | IS-M: Affix at End of Undelivered Area (Even) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | HZBISG | Allow NULL? |
| 20 | HNVONU | IS-M: First House Number in Area Not Delivered (Odd) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | HNVONU | Allow NULL? |
| 21 | HZVONU | IS-M: Affix at Start of Undelivered Area (Odd) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | HZVONU | Allow NULL? |
| 22 | HNBISU | IS-M: Last House Number in Area Not Delivered (Odd) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | HNBISU | Allow NULL? |
| 23 | HZBISU | IS-M: Affix at End of Undelivered Area (Odd) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | HZBISU | Allow NULL? |
