SAP DICLDAT Characteristic valuation Table data and field list

DICLDAT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Characteristic valuation" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DICLDAT TYPE DICLDAT.

The DICLDAT table consists of various fields, each holding specific information or linking keys about Characteristic valuation data available in SAP. These include TABIX (Row Index of Internal Tables), POSNR (Item number), SMBEZ (Characteristic description), ZAEHL (Characteristic value counter)... 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. .

DICLDAT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP DICLDAT structure 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 DICLDAT 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
TABIX	Row Index of Internal Tables	SYTABIX	INT4	10			SYST_LONG
POSNR	Item number	KPOSNR	NUMC	3			NUM03
SMBEZ	Characteristic description	ATBEZ	CHAR	30			TEXT30
ZAEHL	Characteristic value counter	WZAEHL	NUMC	3			NUM3
OPER1	Operand for value from	OPERAND1	CHAR	2			CHAR2
AUSP1	Characteristic Value	ATWRT	CHAR	30			ATWRT
DIME1	Unit of Measure, Language-Dependent	ATEI6	CHAR	6			MSEH6
ATFLV	Internal floating point from	ATFLV	FLTP	16(16)			FLTP
OPER2	Operand for value to	OPERAND2	CHAR	2			CHAR2
AUSP2	To characteristic value	ATWRT2	CHAR	30			ATWRT
DIME2	Language-Dependent Unit of Measurement, Value To	ATEI62	CHAR	6			MSEH6
ATNAM	Characteristic Name	ATNAM	CHAR	30			ATNAM	FEA
INHER	Characteristic Is Inherited	MMERB	CHAR	1			XFELD
VCLINT	Superior class from which chars are inherited (int. number)	VCLINT	NUMC	10	Assigned to domain		CLINT
ATVGLART	Comparison Type for Char. Value: ' ' .. '7': Incl./Excl.	ATVGLART	CHAR	1			ATVGLART
ATZIS	Instance counter	ATZIS	NUMC	3			NUMC3
ATIMB	Characteristic Number of User-Defined Data Type	ATIMB	NUMC	10	Assigned to domain	ATINN	ATINN
EQUNR	Equipment Number	EQUNR	CHAR	18	Assigned to domain	ALPHA	EQUNR	EQN	EQUI
TPLNR	Functional Location	TPLNR	CHAR	30	Assigned to domain	TPLNR	TPLNR	IFL	IFLM
QMNUM	Notification No	QMNUM	CHAR	12	Assigned to domain	ALPHA	QMNUM	IQM
FENUM	Item Number in Item Record	FELFD	NUMC	4	Assigned to domain		FELFD
TRPNR	Reference functional location	TRPNR	CHAR	30	Assigned to domain		TRPNR	IRL	IRLM

Key field

Non-key field

< DICLASS - Class DICOM_CMOVEMSG - ISH*MED RAD: Structure with Fields for the DICOM C-MOVE >

How do I retrieve data from SAP structure DICLDAT using ABAP code?

As DICLDAT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DICLDAT as there is no data to select.

How to access SAP table DICLDAT

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

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

Related SAP tables and the relationships to DICLDAT

    DIEQUI - Equipment
        DIIHPA - Partner PM/QM
        DIINET - Object Link
        DIIMPT - Measuring Point: Output Structure for ABAP Lists
            DIIMRG - Measurement Doc.: Output Structure for ABAP Lists
        DIIHSG - Permits
        DIEQUZ - Equipment Usage Period
            DIIFLO - Functional Location
            DIQMEL - PM Notification
            DIAUFK - PM Order
        DICLASS - Class
            DICLDAT - Characteristic Valuation
        DIDRAD - Document

    RQMQMEL - Notifications - Header Data
        QMMACAT - Notifications - Activities
        QMSMCAT - Notifications - Tasks
        DIIHPA - Partner Table
        QMFECAT - Notifications - Defect Item
            QMMAPCAT - Notifications - Activities for Item
            QMSMPCAT - Notifications - Tasks for Item
            QMURCAT - Notifications - Causes
            QMFECLASS - Class of Notification Item
                DICLDAT - Characteristic Valuation

    DIINET - Object link
        DIEQUI - Equipment
        DIIFLO - Functional location
        DICLASS - Class
            DICLDAT - Characteristic valuation
        DIDRAD - Document

    DIQMEL - PM notification
        DIIHPA - Partner PM/QM
        DIQMSM - Notification tasks
        DIQMMAX - Activity for Notif.
        DIAUFK - PM order
        DIIFLO - Functional location
        DIEQUI - Equipment
        DIQMFE - PM notification item
            DIQMUR - Cause of notification item
            DIQMSMX - Tasks for notification item
            DIQMMA - Activities for notification item
            DICLASS - Class
                DICLDAT - Characteristic valuation

    RQMQMEL - Quality Notification - Header Data
        QMFECAT - Quality Notification - Defect Item
            QMFECLASS - Class of Notification Item
                DICLDAT - Characteristic Valuation
            QMURCAT - Quality Notification - Causes
            QMSMPCAT - Quality Notification - Tasks for Item
            QMMAPCAT - Quality Notification - Activities for Item
        DIIHPA - Partner PM/QM
        QMSMCAT - Quality Notification - Tasks
        QMMACAT - Quality Notification - Activities

    DIIRLO - Reference location
        DICLASS - Class
        DIIMPT_R - Reference Meas. Pt: Output Structure for ABAP List
        DIDRAD - Document
                DICLDAT - Characteristic valuation

    DIIFLO - Functional Location
        DIIHPA - Partner PM/QM
        DIINET - Object Link
        DIIMPT - Measuring Point: Output Structure for ABAP Lists
            DIIMRG - Measurement Doc.: Output Structure for ABAP Lists
        DIIHSG - Permits
        DIEQUZ - Equipment Usage Period
            DIEQUI - Equipment
        DIQMEL - PM Notification
        DIAUFK - PM Order
        DICLASS - Class
            DICLDAT - Characteristic Valuation
        DIDRAD - Document