SAP ABAP Table BIW_CMP_NP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BIW_CMP_NP	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
4	APLZL	☑	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
6	RSNUM	☑	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
7	RSPOS	☑	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
8	RSART	☑	RSART	RSART	CHAR	1	0	Record type
9	PSPID_NP_I	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	PROJ
10	POSID_NP_I	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
11	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
12	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
13	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
14	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
15	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
20	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
22	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
23	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
24	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
25	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
26	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_CMP_NP	AUFNR	AUFK	AUFNR	KEY	1	1
2	BIW_CMP_NP	EKGRP	T024	EKGRP	REF	C	CN
3	BIW_CMP_NP	GSBER	TGSB	GSBER	REF	C	CN
4	BIW_CMP_NP	INFNR	EINA	INFNR	REF	C	CN
5	BIW_CMP_NP	KDAUF	VBUK	VBELN	REF	C	CN
6	BIW_CMP_NP	KOKRS	TKA01	KOKRS	REF	1	CN
7	BIW_CMP_NP	LGORT	T001L	LGORT	REF	C	CN
8	BIW_CMP_NP	MANDT	T000	MANDT	KEY	1	CN
9	BIW_CMP_NP	MATKL	T023	MATKL	REF	1	N
10	BIW_CMP_NP	MATNR	MARA	MATNR	REF	1	CN
11	BIW_CMP_NP	POSID_NP_I	PRPS	PSPNR	REF	C	CN
12	BIW_CMP_NP	PSPID_NP_I	PROJ	PSPNR	REF	C	CN
13	BIW_CMP_NP	WAERS	TCURC	WAERS	REF	1	CN
14	BIW_CMP_NP	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in