SAP ABAP Table CCIHS_PLANT (EHS: Data for Plant)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

Table Category	INTTAB	Structure
Structure	CCIHS_PLANT	Table Relationship Diagram
Short Description	EHS: Data for Plant

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	110