CATSDB_ALV SAP (Time Sheet Data - Layout for ALV Reporting) Structure details

Dictionary Type: Structure
Description: Time Sheet Data - Layout for ALV Reporting




ABAP Code to SELECT data from CATSDB_ALV
Related tables to CATSDB_ALV
Access table CATSDB_ALV




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
MANDTClient MANDTCLNT3T000MANDT
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
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
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
ROWLines in parameter BAPI_LINEINT410INT4
PFLAG_ICONStatus and Processing Indicator CATSXT_PFLAG_ICONSTRG0
LONGTEXT_ICONLong Text CATSXT_LONGTEXT_ICONSTRG0
TASKTYPE_TEXTTask Type CATSXT_TASKTYPE_TEXTCHAR25TEXT25
TASKLEVEL_TEXTTask Level CATSXT_TASKLEVEL_TEXTCHAR25TEXT25
TASKCOMPONENT_TEXTTask Component CATSXT_TASKCOMPONENT_TEXTCHAR25TEXT25
ENAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
SNAMEEmployee's Name (Sortable by LAST NAME FIRST NAME) SMNAMCHAR30CHAR30
RACCOBJAccount Assignment (Receiver) CATSXT_RACCOBJ_TEXTCHAR25TEXT25
RACCOBJ_TEXTAccount Assignment Description (Receiver) CATSXT_RACCOBJ_TEXT1STRG0
RACCOBJ_GENRECGeneral Receiver GEN_RECCHAR35CHAR_35
REASON_TEXTText for Rejection Reason CATSRETEXTCHAR50TEXT50
TMP_KEYCounter for Records in Time Recording CATSCOUNTECHAR12CHAR12
CORR_ICONCorrection Indicator CATSXT_CORR_ICONSTRG0
ADDITIONAL_RECEIVERSMultiple Account Assignment CATSXT_ADDITIONAL_RECEIVERSSTRG0
CO_TRANSFERCO Transmission Takes Place 'X' = Yes CATSXT_CO_TRANSFERCHAR1XFELD
INVOICEDBilling Document Being Processed 'X' = Yes CATSXT_INVOICEDCHAR1XFELD
CPR_TEXTcProject Description CATS_CPR_TEXTCHAR40CHAR40
CPR_OBJTEXTcProject Description CATS_CPR_TEXTCHAR40CHAR40

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 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!