| 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 | TD_ACTION | TD action (schedule, load, delivery confirmation) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_TDACT | Allow NULL? |
| 6 | SHITEM | Shipment item | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | OIGSI | OIG_SHITM | Allow NULL? |
| 7 | POSNR | TD document item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | OIG_ITEM | Allow NULL? |
| 8 | TPU_NR | Transport unit sequence number in shipment | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | OIGSVC | OIG_TPUNR | Allow NULL? |
| 9 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIG_SEQNR | Allow NULL? |
| 10 | VEH_NR | Vehicle Sequence Number in Shipment | nvarchar | 3 | 0 | NUMC | (N'000') | No | OIGSV | OIG_VEHNR | Allow NULL? |
| 11 | TRQTY | TD transaction quantity | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_TRQTY | |
| 12 | TRUOM | TD transaction unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_TRUOM | Allow NULL? |
| 13 | QTY_VOL | Quantity in volume UoM | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_QTYVOL | |
| 14 | QTY_WGT | Quantity in weight UoM | float | 15 | 16 | FLTP | ((0)) | Yes | | OIG_QTYWGT | |
| 15 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 16 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 17 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_D | Allow NULL? |
| 18 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | MCHB | CHARG_D | Allow NULL? |
| 19 | LFIMG | Actual quantity delivered (in sales units) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LFIMG | |
| 20 | LGMNG | Actual quantity delivered in stockkeeping units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LGMNG | |
| 21 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T149D | BWTAR_D | Allow NULL? |
| 22 | HPM_ITM | Sequence number for HPM segments | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | OIG_HPMITM | Allow NULL? |
| 23 | HIS_ITM | TD shipment history item number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIG_HISITM | Allow NULL? |
| 24 | QTY_ITM_C | TD quantity item number of a shipment/transport | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | OIG_QTYITM | Allow NULL? |
| 25 | REAS_CODE | Reason code - to group quantities in shipment process | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOIGS4 | OIG_REASCD | Allow NULL? |
| 26 | CRE_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 27 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 28 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 29 | CHA_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 30 | CHA_DATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 31 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
