| 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 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIGS | OIG_SHNUM | Allow NULL? |
| 3 | MAT_ITM | TD material item sequence number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OIG_MATITM | Allow NULL? |
| 4 | QTY_ITM | TD quantity item number of a shipment/transport | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | OIG_QTYITM | Allow NULL? |
| 5 | TPU_NR | Transport unit sequence number in shipment | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | OIGSVC | OIG_TPUNR | Allow NULL? |
| 6 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIG_SEQNR | Allow NULL? |
| 7 | VEH_NR | Vehicle Sequence Number in Shipment | nvarchar | 3 | 0 | NUMC | (N'000') | No | OIGSV | OIG_VEHNR | Allow NULL? |
| 8 | CONTROL | Control flag for technical use in TD | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CONTROL | Allow NULL? |
| 9 | CRE_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 10 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 11 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 12 | CHA_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 13 | CHA_DATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 14 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
