SAP ABAP View BIW_NAE_D (Data Collection: Network Activity Element Dates 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_D
Short Description	Data Collection: Network Activity Element Dates 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	AFVV

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	AFVV	MANDT	JL	EQ				0	0
10	AFVC	MANDT	JR	EQ			AND	0	0
11	AFVV	AUFPL	JL	EQ				0	0
12	AFVC	AUFPL	JR	EQ			AND	0	0
13	AFVV	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	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
34	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
35	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
36	PLIFZ	AFVV	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
37	DAUNO	AFVV	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
38	DAUNE	AFVV	DAUNE		☐	DAUNORE	☐	Normal duration/unit
39	DAUMI	AFVV	DAUMI		☐	DAUMIN	☐	Minimum activity duration
40	DAUME	AFVV	DAUME		☐	DAUMINE	☐	Unit for the minimum duration
41	EINSA	AFVV	EINSA		☐	EINSCHRA	☐	Constraint on the basic start date for the activity
42	EINSE	AFVV	EINSE		☐	EINSCHRE	☐	Constraint on the finish date of the activity
43	FSAVD	AFVV	FSAVD		☐	FSAVD	☐	Earliest scheduled start: Execution (date)
44	FSAVZ	AFVV	FSAVZ		☐	FSAVZ	☐	Earliest scheduled start: Execution (time)
45	FSSBD	AFVV	FSSBD		☐	FSSBD	☐	Earliest scheduled start: Processing (date)
46	FSSBZ	AFVV	FSSBZ		☐	FSSBZ	☐	Earliest scheduled start: Processing (time)
47	FSSAD	AFVV	FSSAD		☐	FSSAD	☐	Earliest scheduled start: Teardown (date)
48	FSSAZ	AFVV	FSSAZ		☐	FSSAZ	☐	Earliest scheduled start: Teardown (time)
49	FSEDD	AFVV	FSEDD		☐	FSEDD	☐	Earliest scheduled finish: Execution (date)
50	FSEDZ	AFVV	FSEDZ		☐	FSEDZ	☐	Earliest scheduled finish: Execution (time)
51	FSSLD	AFVV	FSSLD		☐	FSSLD	☐	Earliest scheduled start: Wait (date)
52	FSSLZ	AFVV	FSSLZ		☐	FSSLZ	☐	Earliest scheduled start: Wait (time)
53	FSELD	AFVV	FSELD		☐	FSELD	☐	Earliest scheduled finish: Wait (date)
54	FSELZ	AFVV	FSELZ		☐	FSELZ	☐	Earliest scheduled finish: Wait (time)
55	SSAVD	AFVV	SSAVD		☐	SSAVD	☐	Latest scheduled start: Execution (date)
56	SSAVZ	AFVV	SSAVZ		☐	SSAVZ	☐	Latest scheduled start: Execution (time)
57	SSSBD	AFVV	SSSBD		☐	SSSBD	☐	Latest scheduled start: Processing (date)
58	SSSBZ	AFVV	SSSBZ		☐	SSSBZ	☐	Latest scheduled start: Processing (time)
59	SSSAD	AFVV	SSSAD		☐	SSSAD	☐	Latest scheduled start: Teardown (date)
60	SSSAZ	AFVV	SSSAZ		☐	SSSAZ	☐	Latest scheduled start: Teardown (time)
61	SSEDD	AFVV	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
62	SSEDZ	AFVV	SSEDZ		☐	SSEDZ	☐	Latest scheduled finish: Execution (time)
63	SSSLD	AFVV	SSSLD		☐	SSSLD	☐	Latest scheduled start: Wait time (date)
64	SSSLZ	AFVV	SSSLZ		☐	SSSLZ	☐	Latest scheduled start: Wait time
65	SSELD	AFVV	SSELD		☐	SSELD	☐	Latest scheduled finish: Wait time (date)
66	SSELZ	AFVV	SSELZ		☐	SSELZ	☐	Latest scheduled finish: Wait time
67	ISAVD	AFVV	ISAVD		☐	ISAVD	☐	Actual operation start (date)
68	IEAVD	AFVV	IEAVD		☐	IEAVD	☐	Actual finish of operation (date)
69	ISDD	AFVV	ISDD		☐	ISDD	☐	Actual start: Execution (date)
70	ISDZ	AFVV	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
71	IERD	AFVV	IERD		☐	IERD	☐	Actual finish: Setup (date)
72	IERZ	AFVV	IERZ		☐	IERZ	☐	Actual finish: Setup (time)
73	ISBD	AFVV	ISBD		☐	ISBD	☐	Actual start: Processing (date)
74	ISBZ	AFVV	ISBZ		☐	ISBZ	☐	Actual start: Processing (time)
75	IEBD	AFVV	IEBD		☐	IEBD	☐	Actual finish: Processing (date)
76	IEBZ	AFVV	IEBZ		☐	IEBZ	☐	Actual processing finish (time)
77	ISAD	AFVV	ISAD		☐	ISAD	☐	Actual start: Teardown (date)
78	ISAZ	AFVV	ISAZ		☐	ISAZ	☐	Actual start: Teardown (time)
79	IEDD	AFVV	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
80	IEDZ	AFVV	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
81	PEDD	AFVV	PEDD		☐	CO_PEDD	☐	Forecast finish date of operation from confirmation
82	PEDZ	AFVV	PEDZ		☐	CO_PEDZ	☐	Forecast finish time of operation from confirmation
83	PUFFR	AFVV	PUFFR		☐	PUFFR_FREI	☐	Free float
84	PUFGS	AFVV	PUFGS		☐	PUFFR_GESM	☐	Total float
85	NTANF	AFVV	NTANF		☐	VORGABESTD	☐	Constraint for activity start (Basic)
86	NTANZ	AFVV	NTANZ		☐	VORGABESTZ	☐	Constraint for activity start time (Basic)
87	NTEND	AFVV	NTEND		☐	VORGABEEND2	☐	Constraint for Finish of Activity (Basic)
88	NTENZ	AFVV	NTENZ		☐	VORGABEENZ	☐	Basic finish time of the activity
89	EWSTD	AFVV	EWSTD		☐	EWSTARTD	☐	Forecasted start date for the activity
90	EWSTZ	AFVV	EWSTZ		☐	EWSTARTZ	☐	Forecast start time of the activity
91	EWEND	AFVV	EWEND		☐	EWENDED	☐	Forecast finish date
92	EWENZ	AFVV	EWENZ		☐	EWENDEZ	☐	Forecast finish time for the activity
93	EWDAN	AFVV	EWDAN		☐	EWDAN	☐	Normal duration (from forecast) of activity
94	EWDNE	AFVV	EWDNE		☐	EWDNE	☐	Unit for forecast normal duration
95	EWDAM	AFVV	EWDAM		☐	EWDAM	☐	Minimum duration (from forecast) for activity
96	EWDME	AFVV	EWDME		☐	EWDME	☐	Unit for forecast minimum duration
97	EWSTE	AFVV	EWSTE		☐	PS_RESTE	☐	Forecast date constraint on activity finish
98	EWSTA	AFVV	EWSTA		☐	PS_RESTA	☐	Forecast date constraint on activity start
99	FPAVD	AFVV	FPAVD		☐	FPAVD	☐	Earliest scheduled start date (forecast)
100	FPAVZ	AFVV	FPAVZ		☐	FPAVZ	☐	Earliest scheduled start time (forecast)
101	FPEDD	AFVV	FPEDD		☐	FPEDD	☐	Earliest scheduled finish date (forecast)
102	FPEDZ	AFVV	FPEDZ		☐	FPEDZ	☐	Earliest scheduled finish time (forecast)
103	SPAVD	AFVV	SPAVD		☐	SPAVD	☐	Latest scheduled start date (forecast)
104	SPAVZ	AFVV	SPAVZ		☐	SPAVZ	☐	Latest scheduled start time (forecast)
105	SPEDD	AFVV	SPEDD		☐	SPEDD	☐	Latest scheduled finish date (forecast)
106	SPEDZ	AFVV	SPEDZ		☐	SPEDZ	☐	Latest scheduled finish time (forecast)
107	BEAZP	AFVV	BEAZP		☐	BEAZEP	☐	Unit of processing time (Forecast)
108	PUFGP	AFVV	PUFGP		☐	PPUFF_GESM	☐	Total float (from forecast)
109	PUFFP	AFVV	PUFFP		☐	PPUFF_FREI	☐	Free float (from forecast)
110	BEARP	AFVV	BEARP		☐	PBEARZEIT	☐	Processing time (forecast)
111	EPANF	AFVV	EPANF		☐	EPANF	☐	Dispatched start date for operation
112	EPANZ	AFVV	EPANZ		☐	EPANZ	☐	Dispatched start time for operation
113	EPEND	AFVV	EPEND		☐	EPEND	☐	Dispatched finish date
114	EPENZ	AFVV	EPENZ		☐	EPENZ	☐	Dispatched finish time
115	PDAU	AFVV	PDAU		☐	PDAU	☐	Forecasted duration of activity from confirmation
116	PDAE	AFVV	PDAE		☐	PDAE	☐	Unit of the forecasted duration from the confirmation
117	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
118	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
119	ISMNW	AFVV	ISMNW		☐	CO_ISMNW	☐	Actual work
120	RUEST	AFVV	RUEST		☐	RUEST	☐	Setup time
121	RSTZE	AFVV	RSTZE		☐	RSTZE	☐	Unit of measure for setup time
122	BEARZ	AFVV	BEARZ		☐	BEARZEIT	☐	Processing time
123	BEAZE	AFVV	BEAZE		☐	BEAZE	☐	Unit of measure for processing time
124	ABRUE	AFVV	ABRUE		☐	ABRUE	☐	Teardown
125	ARUZE	AFVV	ARUZE		☐	ARUZE	☐	Unit of measure for teardown

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