SAP Table T001W_EXT
Plants (Company's Own and External)
T001W_EXT (Plants (Company's Own and External)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T001W_EXT to other SAP tables.
Source: T001W_EXT (Plants (Company's Own and External))
T001W_EXT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| WERKS | Plant for Cross-System Flows of Goods | WERKS_D_EXT | CHAR | 4 | 0 | |||
| LNUMBER | AIP: Sequential Number | AIP_NUMBER | NUMC | 4 | 0 | |||
| NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||
| NAME2 | Name 2 | NAME2 | CHAR | 30 | 0 | |||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| LIFNR | Vendor number of plant | LIFNR_WK | LFA1 | CHAR | 10 | 0 | ||
| NODETYPE | Node type: supply chain network | NODETYPE | MDRP_NODT | CHAR | 3 | 0 | ||
| VKORG | Sales organization for intercompany billing | VKOIV | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution channel for intercompany billing | VTWIV | TVTW | CHAR | 2 | 0 | ||
| SPART | Division for intercompany billing | SPAIV | TSPA | CHAR | 2 | 0 | ||
| MTVFP | Checking Group for Availability Check | MTVFP | TMVF | CHAR | 2 | 0 | ||
| ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | 0 | |||
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||
| XLOWE | Customer number of plant | KUNNR_WK | KNA1 | CHAR | 10 | 0 | ||
T001W_EXT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T001W_EXT | BUKRS | T001W_EXT | BUKRS | T001 | Company Codes | BUKRS |
| T001W_EXT | BUKRS | T001W_EXT | MANDT | T001 | Company Codes | MANDT |
| T001W_EXT | LAND1 | T001W_EXT | LAND1 | T005 | Countries | LAND1 |
| T001W_EXT | LAND1 | T001W_EXT | MANDT | T005 | Countries | MANDT |
| T001W_EXT | LIFNR | T001W_EXT | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| T001W_EXT | LIFNR | T001W_EXT | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| T001W_EXT | LOGSYS | T001W_EXT | LOGSYS | TBDLS | Logical system | LOGSYS |
| T001W_EXT | MANDT | T001W_EXT | MANDT | T000 | Clients | MANDT |
| T001W_EXT | MTVFP | T001W_EXT | MANDT | TMVF | Availability Check Control | MANDT |
| T001W_EXT | MTVFP | T001W_EXT | MTVFP | TMVF | Availability Check Control | MTVFP |
| T001W_EXT | NODETYPE | T001W_EXT | NODETYPE | MDRP_NODT | Node Type for DRP Network | NODETYPE |
| T001W_EXT | SPART | T001W_EXT | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| T001W_EXT | SPART | T001W_EXT | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| T001W_EXT | VKORG | T001W_EXT | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| T001W_EXT | VKORG | T001W_EXT | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| T001W_EXT | VTWEG | T001W_EXT | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| T001W_EXT | VTWEG | T001W_EXT | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| T001W_EXT | XLOWE | T001W_EXT | MANDT | KNA1 | General Data in Customer Master | MANDT |
| T001W_EXT | XLOWE | T001W_EXT | XLOWE | KNA1 | General Data in Customer Master | KUNNR |
