SAP ABAP Table OLR3_NETZI (PSIS - Individual Overviews: Networks)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-ST (Application Component) Structures
     ⤷ R3_OBJECTLINK_R3 (Package) Object Link cProjects and R/3

Basic Data

Table Category	INTTAB	Structure
Structure	OLR3_NETZI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: Networks

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	.INCLUDE	☐				0	0	Network Master Data Structure for Project Reporting
2	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
3	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
4	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
6	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
7	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
8	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
9	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
10	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
11	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
12	AUFNR	☐	NW_AUFNR	AUFNR	CHAR	12	0	Network number	AUFK
13	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	*
14	VORNT	☐	CN_VORNRT	VORNR	CHAR	4	0	Activity number replaced by sub-network
15	AUART	☐	NW_AUART	AUFART	CHAR	4	0	Network type	T003O
16	KTEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
17	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
18	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
20	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
22	KOSTV	☐	AUFKOSTV	KOSTL	CHAR	10	0	Responsible cost center	*
23	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
25	SCOPE	☐	SCOPE_CV	SCOPE_CV	CHAR	2	0	Object Class
26	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
27	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
28	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
29	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
30	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
31	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
32	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
33	GETRI	☐	CO_GETRI	DATUM	DATS	8	0	Confirmed Order Finish Date
34	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
35	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
36	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
37	DISPO	☐	CO_DISPO	DISPO	CHAR	3	0	MRP controller for the order	T024D
38	DSNAM	☐	DSNAM	TEXT18	CHAR	18	0	Name of MRP controller
39	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
40	TERKZ	☐	TERMKZ	TERART	CHAR	1	0	Scheduling type	T482
41	REDKZ	☐	REDKZ	REDKZ	CHAR	1	0	Reduction indicator for scheduling
42	APRIO	☐	CO_APRIO	CHAR1	CHAR	1	0	Order priority
43	GLTPP	☐	CO_GLTPP	DATUM	DATS	8	0	Finish date (forecast)
44	GSTPP	☐	CO_GSTPP	DATUM	DATS	8	0	Forecast start date
45	GLTPS	☐	CO_GLTPS	DATUM	DATS	8	0	Scheduled forecast finish
46	GSTPS	☐	CO_GSTPS	DATUM	DATS	8	0	Scheduled forecast start
47	FTRPS	☐	CO_FTRPS	DATUM	DATS	8	0	Scheduled release date (forecast)
48	RDKZP	☐	REDKZP	REDKZ	CHAR	1	0	Reduction indicator for scheduling (forecast)
49	TRKZP	☐	TERMKZP	TERART	CHAR	1	0	Scheduling type (forecast)	T482
50	GLUZS	☐	CO_GLUZS	UHRZT	TIMS	6	0	Scheduled finish time
51	GSUZS	☐	CO_GSUZS	ATIME	TIMS	6	0	Scheduled Start (Time)
52	AUTERM	☐	CO_AUTERM	KREUZ	CHAR	1	0	Indicator: Schedule automatically
53	AUCOST	☐	CO_AUCOST	KREUZ	CHAR	1	0	Indicator: Cost automatically
54	AUDISP	☐	AUDISP	XFELD	CHAR	1	0	Ind: Reservation applicable to MRP;Purc. req. is created
55	GLUZP	☐	CO_GLUZP	UHRZT	TIMS	6	0	Basic finish (time)
56	GSUZP	☐	CO_GSUZP	UHRZT	TIMS	6	0	Basic start time
57	GSUZI	☐	CO_GSUZI	UHRZT	TIMS	6	0	Actual start time
58	GEUZI	☐	CO_GEUZI	UHRZT	TIMS	6	0	Confirmed order finish (time)
59	GLUPP	☐	CO_GLUPP	UHRZT	TIMS	6	0	Forecast finish (time)
60	GSUPP	☐	CO_GSUPP	UHRZT	TIMS	6	0	Forecast start (time)
61	GLUPS	☐	CO_GLUPS	UHRZT	TIMS	6	0	Scheduled forecast finish time
62	GSUPS	☐	CO_GSUPS	UHRZT	TIMS	6	0	Scheduled start time (Forecast)
63	AUKBED	☐	AUKBED	XFELD	CHAR	1	0	Indicator: Calculate capacity requirements
64	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
65	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text
66	FRUEHER	☐	FRUEHER_2	DAUER_9_1	QUAN	10	1	Actual start is before earliest scheduled start
67	SPAETER	☐	SPAETER_2	DAUER_9_1	QUAN	10	1	Actual Finish/Planned Finish After Latest Scheduled Finish
68	VERZUG	☐	VERZUG_2	DAUER_9_1	QUAN	10	1	Duration After Latest Scheduled Finish
69	VORBEI	☐	VORBEI_2	DAUER_9_1	QUAN	10	1	Duration After Earliest Scheduled Start
70	VEINH	☐	VERZ_EINHT	MEINS	UNIT	3	0	Unit for Duration of the Delay	T006
71	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
72	KZAVC	☐	KZAVC	KZAVC	CHAR	1	0	Indicator for type of availability check
73	RETCODE	☐	RC_VERF_NW	CHAR2	CHAR	2	0	Result of availability check
74	MSGTY	☐	SYMSGTY	SYCHAR01	CHAR	1	0	Message Type
75	FUNC_AREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
76	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
77	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
78	AUFLD	☐	CO_AUFLD	DATUM	DATS	8	0	Date of BOM Explosion/Routing Transfer
79	EDAUER	☐	PS_EDAUER	DAUER_4_1	QUAN	5	1	Duration
80	EDAUEH	☐	PS_DAUEH	MEINS	UNIT	3	0	Actual duration unit	*
81	PDAUER	☐	PS_PDAUER	DAUER_4_1	QUAN	5	1	Forecast duration
82	PDAUEH	☐	PS_DAUEH	MEINS	UNIT	3	0	Actual duration unit	*
83	IDAUER	☐	PS_IDAUER	DAUER_4_1	QUAN	5	1	Actual duration
84	IDAUEH	☐	PS_DAUEH	MEINS	UNIT	3	0	Actual duration unit	*
85	PLNAW	☐	PLNAW	PLNAW	CHAR	1	0	Application of the task list	*
86	PROFID	☐	PROFIDNZPL	PROFILID	CHAR	7	0	Network profile	*
87	PSPNR	☐	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	*
88	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
89	INT_ID	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
90	LOEKZ	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
91	LIGHT	☐	LVC_EXLED	CHAR1	CHAR	1	0	ALV control: Exception as LED

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OLR3_NETZI	AENNR	AENR	AENNR
2	OLR3_NETZI	AUART	T003O	AUART	REF	1	CN
3	OLR3_NETZI	AUFNR	AUFK	AUFNR	KEY	1	CN
4	OLR3_NETZI	BUKRS	T001	BUKRS	REF	1	CN
5	OLR3_NETZI	DISPO	T024D	DISPO	REF	C	CN
6	OLR3_NETZI	FEVOR	T024F	FEVOR	REF	C	CN
7	OLR3_NETZI	GSBER	TGSB	GSBER	REF	C	CN
8	OLR3_NETZI	KDAUF	VBUK	VBELN	REF	C	CN
9	OLR3_NETZI	KDPOS	VBUP	POSNR	REF	C	CN
10	OLR3_NETZI	PRCTR	CEPC	PRCTR	REF	C	CN
11	OLR3_NETZI	PRNAM	IMTP	PRNAM			CN
12	OLR3_NETZI	TERKZ	T482	TERMKZ	REF	C	CN
13	OLR3_NETZI	TRKZP	T482	TERMKZ	REF	C	CN
14	OLR3_NETZI	TXJCD	TTXJ	TXJCD	REF	C	CN
15	OLR3_NETZI	VEINH	T006	MSEHI	REF	C	CN
16	OLR3_NETZI	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in