CATSXT_ALV SAP (CATSXT: Work Area for List Viewer) Structure details
Description: CATSXT: Work Area for List Viewer
Structure field list including key, data, relationships and ABAP select examples
CATSXT_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 "CATSXT: Work Area for List Viewer" 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_CATSXT_ALV TYPE CATSXT_ALV.
The CATSXT_ALV table consists of various fields, each holding specific information or linking keys about CATSXT: Work Area for List Viewer data available in SAP. These include MANDT (Client), PERNR (Personnel Number), WORKDATE (Date), SKOSTL (Sender Cost Center).. 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 CATSXT_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 | |||
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 | |
SEBELN | Sending purchase order | SEBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
SEBELP | Sending purchase order item | SEBELP | NUMC | 5 | Assigned to domain | EBELP | |||
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 | ||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
WABLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
HRCOSTASG | Cost Accounting Variants | CATSHRCO | CHAR | 1 | CATSHRCO | ||||
TASKTYPE | Task Type | CATSTASKTYPE | CHAR | 4 | CATSTASKTYPE | ||||
TASKLEVEL | Task Level | CATSTASKLEVEL | CHAR | 8 | CATSTASKLEVEL | ||||
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 | |||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
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 | |||
LTXA1 | Short Text | CATSSHORTT | CHAR | 40 | TEXT40 | ||||
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 | |||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
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 | ||||
TASKTYPE_TEXT | Task Type | CATSXT_TASKTYPE_TEXT | CHAR | 25 | TEXT25 | ||||
TASKLEVEL_TEXT | Task Level | CATSXT_TASKLEVEL_TEXT | CHAR | 25 | TEXT25 | ||||
RACCOBJ | Account Assignment (Receiver) | CATSXT_RACCOBJ_TEXT | CHAR | 25 | TEXT25 | ||||
RACCOBJ_TEXT | Account Assignment Description (Receiver) | CATSXT_RACCOBJ_TEXT1 | STRG | 0 | |||||
LONGTEXT_ICON | Long Text | CATSXT_LONGTEXT_ICON | STRG | 0 | |||||
PFLAG_ICON | Status and Processing Indicator | CATSXT_PFLAG_ICON | STRG | 0 | |||||
PROFILE | Data Entry Profile | CATSVARIAN | CHAR | 8 | Assigned to domain | CATSVARIAN | CVR | ||
RACCOBJ_GENREC | General Receiver | GEN_REC | CHAR | 35 | CHAR_35 | ||||
TMP_KEY | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
MARKER | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
NO_CHANGE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
SAVE_AS_LOCKED | Save Data with 'In Process' Status | CATSXT_SAVE_AS_LOCKED | CHAR | 1 | XFELD | ||||
GOS_ICON | Attachment List | CATSXT_GOS_ICON | STRG | 0 | |||||
ADDITIONAL_RECEIVERS | Multiple Account Assignment | CATSXT_ADDITIONAL_RECEIVERS | STRG | 0 | |||||
CAT2AMOUNT | CATS Amount | CATSAMOUNT | CURR | 13(2) | CATSAMOUNT | ||||
CAT2WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CORR_ICON | Correction Indicator | CATSXT_CORR_ICON | 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 |
Key field | Non-key field |
How do I retrieve data from SAP structure CATSXT_ALV using ABAP code?
As CATSXT_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 CATSXT_ALV as there is no data to select.How to access SAP table CATSXT_ALV
Within an ECC or HANA version of SAP you can also view further information about CATSXT_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