SAP Table
LTBK Transfer requirement header
SAP table LTBK has 3 primary key fields being MANDT,LGNUM,TBNUM.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
LTBK columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||
| KeyLGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |||||||
| KeyTBNUM | Transfer Requirement Number | NUMC | 10 | 0 | TBNUM | ||||||||
| STATU | Header Status of Transfer Requirement | CHAR | 1 | 0 | LTBK_STATU | ||||||||
|
|||||||||||||
| TRART | Shipment Type | CHAR | 1 | 0 | T333A | LVS_TRART | |||||||
| TBPRI | Transfer Priority | CHAR | 1 | 0 | TBPRI | ||||||||
| BNAME | User Name | CHAR | 12 | 0 | LVS_BNAME | ||||||||
| BDATU | Creation Date of Transfer Request | DATS | 8 | 0 | LTBK_BDATU | ||||||||
| BZEIT | Creation time of transfer request | TIMS | 6 | 0 | LTBK_BZEIT | ||||||||
| TBKTX | Header Text of Transfer Requirement | CHAR | 40 | 0 | LTBK_TBKTX | ||||||||
| BETYP | Requirement Type | CHAR | 1 | 0 | T308 | LVS_BETYP | |||||||
| BENUM | Requirement Number | CHAR | 10 | 0 | LVS_BENUM | ||||||||
| BWART | Movement type (inventory management) | CHAR | 3 | 0 | T156 | BWART | |||||||
| BWLVS | Movement Type for Warehouse Management | NUMC | 3 | 0 | T333 | BWLVS | |||||||
| VLTYP | Source Storage Type | CHAR | 3 | 0 | T301 | T333_VLTYP | |||||||
| VLPLA | Source storage bin | CHAR | 10 | 0 | T333_VLPLA | ||||||||
| VKDYN | Indicator: dynamic source bin | CHAR | 1 | 0 | T333_VKDYN | ||||||||
| NLTYP | Destination Storage Type | CHAR | 3 | 0 | T301 | T333_NLTYP | |||||||
| NLPLA | Destination Storage Bin | CHAR | 10 | 0 | T333_NLPLA | ||||||||
| NKDYN | Indicator: dynamic destination bin | CHAR | 1 | 0 | T333_NKDYN | ||||||||
| PDATU | Date of Planned Execution of Transfer Request | DATS | 8 | 0 | LTBK_PDATU | ||||||||
| PZEIT | Time of Planned Execution of Transfer Requirement | TIMS | 6 | 0 | LTBK_PZEIT | ||||||||
| MBLNR | Number of Material Document | CHAR | 10 | 0 | MBLNR | ||||||||
| MJAHR | Material Document Year | NUMC | 4 | 0 | MJAHR | ||||||||
| ANZPS | Number of Transfer Requirement Items | DEC | 4 | 0 | LTBK_ANZPS | ||||||||
| BRGEW | Total Weight of Transfer Request | DEC | 11 | 3 | LTBK_BRGEW | ||||||||
| GEWEI | Weight Unit | UNIT | 3 | 0 | GEWEI | ||||||||
| KLFR2 | Indicator: Delivery document from superior system (R/2) | CHAR | 1 | 0 | LTBK_KLFR2 | ||||||||
| KFAR2 | Indicator: Production order from superior system (R/2) | CHAR | 1 | 0 | LTBK_KFAR2 | ||||||||
| TBRUE | Indicator: confirm transfer requriement | CHAR | 1 | 0 | LTBK_TBRUE | ||||||||
| RSNUM | Number of reservation/dependent requirements | NUMC | 10 | 0 | RSNUM | ||||||||
| LZNUM | Additional Reference Number for Transport | CHAR | 20 | 0 | LVS_LZNUM | ||||||||
| AUTTA | Automatic Transfer Order Creation | CHAR | 1 | 0 | T333N | LVS_AUTTA | |||||||
| BDART | Requirement type | CHAR | 2 | 0 | BDART | ||||||||
| PKNUM | Control Cycle | CHAR | 7 | 0 | PKNUM | ||||||||
| PKPOS | Kanban Control Cycle Item | NUMC | 3 | 0 | PKPOS | ||||||||
| DIRTA | Automatic TO Creation Immediately After TR Generation | CHAR | 1 | 0 | LVS_DIRTA | ||||||||
| KBNKZ | Kanban Indicator | CHAR | 1 | 0 | KBNKZ | ||||||||
|
|||||||||||||
/ Relationships
LTBK foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| LTBK | AUTTA | T333N | Control for automatic transfer order creation | MANDT |
| LTBK | AUTTA | T333N | Control for automatic transfer order creation | LGNUM |
| LTBK | BETYP | T308 | Requirements Categories | MANDT |
| LTBK | BETYP | T308 | Requirements Categories | LGNUM |
| LTBK | BWART | T156 | Movement Type | MANDT |
| LTBK | BWART | T156 | Movement Type | BWART |
| LTBK | BWLVS | T333 | WM Movement Types | MANDT |
| LTBK | BWLVS | T333 | WM Movement Types | LGNUM |
| LTBK | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| LTBK | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| LTBK | NLTYP | T301 | WM Storage Types | MANDT |
| LTBK | NLTYP | T301 | WM Storage Types | LGNUM |
| LTBK | NLTYP | T301 | WM Storage Types | LGTYP |
| LTBK | TRART | T333A | Shipment Types | MANDT |
| LTBK | TRART | T333A | Shipment Types | LGNUM |
| LTBK | TRART | T333A | Shipment Types | TRART |
| LTBK | VLTYP | T301 | WM Storage Types | MANDT |
| LTBK | VLTYP | T301 | WM Storage Types | LGNUM |
| LTBK | VLTYP | T301 | WM Storage Types | LGTYP |