CYDETALL SAP (Fields used for generating the detailed list) Structure details
Dictionary Type: Structure
Description: Fields used for generating the detailed list
Description: Fields used for generating the detailed list
Structure field list including key, data, relationships and ABAP select examples
CYDETALL 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 "Fields used for generating the detailed list" 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_CYDETALL TYPE CYDETALL.
The CYDETALL table consists of various fields, each holding specific information or linking keys about Fields used for generating the detailed list data available in SAP. These include BEDID (ID of the capacity requirements record), BEDZL (Internal counter), CANUM (Capacity allocation number), HARBID (Work center ID).. 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 CYDETALL 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 | Assigned to domain | MANDT | |||
| BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
| BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| CANUM | Capacity allocation number | CR_CAPNUM | NUMC | 4 | NUM4 | ||||
| HARBID | Work center ID | ARBPLATZ | NUMC | 8 | NUM08 | ||||
| ARBID | Work center ID | ARBPLATZ | NUMC | 8 | NUM08 | ||||
| TYPKZ | Category of object causing the load (order category) | TYPKZ | CHAR | 1 | TYPKZ | ||||
| HKAPID | Superior capacity in a work center hierarchy | HKAPID | NUMC | 8 | Assigned to domain | KAPID | |||
| KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | CR_VERTL | |||
| OBSTA | Object status (order status) | OBSTA | CHAR | 22 | Assigned to domain | J_OBJNR | |||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
| PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | Assigned to domain | PLSCN | PLS | ||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | 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 | ||
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
| PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
| NAME1 | Name of the customer for the customer order | CY_NAME1 | CHAR | 35 | NAME | ||||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
| STEUS | Control key | STEUS | CHAR | 4 | Assigned to domain | STEUS | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| LTXA1 | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
| LOART | Wage Type | LOHNART | CHAR | 4 | LOART | ||||
| MGVRG | Operation Quantity | MGVRG | QUAN | 13(3) | MENG13 | ||||
| MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| RFGRP | Setup group category | RUEFAGRP | CHAR | 10 | Assigned to domain | RUEFAGRP | |||
| RFSCH | Setup group key | RUEFASCHLU | CHAR | 10 | Assigned to domain | RUEFASCHLU | |||
| RASCH | Setup Type Key | RUEARSCHLU | CHAR | 2 | Assigned to domain | RUEARSCHLU | |||
| ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
| ARBEH | Unit for work | ARBEITE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
| DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| EWDAN | Normal duration (from forecast) of activity | EWDAN | QUAN | 5(1) | DAUER_4_1 | ||||
| EWDNE | Unit for forecast normal duration | EWDNE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
| ASVRG | Operation scrap | ASVRG | QUAN | 13(3) | MENG13 | ||||
| ISMNW | Actual work | ISMNW | QUAN | 7(1) | ARBEIT | ||||
| LMNGA | Total Yield Confirmed | LMNGA | QUAN | 13(3) | MENG13 | ||||
| QUALF | Suitability | QUALF | CHAR | 2 | Assigned to domain | QUALF | |||
| LOGRP | Wage group | LOHNGRP | CHAR | 3 | Assigned to domain | LOHNGRP | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| NPRIO | Priority | NW_PRIO | CHAR | 1 | Assigned to domain | NW_PRIO | |||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
| TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
| FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
| FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
| 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 | ||||
| FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
| FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
| FSSLD | Earliest scheduled start: Wait (date) | FSSLD | DATS | 8 | DATUM | ||||
| FSSLZ | Earliest scheduled start: Wait (time) | FSSLZ | TIMS | 6 | ATIME | ||||
| FSELD | Earliest scheduled finish: Wait (date) | FSELD | DATS | 8 | DATUM | ||||
| FSELZ | Earliest scheduled finish: Wait (time) | FSELZ | TIMS | 6 | ATIME | ||||
| SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
| SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | 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 | ||||
| SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
| SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
| SSSLD | Latest scheduled start: Wait time (date) | SSSLD | DATS | 8 | DATUM | ||||
| SSSLZ | Latest scheduled start: Wait time | SSSLZ | TIMS | 6 | ATIME | ||||
| SSELD | Latest scheduled finish: Wait time (date) | SSELD | DATS | 8 | DATUM | ||||
| SSELZ | Latest scheduled finish: Wait time | SSELZ | TIMS | 6 | ATIME | ||||
| 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 | |||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| PROJN | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
| PRONR | Project definition | PS_PSP_PRO | NUMC | 8 | Assigned to domain | KONPD | PS_PSPNR | ||
| WARTZ | Queue time used for scheduling | WARTEZEIT | FLTP | 16(16) | CX_ZEIT | ||||
| WRTZE | Unit of measure for queue time | WTRZE | UNIT | 3 | CUNIT | EINHEIT | |||
| RUEST | Setup time | RUEST | FLTP | 16(16) | CX_ZEIT | ||||
| RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
| BEARZ | Processing time | BEARZEIT | FLTP | 16(16) | CX_ZEIT | ||||
| BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
| ABRUE | Teardown | ABRUE | FLTP | 16(16) | CX_ZEIT | ||||
| ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
| LIEGZ | Wait time used for scheduling | LIEGEZEIT | FLTP | 16(16) | CX_ZEIT | ||||
| LIGZE | Unit of measure for wait time | LIGZE | UNIT | 3 | CUNIT | EINHEIT | |||
| TRANZ | Move time used for scheduling | TRANSZEIT | FLTP | 16(16) | CX_ZEIT | ||||
| TRAZE | Unit of measure for move time | TRAZE | UNIT | 3 | CUNIT | EINHEIT | |||
| AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
| PLSVB | To lot size | LOSGRBIS | QUAN | 13(3) | MENG13 | ||||
| PLSVN | From Lot Size | LOSGRVON | QUAN | 13(3) | MENG13 | ||||
| PLNME | Task list unit of measure | PLNME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| AUF_OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
| GSTRP | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
| FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
| GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
| GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
| GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
| GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
| FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
| FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
| GAMNG | Total order quantity | GAMNG | QUAN | 13(3) | MENG13 | ||||
| GMEIN | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| APRIO | Order priority | CO_APRIO | CHAR | 1 | CHAR1 | ||||
| REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | REDKZ | ||||
| IGMNG | Yield confirmed from order confirmation | CO_IGMNG | QUAN | 13(3) | MENG13 | ||||
| PLNBEZ | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| PLNAW | Application of the task list | PLNAW | CHAR | 1 | Assigned to domain | PLNAW | |||
| PVERW | Task list usage | PLN_VERWE | CHAR | 3 | Assigned to domain | PLN_VERWE | H_T411 | ||
| PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
| STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
| DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | Assigned to domain | DISPO | DGR | ||
| FEVOR | Production Supervisor | FEVOR | CHAR | 3 | Assigned to domain | FEVOR | CFV | ||
| AUART | Order Type | AUFART | CHAR | 4 | Assigned to domain | AUFART | AAT | ||
| AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
| KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| CCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
| KOSTV | Responsible cost center | AUFKOSTV | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
| PDAT1 | Planned release date | AUFPDAT1 | DATS | 8 | DATUM | ||||
| PDAT2 | Planned completion date | AUFPDAT2 | DATS | 8 | DATUM | ||||
| PDAT3 | Planned closing date | AUFPDAT3 | DATS | 8 | DATUM | ||||
| IDAT1 | Release date | AUFIDAT1 | DATS | 8 | DATUM | ||||
| IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
| IDAT3 | Close date | AUFIDAT3 | DATS | 8 | DATUM | ||||
| ABKRS | Processing group | AUFABKRS | NUMC | 2 | Assigned to domain | AKREIS | AKR | ||
| KOSTL | Cost center for basic settlement | AUFKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| PLWRK | Planning Plant | PLWRK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
| PWWRK | Production plant in planned order | PWWRK | CHAR | 4 | Assigned to domain | WERKS | |||
| PAART | Order type | PAART | CHAR | 4 | PAART | ||||
| AUFFX | Firming indicator for planned order data | PLAFX | CHAR | 1 | XFELD | ||||
| BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
| PSTTR | Order start date in planned order | PSTTR | DATS | 8 | DATUM | ||||
| PEDTR | Order finish date in the planned order | PEDTR | DATS | 8 | DATUM | ||||
| GSMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| PALTR | Explosion date | PALTR | DATS | 8 | DATUM | ||||
| POOLK | Indicator for pooled capacity | KAP_KZPOOL | CHAR | 1 | XFELD | ||||
| PERIOD | Planning period considered (capacity planning) | KAPER | CHAR | 10 | CHAR10 | ||||
| BEDARF | Scheduled capacity requirements | KPSOL | FLTP | 16(16) | KAPBED | ||||
| ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
| ARBPLTEXT | Text describing work center in more detail | ARBPLTEXT | CHAR | 40 | TEXT40 | ||||
| VRG_ARBPL | Work center of the operation | VRG_ARBPL | CHAR | 8 | ARBPL | AGR | |||
| VRG_ARBPLT | Work center text of sub-operation | VRG_ARBPLT | CHAR | 40 | TEXT40 | ||||
| KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
| KAPARTEXT | Capacity short text | KAPTEXT | CHAR | 40 | TEXT40 | ||||
| STATUS | Text of order status | STATUS_TXT | CHAR | 4 | STATUS_TXT | ||||
| STATUV | Text for the status of an operation or a network activity | STATUV_TXT | CHAR | 4 | STATUV_TXT | ||||
| MATTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
| MATNR | Material in planned order | CYMATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
| MATNRALG | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| LIEINH | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| ANGEB | Quantity field | MENGEP | DEC | 14(3) | MENGEP | ||||
| LIEINHA | Unit of of measure for displaying capacity requirements | CY_KEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| PERIODINT | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
| BED_VERUR | Pegged requirements (work- or planned order) as type char. | BED_VERUR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
| BED_MENGE | Order quantity displayed in a list | BED_GSMNG | QUAN | 13(3) | MENG13 | ||||
| BED_EINH | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| STTXT | System Status | CO_STTXT | CHAR | 40 | CHAR40 | ||||
| AWTXT | User status set at order level | CY_AWTXT | CHAR | 40 | CHAR40 | ||||
| AWVST | User status set at operation level | CY_AWVTXT | CHAR | 40 | CHAR40 | ||||
| USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
| USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
| USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
| USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
| USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
| USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
| USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
| USE06 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
| USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
| USE07 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
| USR08 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
| USR09 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
| USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
| USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
| VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
| POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER |
| Key field | Non-key field |
How do I retrieve data from SAP structure CYDETALL using ABAP code?
As CYDETALL 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 CYDETALL as there is no data to select.How to access SAP table CYDETALL
Within an ECC or HANA version of SAP you can also view further information about CYDETALL 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