SAP ABAP View BIW_NAE (Data Collection: Network Activity Element Master Data for BW)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ KAP8 (Package) Export from Projects into BIW

Basic Data

View Type	D	Database View
Database View	BIW_NAE
Short Description	Data Collection: Network Activity Element Master Data for BW
Root table	AUFK	Order master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFK	AUFK
2	AFKO	AFKO
3	AFVC
4	AFVU

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFKO	MANDT	JL	EQ				0	0
2	AFVC	MANDT	JR	EQ			AND	0	0
3	AUFK	MANDT	JL	EQ				0	0
4	AFKO	MANDT	JR	EQ			AND	0	0
5	AUFK	AUFNR	JL	EQ				0	0
6	AFKO	AUFNR	JR	EQ			AND	0	0
7	AFKO	AUFPL	JL	EQ				0	0
8	AFVC	AUFPL	JR	EQ			AND	0	0
9	AFVU	MANDT	JL	EQ				0	0
10	AFVC	MANDT	JR	EQ			AND	0	0
11	AFVU	AUFPL	JL	EQ				0	0
12	AFVC	AUFPL	JR	EQ			AND	0	0
13	AFVU	APLZL	JL	EQ				0	0
14	AFVC	APLZL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFKO	MANDT		☐	MANDT	☐	Client
2	AUFNR	AFKO	AUFNR		☐	AUFNR	☐	Order Number
3	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
4	APLZL	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
5	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
6	PSPID_NP_I	AFKO	PRONR		☐	PS_PSP_PRO	☐	Project definition
7	POSID_NP_I	AUFK	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
8	POSID_NV_I	AFVC	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
9	ERDAT	AUFK	ERDAT		☐	AUFERFDAT	☐	Created on
10	AEDAT	AUFK	AEDAT		☐	AUFAEDAT	☐	Change date for Order Master
11	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
12	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
13	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
14	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
15	ANFKO	AFVC	ANFKO		☐	ANFKO	☐	Requesting cost center
16	GSBER	AFVC	GSBER		☐	GSBER	☐	Business Area
17	PRCTR	AFVC	PRCTR		☐	PRCTR	☐	Profit Center
18	STEUS	AFVC	STEUS		☐	STEUS	☐	Control key
19	LIFNR	AFVC	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
20	SAKTO	AFVC	SAKTO		☐	KSTAR	☐	Cost Element
21	WAERS	AFVC	WAERS		☐	WAERS	☐	Currency Key
22	INFNR	AFVC	INFNR		☐	INFNR	☐	Number of purchasing info record
23	EKORG	AFVC	EKORG		☐	EKORG	☐	Purchasing organization
24	EKGRP	AFVC	EKGRP		☐	VG_EKGRP	☐	Purchasing group for external processing
25	MATKL	AFVC	MATKL		☐	MATKL	☐	Material Group
26	BUKRS	AFVC	BUKRS		☐	BUKRS	☐	Company Code
27	ANFKOKRS	AFVC	ANFKOKRS		☐	ANFKOKRS	☐	Controlling area of the requesting cost center
28	LARNT	AFVC	LARNT		☐	LSTAR	☐	Activity Type
29	NPRIO	AFVC	NPRIO		☐	NW_PRIO	☐	Priority
30	SCOPE	AFVC	SCOPE		☐	SCOPE_CV	☐	Object Class
31	EBELN	AFVC	EBELN		☐	EBELN	☐	Purchasing Document Number
32	EBELP	AFVC	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
33	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
34	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
35	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
36	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
37	USR00	AFVU	USR00		☐	USRCHAR20	☐	User field with 20 characters
38	USR01	AFVU	USR01		☐	USRCHAR20	☐	User field with 20 characters
39	USR02	AFVU	USR02		☐	USRCHAR10	☐	User field with 10 characters
40	USR03	AFVU	USR03		☐	USRCHAR10	☐	User field with 10 characters
41	USR04	AFVU	USR04		☐	USRQUAN13	☐	User field for quantity (length 10.3)
42	USE04	AFVU	USE04		☐	USRUNIT	☐	User field: Unit for quantity fields
43	USR05	AFVU	USR05		☐	USRQUAN13	☐	User field for quantity (length 10.3)
44	USE05	AFVU	USE05		☐	USRUNIT	☐	User field: Unit for quantity fields
45	USR06	AFVU	USR06		☐	USRCURR13	☐	User-defined field for values (length 10,3)
46	USE06	AFVU	USE06		☐	USRCUKY	☐	User field: Unit for value fields
47	USR07	AFVU	USR07		☐	USRCURR13	☐	User-defined field for values (length 10,3)
48	USE07	AFVU	USE07		☐	USRCUKY	☐	User field: Unit for value fields
49	USR08	AFVU	USR08		☐	USRDATE	☐	User field for date
50	USR09	AFVU	USR09		☐	USRDATE	☐	User field for date
51	USR10	AFVU	USR10		☐	USRFLAG	☐	User-defined field: Indicator for reports
52	USR11	AFVU	USR11		☐	USRFLAG	☐	User-defined field: Indicator for reports

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in