SAP Table T001W
Plants/Branches
T001W (Plants/Branches) 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 to other SAP tables.
T001W table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
WERKS
Plant
|
WERKS_D |
CHAR
|
4 | 0 | ||||||||||||||
|
NAME1
Name
|
NAME1 |
CHAR
|
30 | 0 | ||||||||||||||
|
BWKEY
Valuation Area
|
BWKEY | T001K |
CHAR
|
4 | 0 | |||||||||||||
|
KUNNR
Customer number of plant
|
KUNNR_WK | KNA1 |
CHAR
|
10 | 0 | |||||||||||||
|
LIFNR
Vendor number of plant
|
LIFNR_WK | LFA1 |
CHAR
|
10 | 0 | |||||||||||||
|
FABKL
Factory calendar key
|
FABKL | TFACD |
CHAR
|
2 | 0 | |||||||||||||
|
NAME2
Name 2
|
NAME2 |
CHAR
|
30 | 0 | ||||||||||||||
|
STRAS
House number and street
|
STRAS |
CHAR
|
30 | 0 | ||||||||||||||
|
PFACH
PO Box
|
PFACH |
CHAR
|
10 | 0 | ||||||||||||||
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||||||||||||||
|
ORT01
City
|
ORT01 |
CHAR
|
25 | 0 | ||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||
|
VKORG
Sales organization for intercompany billing
|
VKOIV | TVKO |
CHAR
|
4 | 0 | |||||||||||||
|
CHAZV
Indicator: batch status management active
|
CHAZV |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KKOWK
Indicator: Conditions at plant level
|
KKOWK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
KORDB
Indicator: Source list requirement
|
KORDB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BEDPL
Activating requirements planning
|
BEDPL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||||||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||||||
|
COUNC
County Code
|
COUNC | T005E |
CHAR
|
3 | 0 | |||||||||||||
|
CITYC
City Code
|
CITYC | T005G |
CHAR
|
4 | 0 | |||||||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T001W |
CHAR
|
4 | 0 | |||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||
|
VTWEG
Distribution channel for intercompany billing
|
VTWIV | TVTW |
CHAR
|
2 | 0 | |||||||||||||
|
SPART
Division for intercompany billing
|
SPAIV | TSPA |
CHAR
|
2 | 0 | |||||||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||
|
WKSOP
SOP plant
|
WKSOP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AWSLS
Variance Key
|
AWSLS | TKV01 |
CHAR
|
6 | 0 | |||||||||||||
|
CHAZV_OLD
Indicator: batch status management active
|
CHAZV |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VLFKZ
Plant category
|
VLFKZ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BZIRK
Sales district
|
BZIRK | T171 |
CHAR
|
6 | 0 | |||||||||||||
|
ZONE1
Supply region (region supplied)
|
LFREG | TZONE |
CHAR
|
10 | 0 | |||||||||||||
|
TAXIW
Tax Indicator: Plant (Purchasing)
|
TAXIW1 | TMKW1 |
CHAR
|
1 | 0 | |||||||||||||
|
BZQHL
Take regular vendor into account
|
BZQHL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
LET01
Number of Days for First Reminder/Expediter
|
MAHN1 |
DEC
|
3 | 0 | ||||||||||||||
|
LET02
Number of Days for Second Reminder/Expediter
|
MAHN2 |
DEC
|
3 | 0 | ||||||||||||||
|
LET03
Number of Days for Third Reminder/Expediter
|
MAHN3 |
DEC
|
3 | 0 | ||||||||||||||
|
TXNAM_MA1
Text name of 1st dunning of vendor declarations
|
TXNAM_MA1 |
CHAR
|
16 | 0 | ||||||||||||||
|
TXNAM_MA2
Text name of the 2nd dunning of vendor declarations
|
TXNAM_MA2 |
CHAR
|
16 | 0 | ||||||||||||||
|
TXNAM_MA3
Text name of 3rd dunning of vendor declarations
|
TXNAM_MA3 |
CHAR
|
16 | 0 | ||||||||||||||
|
BETOL
Number of days for PO tolerance - Compress info records - SU
|
BETOL |
NUMC
|
3 | 0 | ||||||||||||||
|
J_1BBRANCH
Business Place
|
J_1BBRANC_ | J_1BBRANCH |
CHAR
|
4 | 0 | |||||||||||||
|
VTBFI
Rule for determining the sales area for stock transfers
|
VTBFI |
CHAR
|
2 | 0 | ||||||||||||||
|
||||||||||||||||||
|
FPRFW
Distribution profile at plant level
|
FPRFW | TWFPF |
CHAR
|
3 | 0 | |||||||||||||
|
ACHVM
Central archiving marker for master record
|
ACHVM_X |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DVSART
Batch Record: Type of DMS Used
|
DVSART |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
NODETYPE
Node type: supply chain network
|
NODETYPE | MDRP_NODT |
CHAR
|
3 | 0 | |||||||||||||
|
NSCHEMA
Structure for name formation
|
CKML_NSCHEMA | CKMLMV007 |
CHAR
|
4 | 0 | |||||||||||||
|
PKOSA
Cost Object Controlling linking active
|
CKML_FLG_PKOSA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MISCH
Updating is active for mixed costing
|
CKML_FLG_MISCH |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MGVUPD
Updating is active in actual costing
|
CKML_FLG_MGVUPD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
VSTEL
Shipping Point/Receiving Point
|
VSTEL | TVST |
CHAR
|
4 | 0 | |||||||||||||
|
MGVLAUPD
Update of Activity Consumption in the Quantity Structure
|
CKML_MGVLAUPD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
MGVLAREVAL
Control of Credit of Cost Centers
|
CKML_MGVLAREVAL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SOURCING
Invoke Added-Function Source Determination via ATP
|
MMPUR_SOURCING |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OILIVAL
Exchange valuation indicator
|
OIA_VALFLG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OIHVTYPE
Vendor type (refinery/mill/other) (Brazil)
|
OIH_J1B_VTYP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OIHCREDIPI
IPI credit allowed
|
OIH_J1B_TXCREDIP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
STORETYPE
Store Category to Differentiate Store, Dep. Store, Shop
|
WRF_STORETYPE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DEP_STORE
Superior Department Store
|
WRF_DEP_STORE |
CHAR
|
4 | 0 | ||||||||||||||
T001W foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T001W | AWSLS | T001W | MANDT |
TKV01
Variance Keys: Cost Centers/Costing
|
MANDT |
| T001W | AWSLS | 'OR' |
TKV01
Variance Keys: Cost Centers/Costing
|
AWOBA | |
| T001W | AWSLS | T001W | AWSLS |
TKV01
Variance Keys: Cost Centers/Costing
|
AWSLS |
| T001W | BWKEY | T001W | MANDT |
T001K
Valuation area
|
MANDT |
| T001W | BWKEY | T001W | BWKEY |
T001K
Valuation area
|
BWKEY |
| T001W | BZIRK | T001W | BZIRK |
T171
Customers: Sales Districts
|
BZIRK |
| T001W | BZIRK | T001W | MANDT |
T171
Customers: Sales Districts
|
MANDT |
| T001W | CITYC | T001W | MANDT |
T005G
City
|
MANDT |
| T001W | CITYC | T001W | LAND1 |
T005G
City
|
LAND1 |
| T001W | CITYC | T001W | REGIO |
T005G
City
|
REGIO |
| T001W | CITYC | T001W | CITYC |
T005G
City
|
CITYC |
| T001W | COUNC | T001W | MANDT |
T005E
County
|
MANDT |
| T001W | COUNC | T001W | LAND1 |
T005E
County
|
LAND1 |
| T001W | COUNC | T001W | REGIO |
T005E
County
|
REGIO |
| T001W | COUNC | T001W | COUNC |
T005E
County
|
COUNC |
| T001W | EKORG | T001W | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| T001W | EKORG | T001W | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| T001W | FABKL | T001W | FABKL |
TFACD
Factory calendar definition
|
IDENT |
| T001W | FPRFW | T001W | MANDT |
TWFPF
Plant Profiles for Merchandise Distribution
|
MANDT |
| T001W | FPRFW | T001W | FPRFW |
TWFPF
Plant Profiles for Merchandise Distribution
|
FPRFW |
| T001W | IWERK | T001W | MANDT |
T001W
Plants/Branches
|
MANDT |
| T001W | IWERK | T001W | IWERK |
T001W
Plants/Branches
|
WERKS |
| T001W | J_1BBRANCH | T001W | MANDT |
J_1BBRANCH
Business Place
|
MANDT |
| T001W | J_1BBRANCH | * |
J_1BBRANCH
Business Place
|
BUKRS | |
| T001W | J_1BBRANCH | T001W | J_1BBRANCH |
J_1BBRANCH
Business Place
|
BRANCH |
| T001W | KUNNR | T001W | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| T001W | KUNNR | T001W | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| T001W | LAND1 | T001W | MANDT |
T005
Countries
|
MANDT |
| T001W | LAND1 | T001W | LAND1 |
T005
Countries
|
LAND1 |
| T001W | LIFNR | T001W | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| T001W | LIFNR | T001W | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| T001W | MANDT | T001W | MANDT |
T000
Clients
|
MANDT |
| T001W | NODETYPE | T001W | NODETYPE |
MDRP_NODT
Node Type for DRP Network
|
NODETYPE |
| T001W | NSCHEMA | T001W | MANDT |
CKMLMV007
Name formation (structure table)
|
MANDT |
| T001W | NSCHEMA | T001W | NSCHEMA |
CKMLMV007
Name formation (structure table)
|
NSCHEMA |
| T001W | REGIO | T001W | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| T001W | REGIO | T001W | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| T001W | REGIO | T001W | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| T001W | SPART | T001W | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| T001W | SPART | T001W | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| T001W | SPRAS | T001W | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| T001W | TAXIW | T001W | LAND1 |
TMKW1
Taxes: Plant (Purchasing)
|
LAND1 |
| T001W | TAXIW | T001W | TAXIW |
TMKW1
Taxes: Plant (Purchasing)
|
TAXIW |
| T001W | TAXIW | T001W | MANDT |
TMKW1
Taxes: Plant (Purchasing)
|
MANDT |
| T001W | TXJCD | T005 | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| T001W | TXJCD | T001W | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| T001W | TXJCD | T001W | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| T001W | VKORG | T001W | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| T001W | VKORG | T001W | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| T001W | VSTEL | T001W | VSTEL |
TVST
Organizational Unit: Shipping Points
|
VSTEL |
| T001W | VSTEL | T001W | MANDT |
TVST
Organizational Unit: Shipping Points
|
MANDT |
| T001W | VTWEG | T001W | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| T001W | VTWEG | T001W | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |
| T001W | ZONE1 | T001W | LAND1 |
TZONE
Customers: Regional zones
|
LAND1 |
| T001W | ZONE1 | T001W | ZONE1 |
TZONE
Customers: Regional zones
|
ZONE1 |
| T001W | ZONE1 | T001W | MANDT |
TZONE
Customers: Regional zones
|
MANDT |