CATSMM
Cross-Application Time Sheet (CATS): Transfer to MM
CATSMM is an SAP database table in S/4HANA. Cross-Application Time Sheet (CATS): Transfer to MM. It contains 24 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SESTimeRecording | view | from | EXTENSION | Extension View on CATSMM |
| I_MMTimeRecording | view | from | BASIC | Time Sheet (CATS): Transfer to MM |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | counter | CATSCOUNTE | Counter | |||
| KEY | stokz | CO_STOKZ | Reversed | |||
| pernr | PERNR_D | Personnel No. | ||||
| workdate | CATSDATE | Date | ||||
| catshours | CATSHOURS | Hours | ||||
| beguz | CATSBEGUZ | Start time | ||||
| enduz | CATSENDUZ | End time | ||||
| ltxa1 | CO_RTEXT | Confirm. text | ||||
| rkostl | EKOSTL | Rec. CCtr | ||||
| rproj | EPROJ | Rec. WBS Elem. | ||||
| raufnr | EAUFNR | Rec. order | ||||
| rkdauf | EKDAU | Rec. sales ord. | ||||
| rkdpos | EKDPO | RecSalOrd. item | ||||
| sebeln | SEBELN | Sending order | ||||
| sebelp | SEBELP | Send. PO item | ||||
| lstnr | ASNUM | Activity number | ||||
| aueru | AUERU_VS | Final Confirmtn | ||||
| belnr | CATSBELNR | Document no. | ||||
| transfer | CATSTRANSF | Transferred | ||||
| catsquantity | CATSNUMBER | Number (unit) | ||||
| unit | MSEHI | Internal UoM | ||||
| work_item_id | /CPD/PFP_WORKITEM_ID | Work Item ID | ||||
| dummy_incl_eew_prs_cpils | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cross-Application Time Sheet (CATS): Transfer to MM
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CATSMM (
MANDT, -- Client [MANDT]
COUNTER, -- Counter [CATSCOUNTE]
STOKZ, -- Reversed [CO_STOKZ]
PERNR, -- Personnel No. [PERNR_D]
WORKDATE, -- Date [CATSDATE]
CATSHOURS, -- Hours [CATSHOURS]
BEGUZ, -- Start time [CATSBEGUZ]
ENDUZ, -- End time [CATSENDUZ]
LTXA1, -- Confirm. text [CO_RTEXT]
RKOSTL, -- Rec. CCtr [EKOSTL]
RPROJ, -- Rec. WBS Elem. [EPROJ]
RAUFNR, -- Rec. order [EAUFNR]
RKDAUF, -- Rec. sales ord. [EKDAU]
RKDPOS, -- RecSalOrd. item [EKDPO]
SEBELN, -- Sending order [SEBELN]
SEBELP, -- Send. PO item [SEBELP]
LSTNR, -- Activity number [ASNUM]
AUERU, -- Final Confirmtn [AUERU_VS]
BELNR, -- Document no. [CATSBELNR]
TRANSFER, -- Transferred [CATSTRANSF]
CATSQUANTITY, -- Number (unit) [CATSNUMBER]
UNIT, -- Internal UoM [MSEHI]
WORK_ITEM_ID, -- Work Item ID [/CPD/PFP_WORKITEM_ID]
DUMMY_INCL_EEW_PRS_CPILS, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, COUNTER, STOKZ)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA