TCLA
Class Types
TCLA is an SAP database table in S/4HANA. Class Types. It contains 29 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ClfnClassType | view | from | BASIC | Class Type of Classification |
| I_ClfnClassType | view | inner | BASIC | Class Type of Classification |
| I_ClfnClassTypeBasic | view | from | BASIC | Class Type Basic of Classification |
| P_ClfnSdmClfHdr | view | inner | BASIC | |
| P_ClfnSdmInobIncons | view | inner | BASIC | Helper View for INOB Inconsistency SDM |
| P_MDChgProcCustClAssgmt | view | inner | BASIC | |
| P_MDChgProcCustValn | view | inner | BASIC | |
| P_MDChgProcProdClAssgmt | view | inner | BASIC | |
| P_MDChgProcProdValn | view | inner | BASIC | |
| P_MDChgProcSuplrClAssgmt | view | inner | BASIC | |
| P_MDChgProcSuplrValn | view | inner | BASIC | |
| VC_INTEGRATION_TCLA | view | from | Extraction for TCLA |
Fields (29)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | klart | KLASSENART | Class Type | |||
| obtab | TABELLE | Table | ||||
| swofl | SWORKENNZ | Keywords | ||||
| smefl | SACHMKENNZ | Characteristics | ||||
| dokfl | DOKUKENNZ | Documents | ||||
| txtfl | TEXTKENNZ | Texts | ||||
| dinfl | DINBUKENNZ | Stds data | ||||
| stand | KLARTST | Std Class Type | ||||
| mfkls | MEHRFACHKL | Multiple class. | ||||
| tracl | TRANSCL | Master record | ||||
| varklart | VARKLART | Var. class type | ||||
| multobj | MULTOBJ | Multiple objs | ||||
| konfobj | KONFOBJ | Config. object | ||||
| intklart | INTKLART | Int. class type | ||||
| aeblgzuord | CLAEBZUORD | Change Docs | ||||
| aediezuord | CLAEDIZUOR | ECH (time) | ||||
| migration | CLMIGRATIO | Distribution | ||||
| hierarchie | CLHIER | Hier. allowed | ||||
| ausp_new | CLAUSPNEW | AUSP new | ||||
| effe_act | CLEFFEACT | ECH (parameter) | ||||
| effe_datum | DATUM | Date | ||||
| aedikzcls | AEDIKZCLS | ECH (time) | ||||
| aediclscreate | AEDICLSCREATE | ECH create | ||||
| aediclschange | AEDICLSCHANGE | ECH change | ||||
| aedichgcre | AEDICHGCRE | ECH create/change | ||||
| aediclsfromstatu | AEDICLSFROMSTATUS | ECH from status | ||||
| aedifromstatus | AEDIFROMSTATUS | ECH from status | ||||
| ausp_gen | CLAUSP_GEN | Gen. tables |
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.
-- Class Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCLA (
MANDT, -- Client [MANDT]
KLART, -- Class Type [KLASSENART]
OBTAB, -- Table [TABELLE]
SWOFL, -- Keywords [SWORKENNZ]
SMEFL, -- Characteristics [SACHMKENNZ]
DOKFL, -- Documents [DOKUKENNZ]
TXTFL, -- Texts [TEXTKENNZ]
DINFL, -- Stds data [DINBUKENNZ]
STAND, -- Std Class Type [KLARTST]
MFKLS, -- Multiple class. [MEHRFACHKL]
TRACL, -- Master record [TRANSCL]
VARKLART, -- Var. class type [VARKLART]
MULTOBJ, -- Multiple objs [MULTOBJ]
KONFOBJ, -- Config. object [KONFOBJ]
INTKLART, -- Int. class type [INTKLART]
AEBLGZUORD, -- Change Docs [CLAEBZUORD]
AEDIEZUORD, -- ECH (time) [CLAEDIZUOR]
MIGRATION, -- Distribution [CLMIGRATIO]
HIERARCHIE, -- Hier. allowed [CLHIER]
AUSP_NEW, -- AUSP new [CLAUSPNEW]
EFFE_ACT, -- ECH (parameter) [CLEFFEACT]
EFFE_DATUM, -- Date [DATUM]
AEDIKZCLS, -- ECH (time) [AEDIKZCLS]
AEDICLSCREATE, -- ECH create [AEDICLSCREATE]
AEDICLSCHANGE, -- ECH change [AEDICLSCHANGE]
AEDICHGCRE, -- ECH create/change [AEDICHGCRE]
AEDICLSFROMSTATU, -- ECH from status [AEDICLSFROMSTATUS]
AEDIFROMSTATUS, -- ECH from status [AEDIFROMSTATUS]
AUSP_GEN, -- Gen. tables [CLAUSP_GEN]
PRIMARY KEY (MANDT, KLART)
);
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