| 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 | SHTYP | TD shipment type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OIG_TDSTYP | Allow NULL? |
| 3 | NUMKI | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKI | Allow NULL? |
| 4 | NUMKE | Number range in the case of external number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKE | Allow NULL? |
| 5 | VEH_MODE | TD vehicle mode of transport | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VMOT | Allow NULL? |
| 6 | VMRQT | Vehicle meter required indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VMRQT | Allow NULL? |
| 7 | CPLID | Compartment load indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CPLID | Allow NULL? |
| 8 | CHKCMP_P_C | Check compatibility at scheduling for product/compartment | char | 1 | 0 | NUMC | (N'0') | Yes | | OIG_CMP_PC | Allow NULL? |
| 9 | CHKCMP_V_C | Check compatibility at scheduling for vehicle/customer | char | 1 | 0 | NUMC | (N'0') | Yes | | OIG_CMP_VC | Allow NULL? |
| 10 | PART_DC | TD partial delivery confirmation allowance | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_PRTDC | Allow NULL? |
| 11 | UOMID | Unit of measure identification | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_UOMID | Allow NULL? |
| 12 | CFBLL | Confirm balance load of deliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CFBLL | Allow NULL? |
| 13 | INPGP | Intransit posting group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TOIGS2 | OIG_INPGP | Allow NULL? |
| 14 | WGT_UOM | TD weight unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_WGTUOM | Allow NULL? |
| 15 | VOL_UOM | TD volume unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_VOLUOM | Allow NULL? |
| 16 | NR_DECV | Number of decimal places for shipment quantities | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OIG_NRDEC | Allow NULL? |
| 17 | NR_DECW | Number of decimal places for shipment quantities | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OIG_NRDEC | Allow NULL? |
| 18 | VOLA_UOM | TD volume unit of measure (ambient) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_VOLA | Allow NULL? |
| 19 | VOLC_UOM | TD volume unit of measure, corrected (temperature) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIG_VOLC | Allow NULL? |
| 20 | OVLD_WRNG | TD check overloading at loading - (only warning) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CHKOWE | Allow NULL? |
| 21 | OIG_DLNMCK | Sequence number check for TD document | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_DLNMCK | Allow NULL? |
| 22 | SCHUND | TD-S Underdelivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_SCHUND | Allow NULL? |
| 23 | SCHOVR | TD-S Overdelivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_SCHOVR | Allow NULL? |
| 24 | LOAUND | TD-L under-delivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_LOAUND | Allow NULL? |
| 25 | LOAOVR | TD-L Over-delivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_LOAOVR | Allow NULL? |
| 26 | DELUND | TD-D Under-delivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_DELUND | Allow NULL? |
| 27 | DELOVR | TD-D over-delivery tolerance message level | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_DELOVR | Allow NULL? |
| 28 | EV_SEQ_UNI | TD Event sequence number (unique) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_EVSEQU | Allow NULL? |
| 29 | EV_GROUP | TD - event default group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIGEG | OIG_EVGRP | Allow NULL? |
| 30 | SHFT_MNT | TD - shift mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_SHFTMT | Allow NULL? |
| 31 | CHK_OVL | TD check overloading | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CHKOVL | Allow NULL? |
| 32 | VCLOSE | Vehicle close flag; set confirmation to complete (status=6) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VCLOSE | Allow NULL? |
| 33 | VBALNC | TD vehicle balance check against tolerance table (TOIGS5) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VBALNC | Allow NULL? |
| 34 | GLPST | TD gain/loss postings at vehicle close | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_GLPST | Allow NULL? |
| 35 | EXCH_SCH | Automatically access user exit for exchange assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_EXCH | Allow NULL? |
| 36 | FFTYP | Fulfillment indicator for exchange assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | OIA_FFTYP | Allow NULL? |
| 37 | EXGASS | Purchase assignment user exit | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | OIA_EXGASS | Allow NULL? |
| 38 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | BWARTWE | Allow NULL? |
| 39 | VSART | Shipping type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T173 | VSARTTR | Allow NULL? |
| 40 | EXCH_LOAD | Automatically access user exit for exchange assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_EXCH | Allow NULL? |
| 41 | EXCH_CHECK | Check exchange assignments at scheduling | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_EXCHCH | Allow NULL? |
| 42 | AUSTGASGN | TD-F auto assignment of stages to document items | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_ASTGAS | Allow NULL? |
| 43 | FKART | Shipment cost type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVTF | FKART_T | Allow NULL? |
| 44 | FRKRL | Proposal freight costs relevance, Shipment header | char | 1 | 0 | CHAR | (N' ') | Yes | | FRKRL_KOP | Allow NULL? |
| 45 | FRKRL_STR | Proposal freight costs relevance, shipment leg | char | 1 | 0 | CHAR | (N' ') | Yes | | FRKRL_STR | Allow NULL? |
| 46 | FRKRL_UMP | Proposal for shipment costs relevance - Load transfer point | char | 1 | 0 | CHAR | (N' ') | Yes | | FRKRL_UMP | Allow NULL? |
| 47 | FRKRL_GRP | Proposal for freight costs relevance, Border cross.pt | char | 1 | 0 | CHAR | (N' ') | Yes | | FRKRL_GRP | Allow NULL? |
| 48 | FRKRL_VEH | TD - shipment cost relevance for vehicles | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_FRKRLV | Allow NULL? |
| 49 | SCLDTYPE | TD-F -Shipment costing based on loaded or disch. quantitites | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_STYPE | Allow NULL? |
| 50 | CPL_CUSFNT | TD compartment planning - customer function | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CPCUSF | Allow NULL? |
| 51 | NEW_COMP | Adopt compartment allocation when the vehicle is changed | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_NCOMP | Allow NULL? |
| 52 | CHGDOCS | IS-OIL TD Write Change Documents for TD shipments | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CHGDOCS | Allow NULL? |
| 53 | PROLI | Dangerous Goods Management Profile in SD Documents | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | ADGE_PROLI | Allow NULL? |
| 54 | DGTLOCK | Block Indicator for Dangerous Goods | char | 1 | 0 | CHAR | (N' ') | Yes | | ADGE_TLOCK | Allow NULL? |
| 55 | DGMDDAT | Selection date dangerous goods master data | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ADGE_MDDAT | Allow NULL? |
| 56 | CONT_DG | Indicator: Document contains dangerous goods | char | 1 | 0 | CHAR | (N' ') | Yes | | ADGE_NCDG | Allow NULL? |
| 57 | C_SHTYP | Shipment type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVTK | SHTYP | Allow NULL? |
| 58 | SCH_KALSM | Scheduling output det.procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | OIG_KALSMS | Allow NULL? |
| 59 | LOAD_KALSM | Loading output det.procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | OIG_KALSML | Allow NULL? |
| 60 | DEL_KALSM | Delivery output determination procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | OIG_KALSMD | Allow NULL? |
| 61 | SHV_KALSM | Scheduling (shipment/vehicle) output det.procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | OIG_KALSMV | Allow NULL? |
| 62 | QTY_FROM | TD quantity from | decimal | 11 | 3 | DEC | ((0)) | Yes | | OIG_QTYFR | |
| 63 | QTY_TO | TD - quantity to | decimal | 11 | 3 | DEC | ((0)) | Yes | | OIG_QTYTO | |
| 64 | CHKOVRDLY | Check overdelivery without vehicle close | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_CHKOVRDLY | Allow NULL? |
| 65 | BYP_INSLC | Bypass intransit storage location at loading | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_BYP_INSLC | Allow NULL? |
| 66 | VCLOSEL | Allow vehicle close at loading; status = complete (6) | char | 1 | 0 | CHAR | (N' ') | Yes | | OIG_VCLOSEL | Allow NULL? |
| 67 | EV_GROUP_SI | TD - event default group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIGEG | OIG_EVGRP | Allow NULL? |
