TCLA
Klassenarten
TCLA is an SAP database table in S/4HANA. Klassenarten. It contains 29 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| 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_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.
-- Klassenarten
-- 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