| 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 | * | MANDT | Allow NULL? |
| 2 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | No | T300 | LGNUM | Allow NULL? |
| 3 | TANUM | Transfer Order Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | TANUM | Allow NULL? |
| 4 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | BWART | Allow NULL? |
| 5 | BWLVS | Movement Type for Warehouse Management | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T333 | BWLVS | Allow NULL? |
| 6 | TBPRI | Transfer Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | TBPRI | Allow NULL? |
| 7 | TRART | Shipment Type | char | 1 | 0 | CHAR | (N' ') | Yes | T333A | LVS_TRART | Allow NULL? |
| 8 | BDATU | Creation Date of Transfer Order | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTAK_BDATU | Allow NULL? |
| 9 | BZEIT | Creation time of transfer order | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LTAK_BZEIT | Allow NULL? |
| 10 | BNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | LVS_BNAME | Allow NULL? |
| 11 | REFNR | Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T311 | LVS_REFNR | Allow NULL? |
| 12 | TBNUM | Transfer Requirement Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | TBNUM | Allow NULL? |
| 13 | UBNUM | Posting Change Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | UBNUM | Allow NULL? |
| 14 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 15 | KQUIT | Indicator: Confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KQUIT | Allow NULL? |
| 16 | QDATU | Date of Confirmation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTAK_QDATU | Allow NULL? |
| 17 | MBLNR | Number of Material Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | MBLNR | Allow NULL? |
| 18 | MJAHR | Material Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | MJAHR | Allow NULL? |
| 19 | BETYP | Requirement Type | char | 1 | 0 | CHAR | (N' ') | Yes | T308 | LVS_BETYP | Allow NULL? |
| 20 | BENUM | Requirement Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LVS_BENUM | Allow NULL? |
| 21 | DRUKZ | Indicator: form and sort code for printing transfer orders | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T329F | LVS_DRUKZ | Allow NULL? |
| 22 | DRUCK | Indicator: Transfer Order is Printed | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_DRUCK | Allow NULL? |
| 23 | TEILK | Ind.: partial supply for documents in multiple processing | char | 1 | 0 | CHAR | (N' ') | Yes | | LSAM_TEILK | Allow NULL? |
| 24 | KR2SO | Indicator: Call up R/2 immediately (RM posting) | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KR2SO | Allow NULL? |
| 25 | KR2KU | Indicator: R/2 control accumulated (RM posting) | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KR2KU | Allow NULL? |
| 26 | KDISO | Indicator: Pass on diff. to R/2 immediately (RM posting) | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KDISO | Allow NULL? |
| 27 | KZPLA | Indicator: preplanned transfer order | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZPLA | Allow NULL? |
| 28 | PLDAT | Planned execution date for a transfer order | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LVS_PLDAT | Allow NULL? |
| 29 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | RSNUM | Allow NULL? |
| 30 | LZNUM | Additional Reference Number for Transport | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | LVS_LZNUM | Allow NULL? |
| 31 | BDART | Requirement type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BDART | Allow NULL? |
| 32 | PKNUM | Control cycle number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | * | PKNUM | Allow NULL? |
| 33 | PKPOS | Kanban item number / control cycle item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PKPOS | Allow NULL? |
| 34 | KZLEI | Indicator for performance data | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZLEI | Allow NULL? |
| 35 | KISTZ | Indicator: Actual time required in TO | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KISTZ | Allow NULL? |
| 36 | KISTP | Indicator: Input requirement for actual data | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KISTP | Allow NULL? |
| 37 | PERNR | Personnel Number of User | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | LTAK_PERNR | Allow NULL? |
| 38 | SOLWM | Planned Transfer Order Processing Time From WM | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LTAK_SOLWM | |
| 39 | SOLEX | Planned Transfer Order Processing Time from External System | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LTAK_SOLEX | |
| 40 | ISTWM | Actual Time of the WM Transfer Order | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LTAK_ISTWM | |
| 41 | ZEIEI | Time unit for performance data | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | LVS_ZEIEI | Allow NULL? |
| 42 | HRSTS | Transfer Order Human Resources (HR) Status | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_HRSTS | Allow NULL? |
| 43 | STDAT | Start Date of the Transfer Order | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTAK_STDAT | Allow NULL? |
| 44 | ENDAT | Transfer Order End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTAK_ENDAT | Allow NULL? |
| 45 | STUZT | Start time of the transfer order | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LTAK_STUZT | Allow NULL? |
| 46 | ENUZT | Transfer Order End Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LTAK_ENUZT | Allow NULL? |
| 47 | L2SKA | Transfer Order Type in 2-Step Picking | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_L2SKA | Allow NULL? |
| 48 | MINWM | Transfer order transfers no real storage bin stock | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_MINWM | Allow NULL? |
| 49 | LGTOR | Door for Warehouse Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LGTOR | Allow NULL? |
| 50 | LGBZO | Staging Area for Warehouse Complex | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LGBZO | Allow NULL? |
| 51 | KZVEP | Indicator: Connection to packaging in WM | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZVEP | Allow NULL? |
| 52 | SWABW | Threshold value of planned/actual time deviation as percent | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LVS_SWABW | Allow NULL? |
| 53 | AUSFB | TO processing comment (code) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T339 | LVS_AUSFB | Allow NULL? |
| 54 | SPEZI | Indicator special reference | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_SPEZI | Allow NULL? |
| 55 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 56 | QUEUE | Queue | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LRF_QUEUE | Allow NULL? |
| 57 | KGVNQ | Indicator: Separate confirmation possible | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KGVNQ | Allow NULL? |
| 58 | TAPRI | Transfer order priority | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | TAPRI | Allow NULL? |
| 59 | KVQUI | Indicator: Material pick has been confirmed | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KVQUI | Allow NULL? |
| 60 | HUCON | Indicator, confirm HU | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_HUCON | Allow NULL? |
| 61 | NOITM | Current number of items in TO | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LTAK_CNTPS | Allow NULL? |
| 62 | KZTRM | TRM Interface Active | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_KZTRM | Allow NULL? |
| 63 | LATER | Delayed Update of Outbound Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_LATER | Allow NULL? |
| 64 | PASSD | Confirmation Data Transferred To Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | LTAK_PASSD | Allow NULL? |
| 65 | MULTL | Transfer Order for Multiple Deliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_MULTL | Allow NULL? |