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
⤷ 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 |