TCA09
Task list applications
TCA09 is an SAP database table in S/4HANA. Task list applications. It contains 22 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BOOApplication | view | from | BASIC | Bill of Operation Application Code |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | plnaw | PLNAW | Application | |||
| objsub | OBJSUB_D | Cop.tsk.lst.obj | ||||
| idsub | IDSUB | Cop.tsk.list ID | ||||
| objalt | OBJALT | Header obj. | ||||
| idalt | IDALT | Grp. ct. ID | ||||
| objseq | OBJSEQ | Seqence obj. | ||||
| idseq | IDSEQ | Sequence ID | ||||
| objopr | OBJOPR | Operation obj. | ||||
| idopr | IDOPR | Operation ID | ||||
| objfhm | OBJFHM | PRT obj. | ||||
| idfhm | IDFHM | PRT ID | ||||
| class | LCLAS | Grouping type | ||||
| linesize | TDLINESIZE | Line width | ||||
| objphas | OBJPHAS | Phase obj. | ||||
| idphas | IDPHAS | Phase ID | ||||
| objfeat | OBJFEAT | PI object | ||||
| idfeat | IDFEAT | ProcInst ID | ||||
| objmst | OBJMST | Obj: Milestone | ||||
| idmst | IDMST | Milestone ID | ||||
| objfeav | OBJFEAV | PIC object | ||||
| idfeav | IDFEAV | PI char. ID |
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.
-- Task list applications
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCA09 (
MANDT, -- Client [MANDT]
PLNAW, -- Application [PLNAW]
OBJSUB, -- Cop.tsk.lst.obj [OBJSUB_D]
IDSUB, -- Cop.tsk.list ID [IDSUB]
OBJALT, -- Header obj. [OBJALT]
IDALT, -- Grp. ct. ID [IDALT]
OBJSEQ, -- Seqence obj. [OBJSEQ]
IDSEQ, -- Sequence ID [IDSEQ]
OBJOPR, -- Operation obj. [OBJOPR]
IDOPR, -- Operation ID [IDOPR]
OBJFHM, -- PRT obj. [OBJFHM]
IDFHM, -- PRT ID [IDFHM]
CLASS, -- Grouping type [LCLAS]
LINESIZE, -- Line width [TDLINESIZE]
OBJPHAS, -- Phase obj. [OBJPHAS]
IDPHAS, -- Phase ID [IDPHAS]
OBJFEAT, -- PI object [OBJFEAT]
IDFEAT, -- ProcInst ID [IDFEAT]
OBJMST, -- Obj: Milestone [OBJMST]
IDMST, -- Milestone ID [IDMST]
OBJFEAV, -- PIC object [OBJFEAV]
IDFEAV, -- PI char. ID [IDFEAV]
PRIMARY KEY (MANDT, PLNAW)
);
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