DB2CPYTSP SAP (DB2/390: COPY parameters) Structure details
Description: DB2/390: COPY parameters
Structure field list including key, data, relationships and ABAP select examples
DB2CPYTSP 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 "DB2/390: COPY parameters" 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_DB2CPYTSP TYPE DB2CPYTSP.
The DB2CPYTSP table consists of various fields, each holding specific information or linking keys about DB2/390: COPY parameters data available in SAP. These include DBNAME (Name of the database the tablespace belongs to), DSNUM (Partition or data set that is to be copied), FULLCOPY (Specifies if either a full or an incremental copy is taken), CHGLIMIT (CHANGELIMIT option of COPY utility).. 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: Not classified
SAP DB2CPYTSP 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 |
| TSNAME | Table space that is to be copied | DB2CPYTS | CHAR | 8 | DB2TSNAME | ||||
| DBNAME | Name of the database the tablespace belongs to | DB2CPYDB | CHAR | 8 | DB2DBNAME | ||||
| DSNUM | Partition or data set that is to be copied | DB2CPYDS | CHAR | 3 | CHAR3 | ||||
| FULLCOPY | Specifies if either a full or an incremental copy is taken | DB2CPYFULL | CHAR | 3 | DB2YESNO | ||||
| CHGLIMIT | CHANGELIMIT option of COPY utility | DB2CPYCHG | CHAR | 3 | DB2YESNO | ||||
| CHGLIMIT1 | First value in the CHANGELIMIT range | DB2CPYCL1 | CHAR | 3 | DB2PCTC | ||||
| CHGLIMIT2 | Second value in the CHANGELIMIT range | DB2CPYCL2 | CHAR | 3 | DB2PCTC | ||||
| REPORTONLY | Specifies that image copy information is only displayed | DB2CPYREPO | CHAR | 1 | DB2YNFLAG | ||||
| SHRLEVEL | COPY share level | DB2CPYSHR | CHAR | 10 | DB2SHRLVL | ||||
| COPYDSN1 | Dataset allocated to the SYSCOPY DDNAME | DB2CP1DSN | CHAR | 54 | DB2DDN | ||||
| COPYDEVT1 | Device on which the SYSCOPY dataset resides | DB2CP1DEVT | CHAR | 8 | DB2DEVT | ||||
| COPYSPACE1 | Primary space allocation for the SYSCOPY dataset (cyl.) | DB2CP1SPC | INT2 | 5 | DB2DDPQTYC | ||||
| COPYDSN2 | Dataset allocated to the SYSCOPY2 DDNAME | DB2CP2DSN | CHAR | 54 | DB2DDN | ||||
| COPYDEVT2 | Device on which the SYSCOPY2 dataset resides | DB2CP2DEVT | CHAR | 8 | DB2DEVT | ||||
| COPYSPACE2 | Primary space allocation for the SYSCOPY2 dataset (cyl.) | DB2CP2SPC | INT2 | 5 | DB2DDPQTYC | ||||
| RCPYDSN1 | Dataset allocated to the SYSRCPY1 DDNAME | DB2RC1DSN | CHAR | 54 | DB2DDN | ||||
| RCPYDEVT1 | Device on which the SYSRCPY1 dataset resides | DB2RC1DEVT | CHAR | 8 | DB2DEVT | ||||
| RCPYSPACE1 | Primary space allocation for the SYSRCPY1 dataset (cyl.) | DB2RC1SPC | INT2 | 5 | DB2DDPQTYC | ||||
| RCPYDSN2 | Dataset allocated to the SYSRCPY2 DDNAME | DB2RC2DSN | CHAR | 54 | DB2DDN | ||||
| RCPYDEVT2 | Device on which the SYSRCPY2 dataset resides | DB2RC2DEVT | CHAR | 8 | DB2DEVT | ||||
| RCPYSPACE2 | Primary space allocation for the SYSRCPY2 dataset (cyl.) | DB2RC2SPC | INT2 | 5 | DB2DDPQTYC | ||||
| RESTART | Whether & at which point a current utility job is restarted | DB2RESTART | CHAR | 8 | DB2RESTART | ||||
| RETCODE | Return code of the utility | DB2UTILRC | INT4 | 10 |
| Key field | Non-key field |
How do I retrieve data from SAP structure DB2CPYTSP using ABAP code?
As DB2CPYTSP 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 DB2CPYTSP as there is no data to select.How to access SAP table DB2CPYTSP
Within an ECC or HANA version of SAP you can also view further information about DB2CPYTSP 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