| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TU_NUMBER | TD transport unit number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | OIG_TRUNMR | Allow NULL? |
| 3 | TU_TYPE | TD Transport unit type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIGC | OIG_TRUTYP | Allow NULL? |
| 4 | WGT_UOM | TD weight unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_WGTUOM | Allow NULL? |
| 5 | TU_ID | TD transport unit identifier | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | OIG_LICNMR | Allow NULL? |
| 6 | TU_NRCOMPS | Number of compartments (TD) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | OIG_NMRCMP | |
| 7 | TU_NRMETS | TD number of meters on the transport unit | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | OIG_NMRMET | |
| 8 | TU_UNLWGT | TD transport unit unladen weight | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_TUUWT | |
| 9 | TU_MAXWGT | TD transport unit maximum weight | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_TUMWT | |
| 10 | TU_HEIGHT | TD transport unit height | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIG_TUHGT | |
| 11 | TU_WIDTH | TD transport unit width | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIG_TUWDT | |
| 12 | TU_LENGTH | TD transport unit length | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIG_TULEN | |
| 13 | TU_AXLES | TD: number of axles on transport units | char | 1 | 0 | NUMC | (N'0') | Yes | | OIG_AXLE | Allow NULL? |
| 14 | TU_MAXVOL | TD transport unit maximum volume | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_TUMVL | |
| 15 | VOL_UOM | TD volume unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_VOLUOM | Allow NULL? |
| 16 | DIM_UOM | Unit of measure for length/width/height | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_MEABM | Allow NULL? |
| 17 | EQUIP_NR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | EQUI | EQUNR | Allow NULL? |
| 18 | TU_STATUS | TD transport unit status | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_TUSTA | Allow NULL? |
| 19 | TPPOINT | Transportation planning point | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TTDS | TPLST | Allow NULL? |
| 20 | TU_CARRIER | TD carrier (vendor account number) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | OIG_LIFNR | Allow NULL? |
| 21 | CRE_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 22 | CRE_DATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERSDA | Allow NULL? |
| 23 | CHA_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 24 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAEDA | Allow NULL? |
| 25 | RAILCAR_TYPE | TD-Vehicle Own Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VOWNFL | Allow NULL? |