SAP ABAP Table T001W (Plants/Branches)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WFIL (Package) IS-R: Store master

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T001W	Table Relationship Diagram
Short Description	Plants/Branches

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant
3	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
4	NAME2	☐	NAME2	TEXT30	CHAR	30	0	Name 2
5	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
6	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
7	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
8	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
9	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
10	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
11	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	*
12	CHAZV	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
13	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
14	KKOWK	☐	KKOWK	KKOWK	CHAR	1	0	Indicator: Conditions at plant level
15	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
16	BEDPL	☐	BEDPL	XFELD	CHAR	1	0	Activating requirements planning
17	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
19	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
20	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
21	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
22	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
23	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
24	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	*
25	SPART	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing
26	KUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	*
27	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
28	WKSOP	☐	WKSOP	XFELD	CHAR	1	0	SOP plant
29	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	*
30	CHAZV_OLD	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
31	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
32	LIFNR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
33	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
34	ZONE1	☐	LFREG	ZONE	CHAR	10	0	Supply region (region supplied)	TZONE
35	TAXIW	☐	TAXIW1	TAXIW1	CHAR	1	0	Tax Indicator: Plant (Purchasing)	*
36	BZQHL	☐	BZQHL	XFELD	CHAR	1	0	Take regular vendor into account
37	LET01	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
38	LET02	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
39	LET03	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
40	TXNAM_MA1	☐	TXNAM_MA1	TXNAM16	CHAR	16	0	Text name of 1st dunning of vendor declarations
41	TXNAM_MA2	☐	TXNAM_MA2	TXNAM16	CHAR	16	0	Text name of the 2nd dunning of vendor declarations
42	TXNAM_MA3	☐	TXNAM_MA3	TXNAM16	CHAR	16	0	Text name of 3rd dunning of vendor declarations
43	BETOL	☐	BETOL	NUMC3	NUMC	3	0	Number of days for PO tolerance - Compress info records - SU
44	J_1BBRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	*
45	VTBFI	☐	VTBFI	VTBFI	CHAR	2	0	Rule for determining the sales area for stock transfers
46	FPRFW	☐	FPRFW	FEPRF	CHAR	3	0	Distribution profile at plant level	*
47	ACHVM	☐	ACHVM_X	XFELD	CHAR	1	0	Central archiving marker for master record
48	DVSART	☐	DVSART	DVSART	CHAR	1	0	Batch Record: Type of DMS Used
49	NODETYPE	☐	NODETYPE	NODETYPE	CHAR	3	0	Node type: supply chain network	*
50	NSCHEMA	☐	CKML_NSCHEMA	CKML_NSCHEMA	CHAR	4	0	Structure for name formation
51	PKOSA	☐	CKML_FLG_PKOSA	BOOLE	CHAR	1	0	Cost Object Controlling linking active
52	MISCH	☐	CKML_FLG_MISCH	BOOLE	CHAR	1	0	Updating is active for mixed costing
53	MGVUPD	☐	CKML_FLG_MGVUPD	BOOLE	CHAR	1	0	Updating is active in actual costing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T001W	BWKEY	T001K	BWKEY	REF	1	CN
2	T001W	CITYC	T005G	CITYC	REF	C	CN
3	T001W	COUNC	T005E	COUNC	REF	C	CN
4	T001W	EKORG	T024E	EKORG	REF	1	N
5	T001W	FABKL	TFACD	IDENT	REF	1	CN
6	T001W	IWERK	T001W	WERKS	REF	C	CN
7	T001W	LAND1	T005	LAND1	REF	1	CN
8	T001W	LIFNR	LFA1	LIFNR	KEY	1	CN
9	T001W	MANDT	T000	MANDT	KEY	1	CN
10	T001W	REGIO	T005S	BLAND	REF	C	CN
11	T001W	SPRAS	T002	SPRAS	REF	C	CN
12	T001W	ZONE1	TZONE	ZONE1	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in