T001W SAP (Plants/Branches) Table details
Dictionary Type: Table
Description: Plants/Branches
Description: Plants/Branches
Table field list including key, data, relationships and ABAP select examples
T001W is a standard SAP Table which is used to store Plants/Branches data and is available within R/3 SAP systems depending on the version and release level.
The T001W table consists of various fields, each holding specific information or linking keys about Plants/Branches data available in SAP. These include WERKS (Plant), NAME1 (Name), BWKEY (Valuation Area), KUNNR (Customer number of plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP T001W table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
NAME1 | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | T001K | BWKEY | BWK | ||
KUNNR | Customer number of plant | KUNNR_WK | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LIFNR | Vendor number of plant | LIFNR_WK | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
FABKL | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
NAME2 | Name 2 | NAME2 | CHAR | 30 | TEXT30 | ||||
STRAS | House number and street | STRAS | CHAR | 30 | TEXT30 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01 | CHAR | 25 | TEXT25 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
VKORG | Sales organization for intercompany billing | VKOIV | CHAR | 4 | TVKO | VKORG | VKO | ||
CHAZV | Indicator: batch status management active | CHAZV | CHAR | 1 | XFELD | ||||
KKOWK | Indicator: Conditions at plant level | KKOWK | CHAR | 1 | KKOWK | ||||
KORDB | Indicator: Source list requirement | KORDB | CHAR | 1 | XFELD | ||||
BEDPL | Activating requirements planning | BEDPL | CHAR | 1 | XFELD | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
COUNC | County Code | COUNC | CHAR | 3 | T005E | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | T005G | CITYC | |||
ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T001W | WERKS | IWK | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
VTWEG | Distribution channel for intercompany billing | VTWIV | CHAR | 2 | TVTW | VTWEG | VTW | ||
SPART | Division for intercompany billing | SPAIV | CHAR | 2 | TSPA | SPART | SPA | ||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
WKSOP | SOP plant | WKSOP | CHAR | 1 | XFELD | ||||
AWSLS | Variance Key | AWSLS | CHAR | 6 | TKV01 | AWSLS | |||
CHAZV_OLD | Indicator: batch status management active | CHAZV | CHAR | 1 | XFELD | ||||
VLFKZ | Plant category | VLFKZ | CHAR | 1 | VLFKZ | ||||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
ZONE1 | Supply region (region supplied) | LFREG | CHAR | 10 | TZONE | ZONE | |||
TAXIW | Tax Indicator: Plant (Purchasing) | TAXIW1 | CHAR | 1 | TMKW1 | TAXIW1 | |||
BZQHL | Take regular vendor into account | BZQHL | CHAR | 1 | XFELD | ||||
LET01 | Number of Days for First Reminder/Expediter | MAHN1 | DEC | 3 | MAHNT | ||||
LET02 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC | 3 | MAHNT | ||||
LET03 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC | 3 | MAHNT | ||||
TXNAM_MA1 | Text name of 1st dunning of vendor declarations | TXNAM_MA1 | CHAR | 16 | TXNAM16 | ||||
TXNAM_MA2 | Text name of the 2nd dunning of vendor declarations | TXNAM_MA2 | CHAR | 16 | TXNAM16 | ||||
TXNAM_MA3 | Text name of 3rd dunning of vendor declarations | TXNAM_MA3 | CHAR | 16 | TXNAM16 | ||||
BETOL | Number of days for PO tolerance - Compress info records - SU | BETOL | NUMC | 3 | NUMC3 | ||||
J_1BBRANCH | Business Place | J_1BBRANC_ | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
VTBFI | Rule for determining the sales area for stock transfers | VTBFI | CHAR | 2 | VTBFI | ||||
FPRFW | Distribution profile at plant level | FPRFW | CHAR | 3 | TWFPF | FEPRF | |||
ACHVM | Central archiving marker for master record | ACHVM_X | CHAR | 1 | XFELD | ||||
DVSART | Batch Record: Type of DMS Used | DVSART | CHAR | 1 | DVSART | ||||
NODETYPE | Node type: supply chain network | NODETYPE | CHAR | 3 | MDRP_NODT | NODETYPE | |||
NSCHEMA | Structure for name formation | CKML_NSCHEMA | CHAR | 4 | CKMLMV007 | CKML_NSCHEMA | |||
PKOSA | Cost Object Controlling linking active | CKML_FLG_PKOSA | CHAR | 1 | BOOLE | ||||
MISCH | Updating is active for mixed costing | CKML_FLG_MISCH | CHAR | 1 | BOOLE | ||||
MGVUPD | Updating is active in actual costing | CKML_FLG_MGVUPD | CHAR | 1 | BOOLE | ||||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | TVST | VSTEL | VST | ||
MGVLAUPD | Update of Activity Consumption in the Quantity Structure | CKML_MGVLAUPD | CHAR | 1 | CKML_MGVLAUPD | ||||
MGVLAREVAL | Control of Credit of Cost Centers | CKML_MGVLAREVAL | CHAR | 1 | CKML_MGVLAREVAL | ||||
SOURCING | Invoke Added-Function Source Determination via ATP | MMPUR_SOURCING | CHAR | 1 | MMPUR_SOURCING | ||||
.INCLU--AP | 0 | ||||||||
OILIVAL | Exchange valuation indicator | OIA_VALFLG | CHAR | 1 | OIA_VALFLG | ||||
OIHVTYPE | Vendor type (refinery/mill/other) (Brazil) | OIH_J1B_VTYP | CHAR | 1 | OIH_J1B_VTYP | ||||
OIHCREDIPI | IPI credit allowed | OIH_J1B_TXCREDIP | CHAR | 1 | ANKREUZ | ||||
.INCLU--AP | 0 | ||||||||
STORETYPE | Store Category to Differentiate Store, Dep. Store, Shop | WRF_STORETYPE | CHAR | 1 | WRF_STORETYPE | ||||
DEP_STORE | Superior Department Store | WRF_DEP_STORE | CHAR | 4 | Assigned to domain | WERKS |
Key field | Non-key field |
How do I retrieve data from SAP table T001W using ABAP code
The following ABAP code Example will allow you to do a basic selection on T001W to SELECT all data from the tableDATA: WA_T001W TYPE T001W.
SELECT SINGLE *
FROM T001W
INTO CORRESPONDING FIELDS OF WA_T001W
WHERE...
How to access SAP table T001W
Within an ECC or HANA version of SAP you can also view further information about T001W and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects