CATS_OFFLINE_EXPORT SAP (CATS Data Format for Exporting to Offline Application) Structure details
Description: CATS Data Format for Exporting to Offline Application
Related tables to CATS_OFFLINE_EXPORT
Access table CATS_OFFLINE_EXPORT
Structure field list including key, data, relationships and ABAP select examples
CATS_OFFLINE_EXPORT 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 Format for Exporting to Offline Application" 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_CATS_OFFLINE_EXPORT TYPE CATS_OFFLINE_EXPORT.
The CATS_OFFLINE_EXPORT table consists of various fields, each holding specific information or linking keys about CATS Data Format for Exporting to Offline Application data available in SAP. These include DELETED (Checkbox), TRANSKEY (Transaction Key for CATS Offline Applications), TRANSAPPL (Identification of a CATS Offline Application), COUNTER (Counter for Records in Time Recording).. 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 CATS_OFFLINE_EXPORT 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 |
FIRSTCOUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
DELETED | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
TRANSKEY | Transaction Key for CATS Offline Applications | CATS_OFFLINE_TRANSACTION_KEY | RAW | 16 | SYSUUID | ||||
TRANSAPPL | Identification of a CATS Offline Application | CATS_OFFLINE_APPLICATION | CHAR | 4 | CHAR4 | ||||
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 | |||
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 | ||
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure CATS_OFFLINE_EXPORT using ABAP code?
As CATS_OFFLINE_EXPORT 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 CATS_OFFLINE_EXPORT as there is no data to select.How to access SAP table CATS_OFFLINE_EXPORT
Within an ECC or HANA version of SAP you can also view further information about CATS_OFFLINE_EXPORT 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