SAP TECS Master Effectivity Object Table data and field list

TECS is a standard SAP Table which is used to store Master Effectivity Object data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TECS table consists of various fields, each holding specific information or linking keys about Master Effectivity Object data available in SAP. These include TECHS (Parameter Variant/Standard Variant), ANDAT (Date record created on), ANNAM (User who created record), DATE_LO (Date - lower limit)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

TECS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = TECT

SAP TECS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TECS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
TECHS	Parameter Variant/Standard Variant	TECHS	CHAR	12			TECHS
ANDAT	Date record created on	CC_ANDAT	DATS	8			CC_DATUM
ANNAM	User who created record	CC_ANNAM	CHAR	12			CC_USNAM
DATE_LO	Date - lower limit	CC_DATE_LO	DATS	8			CC_DATUM
DATE_HI	Date - upper limit	CC_DATE_HI	DATS	8			CC_DATUM
DATE_OI	Date - open interval	CC_DATE_OI	CHAR	1			CC_XFELD
MATNR_LO	Material number - lower limit	CC_MATNR_LO	CHAR	18		MATN1	CC_MATNR	MAT
SERNR_LO	Serial number - lower limit	CC_SERNR_LO	CHAR	18		ALPHA	CC_GERNR
SERNR_HI	Serial number - upper limit	CC_SERNR_HI	CHAR	18		ALPHA	CC_GERNR
PRODUCT_LO	Internal Number (GUID) for Product	CC_PRODUCTID_LO	CHAR	22			CC_PRODUCTID
CLASS_LO	Class number	KLASSE_D	CHAR	18			KLASSE	KLA
CLASSTY_LO	Class Type	KLASSENART	CHAR	3	Assigned to domain		KLASSENART	KAR
PLANT_LO	Plant	CC_WERKS_D	CHAR	4	Assigned to domain		CC_WERKS		CC_WERKS
STARTUP_LO	Start-Up Parameters for Effectivity	CC_STARTUP	CHAR	30		ALPHA	CC_STARTUP
LOCNO_LO	Internal location number (customer, supplier or plant)	CC_LOCID_LO	CHAR	22			CC_LOCID
SERNR_OI	Serial number - indicator	CC_SERNR_OI	CHAR	1			CC_XFELD
TABNAME	Table Name	TABNAME	CHAR	30	Assigned to domain		AS4TAB	DTB
OBJKY	Object key	CC_OBJKY	CHAR	50			CHAR50
TECHU	Original technical status	CC_TECHU	CHAR	12			TECHS
TECHO	Technical status for original	CC_TECHO	CHAR	12			TECHS

Key field

Non-key field

< TECRMMKT_F - Flyers/Standard Texts for Campaign TECST - Account Groups for Ref. Customers in IS-U >

How do I retrieve data from SAP table TECS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TECS to SELECT all data from the table
DATA: WA_TECS TYPE TECS.

SELECT SINGLE *
FROM TECS
INTO CORRESPONDING FIELDS OF WA_TECS
WHERE...

How to access SAP table TECS

Within an ECC or HANA version of SAP you can also view further information about TECS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).