| 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 | AENDNR | Change Number | nvarchar | 9 | 0 | CHAR | (N' ') | No | | AENDNR | Allow NULL? |
| 3 | GUELTIGAB | IS-M: Date from Which Change Number is Valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANDGLTGVON | Allow NULL? |
| 4 | GUELTIGBIS | IS-M: Date to Which Change Number is Valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANDGLTGBIS | Allow NULL? |
| 5 | ARTAENDNR | IS-M: Type of Change Number | char | 1 | 0 | CHAR | (N' ') | Yes | | ARTAENDNR | Allow NULL? |
| 6 | AENDLFDNR | Sequence Number of Change on Change Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AENDLFDNR | Allow NULL? |
| 7 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 8 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 9 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 10 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 11 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 12 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
| 13 | BEZEI | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISM_OBJNAME30 | Allow NULL? |
| 14 | BEZEI_2 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISM_OBJNAME30 | Allow NULL? |
| 15 | AENDSTATUS | Status of Structure Changes | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJS13 | AENDSTATUS | Allow NULL? |
| 16 | XUSERSPEZ | Change Number is User-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | | XUSERSPEZ | Allow NULL? |
| 17 | XISTBEZ | IS-M: Carrier Route Structure was Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTBEZ | Allow NULL? |
| 18 | XISTROUTE | IS-M: Unloading Point Sequence Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTROUTE | Allow NULL? |
| 19 | XISTLIEF | IS-M: Viability Set Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTLIEF | Allow NULL? |
| 20 | XISTORG | IS-M: Organizational Structure Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTORG | Allow NULL? |
| 21 | XISTABLAD | IS-M: Unloading Viability Sets Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTABLAD | Allow NULL? |
| 22 | XISTABREG | IS-M: Unloading Rule Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTABREG | Allow NULL? |
| 23 | XISTPVA | IS-M: Truck Route-Edition Assignment was Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTPVA | Allow NULL? |
| 24 | XISTPOST | IS-M: Postal Data was Edited | char | 1 | 0 | CHAR | (N' ') | Yes | | XISTPOST | Allow NULL? |
| 25 | XPLANBEZ | IS-M: Change Number for Carrier Route Structure | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANBEZ | Allow NULL? |
| 26 | XPLANROUTE | IS-M: Change Number for Truck Route Structuring | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANROUTE | Allow NULL? |
| 27 | XPLANLIEF | IS-M: Change Number to Edit Viability Sets | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANLIEF | Allow NULL? |
| 28 | XPLANORG | IS-M: Change Number for Organizational Structuring | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANORG | Allow NULL? |
| 29 | XPLANABLAD | IS-M: Change Number for Unloading Viability Sets | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANABLAD | Allow NULL? |
| 30 | XPLANABREG | IS-M: Unloading rule to be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANABREG | Allow NULL? |
| 31 | XPLANPVA | IS-M: Truck Route-Edition Assignment was Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | XPLANPVA | Allow NULL? |
| 32 | XFREIGABE | IS-M: Change Number Scheduled for Release | char | 1 | 0 | CHAR | (N' ') | Yes | | XFREIGABE | Allow NULL? |
| 33 | POSTSTATUS | IS-M: Status of Postal Change Service | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJS35 | POSTSTATUS | Allow NULL? |
| 34 | XDELIV_OPT | IS-M/SD: Delivery Viability Optimization for Release | char | 1 | 0 | CHAR | (N' ') | No | | XDELIV_OPT | Allow NULL? |
| 35 | XDELIV_OPT_STOCK | IS-M/SD: Marking for Delivery Viability Optimization | char | 1 | 0 | CHAR | (N' ') | Yes | | XDELIV_OPT_STOCK | Allow NULL? |
| 36 | JORDER_GET | IS-M: Procedure for determining orders during release | nvarchar | 2 | 0 | CHAR | (N' ') | No | | JMSDORDERGET | Allow NULL? |
| 37 | XENQORDREL | IS-M/SD: Restricted Order Block (by Geo.) for Release | char | 1 | 0 | CHAR | (N' ') | No | | XENQORDREL | Allow NULL? |
| 38 | XUNLOADING_POINT | IS-M: Change Number for Unloading Point Context Only | char | 1 | 0 | CHAR | (N' ') | Yes | | XUNLOADING_POINT | Allow NULL? |
