HRMSS_CAT_APPR_CATSDB_EXT SAP (CATS Approval: CATSDB Fields for Display) Structure details
Description: CATS Approval: CATSDB Fields for Display
Related tables to HRMSS_CAT_APPR_CATSDB_EXT
Access table HRMSS_CAT_APPR_CATSDB_EXT
Structure field list including key, data, relationships and ABAP select examples
HRMSS_CAT_APPR_CATSDB_EXT 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 "CATS Approval: CATSDB Fields for Display" 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_HRMSS_CAT_APPR_CATSDB_EXT TYPE HRMSS_CAT_APPR_CATSDB_EXT.
The HRMSS_CAT_APPR_CATSDB_EXT table consists of various fields, each holding specific information or linking keys about CATS Approval: CATSDB Fields for Display data available in SAP. These include PERNR (Personnel Number), SKOSTL (Sender Cost Center), LSTAR (Activity Type), SEBELN (Sending purchase order).. 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 HRMSS_CAT_APPR_CATSDB_EXT 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 |
COUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
SEBELN | Sending purchase order | SEBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
SEBELP | Sending purchase order item | SEBELP | NUMC | 5 | Assigned to domain | EBELP | |||
SPRZNR | Sender Business Process | SPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
LSTNR | Activity Number | ASNUM | CHAR | 18 | Assigned to domain | ALPHA | ASNUM | ASN | |
RKOSTL | Receiver Cost Center | EKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
RAUFNR | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RNPLNR | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
RKDAUF | Receiver sales order | EKDAU | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
RKDPOS | Item number in receiver sales order | EKDPO | NUMC | 6 | Assigned to domain | POSNR | |||
RKSTR | Receiver cost object | EKSTR | CHAR | 12 | Assigned to domain | KSTRG | |||
RPRZNR | Receiver business process | EPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
FUND | Receiver fund | FM_EFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | RECEIVER_FUND | ||
FUNC_AREA | Receiving Functional Area | EFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
GRANT_NBR | Receiver Grant | GM_GRANT_RECEIVER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
S_FUND | Sender fund | FM_SFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | SENDER_FUND | ||
S_FUNC_AREA | Sending Functional Area | SFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
S_GRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
AWART | Attendance or Absence Type | AWART | CHAR | 4 | Assigned to domain | AWART | |||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
WABLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
VERSL | Overtime Compensation Type | VRSCH | CHAR | 1 | T555R | VRSCH | |||
WTART | Tax area work center | HRWRKAR | CHAR | 4 | HRWRKAR | ||||
BWGRL | Valuation basis | CATSBWGRL | CURR | 13(2) | WERTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFKZ | Extra Pay Indicator | AUFKN | CHAR | 1 | AUFKN | ||||
TRFGR | Pay Scale Group | TRFGR | CHAR | 8 | Assigned to domain | TRFGR | |||
TRFST | Pay Scale Level | TRFST | CHAR | 2 | Assigned to domain | TRFST | |||
PRAKN | Premium Number | PRAKN | CHAR | 2 | Assigned to domain | PRAKN | |||
PRAKZ | Premium Indicator | PRAKZ | NUMC | 4 | PRAKZ | ||||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
PLANS | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
TCURR | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
PRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
HRCOSTASG | Cost Accounting Variants | CATSHRCO | CHAR | 1 | CATSHRCO | ||||
HRKOSTL | Cost Center | CATSHRKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
HRLSTAR | Activity Type | CATSHRLSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART | |
HRFUND | Master Fund | CATSHRFUND | CHAR | 10 | Assigned to domain | BP_GEBER | |||
HRFUNC_AREA | Master Functional Area | CATSHRFUNC_AREA | CHAR | 16 | Assigned to domain | FKBER | |||
HRGRANT_NBR | Master Grant | CATSHRGRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
STATKEYFIG | Statistical key figure | STAGR | CHAR | 6 | Assigned to domain | STAGR | STA | ||
CPR_EXTID | External Project ID | CATS_CPR_EXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPR_OBJGEXTID | CHAR | 24 | CHAR24 | ||||
TASKTYPE | Task Type | CATSTASKTYPE | CHAR | 4 | CATSTASKTYPE | ||||
TASKLEVEL | Task Level | CATSTASKLEVEL | CHAR | 8 | CATSTASKLEVEL | ||||
TASKCOMPONENT | Task component | CATSTASKCOMPONENT | CHAR | 8 | CATSTASKCOMPONENT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ERSDA | Created on | CATS_ERSDA | DATS | 8 | DATUM | ||||
ERSTM | Time of Entry | CATS_CPUTM | TIMS | 6 | UZEIT | ||||
ERNAM | User Who Created Data Record | CATS_ERNAM | CHAR | 12 | USNAM | ||||
LAEDA | Date of Last Change | CATS_LAEDA | DATS | 8 | DATUM | ||||
LAETM | Time of Last Change | CATS_LAETM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
APNAM | Name of person who approved data | CATSAPNAM | CHAR | 12 | UNAME | ||||
APDAT | Date of Approval | CATSAPDAT | DATS | 8 | DATUM | ||||
WORKITEMID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
STATUS | Processing status | CATSSTATUS | CHAR | 2 | CATSSTATUS | ||||
REFCOUNTER | Reference Counter for Record to be Changed | CATSREFCOU | CHAR | 12 | CHAR12 | ||||
BELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
EXTSYSTEM | Logical system of source document | HR_AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EXTAPPLICATION | External Application | HR_AWTYP | CHAR | 5 | HR_AWTYP | ||||
EXTDOCUMENTNO | Document number | HR_AWKEY | CHAR | 20 | AWKEY | ||||
TASKCOUNTER | CATS: Task Counter | CATSTASKCOUNTER | CHAR | 10 | ALPHA | BELNR | |||
BEGUZ | Start time | CATSBEGUZ | TIMS | 6 | UZEIT | ||||
ENDUZ | End time | CATSENDUZ | TIMS | 6 | UZEIT | ||||
VTKEN | Previous Day Indicator | VTKEN | CHAR | 1 | XFELD | ||||
ALLDF | Record is for Full Day | ALLDF | CHAR | 1 | XFELD | ||||
OFMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | AUERU_VS | ||||
LTXA1 | Short Text | CATSSHORTT | CHAR | 40 | TEXT40 | ||||
ERUZU | Indicator: Partial confirmation | ERUZU | CHAR | 1 | XFELD | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
BUDGET_PD | FM: Receiver Budget Period | FM_EBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
HRBUDGET_PD | Master Budget Period | CATSHR_BUDGET_PERIOD_COPY | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | |||
ZCPR_GUID | 0 | ||||||||
ZCPR_EXTID | 0 | ||||||||
ZCPR_OBJGUID | 0 | ||||||||
ZCPR_OBJGEXTID | 0 | ||||||||
ZCPR_OBJTYPE | 0 | ||||||||
YYRPM_REL_TYPE | Relation Type | Y23_RPM_REL_TYPE | CHAR | 3 | CHAR3 | ||||
YYRPM_PROJ_GUID | Project GUID (xRPM) | Y23_RPM_PROJ_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_PROJ_ID | Project ID (ext.) | Y23_RPM_PROJ_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_RES_GUID | Resource GUID (xRPM) | Y23_RPM_RES_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_RES_ID | Resource ID (ext.) | Y23_RPM_RES_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_ROLE_GUID | Role GUID (xRPM) | Y23_RPM_ROLE_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_ROLE_ID | Role ID (ext.) | Y23_RPM_ROLE_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_TASK_GUID | Task GUID (xRPM) | Y23_RPM_TASK_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_TASK_ID | Task ID | Y23_RPM_TASK_ID | CHAR | 24 | CHAR24 | ||||
Z_PRS_OFFSHORE | 0 | ||||||||
Z_PRS_BILL_FLAG | 0 | ||||||||
Z_PRS_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
Z_PRS_CHARGELEVL | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure HRMSS_CAT_APPR_CATSDB_EXT using ABAP code?
As HRMSS_CAT_APPR_CATSDB_EXT 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 HRMSS_CAT_APPR_CATSDB_EXT as there is no data to select.How to access SAP table HRMSS_CAT_APPR_CATSDB_EXT
Within an ECC or HANA version of SAP you can also view further information about HRMSS_CAT_APPR_CATSDB_EXT 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