IOOPCAP SAP (Database structure for capacities - order operations) Structure details
Dictionary Type: Structure
Description: Database structure for capacities - order operations
Description: Database structure for capacities - order operations
Structure field list including key, data, relationships and ABAP select examples
IOOPCAP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Database structure for capacities - order operations" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_IOOPCAP TYPE IOOPCAP.
The IOOPCAP table consists of various fields, each holding specific information or linking keys about Database structure for capacities - order operations data available in SAP. These include MANDT (Client), BEDID (ID of the capacity requirements record), BEDZL (Internal counter), CANUM (Counters for cap. rqmts. records (various caps. + indiv.caps).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP IOOPCAP structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | KBKO | BEDID | |||
| BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| CANUM | Counters for cap. rqmts. records (various caps. + indiv.caps | CY_COUNT | NUMC | 4 | Assigned to domain | CY_COUNT | |||
| ARBID | Work center ID | ARBPLATZ | NUMC | 8 | NUM08 | ||||
| TYPKZ | Category of object causing the load (order category) | TYPKZ | CHAR | 1 | TYPKZ | ||||
| OBJKZ | Indicator: Remaining split record | OBJKZ | CHAR | 1 | OBJKZ | ||||
| KAPID | Capacity ID | KAPID | NUMC | 8 | KAKO | KAPID | |||
| BEDKZ | Indicator: Remaining split record | BEDKZ | CHAR | 1 | X | ||||
| KRUESOLL | Scheduled cap. requirements for the op. segment 'setup' | CY_KRUESOL | FLTP | 16(16) | KAPBED | ||||
| KRUEREST | Remaining capacity rqmts. for operation segment 'Setup' | CY_KRUERES | FLTP | 16(16) | KAPBED | ||||
| KBEASOLL | Scheduled cap. requirements for the op. segment 'processing' | CY_KBEASOL | FLTP | 16(16) | KAPBED | ||||
| KBEAREST | Remaining capacity rqmts.for operation segment 'Processing' | CY_KBEARES | FLTP | 16(16) | KAPBED | ||||
| KABRSOLL | Scheduled cap. requirements for the op. segment teardown | CY_KABRSOL | FLTP | 16(16) | KAPBED | ||||
| KABRREST | Remaining capacity requirements for op. segment 'tear down' | CY_KABRRES | FLTP | 16(16) | KAPBED | ||||
| KEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| FSTAD | Earliest start / date | FSTAD | DATS | 8 | DATUM | ||||
| FSTAU | Earliest start / time | FSTAU | TIMS | 6 | T | ||||
| FENDD | Earliest finish /date | FENDD | DATS | 8 | DATUM | ||||
| FENDU | Earliest finish /time | FENDU | TIMS | 6 | T | ||||
| SSTAD | Latest start / date | SSTAD | DATS | 8 | DATUM | ||||
| SSTAU | Latest start / time | SSTAU | TIMS | 6 | T | ||||
| SENDD | Latest finish / date | SENDD | DATS | 8 | DATUM | ||||
| SENDU | Latest finish / time | SENDU | TIMS | 6 | T | ||||
| ISTAD | Actual start / date | ISTAD | DATS | 8 | DATUM | ||||
| ISTAU | Actual start / time | ISTAU | TIMS | 6 | T | ||||
| IENDD | Actual finish / date | IENDD | DATS | 8 | DATUM | ||||
| IENDU | Actual finish / time | IENDU | TIMS | 6 | T | ||||
| PENDD | Forecast finish / date | PENDD | DATS | 8 | DATUM | ||||
| PENDU | Forecast finish / time | PENDU | TIMS | 6 | T | ||||
| ISPLI | Actual number of splits | ISPLI | DEC | 3 | SPLITTANZ | ||||
| KPVER | Distribution of capacity requirements (Planned/prod.order) | CR_VERTL | CHAR | 8 | TC29 | CR_VERTL | |||
| OBSTA | Object status (order status) | OBSTA | CHAR | 22 | ONR00 | J_OBJNR | |||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
| APLZL | General counter for order | CO_APLZL | NUMC | 8 | AFVC | CO_APLZL | |||
| PLNUM | Planned order number | PLNUM | CHAR | 10 | PLAF | ALPHA | PLNUM | PAF | |
| PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
| ZAEHF | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
| ZAEHP | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| SPLKN | Number of the task list node of the sub-operation | SPLNKN | NUMC | 8 | KNTNR | ||||
| SZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| SAFNR | SOP order number | SAFNR | CHAR | 10 | SAFNR | ||||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
| CANUMF | Counter for the main capacity requirements record | CANUMF | NUMC | 4 | NUM4 | ||||
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
| KBSTA | Status of a capacity requirements (object number) | CY_KBSTA | CHAR | 22 | ONR00 | J_OBJNR | |||
| FSSBD | Earliest scheduled start: Processing (date) | FSSBD | DATS | 8 | DATUM | ||||
| FSSBZ | Earliest scheduled start: Processing (time) | FSSBZ | TIMS | 6 | ATIME | ||||
| FSSAD | Earliest scheduled start: Teardown (date) | FSSAD | DATS | 8 | DATUM | ||||
| FSSAZ | Earliest scheduled start: Teardown (time) | FSSAZ | TIMS | 6 | ATIME | ||||
| SSSBD | Latest scheduled start: Processing (date) | SSSBD | DATS | 8 | DATUM | ||||
| SSSBZ | Latest scheduled start: Processing (time) | SSSBZ | TIMS | 6 | ATIME | ||||
| SSSAD | Latest scheduled start: Teardown (date) | SSSAD | DATS | 8 | DATUM | ||||
| SSSAZ | Latest scheduled start: Teardown (time) | SSSAZ | TIMS | 6 | ATIME | ||||
| MGVRG | Operation Quantity | MGVRG | QUAN | 13(3) | MENG13 | ||||
| MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| RSTUF | Reduction level which reduces operation lead time | RSTUF | NUMC | 1 | REDST | ||||
| PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | PLSC | PLSCN | PLS | ||
| BSTKZ | Indicator rqmts.record is confirmed (cap.availability check) | CY_BSTKZ | CHAR | 1 | CY_BSTKZ | ||||
| BEDZLF | BEDZL of Main Operation (for Phases and Their Main Ops) | BEDZLF | NUMC | 8 | CIM_COUNT | ||||
| PHASE_KZ | Indicator: Phase | PHASE_KZ | CHAR | 1 | PHASE_KZ | ||||
| MAXBD_KZ | Indicator: Capacity fully committed | MAXBD_KZ | CHAR | 1 | XFELD | ||||
| ANZMA | Number of employees | ANZMS | DEC | 5(2) | ANZMA | ||||
| VGW01 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE01 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VGW02 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE02 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VGW03 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE03 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VGW04 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE04 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VGW05 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE05 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VGW06 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
| VGE06 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
| USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
| USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
| USE05 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
| LEK01 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| LEK02 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| LEK03 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| LEK04 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| LEK05 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| LEK06 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
| BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
| ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
| ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
| ARBEH | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| LEKNW | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
| ASVRG | Operation scrap | ASVRG | QUAN | 13(3) | MENG13 | ||||
| UMREN | Denominator for converting rtg and op units of measure | CP_UMREN | DEC | 5 | UMBSN | ||||
| UMREZ | Numerator for converting task list and oper. un. of measure | CP_UMREZ | DEC | 5 | UMBSZ | ||||
| BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | ||||
| LMNGA | Total Yield Confirmed | LMNGA | QUAN | 13(3) | MENG13 | ||||
| XMNGA | Total scrap quantity confirmed | XMNGA | QUAN | 13(3) | MENG13 | ||||
| ISMNW | Actual work | CO_ISMNW | QUAN | 13(3) | MENG13 | ||||
| ISM01 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISM02 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISM03 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISM04 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISM05 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISM06 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
| ISERH | Confirmed break time | ISERH | QUAN | 9(3) | VGWRT | ||||
| ZEIER | Unit for the break time | DZEIER | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
| ISDZ | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
| IERD | Actual finish: Setup (date) | IERD | DATS | 8 | DATUM | ||||
| IERZ | Actual finish: Setup (time) | IERZ | TIMS | 6 | ATIME | ||||
| ISBD | Actual start: Processing (date) | ISBD | DATS | 8 | DATUM | ||||
| ISBZ | Actual start: Processing (time) | ISBZ | TIMS | 6 | ATIME | ||||
| IEBD | Actual finish: Processing (date) | IEBD | DATS | 8 | DATUM | ||||
| IEBZ | Actual processing finish (time) | IEBZ | TIMS | 6 | ATIME | ||||
| ISAD | Actual start: Teardown (date) | ISAD | DATS | 8 | DATUM | ||||
| ISAZ | Actual start: Teardown (time) | ISAZ | TIMS | 6 | ATIME | ||||
| IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
| IEDZ | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
| PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
| PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
| OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
| OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
| PDAU | Forecasted duration of activity from confirmation | PDAU | QUAN | 5(1) | DAUER_4_1 | ||||
| PDAE | Unit of the forecasted duration from the confirmation | PDAE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
| DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PER_EX | Entry in KPER exists for this split | CY_PEREX | CHAR | 1 | KREUZ | ||||
| DELTA_ST | Time Difference Between Start Capacity and Individ. Capacity | CY_DELTAST | QUAN | 13(3) | MENGV13 | ||||
| DELTA_EN | Time Difference Between Fin. Capacity and Individ. Capacity | CY_DELTAEN | QUAN | 13(3) | MENGV13 | ||||
| AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
| ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
| LTXA1 | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
| LTXA2 | Second line of the description | LTXA2 | CHAR | 40 | TEXT40 | ||||
| KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
| BEDSOLL | Capacity requirements scheduled for the operation/activity | CY_KBEDSOL | QUAN | 7(2) | CY_KBED_P | ||||
| KEHSOLL | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| UELSOLL | Capacity requirements greater (field overflow) | CY_UEBERL | CHAR | 1 | XFELD | ||||
| BEDREST | Remaining capacity requirements scheduled for operation | CY_KBEDRES | QUAN | 7(2) | CY_KBED_P | ||||
| KEHREST | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| UELREST | Capacity requirements greater (field overflow) | CY_UEBERL | CHAR | 1 | XFELD | ||||
| BREAKS | Indicator: Scheduling allowing for breaks | BREAKS | CHAR | 1 | XFELD | ||||
| ERR_MASK | Error mask | ERR_MASK | CHAR | 5 | ERR_MASK | ||||
| FLG_SEL | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
| INDBT | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
| BEDIDORG | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
| BEDZLORG | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| CANUMORG | Counters for cap. rqmts. records (various caps. + indiv.caps | CY_COUNT | NUMC | 4 | Assigned to domain | CY_COUNT | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| KTEXT | Capacity short text | KAPTEXT | CHAR | 40 | TEXT40 | ||||
| KZ_MARK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| INDEX_NODE | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX |
| Key field | Non-key field |
How do I retrieve data from SAP structure IOOPCAP using ABAP code?
As IOOPCAP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on IOOPCAP as there is no data to select.How to access SAP table IOOPCAP
Within an ECC or HANA version of SAP you can also view further information about IOOPCAP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects