SAP ABAP Table CNSH_SEL (Structure with selection fields for delivery from PS)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-MAT-DLV (Application Component) Delivery
     ⤷ CNSH (Package) Delivery from Project System

Basic Data

Table Category	INTTAB	Structure
Structure	CNSH_SEL	Table Relationship Diagram
Short Description	Structure with selection fields for delivery from PS

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_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	*
2	PSPID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
3	PSPID_MIN	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
4	PSPID_MAX	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
5	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
6	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
7	NPLNR	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	AUFK
8	NPLNR_MIN	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	*
9	NPLNR_MAX	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	*
10	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
11	BDTER_MIN	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
12	BDTER_MAX	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
13	WERKS_MIN	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
14	WERKS_MAX	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
15	SORTF_MIN	☐	SORTP	CHAR10	CHAR	10	0	Sort String
16	SORTF_MAX	☐	SORTP	CHAR10	CHAR	10	0	Sort String
17	MATNR_MIN	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
18	MATNR_MAX	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
20	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
21	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
22	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
23	GSBER_MIN	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	GSBER_MAX	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
25	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
26	STRBE	☐	STRBE	FLAG	CHAR	1	0	Select third party order
27	COFMG	☐	COFMG	FLAG	CHAR	1	0	Also select comp. with open quantity zero
28	PRORD	☐	CNSH_PRORD	FLAG	CHAR	1	0	Ind.: Select components in production orders too
29	VORNR_MIN	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
30	VORNR_MAX	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
31	POSNR_MIN	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
32	POSNR_MAX	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
33	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
34	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
35	VSTEL_MIN	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
36	VSTEL_MAX	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
37	KUNNR_MIN	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
38	KUNNR_MAX	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
39	LFDAT_MIN	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
40	LFDAT_MAX	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
41	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CNSH_SEL	AUFNR	AUFK	AUFNR
2	CNSH_SEL	BNFPO	EBAN	BNFPO
3	CNSH_SEL	GSBER_MAX	TGSB	GSBER
4	CNSH_SEL	GSBER_MIN	TGSB	GSBER
5	CNSH_SEL	KDAUF	VBUK	VBELN
6	CNSH_SEL	KDPOS	VBUP	POSNR
7	CNSH_SEL	NPLNR	AUFK	AUFNR
8	CNSH_SEL	POSTP	T418	POSTP
9	CNSH_SEL	SAKNR	SKA1	SAKNR
10	CNSH_SEL	SOBKZ	T148	SOBKZ

History

Last changed by/on	SAP	20130529
SAP Release Created in