CATSDB_ALV SAP (Time Sheet Data - Layout for ALV Reporting) Structure details
Description: Time Sheet Data - Layout for ALV Reporting
Structure field list including key, data, relationships and ABAP select examples
CATSDB_ALV 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 "Time Sheet Data - Layout for ALV Reporting" 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_CATSDB_ALV TYPE CATSDB_ALV.
The CATSDB_ALV table consists of various fields, each holding specific information or linking keys about Time Sheet Data - Layout for ALV Reporting data available in SAP. These include MANDT (Client), COUNTER (Counter for Records in Time Recording), PERNR (Personnel Number), WORKDATE (Date).. 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 (Deep)
SAP CATSDB_ALV 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 | |||
COUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
WORKDATE | Date | CATSDATE | DATS | 8 | DATUM | ||||
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 | |
RPROJ | Receiver WBS element | EPROJ | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
RAUFNR | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RNPLNR | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
RAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
RAPLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
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 | |||
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 | ||
AWART | Attendance or Absence Type | AWART | CHAR | 4 | Assigned to domain | AWART | |||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | KAPID | |||
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 | ||
MEINH | Unit of Measure for Display | MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TCURR | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
PRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | ||||
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
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 | |||
UNIT | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STATKEYFIG | Statistical key figure | STAGR | CHAR | 6 | Assigned to domain | STAGR | STA | ||
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 | |
CPR_GUID | Project GUID | CATS_CPR_GUID | CHAR | 32 | SYSUUID_C | ||||
CPR_EXTID | External Project ID | CATS_CPR_EXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJGUID | Object ID | CATS_CPR_OBJGUID | CHAR | 32 | SYSUUID_C | ||||
CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPR_OBJGEXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJTYPE | cProjects Object Type | CATS_CPR_OBJTYPE | CHAR | 3 | CHAR3 | ||||
HRBUDGET_PD | Master Budget Period | CATSHR_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | |||
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 | ||||
REASON | Reason for rejection | CATSREASON | CHAR | 4 | Assigned to domain | CATSREASON | |||
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 | |||
CATSHOURS | Hours | CATSHOURS | QUAN | 4(2) | CATSHOURS | ||||
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 | ||||
LONGTEXT | Long Text | CATSLONGTE | CHAR | 1 | XFELD | ||||
ERUZU | Indicator: Partial confirmation | ERUZU | CHAR | 1 | XFELD | ||||
CATSAMOUNT | CATS Amount | CATSAMOUNT | CURR | 13(2) | CATSAMOUNT | ||||
CATSQUANTITY | Time Sheet: Number (Unit of Measure) | CATSNUMBER | QUAN | 15(3) | CQUA8 | ||||
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 | ||||||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
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 | ||
ROW | Lines in parameter | BAPI_LINE | INT4 | 10 | INT4 | ||||
PFLAG_ICON | Status and Processing Indicator | CATSXT_PFLAG_ICON | STRG | 0 | |||||
LONGTEXT_ICON | Long Text | CATSXT_LONGTEXT_ICON | STRG | 0 | |||||
TASKTYPE_TEXT | Task Type | CATSXT_TASKTYPE_TEXT | CHAR | 25 | TEXT25 | ||||
TASKLEVEL_TEXT | Task Level | CATSXT_TASKLEVEL_TEXT | CHAR | 25 | TEXT25 | ||||
TASKCOMPONENT_TEXT | Task Component | CATSXT_TASKCOMPONENT_TEXT | CHAR | 25 | TEXT25 | ||||
ENAME | Formatted Name of Employee or Applicant | EMNAM | CHAR | 40 | TEXT40 | ||||
SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | SMNAM | CHAR | 30 | CHAR30 | ||||
RACCOBJ | Account Assignment (Receiver) | CATSXT_RACCOBJ_TEXT | CHAR | 25 | TEXT25 | ||||
RACCOBJ_TEXT | Account Assignment Description (Receiver) | CATSXT_RACCOBJ_TEXT1 | STRG | 0 | |||||
RACCOBJ_GENREC | General Receiver | GEN_REC | CHAR | 35 | CHAR_35 | ||||
REASON_TEXT | Text for Rejection Reason | CATSRETEXT | CHAR | 50 | TEXT50 | ||||
TMP_KEY | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
CORR_ICON | Correction Indicator | CATSXT_CORR_ICON | STRG | 0 | |||||
ADDITIONAL_RECEIVERS | Multiple Account Assignment | CATSXT_ADDITIONAL_RECEIVERS | STRG | 0 | |||||
CO_TRANSFER | CO Transmission Takes Place 'X' = Yes | CATSXT_CO_TRANSFER | CHAR | 1 | XFELD | ||||
INVOICED | Billing Document Being Processed 'X' = Yes | CATSXT_INVOICED | CHAR | 1 | XFELD | ||||
CPR_TEXT | cProject Description | CATS_CPR_TEXT | CHAR | 40 | CHAR40 | ||||
CPR_OBJTEXT | cProject Description | CATS_CPR_TEXT | CHAR | 40 | CHAR40 |
Key field | Non-key field |
How do I retrieve data from SAP structure CATSDB_ALV using ABAP code?
As CATSDB_ALV 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 CATSDB_ALV as there is no data to select.How to access SAP table CATSDB_ALV
Within an ECC or HANA version of SAP you can also view further information about CATSDB_ALV 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