BAPICATS2 SAP (CATS Data Export) Structure details
Dictionary Type: Structure
Description: CATS Data Export
Description: CATS Data Export
Structure field list including key, data, relationships and ABAP select examples
BAPICATS2 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 Data Export" 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_BAPICATS2 TYPE BAPICATS2.
The BAPICATS2 table consists of various fields, each holding specific information or linking keys about CATS Data Export data available in SAP. These include WORKDATE (Date), EMPLOYEENUMBER (Personnel Number), SEND_CCTR (Sender Cost Center), SENBUSPROC (Sender Business Process).. 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: Cannot Be Enhanced
SAP BAPICATS2 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 | ||||
| WORKDATE | Date | CATSDATE | DATS | 8 | DATUM | ||||
| EMPLOYEENUMBER | Personnel Number | HR_PERNR | NUMC | 8 | PERNR | PER | |||
| SEND_CCTR | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
| SENBUSPROC | Sender Business Process | SPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
| ACTTYPE | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
| PO_NUMBER | Sending purchase order | SEBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
| PO_ITEM | Sending purchase order item | SEBELP | NUMC | 5 | Assigned to domain | EBELP | |||
| SERVICE | Activity Number | ASNUM | CHAR | 18 | Assigned to domain | ALPHA | ASNUM | ASN | |
| REC_CCTR | Receiver Cost Center | EKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
| REC_ORDER | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
| NETWORK | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| AVTIVITY | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| SUB_ACTIVITY | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
| WORK_CNTR | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
| CAPA_CATEGORY | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
| RECSALEORD | Receiver sales order | EKDAU | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| RECITEM | Item number in receiver sales order | EKDPO | NUMC | 6 | Assigned to domain | POSNR | |||
| RECCOSTOBJ | Receiver cost object | EKSTR | CHAR | 12 | Assigned to domain | KSTRG | |||
| RECBUSPROC | Receiver business process | EPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
| ABS_ATT_TYPE | Attendance or Absence Type | AWART | CHAR | 4 | Assigned to domain | AWART | |||
| WAGETYPE | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
| TRIPNO | Trip Number | REINR | NUMC | 10 | REINR | ||||
| OT_COMP_TYPE | Overtime Compensation Type | VRSCH | CHAR | 1 | Assigned to domain | VRSCH | |||
| WORKTAXAREA | Tax area work center | HRWRKAR | CHAR | 4 | HRWRKAR | ||||
| VALUATION_BASIS | Valuation basis | HR_BWGRL | DEC | 23(4) | BAPICURR | ||||
| CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
| EXTRA_PAY_INDIC | Extra Pay Indicator | AUFKN | CHAR | 1 | AUFKN | ||||
| PAYSCALEGROUP | Pay Scale Group | TRFGR | CHAR | 8 | Assigned to domain | TRFGR | |||
| PAYSCALELEVEL | Pay Scale Level | HR_TRFST | CHAR | 2 | Assigned to domain | TRFST | |||
| BONUSTYPE | Premium Number | PRAKN | CHAR | 2 | Assigned to domain | PRAKN | |||
| BONUSVALUE | Premium Indicator | PRAKZ | NUMC | 4 | PRAKZ | ||||
| POSITION | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
| CO_AREA | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| TRANS_CURR | Transaction Currency | TWAER | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| TRANS_CURR_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
| PRICE | Price for Activity Allocation | BAPICATSPRICE | DEC | 23(4) | BAPICURR | ||||
| PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| CALC_MOTIVE | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
| CATSHOURS | Hours | CATSHOURS | QUAN | 4(2) | CATSHOURS | ||||
| UNIT | Unit of Measure for Display | MEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| ISOCODE_UNIT | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
| STARTTIME | Start Time | BEGUZ | TIMS | 6 | UZEIT | ||||
| ENDTIME | End Time | ENDUZ | TIMS | 6 | UZEIT | ||||
| PREVIOUS_DAY | Previous Day Indicator | VTKEN | CHAR | 1 | XFELD | ||||
| ALL_DAY_FLAG | Record is for Full Day | ALLDF | CHAR | 1 | XFELD | ||||
| REM_WORK | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
| FCST_FIN_DATE | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
| FIN_CONF | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | AUERU_VS | ||||
| SHORTTEXT | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
| PART_CONF | Indicator: Partial confirmation | ERUZU | CHAR | 1 | XFELD | ||||
| EXTSYSTEM | External Logical System | CATS_AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| EXTAPPLICATION | External Application of Original Record | CATS_AWTYP | CHAR | 5 | HR_AWTYP | ||||
| EXTDOCUMENTNO | Document Number | CATS_AWKEY | CHAR | 20 | AWKEY | ||||
| CREATIONDATE | Created on | CATS_ERSDA | DATS | 8 | DATUM | ||||
| ENTRYTIME | Time of Entry | CATS_CPUTM | TIMS | 6 | UZEIT | ||||
| CREATING_ADMIN | User Who Created Data Record | CATS_ERNAM | CHAR | 12 | USNAM | ||||
| LASTCHANGED_ON | Date of Last Change | CATS_LAEDA | DATS | 8 | DATUM | ||||
| LASTCHANGED_AT | Time of Last Change | CATS_LAETM | TIMS | 6 | UZEIT | ||||
| CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| APPROVING_ADMIN | Name of person who approved data | CATSAPNAM | CHAR | 12 | UNAME | ||||
| DATE_OF_APPROVAL | Date of Approval | CATSAPDAT | DATS | 8 | DATUM | ||||
| WORKITEMID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
| LOG_SYSTEM | 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 | |||
| CATS_DOC_NO | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
| STATKEYFIG | Statistical key figure | STAGR | CHAR | 6 | Assigned to domain | STAGR | STA | ||
| QUANTITY | Time Sheet: Number (Unit of Measure) | CATSNUMBER | QUAN | 15(3) | CQUA8 | ||||
| UNITQ | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| ISO_UNITQ | ISO code for unit of measurement | ISOCD_UNIT | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
| AMOUNT | Amount | BAPICATSAMOUNT | DEC | 23(4) | BAPICURR | ||||
| LONGTEXT | Long Text | CATSLONGTE | CHAR | 1 | XFELD | ||||
| FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| FUNC_AREA | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
| SEND_FUND | Sender fund | FM_SFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | SENDER_FUND | ||
| SEND_FUNCTION | Sending Functional Area | SFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
| SEND_GRANT | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
| CPR_GUID | Project ID (GUID) | CATS_CPROJECT_GUID | CHAR | 32 | SYSUUID_C | ||||
| CPR_EXTID | External Project ID | CATS_CPROJECT_EXTID | CHAR | 24 | CHAR24 | ||||
| CPR_OBJGUID | Object ID | CATS_CPROJECT_OBJGUID | CHAR | 32 | SYSUUID_C | ||||
| CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPROJECT_EXTOBJID | CHAR | 24 | CHAR24 | ||||
| CPR_OBJTYPE | cProjects Object Type | CATS_CPROJECT_TYPE | CHAR | 3 | CHAR3 | ||||
| FUND_LONG | Obsolete | FM_GEBER_LONG | CHAR | 20 | CHAR20 | ||||
| SEND_FUND_LONG | Obsolete | FM_SGEBER_LONG | CHAR | 20 | CHAR20 | ||||
| BUDGET_PERIOD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
| SEND_BUDGET_PERIOD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
| Key field | Non-key field |
How do I retrieve data from SAP structure BAPICATS2 using ABAP code?
As BAPICATS2 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 BAPICATS2 as there is no data to select.How to access SAP table BAPICATS2
Within an ECC or HANA version of SAP you can also view further information about BAPICATS2 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