CATS_APPR_PERSP SAP (Approval Views) Table details
Dictionary Type: Table
Description: Approval Views
Description: Approval Views
ABAP Code to SELECT data from CATS_APPR_PERSP
Related tables to CATS_APPR_PERSP
Access table CATS_APPR_PERSP
Related tables to CATS_APPR_PERSP
Access table CATS_APPR_PERSP
Table field list including key, data, relationships and ABAP select examples
CATS_APPR_PERSP is a standard SAP Table which is used to store Approval Views data and is available within R/3 SAP systems depending on the version and release level.
The CATS_APPR_PERSP table consists of various fields, each holding specific information or linking keys about Approval Views data available in SAP. These include PERSPECTIVE_ID (View for Approval of Time Sheet Data), PERIOD_TYPE (Period Type), START_DAY (First Day of Period), CONS_FIELD1 (Field Name of Criterion for Collective Approval).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = CATS_APPR_PERSPT
SAP CATS_APPR_PERSP table 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 | |||
| PERSPECTIVE_ID | View for Approval of Time Sheet Data | MSS_CAT_APPR_PERSPECTIVE | CHAR | 8 | MSS_CAT_APPR_PERSPECTIVE | ||||
| PERIOD_TYPE | Period Type | HRMSS_CAT_APPR_PERTYPE | INT1 | 3 | HRMSS_CAT_APPR_PERTYPE | ||||
| START_DAY | First Day of Period | HRMSS_CAT_APPR_FIRST_DAY | NUMC | 1 | HRMSS_CAT_APPR_FIRST_DAY | ||||
| CONS_FIELD1 | Field Name of Criterion for Collective Approval | HRMSS_CAT_APPR_CRIT_NAME | CHAR | 60 | HRMSS_CAT_APPR_CRIT_NAME | ||||
| CONS_DESCR1 | Column with Description of Collective Approval Criterion | HRMSS_CATS_APPR_CRIT_DESCR_COL | CHAR | 1 | XFELD | ||||
| CONS_FIELD2 | Field Name of Criterion for Collective Approval | HRMSS_CAT_APPR_CRIT_NAME | CHAR | 60 | HRMSS_CAT_APPR_CRIT_NAME | ||||
| CONS_DESCR2 | Column with Description of Collective Approval Criterion | HRMSS_CATS_APPR_CRIT_DESCR_COL | CHAR | 1 | XFELD | ||||
| CONS_FIELD3 | Field Name of Criterion for Collective Approval | HRMSS_CAT_APPR_CRIT_NAME | CHAR | 60 | HRMSS_CAT_APPR_CRIT_NAME | ||||
| CONS_DESCR3 | Column with Description of Collective Approval Criterion | HRMSS_CATS_APPR_CRIT_DESCR_COL | CHAR | 1 | XFELD | ||||
| FIELDSEL_DETAIL | Field Selection for Approval of Time Sheet Data | HRMSS_CAT_APPR_FIELDSEL | CHAR | 7 | SYCHAR07 | ||||
| FIELDSEL_SINGLE | Field Selection for Approval of Time Sheet Data | HRMSS_CAT_APPR_FIELDSEL | CHAR | 7 | SYCHAR07 |
| Key field | Non-key field |
How do I retrieve data from SAP table CATS_APPR_PERSP using ABAP code
The following ABAP code Example will allow you to do a basic selection on CATS_APPR_PERSP to SELECT all data from the tableDATA: WA_CATS_APPR_PERSP TYPE CATS_APPR_PERSP.
SELECT SINGLE *
FROM CATS_APPR_PERSP
INTO CORRESPONDING FIELDS OF WA_CATS_APPR_PERSP
WHERE...
How to access SAP table CATS_APPR_PERSP
Within an ECC or HANA version of SAP you can also view further information about CATS_APPR_PERSP 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