SAP ABAP Table TWRF2 (Plant Profiles)

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	TWRF2	Table Relationship Diagram
Short Description	Plant Profiles

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	BETRP	☑	BETRP	BETRP	CHAR	4	0	Plant profile
3	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
4	CLINT	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	*
5	REF_WKFIL	☐	REF_WKFIL	WERKS	CHAR	4	0	Reference for plant	T001W
6	REF_BUKRS	☐	REF_BUKRS	BUKRS	CHAR	4	0	Reference Company Code	T001
7	REF_VKORG	☐	REF_VKORG	VKORG	CHAR	4	0	Reference sales organization	TVKO
8	REF_VTWEG	☐	REF_VTWEG	VTWEG	CHAR	2	0	Reference distribution channel	TVTW
9	REF_SPART	☐	REF_SPART	SPART	CHAR	2	0	Division that is used as a reference	TSPA
10	KTOKK	☐	KTOGK	KTOKK	CHAR	4	0	Vendor account group	T077K
11	KTOKD	☐	KTOGD	KTOKD	CHAR	4	0	Customer account group	T077D
12	FAUSW	☐	FAUSW_077D	FA040	CHAR	40	0	Field status bar, plant master for IS-R data
13	CLINT_ABTL	☐	CLINT	CLINT	NUMC	10	0	Internal Class Number	*
14	FAUSS	☐	FAUSS_WRF2	FA040	CHAR	40	0	Field status definition plant master
15	WRKRG	☐	WRKRG	WRKRG	CHAR	2	0	Copy rule for plant	TWRF3
16	REF_KUNNR	☐	REF_KUNNR	KUN16	CHAR	16	0	Reference for customer (matchcode field)
17	REF_LIFNR	☐	REF_LIFNR	LIF16	CHAR	16	0	Reference for vendor (matchcode field)
18	REF_BUKRSK	☐	REF_BUKRS	BUKRS	CHAR	4	0	Reference Company Code	T001
19	REF_EKORG	☐	REF_EKORG	EKORG	CHAR	4	0	Reference Purchasing Organization	T024E
20	FAUSW_Z1	☐	FAUSW_077D	FA040	CHAR	40	0	Field status bar, plant master for IS-R data
21	UPD_FLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
22	ADDR_EXTRACTION	☐	ADDRESS_EXTRACTION	ADDRESS_EXTRACTION	CHAR	1	0	Address origin
23	MANUFACTURING	☐	PRODUCING	FLAG	CHAR	1	0	Producing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TWRF2	KTOKD	T077D	KTOKD			CN
2	TWRF2	KTOKK	T077K	KTOKK		1	CN
3	TWRF2	MANDT	T000	MANDT
4	TWRF2	REF_BUKRS	T001	BUKRS		1	CN
5	TWRF2	REF_BUKRSK	T001	BUKRS		1	CN
6	TWRF2	REF_EKORG	T024E	EKORG		1	CN
7	TWRF2	REF_SPART	TSPA	SPART	KEY	1	CN
8	TWRF2	REF_VKORG	TVKO	VKORG	KEY	1	CN
9	TWRF2	REF_VTWEG	TVTW	VTWEG	KEY	1	CN
10	TWRF2	REF_WKFIL	T001W	WERKS	KEY	1	CN
11	TWRF2	WRKRG	TWRF3	WRKRG	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in