SAP ABAP Table CNMM_SEL (Structure with Selection Fields for Material Handling)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS-MAT-PRO (Application Component) Project-Oriented Procurement
     ⤷ CNMM (Package) Project oriented production and procurement

Basic Data

Table Category	INTTAB	Structure
Structure	CNMM_SEL	Table Relationship Diagram
Short Description	Structure with Selection Fields for Material Handling

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	PROID	☐	PS_INTNR	PS_PSPNR	NUMC	8	0	Current number for project or project item	*
2	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
3	POSID_LOW	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
4	POSID_HIGH	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
5	NPLNR_LOW	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	*
6	NPLNR_HIGH	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	*
7	PROFILE	☐	PROMAN_PROFILE	CNMM_PROFILE	CHAR	6	0	Profile for ProMan	TPROMANPR
8	DISPO_LOW	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
9	DISPO_HIGH	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
10	VORNR_LOW	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
11	VORNR_HIGH	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
12	MATNR_LOW	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	MATNR_HIGH	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
14	WERKS_LOW	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
15	WERKS_HIGH	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
16	SORTF_LOW	☐	SORTP	CHAR10	CHAR	10	0	Sort String
17	SORTF_HIGH	☐	SORTP	CHAR10	CHAR	10	0	Sort String
18	BDTER_LOW	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
19	BDTER_HIGH	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
20	MATKL_LOW	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
21	MATKL_HIGH	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
22	EKGRP_LOW	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
23	EKGRP_HIGH	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
24	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
25	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
26	ACT_WERKS_LOW	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
27	ACT_WERKS_HIGH	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
28	ACT_ARBPL_LOW	☐	ARBPL	ARBPL	CHAR	8	0	Work center
29	ACT_ARBPL_HIGH	☐	ARBPL	ARBPL	CHAR	8	0	Work center
30	ACT_SORTF_LOW	☐	SORTP	CHAR10	CHAR	10	0	Sort String
31	ACT_SORTF_HIGH	☐	SORTP	CHAR10	CHAR	10	0	Sort String
32	ACT_MATKL_LOW	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
33	ACT_MATKL_HIGH	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
34	ACT_EKGRP_LOW	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
35	ACT_EKGRP_HIGH	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
36	ACT_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CNMM_SEL	ACT_EKGRP_HIGH	T024	EKGRP		C	CN
2	CNMM_SEL	ACT_EKGRP_LOW	T024	EKGRP		C	CN
3	CNMM_SEL	ACT_LIFNR	LFA1	LIFNR		1	N
4	CNMM_SEL	ACT_MATKL_HIGH	T023	MATKL		1	N
5	CNMM_SEL	ACT_MATKL_LOW	T023	MATKL		1	N
6	CNMM_SEL	ACT_WERKS_HIGH	T001W	WERKS		1	N
7	CNMM_SEL	ACT_WERKS_LOW	T001W	WERKS		1	N
8	CNMM_SEL	DISPO_HIGH	T024D	DISPO
9	CNMM_SEL	DISPO_LOW	T024D	DISPO
10	CNMM_SEL	EKGRP_HIGH	T024	EKGRP		C	CN
11	CNMM_SEL	EKGRP_LOW	T024	EKGRP		C	CN
12	CNMM_SEL	POSTP	T418	POSTP		1	N
13	CNMM_SEL	PROFILE	TPROMANPR	PROFILE		1	N

History

Last changed by/on	SAP	20110901
SAP Release Created in