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
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
X Yes
NULL No
KKOWK Indicator: Conditions at plant level KKOWK CHAR 1 0
NULL Conditions allowed with and without plant
+ Only plant-related conditions allowed
- No plant-related conditions allowed
KORDB Indicator: Source list requirement KORDB CHAR 1 0
X Yes
NULL No
BEDPL Activating requirements planning BEDPL CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
AWSLS Variance Key AWSLS TKV01 CHAR 6 0
CHAZV_OLD Indicator: batch status management active CHAZV CHAR 1 0
X Yes
NULL No
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
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
X Yes
NULL No
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
NULL Sales area of supplying plant (standard)
01 Search using supplying plant / customer (Table TVKWZ, KNVV)
FPRFW Distribution profile at plant level FPRFW TWFPF CHAR 3 0
ACHVM Central archiving marker for master record ACHVM_X CHAR 1 0
X Yes
NULL No
DVSART Batch Record: Type of DMS Used DVSART CHAR 1 0
NULL SAP document management system
1 External document management system
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
X TRUE
NULL FALSE
MISCH Updating is active for mixed costing CKML_FLG_MISCH CHAR 1 0
X TRUE
NULL FALSE
MGVUPD Updating is active in actual costing CKML_FLG_MGVUPD CHAR 1 0
X TRUE
NULL FALSE
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
MGVLAUPD Update of Activity Consumption in the Quantity Structure CKML_MGVLAUPD CHAR 1 0
0 No activity update
1 Activity update not relevant to price determination
2 Activity update relevant to price determination
MGVLAREVAL Control of Credit of Cost Centers CKML_MGVLAREVAL CHAR 1 0
NULL Credit Cost Centers Using Periodic Run / Parallel COGM
1 Credit Cost Centers Using Alternative Valuation Run
SOURCING Invoke Added-Function Source Determination via ATP MMPUR_SOURCING CHAR 1 0
NULL No added-function source determination
1 Added-function source determ. in case of no existing sources
2 Added-function source determ. in case of existing sources
OILIVAL Exchange valuation indicator OIA_VALFLG CHAR 1 0
NULL Exchange inventory valuation from valuation segment MBEW
X Exchange inventory valuation from purchase order net price
OIHVTYPE Vendor type (refinery/mill/other) (Brazil) OIH_J1B_VTYP CHAR 1 0
M Mill (for alcohol)
R Refinery only
O Other
NULL Distributor only
X Refinery and Distributor
OIHCREDIPI IPI credit allowed OIH_J1B_TXCREDIP CHAR 1 0
X Yes
. No
NULL No
STORETYPE Store Category to Differentiate Store, Dep. Store, Shop WRF_STORETYPE CHAR 1 0
NULL Store
1 Department Store
2 Shop
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