CATS_OFFLINE_EXPORT SAP (CATS Data Format for Exporting to Offline Application) Structure details

Dictionary Type: Structure
Description: CATS Data Format for Exporting to Offline Application




ABAP Code to SELECT data from CATS_OFFLINE_EXPORT
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
FIRSTCOUNTERCounter for Records in Time Recording CATSCOUNTECHAR12CHAR12
DELETEDCheckbox XFELDCHAR1XFELD
TRANSKEYTransaction Key for CATS Offline Applications CATS_OFFLINE_TRANSACTION_KEYRAW16SYSUUID
TRANSAPPLIdentification of a CATS Offline Application CATS_OFFLINE_APPLICATIONCHAR4CHAR4
COUNTERCounter for Records in Time Recording CATSCOUNTECHAR12CHAR12
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
WORKDATEDate CATSDATEDATS8DATUM
SKOSTLSender Cost Center SKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
SEBELNSending purchase order SEBELNCHAR10Assigned to domainALPHAEBELN
SEBELPSending purchase order item SEBELPNUMC5Assigned to domainEBELP
SPRZNRSender Business Process SPRZNRCHAR12Assigned to domainALPHACO_PRZNR
LSTNRActivity Number ASNUMCHAR18Assigned to domainALPHAASNUMASN
RKOSTLReceiver Cost Center EKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
RPROJReceiver WBS element EPROJNUMC8Assigned to domainKONPRPS_POSNR
RAUFNRReceiver Order EAUFNRCHAR12Assigned to domainALPHAAUFNR
RNPLNRNetwork number NW_AUFNRCHAR12Assigned to domainALPHAAUFNRANR
RAUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
RAPLZLGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
RKDAUFReceiver sales order EKDAUCHAR10Assigned to domainALPHAVBELN
RKDPOSItem number in receiver sales order EKDPONUMC6Assigned to domainPOSNR
RKSTRReceiver cost object EKSTRCHAR12Assigned to domainKSTRG
RPRZNRReceiver business process EPRZNRCHAR12Assigned to domainALPHACO_PRZNR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
FUNDReceiver fund FM_EFONDSCHAR10Assigned to domainBP_GEBERRECEIVER_FUND
FUNC_AREAReceiving Functional Area EFKTBERCHAR16Assigned to domainFKBER
GRANT_NBRReceiver Grant GM_GRANT_RECEIVERCHAR20ALPHAGM_GRANT_NBR
S_FUNDSender fund FM_SFONDSCHAR10Assigned to domainBP_GEBERSENDER_FUND
S_FUNC_AREASending Functional Area SFKTBERCHAR16Assigned to domainFKBER
S_GRANT_NBRSender Grant GM_GRANT_SENDERCHAR20ALPHAGM_GRANT_NBR
BUDGET_PDFM: Receiver Budget Period FM_EBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
SBUDGET_PDFM: Sender Budget Period FM_SBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
AWARTAttendance or Absence Type AWARTCHAR4Assigned to domainAWART
LGARTWage Type LGARTCHAR4Assigned to domainLGART
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
SPLITSplit number CY_SPLITINT13INT1
REINRTrip Number REINRNUMC10REINR
WABLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
VERSLOvertime Compensation Type VRSCHCHAR1T555RVRSCH
WTARTTax area work center HRWRKARCHAR4HRWRKAR
BWGRLValuation basis CATSBWGRLCURR13(2) WERTV7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AUFKZExtra Pay Indicator AUFKNCHAR1AUFKN
TRFGRPay Scale Group TRFGRCHAR8Assigned to domainTRFGR
TRFSTPay Scale Level TRFSTCHAR2Assigned to domainTRFST
PRAKNPremium Number PRAKNCHAR2Assigned to domainPRAKN
PRAKZPremium Indicator PRAKZNUMC4PRAKZ
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
PLANSPosition PLANSNUMC8Assigned to domainPLANS
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
MEINHUnit of Measure for Display MEINHUNIT3T006CUNITMEINS
TCURRTransaction Currency TWAERCUKY5TCURCWAERSFWS
PRICEPrice in Transaction Currency CATSPRICECURR11(2) WERTV6
ARBIDObject ID OBJEKTIDNUMC8NUM08PON
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
AUTYPOrder category AUFTYPNUMC2AUFTYP
HRCOSTASGCost Accounting Variants CATSHRCOCHAR1CATSHRCO
HRKOSTLCost Center CATSHRKOSTLCHAR10Assigned to domainALPHAKOSTLKOS
HRLSTARActivity Type CATSHRLSTARCHAR6Assigned to domainLSTARLARLART
HRFUNDMaster Fund CATSHRFUNDCHAR10Assigned to domainBP_GEBER
HRFUNC_AREAMaster Functional Area CATSHRFUNC_AREACHAR16Assigned to domainFKBER
HRGRANT_NBRMaster Grant CATSHRGRANT_NBRCHAR20ALPHAGM_GRANT_NBR
BEMOTAccounting Indicator BEMOTCHAR2Assigned to domainBEMOT
UNITUnit of Measurement MSEHIUNIT3Assigned to domainCUNITMEINS
STATKEYFIGStatistical key figure STAGRCHAR6Assigned to domainSTAGRSTA
TASKTYPETask Type CATSTASKTYPECHAR4CATSTASKTYPE
TASKLEVELTask Level CATSTASKLEVELCHAR8CATSTASKLEVEL
TASKCOMPONENTTask component CATSTASKCOMPONENTCHAR8CATSTASKCOMPONENT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CPR_GUIDProject GUID CATS_CPR_GUIDCHAR32SYSUUID_C
CPR_EXTIDExternal Project ID CATS_CPR_EXTIDCHAR24CHAR24
CPR_OBJGUIDObject ID CATS_CPR_OBJGUIDCHAR32SYSUUID_C
CPR_OBJGEXTIDExternal ID of Project Subobject CATS_CPR_OBJGEXTIDCHAR24CHAR24
CPR_OBJTYPEcProjects Object Type CATS_CPR_OBJTYPECHAR3CHAR3
HRBUDGET_PDMaster Budget Period CATSHR_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIOD
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
UVORNSuboperation UVORNCHAR4NUMCVVORNR
BEDIDID of the capacity requirements record BEDIDNUMC12Assigned to domainBEDID
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA
ARBPLWork center ARBPLCHAR8ARBPLAGR
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
ERSDACreated on CATS_ERSDADATS8DATUM
ERSTMTime of Entry CATS_CPUTMTIMS6UZEIT
ERNAMUser Who Created Data Record CATS_ERNAMCHAR12USNAM
LAEDADate of Last Change CATS_LAEDADATS8DATUM
LAETMTime of Last Change CATS_LAETMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
APNAMName of person who approved data CATSAPNAMCHAR12UNAME
APDATDate of Approval CATSAPDATDATS8DATUM
WORKITEMIDWork item ID SWW_WIIDNUMC12Assigned to domainSWW_WIIDWID
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
STATUSProcessing status CATSSTATUSCHAR2CATSSTATUS
REFCOUNTERReference Counter for Record to be Changed CATSREFCOUCHAR12CHAR12
REASONReason for rejection CATSREASONCHAR4Assigned to domainCATSREASON
BELNRDocument Number CATSBELNRCHAR10ALPHABELNR
EXTSYSTEMLogical system of source document HR_AWSYSCHAR10Assigned to domainALPHALOGSYS
EXTAPPLICATIONExternal Application HR_AWTYPCHAR5HR_AWTYP
EXTDOCUMENTNODocument number HR_AWKEYCHAR20AWKEY
TASKCOUNTERCATS: Task Counter CATSTASKCOUNTERCHAR10ALPHABELNR
CATSHOURSHours CATSHOURSQUAN4(2) CATSHOURS
BEGUZStart time CATSBEGUZTIMS6UZEIT
ENDUZEnd time CATSENDUZTIMS6UZEIT
VTKENPrevious Day Indicator VTKENCHAR1XFELD
ALLDFRecord is for Full Day ALLDFCHAR1XFELD
OFMNWRemaining work REMNWQUAN7(1) ARBEIT
PEDDForecast finish date of operation from confirmation CO_PEDDDATS8DATUM
AUERUPartial/Final Confirmation AUERU_VSCHAR1AUERU_VS
LTXA1Short Text CATSSHORTTCHAR40TEXT40
LONGTEXTLong Text CATSLONGTECHAR1XFELD
ERUZUIndicator: Partial confirmation ERUZUCHAR1XFELD
CATSAMOUNTCATS Amount CATSAMOUNTCURR13(2) CATSAMOUNT
CATSQUANTITYTime Sheet: Number (Unit of Measure) CATSNUMBERQUAN15(3) CQUA8
ZCPR_GUID 0
ZCPR_EXTID 0
ZCPR_OBJGUID 0
ZCPR_OBJGEXTID 0
ZCPR_OBJTYPE 0
YYRPM_REL_TYPERelation Type Y23_RPM_REL_TYPECHAR3CHAR3
YYRPM_PROJ_GUIDProject GUID (xRPM) Y23_RPM_PROJ_GUIDCHAR32CHAR32
YYRPM_PROJ_IDProject ID (ext.) Y23_RPM_PROJ_IDCHAR24CHAR24
YYRPM_RES_GUIDResource GUID (xRPM) Y23_RPM_RES_GUIDCHAR32CHAR32
YYRPM_RES_IDResource ID (ext.) Y23_RPM_RES_IDCHAR24CHAR24
YYRPM_ROLE_GUIDRole GUID (xRPM) Y23_RPM_ROLE_GUIDCHAR32CHAR32
YYRPM_ROLE_IDRole ID (ext.) Y23_RPM_ROLE_IDCHAR24CHAR24
YYRPM_TASK_GUIDTask GUID (xRPM) Y23_RPM_TASK_GUIDCHAR32CHAR32
YYRPM_TASK_IDTask ID Y23_RPM_TASK_IDCHAR24CHAR24
Z_PRS_OFFSHORE 0
Z_PRS_BILL_FLAG 0
Z_PRS_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!