SAP EDESK_DOCUMENT Engineering Desktop: Document Data Structure Table data and field list

EDESK_DOCUMENT 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 "Engineering Desktop: Document Data Structure" 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_EDESK_DOCUMENT TYPE EDESK_DOCUMENT.

The EDESK_DOCUMENT table consists of various fields, each holding specific information or linking keys about Engineering Desktop: Document Data Structure data available in SAP. These include GUID_IDENT (Character field, 8 characters long), GUID_PARENT (Character field, 8 characters long), OBJECT_ID (Internal Object Identification in Engineering Desktop), DOCUMENTTYPE (Document Type)... 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. .

EDESK_DOCUMENT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP EDESK_DOCUMENT 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 EDESK_DOCUMENT 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
ILEVEL	Explosion Level of Allowed Configuration	EDESK_LEVEL	INT1	3			INT1
GUID_IDENT	Character field, 8 characters long	CHAR8	CHAR	8			CHAR8
GUID_PARENT	Character field, 8 characters long	CHAR8	CHAR	8			CHAR8
OBJECT_ID	Internal Object Identification in Engineering Desktop	EDESK_OBJECT_ID	INT4	10			TABIX
DOCUMENTTYPE	Document Type	DOKAR	CHAR	3	Assigned to domain		DOKAR	CV2
DOCUMENTNUMBER	Document number	DOKNR	CHAR	25	Assigned to domain	ALPHA	DOKNR	CV1
DOCUMENTVERSION	Document Version	DOKVR	CHAR	2			DOKVR	CV3
DOCUMENTPART	Document Part	DOKTL_D	CHAR	3			DOKTL	CV4
DOCUMENTID_EXT	External Document Key in Engineering Desktop	EDESK_DOCID_EXT	CHAR	36
DESCRIPTION	Document description	DKTXT	CHAR	40			TEXT40
USERNAME	Name of person responsible	DWNAM	CHAR	12			DWNAM
STATUSEXTERN	Status of a document (language-dependent)	STABK	CHAR	2			CHAR2
STATUSINTERN	Document Status	DOKST	CHAR	2	Assigned to domain		DOKST
STATUSLOG	Document management log field	PROTF	CHAR	20			PROTF
LABORATORY	Laboratory/design office	LABOR	CHAR	3	Assigned to domain		LABOR
ECNUMBER	Change Number	DAENR	CHAR	12	Assigned to domain	AENNR	AENNR
ACC_EXT	Character field length 24	CHAR24	CHAR	24			CHAR24
VALIDFROMDATE	Valid-From Date	CCDAT	DATS	8			CC_DATUM
REVLEVEL	Revision Level	REVLV	CHAR	2		NUMCV	REVLV	RVS
DELETEINDICATOR	Deletion indicator	LOEDK	CHAR	1			XFELD
CADINDICATOR	CAD Indicator	CADKZ	CHAR	1			XFELD
STRUCTUREINDICATOR	Document Management Flag	CVFLAG	CHAR	1			CHAR1
PARENTDOCUMENTTYPE	Document Type	DOKAR	CHAR	3	Assigned to domain		DOKAR	CV2
PARENTDOCUMENTNUMBER	Document number	DOKNR	CHAR	25	Assigned to domain	ALPHA	DOKNR	CV1
PARENTDOCUMENTVERSION	Document Version	DOKVR	CHAR	2			DOKVR	CV3
PARENTDOCUMENTPART	Document Part	DOKTL_D	CHAR	3			DOKTL	CV4
AUTHORITYGROUP	Authorization Group	BEGRU	CHAR	4			BEGRU
WSAPPLICATION	Application	DAPPL	CHAR	3	Assigned to domain		DAPPL
USERDEFINED1	Reserve field DRAW	RESDRAW	CHAR	14			CHAR14
USERDEFINED2	Reserve field DRAW	RESDRAW	CHAR	14			CHAR14
USERDEFINED3	Reserve field DRAW	RESDRAW	CHAR	14			CHAR14
USERDEFINED4	Reserve field DRAW	RESDRAW	CHAR	14			CHAR14
CREATEDATE	Output date for document	ADATUM	DATS	8			DATUM
REFDOCUMENTNUMBER	Document Number of Source Document	DOKNR_VL	CHAR	25	Assigned to domain	ALPHA	DOKNR
REFDOCUMENTPART	Document part of source document	DOKTL_VL	CHAR	3			DOKTL
REFDOCUMENTVERSION	Document version of source document	DOKVR_VL	CHAR	2			DOKVR
CMFIXED	Document fixed	DMS_CM_FIXED	CHAR	1			XFELD
CMRELEVANCE	Relevant for Configuration Management	DE_CM_RELEVANCE_FLAG	CHAR	1			DO_CM_RELEVANCE_FLAG
FLG_STKO	General Flag	FLAG	CHAR	1			FLAG
LATEST_VERSION	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
NO_DIR	General Flag	FLAG	CHAR	1			FLAG
CAD_MODIFIED	General Flag	FLAG	CHAR	1			FLAG
CAD_DATE	Time of change (UTC)	SDOK_CHTST	NUMC	14		TSTLC	SDOK_TSTMP
ORIGINALTYPE	Application number	DMS_APPNR	CHAR	5			CHAR5
STORAGECATEGORY	Storage category for original files	CV_STORAGE_CAT	CHAR	10			CHAR10
DOCPATH	Directory Name in Engineering Desktop	EDESK_FILEPATH	CHAR	255			EDESK_FILENAME
DOCFILE	File Name in Engineering Desktop	EDESK_FILENAME	CHAR	255			EDESK_FILENAME
APPLICATION_ID	Logical document	SDOK_LOID	CHAR	32			SDOK_DOCID
FILE_ID	Physical document	SDOK_PHID	CHAR	32			SDOK_DOCID
LANGUAGE	Language Key	SPRAS	LANG	1	Assigned to domain	ISOLA	SPRAS	SPR	H_T002
CHECKEDIN	Document is cheked In	DMS_BAPI_CHECKEDIN	CHAR	1			XFELD
ACTIVE_CONTENT_VERSION	Active version of the original	CV_FILE_ACT_VERSION	CHAR	1			XFELD
CREATED_AT	Time of change (UTC)	SDOK_CHTST	NUMC	14		TSTLC	SDOK_TSTMP
CHANGED_AT	Time of change (UTC)	SDOK_CHTST	NUMC	14		TSTLC	SDOK_TSTMP
MATERIAL	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
MATERIAL_LONG	External Long Material Number	MATNR_EXT	CHAR	40		MATNL	MATNR_EXT
MATDESCRIPTION	Material Description (Short Text)	MAKTX	CHAR	40			TEXT40
MATERIALX	Checkbox	XFELD	CHAR	1			XFELD
DOSTX	Description of document status	DOSTX	CHAR	16			TEXT16
DOSAR	Document status type	DOSAR	CHAR	1			DOSAR
FRKNZ	Indicator: released	FRKNZ	CHAR	1			XFELD
COPYLINKS	Criterion for Type of Copying of Object Links	EDESK_COPYLINKS	INT1	3			EDESK_COPYLINKS
DISKEY	Short Form of Document Key Fields	EDESK_DISKEYS	CHAR	40
OBJECT_TYPE	CAD Object Type	EDESK_OBJ_TYPE	CHAR	14
REL_TYPE	Type of Relationship Between CAD Documents (Sort Field)	EDESK_RELATION_TYPE	CHAR	10
QUANTITY	Quantity	EDESK_QUANT	INT4	10			INT4
QUANTITY_UNIT	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
QUANTITY_UNIT_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3	Assigned to domain		ISOCD_UNIT
IS_EXPANDABLE	Replacement for Real Boolean Type: 'X' == True ' ' == False	EDESK_BOOLEAN	CHAR	1			CHAR1
IS_SELECTED	Checkbox	XFELD	CHAR	1			XFELD
IS_CORRUPT	Replacement for Real Boolean Type: 'X' == True ' ' == False	EDESK_BOOLEAN	CHAR	1			CHAR1
IS_MISSING	Replacement for Real Boolean Type: 'X' == True ' ' == False	EDESK_BOOLEAN	CHAR	1			CHAR1
VIRTUAL	Checkbox	XFELD	CHAR	1			XFELD
GUID_REF	Row Index of Internal Tables	SYTABIX	INT4	10			SYST_LONG
TINDEX	Index in category table	TTIDX	INT4	10			TABIX
HEADOFSTRUCTURE	Checkbox	XFELD	CHAR	1			XFELD
RECALLOWED	Indicator: recursiveness allowed	REKRS	CHAR	1			XFELD
BOM_OBJECT_TYPE	Object Type of BOM/BOM Item	EDESK_BOM_OBJECT_TYPE	CHAR	16			EDESK_BOM_OBJECT_TYPE
BOM_OBJECT_ICON	BOM Icon	EDESK_BOM_ICON	CHAR	40
BOM_ID_EXT	External BOM Key in Engineering Desktop	EDESK_BOMID_EXT	CHAR	80
BOM_ID_INT	Internal BOM Key in Engineering Desktop	EDESK_BOMID_INT	CHAR	80
CHANGE_NO	Change Number	AENNR	CHAR	12	Assigned to domain	AENNR	AENNR	AEN
CREATION_DATE	Date record created on	ANDAT	DATS	8			DATUM
CREATION_BY	User who created record	ANNAM	CHAR	12			USNAM
CHANGE_DATE	Changed On	AEDAT	DATS	8			DATUM
CHANGE_BY	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
ACTION_STATE	Char 20	CHAR20	CHAR	20			CHAR20
CAD_PATH	Directory Name in Engineering Desktop	EDESK_FILEPATH	CHAR	255			EDESK_FILENAME
BOM_OBJ_SELECTED	Checkbox	XFELD	CHAR	1			XFELD
BOM_INDICATOR	BOM Indicator	EDESK_BOM_INDICATOR	CHAR	1			CHAR1
DISPL_LINK_TO_DRW	Replacement for Real Boolean Type: 'X' == True ' ' == False	EDESK_BOOLEAN	CHAR	1			CHAR1
HEADER_ID	Internal BOM Key in Engineering Desktop	EDESK_BOMID_INT	CHAR	80
CUOBJ	Configuration (internal object number)	CUOBJ	NUMC	18			CUOBJ	CUX
TECHS	Parameter Variant/Standard Variant	PPE_TECHS	CHAR	12			PPE_TECHS
POSNR	BOM Item Number	SPOSN	CHAR	4		NUMCV	SPOSN
POSTP	Item Category (Bill of Material)	POSTP	CHAR	1	Assigned to domain		POSTP
ITEM_NODE	BOM item node number	STLKN	NUMC	8			KNTNR
ITEM_COUNT	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
HAS_LIGHTWEIGHT	Component Has Lightweight Representation	/PLMB/EDESK_HAS_LIGHTWEIGHT	CHAR	1			XFELD
CHECKOUT_USER	Name of person responsible	DWNAM	CHAR	12			DWNAM
DRAWING_OUTDATED	Component Type for Outdated Drawing Checkbox	/PLMB/EDESK_DRW_OUTDATED	CHAR	1			XFELD
CLASSIFICATION_DATA				0
PVS_NODE_NAME	Node Name	/PLMB/PPE_NODE	CHAR	40			PVS_PNODE	PND
CLASS	Class number	KLASSE_D	CHAR	18			KLASSE	KLA
CLASS_TYPE	Class Type	KLASSENART	CHAR	3	Assigned to domain		KLASSENART	KAR
PVS_OBJECT_TYPE	Object Type of BOM/BOM Item	EDESK_BOM_OBJECT_TYPE	CHAR	16			EDESK_BOM_OBJECT_TYPE

Key field

Non-key field

< EDESK_DMUTMXPARAM_STRUC - Parameter Structure for DMU Transformation Matrix EDESK_DOCUMENT1 - Proxy Struktur (generiert) >

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

As EDESK_DOCUMENT 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 EDESK_DOCUMENT as there is no data to select.

How to access SAP table EDESK_DOCUMENT

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

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