1. Home
  2. Resources
  3. SAP Tables
  4. BAPICATS1 - CATS: Insert New Data Record

SAP Table BAPICATS1

CATS: Insert New Data Record

BAPICATS1 (CATS: Insert New Data Record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPICATS1 to other SAP tables.

Source: BAPICATS1 (CATS: Insert New Data Record)

BAPICATS1 table fields

Field Data element Checktable Datatype Length Decimals
WORKDATE Date CATSDATE DATS 8 0
EMPLOYEENUMBER Personnel Number HR_PERNR NUMC 8 0
SEND_CCTR Sender Cost Center SKOSTL CHAR 10 0
SENBUSPROC Sender Business Process SPRZNR CHAR 12 0
ACTTYPE Activity Type LSTAR CHAR 6 0
PO_NUMBER Sending purchase order SEBELN CHAR 10 0
PO_ITEM Sending purchase order item SEBELP NUMC 5 0
SERVICE Activity Number ASNUM CHAR 18 0
REC_CCTR Receiver Cost Center EKOSTL CHAR 10 0
REC_ORDER Receiver Order EAUFNR CHAR 12 0
NETWORK Network number NW_AUFNR CHAR 12 0
ACTIVITY Operation/Activity Number VORNR CHAR 4 0
SUB_ACTIVITY Suboperation UVORN CHAR 4 0
CAPA_CATEGORY Capacity category KAPART CHAR 3 0
SPLIT Split number CY_SPLIT INT1 3 0
WORK_CNTR Work center ARBPL CHAR 8 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
RECSALEORD Receiver sales order EKDAU CHAR 10 0
RECITEM Item number in receiver sales order EKDPO NUMC 6 0
RECCOSTOBJ Receiver cost object EKSTR CHAR 12 0
RECBUSPROC Receiver business process EPRZNR CHAR 12 0
ABS_ATT_TYPE Attendance or Absence Type AWART CHAR 4 0
WAGETYPE Wage Type LGART CHAR 4 0
TRIPNO Trip Number REINR NUMC 10 0
OT_COMP_TYPE Overtime Compensation Type VRSCH CHAR 1 0
WORKTAXAREA Tax area work center HRWRKAR CHAR 4 0
VALUATION_BASIS Valuation basis HR_BWGRL DEC 23 4
CURRENCY Currency Key WAERS CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
EXTRA_PAY_INDIC Extra Pay Indicator AUFKN CHAR 1 0
NULL No extra pay: Valuation basis used as is
- Valuation basis used as amount deducted
+ Valuation basis used as amount added
PAYSCALEGROUP Pay Scale Group TRFGR CHAR 8 0
PAYSCALELEVEL Pay Scale Level HR_TRFST CHAR 2 0
BONUSTYPE Premium Number PRAKN CHAR 2 0
BONUSVALUE Premium Indicator PRAKZ NUMC 4 0
POSITION Position PLANS NUMC 8 0
CO_AREA Controlling Area KOKRS CHAR 4 0
TRANS_CURR Transaction Currency TWAER CUKY 5 0
TRANS_CURR_ISO ISO currency code ISOCD CHAR 3 0
PRICE Price for Activity Allocation BAPICATSPRICE DEC 23 4
PLANT Plant WERKS_D CHAR 4 0
CALC_MOTIVE Accounting Indicator BEMOT CHAR 2 0
CATSHOURS Hours CATSHOURS QUAN 4 2
UNIT Unit of Measure for Display MEINH UNIT 3 0
ISOCODE_UNIT ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
STARTTIME Start Time BEGUZ TIMS 6 0
ENDTIME End Time ENDUZ TIMS 6 0
PREVIOUS_DAY Previous Day Indicator VTKEN CHAR 1 0
X Yes
NULL No
ALL_DAY_FLAG Record is for Full Day ALLDF CHAR 1 0
X Yes
NULL No
REM_WORK Remaining work REMNW QUAN 7 1
FCST_FIN_DATE Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
FIN_CONF Partial/Final Confirmation AUERU_VS CHAR 1 0
NULL Partial confirmation
X Final confirmation
1 Automatic final confirmation
SHORTTEXT Operation short text LTXA1 CHAR 40 0
PART_CONF Indicator: Partial confirmation ERUZU CHAR 1 0
X Yes
NULL No
EXTSYSTEM External Logical System CATS_AWSYS CHAR 10 0
EXTAPPLICATION External Application of Original Record CATS_AWTYP CHAR 5 0
EXTDOCUMENTNO Document Number CATS_AWKEY CHAR 20 0
STATKEYFIG Statistical key figure STAGR CHAR 6 0
QUANTITY Time Sheet: Number (Unit of Measure) CATSNUMBER QUAN 15 3
UNITQ Unit of Measurement MSEHI UNIT 3 0
ISO_UNITQ ISO code for unit of measurement ISOCD_UNIT CHAR 3 0
AMOUNT Amount BAPICATSAMOUNT DEC 23 4
LONGTEXT Long Text CATSLONGTE CHAR 1 0
X Yes
NULL No
FUND Fund BP_GEBER CHAR 10 0
FUNC_AREA Functional Area FKBER CHAR 16 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
SEND_FUND Sender fund FM_SFONDS CHAR 10 0
SEND_FUNCTION Sending Functional Area SFKTBER CHAR 16 0
SEND_GRANT Sender Grant GM_GRANT_SENDER CHAR 20 0
CPR_GUID Project ID (GUID) CATS_CPROJECT_GUID CHAR 32 0
CPR_EXTID External Project ID CATS_CPROJECT_EXTID CHAR 24 0
CPR_OBJGUID Object ID CATS_CPROJECT_OBJGUID CHAR 32 0
CPR_OBJGEXTID External ID of Project Subobject CATS_CPROJECT_EXTOBJID CHAR 24 0
CPR_OBJTYPE cProjects Object Type CATS_CPROJECT_TYPE CHAR 3 0
FUND_LONG Obsolete FM_GEBER_LONG CHAR 20 0
SEND_FUND_LONG Obsolete FM_SGEBER_LONG CHAR 20 0
BUDGET_PERIOD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
SEND_BUDGET_PERIOD FM: Sender Budget Period FM_SBUDGET_PERIOD CHAR 10 0