SAP ABAP View CN_RES (CN: Data for the Network Components)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
SRM-EBP (Application Component) Enterprise Buyer
⤷
CN (Package) R/3 Application development: PS Basic data

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | CN_RES | |
Short Description | CN: Data for the Network Components | |
Root table | RESB | Reservation/dependent requirements |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
RESB | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
RSNUM | JL | EQ | 0 | 0 | ||||
4 | ![]() |
RSNUM | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
RSPOS | JL | EQ | 0 | 0 | ||||
6 | ![]() |
RSPOS | JR | EQ | AND | 0 | 0 | |||
7 | ![]() |
RSART | JL | EQ | 0 | 0 | ||||
8 | ![]() |
RSART | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
* | |||||
2 | ![]() |
![]() |
MANDT | MANDT | Client | |||
3 | ![]() |
![]() |
RSNUM | RSNUM | Number of reservation/dependent requirements | |||
4 | ![]() |
![]() |
RSPOS | RSPOS | Item Number of Reservation / Dependent Requirements | |||
5 | ![]() |
![]() |
RSART | RSART | Record type | |||
6 | ![]() |
![]() |
BDART | BDART | Requirement type | |||
7 | ![]() |
![]() |
RSSTA | RSSTA | Status of reservation | |||
8 | ![]() |
![]() |
XLOEK | XLOEK | Item is deleted | |||
9 | ![]() |
![]() |
XWAOK | XWAOK | Goods movement for reservation allowed | |||
10 | ![]() |
![]() |
KZEAR | KZEAR | Final issue for this reservation | |||
11 | ![]() |
![]() |
XFEHL | XFEHL | Pre-allocated stock | |||
12 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
13 | ![]() |
![]() |
WERKS | WERKS_D | Plant | |||
14 | ![]() |
![]() |
LGORT | LGORT_D | Storage location | |||
15 | ![]() |
![]() |
PRVBE | PRVBE | Production Supply Area | |||
16 | ![]() |
![]() |
CHARG | CHARG_D | Batch Number | |||
17 | ![]() |
![]() |
PLPLA | PLPLA | Distribution of Differences | |||
18 | ![]() |
![]() |
SOBKZ | SOBKZ | Special Stock Indicator | |||
19 | ![]() |
![]() |
BDTER | BDTER | Requirements date for the component | |||
20 | ![]() |
![]() |
BDMNG | BDMNG | Requirement Quantity | |||
21 | ![]() |
![]() |
MEINS | MEINS | Base Unit of Measure | |||
22 | ![]() |
![]() |
SHKZG | SHKZG | Debit/Credit Indicator | |||
23 | ![]() |
![]() |
FMENG | FMENG | Quantity is fixed | |||
24 | ![]() |
![]() |
ENMNG | ENMNG | Quantity withdrawn | |||
25 | ![]() |
![]() |
ENWRT | ENWRT | Value Withdrawn | |||
26 | ![]() |
![]() |
WAERS | WAERS | Currency Key | |||
27 | ![]() |
![]() |
ERFMG | ERFMG | Quantity in unit of entry | |||
28 | ![]() |
![]() |
ERFME | ERFME | Unit of entry | |||
29 | ![]() |
![]() |
PLNUM | PLNUM | Planned order number | |||
30 | ![]() |
![]() |
BANFN | BANFN | Purchase requisition number | |||
31 | ![]() |
![]() |
BNFPO | BNFPO | Item number of purchase requisition | |||
32 | ![]() |
![]() |
AUFNR | AUFNR | Order Number | |||
33 | ![]() |
![]() |
BAUGR | BAUGR | Material number of higher-level assembly | |||
34 | ![]() |
![]() |
SERNR | SERNR | BOM explosion number | |||
35 | ![]() |
![]() |
KDAUF | KDAUF | Sales Order Number | |||
36 | ![]() |
![]() |
KDPOS | KDPOS | Item number in Sales Order | |||
37 | ![]() |
![]() |
KDEIN | KDEIN | Delivery schedule for sales order | |||
38 | ![]() |
![]() |
PROJN | PROJN | Old: Project number : No longer used --> PS_POSNR | |||
39 | ![]() |
![]() |
BWART | BWART | Movement type (inventory management) | |||
40 | ![]() |
![]() |
SAKNR | SAKNR | G/L Account Number | |||
41 | ![]() |
![]() |
GSBER | GSBER | Business Area | |||
42 | ![]() |
![]() |
UMWRK | UMWRK | Receiving plant/issuing plant | |||
43 | ![]() |
![]() |
UMLGO | UMLGO | Receiving/issuing storage location | |||
44 | ![]() |
![]() |
NAFKZ | NAFKZ | Indicator: follow-up material active/not active | |||
45 | ![]() |
![]() |
NOMAT | NOMAT | Follow-Up/Original Material | |||
46 | ![]() |
![]() |
NOMNG | NOMNG | Required quantity | |||
47 | ![]() |
![]() |
POSTP | POSTP | Item category (bill of material) | |||
48 | ![]() |
![]() |
POSNR | APOSN | BOM item number | |||
49 | ![]() |
![]() |
ROMS1 | ROMS1 | Size 1 | |||
50 | ![]() |
![]() |
ROMS2 | ROMS2 | Size 2 | |||
51 | ![]() |
![]() |
ROMS3 | ROMS3 | Size 3 | |||
52 | ![]() |
![]() |
ROMEI | ROMEI | Unit of measure for sizes 1 to 3 | |||
53 | ![]() |
![]() |
ROMEN | ROMEN | VarSizeItem Qty | |||
54 | ![]() |
![]() |
SGTXT | SGTXT | Item Text | |||
55 | ![]() |
![]() |
LMENG | LMENG | Required quantity for mat.management in stockkeeping units | |||
56 | ![]() |
![]() |
ROHPS | ROHPS | Variable-sized item indicator | |||
57 | ![]() |
![]() |
RFORM | RFORM | Formula Key | |||
58 | ![]() |
![]() |
ROANZ | ROANZ | Number of Variable-Size Items | |||
59 | ![]() |
![]() |
FLMNG | FLMNG | Shortfall quantity of the component in the order | |||
60 | ![]() |
![]() |
STLTY | STLTY | BOM Category | |||
61 | ![]() |
![]() |
STLNR | STNUM | Bill of Material | |||
62 | ![]() |
![]() |
STLKN | STLKN | BOM Item Node Number | |||
63 | ![]() |
![]() |
STPOZ | CIM_COUNT | Internal counter | |||
64 | ![]() |
![]() |
LTXSP | LTXSP | Language: The long text was stored in this language | |||
65 | ![]() |
![]() |
POTX1 | POTX1 | BOM Item Text (Line 1) | |||
66 | ![]() |
![]() |
POTX2 | POTX2 | BOM Item Text (Line 2) | |||
67 | ![]() |
![]() |
SANKA | CK_SELKZ | Indicator for Relevancy to Costing | |||
68 | ![]() |
![]() |
ALPOS | ALTPS | Alternative item indicator | |||
69 | ![]() |
![]() |
EWAHR | EWAHR | Usage Probability in % (Alternative Item) | |||
70 | ![]() |
![]() |
AUSCH | KAUSF | Component scrap in percent | |||
71 | ![]() |
![]() |
AVOAU | AVOAU | Operation Scrap | |||
72 | ![]() |
![]() |
NETAU | NETAU | Indicator: Net Scrap | |||
73 | ![]() |
![]() |
NLFZT | NLFZT | Lead-Time Offset | |||
74 | ![]() |
![]() |
AENNR | AENNR | Change Number | |||
75 | ![]() |
![]() |
UMREZ | UMREZ | Numerator for Conversion to Base Units of Measure | |||
76 | ![]() |
![]() |
UMREN | UMREN | Denominator for conversion to base units of measure | |||
77 | ![]() |
![]() |
SORTF | SORTP | Sort String | |||
78 | ![]() |
![]() |
SBTER | SBTER | Latest requirements date | |||
79 | ![]() |
![]() |
VERTI | SA_VERTL | MRP Distribution Key | |||
80 | ![]() |
![]() |
SCHGT | SCHGT | Indicator: bulk material | |||
81 | ![]() |
![]() |
UPSKZ | UPSKZ | Indicator: Subitems Exist | |||
82 | ![]() |
![]() |
DBSKZ | DBSKZ | Direct procurement indicator | |||
83 | ![]() |
![]() |
TXTPS | TXTPS | Item text indicator | |||
84 | ![]() |
![]() |
DUMPS | DUMPS | Phantom item indicator | |||
85 | ![]() |
![]() |
BEIKZ | BEIKZ | Material Provision Indicators | |||
86 | ![]() |
![]() |
ERSKZ | ERSKZ | Indicator: Spare Part | |||
87 | ![]() |
![]() |
AUFST | AUFST | Order level | |||
88 | ![]() |
![]() |
AUFWG | AUFWG | Order path | |||
89 | ![]() |
![]() |
BAUST | BAUST | Assembly order level | |||
90 | ![]() |
![]() |
BAUWG | BAUWG | Assembly order path | |||
91 | ![]() |
![]() |
AUFPS | AUFPS | Order item number | |||
92 | ![]() |
![]() |
EBELN | EBELN | Purchasing Document Number | |||
93 | ![]() |
![]() |
EBELP | EBELP | Item Number of Purchasing Document | |||
94 | ![]() |
![]() |
EBELE | EETEN | Delivery Schedule Line Counter | |||
95 | ![]() |
![]() |
KNTTP | KNTTP | Account assignment category | |||
96 | ![]() |
![]() |
KZVBR | KZVBR | Consumption posting | |||
97 | ![]() |
![]() |
PSPEL | PS_POSNR | WBS Element | |||
98 | ![]() |
![]() |
AUFPL | CO_AUFPL | Routing number of operations in the order | |||
99 | ![]() |
![]() |
PLNFL | PLNFOLGE | Sequence | |||
100 | ![]() |
![]() |
VORNR | VORNR | Operation/Activity Number | |||
101 | ![]() |
![]() |
APLZL | CIM_COUNT | Internal counter | |||
102 | ![]() |
![]() |
OBJNR | J_OBJNR | Object number | |||
103 | ![]() |
![]() |
FLGAT | FOLGENART | Sequence category | |||
104 | ![]() |
![]() |
GPREIS | PPCOMP | Price in component currency | |||
105 | ![]() |
![]() |
FPREIS | OPREIFX | Fixed Price in Foreign Currency | |||
106 | ![]() |
![]() |
PEINH | PEINH | Price unit | |||
107 | ![]() |
![]() |
RGEKZ | RGEKZ | Indicator: Backflush | |||
108 | ![]() |
![]() |
EKGRP | EKGRP | Purchasing group | |||
109 | ![]() |
![]() |
ROKME | ROKME | Unit of measure for variable-size component | |||
110 | ![]() |
![]() |
ZUMEI | DZUMEI | Unit for cutting measures | |||
111 | ![]() |
![]() |
ZUMS1 | DZUMS1 | Cutting measure 1 | |||
112 | ![]() |
![]() |
ZUMS2 | DZUMS2 | Cutting measure 2 | |||
113 | ![]() |
![]() |
ZUMS3 | DZUMS3 | Cutting measure 3 | |||
114 | ![]() |
![]() |
ZUDIV | DZUDIV | Integral divisor for cutting measures | |||
115 | ![]() |
![]() |
VMENG | VMENG | Confirmed quantity for availability check in SKU | |||
116 | ![]() |
![]() |
PRREG | PRREG | Checking rule for the availability check | |||
117 | ![]() |
![]() |
LIFZT | LIFZT | Delivery Time in Days | |||
118 | ![]() |
![]() |
CUOBJ | CUOBJ | Configuration (internal object number) | |||
119 | ![]() |
![]() |
KFPOS | KFPOS | Indicator: "configurable item" | |||
120 | ![]() |
![]() |
REVLV | REVLV | Revision level | |||
121 | ![]() |
![]() |
BERKZ | BERKZ | Material Staging Indicator for Production Supply | |||
122 | ![]() |
![]() |
LGNUM | LGNUM | Warehouse Number / Warehouse Complex | |||
123 | ![]() |
![]() |
LGTYP | LGTYP | Storage Type | |||
124 | ![]() |
![]() |
LGPLA | LGPLA | Storage Bin | |||
125 | ![]() |
![]() |
TBMNG | TBMNG | Transfer requirement quantity already requested | |||
126 | ![]() |
![]() |
NPTXTKY | TXTKY | Internal text number (12-character) | |||
127 | ![]() |
![]() |
KBNKZ | KBNKZ | Kanban Indicator | |||
128 | ![]() |
![]() |
KZKUP | KZKUP | Indicator: Co-Product | |||
129 | ![]() |
![]() |
AFPOS | CO_POSNR | Order item number | |||
130 | ![]() |
![]() |
NO_DISP | NO_DISP_PLUS | Effective for Materials Planning | |||
131 | ![]() |
![]() |
BDZTP | BDZTP | Time that reservation quantity required | |||
132 | ![]() |
![]() |
ESMNG | ESMNG | Usage quantity per order unit of measure | |||
133 | ![]() |
![]() |
ALPGR | CS_ALPGR | Alternative Item: Group | |||
134 | ![]() |
![]() |
ALPRF | CS_ALPRF | Alternative Item: Ranking Order | |||
135 | ![]() |
![]() |
ALPST | CS_ALPST | Alternative Item: Strategy | |||
136 | ![]() |
![]() |
KZAUS | AUSLF | Discontinuation type | |||
137 | ![]() |
![]() |
NFEAG | CS_NFEAG | Discontinuation Group | |||
138 | ![]() |
![]() |
NFPKZ | CS_KZNFP | Indicator: Follow-Up Item | |||
139 | ![]() |
![]() |
NFGRP | CS_NFGRP | Follow-Up Group | |||
140 | ![]() |
![]() |
NFUML | NFUML | NOT USED: Quantity transfer factor for follow-up material | |||
141 | ![]() |
![]() |
ADRNR | CADNR | Addresses: Address Number | |||
142 | ![]() |
![]() |
CHOBJ | CUOBJ_CH | Internal object number of the batch classification | |||
143 | ![]() |
![]() |
SPLKZ | CHSPLIT | Batch key | |||
144 | ![]() |
![]() |
SPLRV | RSPOS | Item Number of Reservation / Dependent Requirements | |||
145 | ![]() |
![]() |
KNUMH | KNUMH_CH | Number of condition record from batch determination | |||
146 | ![]() |
![]() |
WEMPF | WEMPF | Goods recipient | |||
147 | ![]() |
![]() |
ABLAD | ABLAD | Unloading Point | |||
148 | ![]() |
![]() |
HKMAT | HKMAT | Material-related origin | |||
149 | ![]() |
![]() |
HRKFT | HRKFT | Origin Group as Subdivision of Cost Element | |||
150 | ![]() |
![]() |
VORAB | VORABKZ | Ind: Preliminary order | |||
151 | ![]() |
![]() |
MATKL | MATKL | Material Group | |||
152 | ![]() |
![]() |
FRUNV | FRUNV | Indicator: External procurement data incomplete | |||
153 | ![]() |
![]() |
CLAKZ | CLAKZ | Indicator: classification exists | |||
154 | ![]() |
![]() |
INPOS | INPOS | Indicator: intra material | |||
155 | ![]() |
![]() |
WEBAZ | WEBAZ | Goods receipt processing time in days | |||
156 | ![]() |
![]() |
LIFNR | LIFNR | Account Number of Vendor or Creditor | |||
157 | ![]() |
![]() |
FLGEX | FLGEX | Indicator: External procurement | |||
158 | ![]() |
![]() |
FUNCT | CY_FUNCT | Distribution function | |||
159 | ![]() |
![]() |
GPREIS_2 | PPGXXX | Total Price in Local Currency | |||
160 | ![]() |
![]() |
FPREIS_2 | PPFXXX | Fixed price in local currency | |||
161 | ![]() |
![]() |
PEINH_2 | PEINH | Price unit | |||
162 | ![]() |
![]() |
INFNR | INFNR | Number of purchasing info record | |||
163 | ![]() |
![]() |
KZECH | KZECH | Determination of batch entry in the production/process order | |||
164 | ![]() |
![]() |
KZMPF | KZMPF | Manual Maintenance of Requirement Date | |||
165 | ![]() |
![]() |
STLAL | STALT | Alternative BOM | |||
166 | ![]() |
![]() |
PBDNR | PBDNR | Requirements Plan Number | |||
167 | ![]() |
![]() |
STVKN | STVKN | Inherited Node Number of BOM Item | |||
168 | ![]() |
![]() |
KTOMA | KTOMA | Acct entered manually | |||
169 | ![]() |
![]() |
VRPLA | VRPLA | Indicator: planning without final assembly | |||
170 | ![]() |
![]() |
KZBWS | KZBWS | Valuation of Special Stock | |||
171 | ![]() |
![]() |
NLFZV | CS_NLFZV | Lead-time offset for operation | |||
172 | ![]() |
![]() |
NLFMV | CS_NLFMV | Unit for lead-time offset for operation | |||
173 | ![]() |
![]() |
TECHS | TECHS | Parameter Variant/Standard Variant | |||
174 | ![]() |
![]() |
OBJTYPE | OCM_OBJ_TYPE | Change indicator | |||
175 | ![]() |
![]() |
CH_PROC | OCM_CH_PROC | Process that has lead to the change of an object | |||
176 | ![]() |
![]() |
FXPRU | CK_FIXPRKU | Fixed-Price Co-Product | |||
177 | ![]() |
![]() |
UMSOK | UMSOK | Special stock indicator for physical stock transfer | |||
178 | ![]() |
![]() |
VORAB_SM | VORAB_SM | Advance Shipment Indicator | |||
179 | ![]() |
![]() |
FIPOS | FIPOS | Commitment Item | |||
180 | ![]() |
![]() |
FIPEX | FM_FIPEX | Commitment item | |||
181 | ![]() |
![]() |
FISTL | FISTL | Funds Center | |||
182 | ![]() |
![]() |
GEBER | BP_GEBER | Fund | |||
183 | ![]() |
![]() |
GRANT_NBR | GM_GRANT_NBR | Grant | |||
184 | ![]() |
![]() |
FKBER | FKBER | Functional Area | |||
185 | ![]() |
![]() |
PRIO_URG | PRIO_URG | Requirement Urgency | |||
186 | ![]() |
![]() |
PRIO_REQ | PRIO_REQ | Requirement Priority | |||
187 | ![]() |
![]() |
KBLNR | KBLNR | Document Number for Earmarked Funds | |||
188 | ![]() |
![]() |
KBLPOS | KBLPOS | Earmarked Funds: Document Item | |||
189 | ![]() |
![]() |
BUDGET_PD | FM_BUDGET_PERIOD | FM: Budget Period | |||
190 | ![]() |
![]() |
SC_OBJECT_ID | /SRMERP/OBJECT_ID | Object ID - Document Number | |||
191 | ![]() |
![]() |
SC_ITM_NO | /SRMERP/SC_ITM_NO | Internal Shopping Cart Item Number | |||
192 | ![]() |
![]() |
ADVCODE | /ISDFPS/ADVCODE | Advice Code | |||
193 | ![]() |
![]() |
* | |||||
194 | ![]() |
![]() |
MANDT | MANDT | Client | |||
195 | ![]() |
![]() |
RSNUM | RSNUM | Number of reservation/dependent requirements | |||
196 | ![]() |
![]() |
RSPOS | RSPOS | Item Number of Reservation / Dependent Requirements | |||
197 | ![]() |
![]() |
RSART | RSART | Record type | |||
198 | ![]() |
![]() |
AFNAM | AFNAM | Name of requisitioner/requester | |||
199 | ![]() |
![]() |
BEDNR | BEDNR | Requirement Tracking Number | |||
200 | ![]() |
![]() |
KZFIX | CN_KZFIX | Indicator: Purchasing info record data are fixed | |||
201 | ![]() |
![]() |
KUNNR | EKUNNR | Customer | |||
202 | ![]() |
![]() |
EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
203 | ![]() |
![]() |
ADRN2 | AD_ADDRNUM | Address number | |||
204 | ![]() |
![]() |
KALNR | CK_KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | |||
205 | ![]() |
![]() |
KLVAR | CK_KLVAR | Costing Variant | |||
206 | ![]() |
![]() |
WKURS | WKURS | Exchange Rate | |||
207 | ![]() |
![]() |
RSCOMP | RSCOMP | Spare Part Indicator | |||
208 | ![]() |
![]() |
MFLIC | CN_MFLIC | Procurement indicator | |||
209 | ![]() |
![]() |
FPLNR | FPLNR | Billing plan number / invoicing plan number | |||
210 | ![]() |
![]() |
FLIEF | FLIEF | Fixed vendor | |||
211 | ![]() |
![]() |
BSTLN | STNUM | Bill of Material | |||
212 | ![]() |
![]() |
BSTLT | STLTY | BOM Category | |||
213 | ![]() |
![]() |
STKAN | STKAN | Edge in the exploded BOM tree | |||
214 | ![]() |
![]() |
GUID | SYSUUID_22 | UUID in compressed form (22 character UUENCODEd) | |||
215 | ![]() |
![]() |
GUID_16 | GUID_16 | GUID in 'RAW' format | |||
216 | ![]() |
![]() |
EKORG | EKORG | Purchasing organization | |||
217 | ![]() |
![]() |
SOBSL | SOBSL | Special procurement type | |||
218 | ![]() |
![]() |
STRECKE | STRECKE | Ind.: Third-party requisition | |||
219 | ![]() |
![]() |
CREADAT | ERDAT | Date on which the record was created | |||
220 | ![]() |
![]() |
CREABY | ERNAM | Name of Person who Created the Object | |||
221 | ![]() |
![]() |
PPE_EXTERN_KEY | CHAR63 | Char63 | |||
222 | ![]() |
![]() |
CHANGEBY | AENAM | Name of Person Who Changed Object | |||
223 | ![]() |
![]() |
CHANGEDAT | AEDAT | Last Changed On | |||
224 | ![]() |
![]() |
BRTDATE | BRUTR | Fixed key date | |||
225 | ![]() |
![]() |
IDNLF | IDNLF | Material Number Used by Vendor | |||
226 | ![]() |
![]() |
MFRPN | MFRPN | Manufacturer Part Number | |||
227 | ![]() |
![]() |
MFRNR | MFRNR | Manufacturer number | |||
228 | ![]() |
![]() |
CATALOGID | KATALOGID | Identification of Web Service | |||
229 | ![]() |
![]() |
CATALOG_PROD_ID | CATALOG_PROD_ID | Product ID in Catalog | |||
230 | ![]() |
![]() |
MCN33 | CHAR1 | Single-Character Flag | |||
Maintenance Status
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 | 46C |