SAP ABAP Table BT001W (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	INTTAB	Structure
Structure	BT001W	Table Relationship Diagram
Short Description	Plants/branches

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	STYPE	☐	STYPE_BI	CHAR1	CHAR	1	0	Batch Input Interface Record Type
2	TBNAM	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	*
3	.INCLUDE	☐				0	0	Plants/Branches
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
6	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
7	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
8	KUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
9	LIFNR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
10	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
11	.INCLUDE	☐				0	0	Plants/branches
12	NAME2	☐	NAME2	TEXT30	CHAR	30	0	Name 2
13	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
14	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
15	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
17	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
18	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
19	CHAZV	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
20	KKOWK	☐	KKOWK	KKOWK	CHAR	1	0	Indicator: Conditions at plant level
21	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
22	BEDPL	☐	BEDPL	XFELD	CHAR	1	0	Activating requirements planning
23	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
26	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
27	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
28	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
29	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
30	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
31	SPART	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA
32	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
33	WKSOP	☐	WKSOP	XFELD	CHAR	1	0	SOP plant
34	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
35	CHAZV_OLD	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
36	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
37	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
38	ZONE1	☐	LFREG	ZONE	CHAR	10	0	Supply region (region supplied)	TZONE
39	TAXIW	☐	TAXIW1	TAXIW1	CHAR	1	0	Tax Indicator: Plant (Purchasing)	TMKW1
40	BZQHL	☐	BZQHL	XFELD	CHAR	1	0	Take regular vendor into account
41	LET01	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
42	LET02	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
43	LET03	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
44	TXNAM_MA1	☐	TXNAM_MA1	TXNAM16	CHAR	16	0	Text name of 1st dunning of vendor declarations
45	TXNAM_MA2	☐	TXNAM_MA2	TXNAM16	CHAR	16	0	Text name of the 2nd dunning of vendor declarations
46	TXNAM_MA3	☐	TXNAM_MA3	TXNAM16	CHAR	16	0	Text name of 3rd dunning of vendor declarations
47	BETOL	☐	BETOL	NUMC3	NUMC	3	0	Number of days for PO tolerance - Compress info records - SU
48	J_1BBRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
49	VTBFI	☐	VTBFI	VTBFI	CHAR	2	0	Rule for determining the sales area for stock transfers
50	FPRFW	☐	FPRFW	FEPRF	CHAR	3	0	Distribution profile at plant level	TWFPF
51	ACHVM	☐	ACHVM_X	XFELD	CHAR	1	0	Central archiving marker for master record
52	DVSART	☐	DVSART	DVSART	CHAR	1	0	Batch Record: Type of DMS Used
53	NODETYPE	☐	NODETYPE	NODETYPE	CHAR	3	0	Node type: supply chain network	MDRP_NODT
54	NSCHEMA	☐	CKML_NSCHEMA	CKML_NSCHEMA	CHAR	4	0	Structure for name formation	CKMLMV007
55	PKOSA	☐	CKML_FLG_PKOSA	BOOLE	CHAR	1	0	Cost Object Controlling linking active
56	MISCH	☐	CKML_FLG_MISCH	BOOLE	CHAR	1	0	Updating is active for mixed costing
57	MGVUPD	☐	CKML_FLG_MGVUPD	BOOLE	CHAR	1	0	Updating is active in actual costing
58	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
59	MGVLAUPD	☐	CKML_MGVLAUPD	CKML_MGVLAUPD	CHAR	1	0	Update of Activity Consumption in the Quantity Structure
60	MGVLAREVAL	☐	CKML_MGVLAREVAL	CKML_MGVLAREVAL	CHAR	1	0	Control of Credit of Cost Centers
61	SOURCING	☐	MMPUR_SOURCING	MMPUR_SOURCING	CHAR	1	0	Invoke Added-Function Source Determination via ATP
62	.INCLU--AP	☐				0	0	Customer fields for Table T001W
63	OILIVAL	☐	OIA_VALFLG	OIA_VALFLG	CHAR	1	0	Exchange valuation indicator
64	OIHVTYPE	☐	OIH_J1B_VTYP	OIH_J1B_VTYP	CHAR	1	0	Vendor type (refinery/mill/other) (Brazil)
65	OIHCREDIPI	☐	OIH_J1B_TXCREDIP	ANKREUZ	CHAR	1	0	IPI credit allowed
66	.INCLU--AP	☐				0	0	Enhancement w/Store Category and Superior Department Store
67	.INCLUDE	☐				0	0	Structure: Store Category - Superior Department Store
68	STORETYPE	☐	WRF_STORETYPE	WRF_STORETYPE	CHAR	1	0	Store Category to Differentiate Store, Dep. Store, Shop
69	DEP_STORE	☐	WRF_DEP_STORE	WERKS	CHAR	4	0	Superior Department Store	*
70	SENDE	☐	SENDE_BI	CHAR1	CHAR	1	0	Record End Indicator for Batch Input Interface

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BT001W	AWSLS	TKV01	AWSLS	REF	C	CN
2	BT001W	BWKEY	T001K	BWKEY	REF	1	CN
3	BT001W	BZIRK	T171	BZIRK	KEY	1	CN
4	BT001W	CITYC	T005G	CITYC	REF	C	CN
5	BT001W	COUNC	T005E	COUNC	REF	C	CN
6	BT001W	EKORG	T024E	EKORG	REF	1	N
7	BT001W	FABKL	TFACD	IDENT	REF	1	CN
8	BT001W	FPRFW	TWFPF	FPRFW	REF	1	CN
9	BT001W	IWERK	T001W	WERKS	REF	C	CN
10	BT001W	J_1BBRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
11	BT001W	KUNNR	KNA1	KUNNR	REF	C	CN
12	BT001W	LAND1	T005	LAND1	REF	1	CN
13	BT001W	LIFNR	LFA1	LIFNR	KEY	1	CN
14	BT001W	MANDT	T000	MANDT	KEY	1	CN
15	BT001W	NODETYPE	MDRP_NODT	NODETYPE		1	CN
16	BT001W	NSCHEMA	CKMLMV007	NSCHEMA	REF	1	CN
17	BT001W	REGIO	T005S	BLAND	REF	C	CN
18	BT001W	SPART	TSPA	SPART	REF	C	CN
19	BT001W	SPRAS	T002	SPRAS	REF	C	CN
20	BT001W	TAXIW	TMKW1	TAXIW	KEY	1	N
21	BT001W	TXJCD	TTXJ	TXJCD	REF	1	CN
22	BT001W	VKORG	TVKO	VKORG	REF	1	CN
23	BT001W	VSTEL	TVST	VSTEL
24	BT001W	VTWEG	TVTW	VTWEG	REF	C	CN
25	BT001W	ZONE1	TZONE	ZONE1	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in