SAP ABAP Table BIW_CMP_NV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BIW_CMP_NV	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	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order
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	POSID_NV_I	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
12	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
13	AEDAT	☐	AUFAEDAT	DATUM	DATS	8	0	Change date for Order Master
14	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
15	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
22	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
23	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
24	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
25	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
26	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
27	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
28	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in