SAP ABAP Table PLM_DOCUMENT (Document Data in CAD Desktop)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ CA-CAD (Application Component) CAD Integration
     ⤷ CDESK (Package) CAD Desktop

Basic Data

Table Category	INTTAB	Structure
Structure	PLM_DOCUMENT	Table Relationship Diagram
Short Description	Document Data in CAD Desktop

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DOCUMENTTYPE	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
2	DOCUMENTNUMBER	☐	DOKNR	DOKNR	CHAR	25	0	Document number	*
3	DOCUMENTVERSION	☐	DOKVR	DOKVR	CHAR	2	0	Document version
4	DOCUMENTPART	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
5	DESCRIPTION	☐	DKTXT	TEXT40	CHAR	40	0	Document description
6	USERNAME	☐	DWNAM	DWNAM	CHAR	12	0	Name of person responsible
7	STATUSEXTERN	☐	STABK	CHAR2	CHAR	2	0	Status of a document (language-dependent)
8	STATUSINTERN	☐	DOKST	DOKST	CHAR	2	0	Document Status	*
9	STATUSLOG	☐	PROTF	PROTF	CHAR	20	0	Document management log field
10	LABORATORY	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
11	ECNUMBER	☐	DAENR	AENNR	CHAR	12	0	Change Number	AENR
12	VALIDFROMDATE	☐	CCDAT	CC_DATUM	DATS	8	0	Valid-From Date
13	REVLEVEL	☐	REVLV	REVLV	CHAR	2	0	Revision level
14	DELETEINDICATOR	☐	LOEDK	XFELD	CHAR	1	0	Deletion indicator
15	CADINDICATOR	☐	CADKZ	XFELD	CHAR	1	0	CAD Indicator
16	STRUCTUREINDICATOR	☐	CVFLAG	CHAR1	CHAR	1	0	Document Management Flag
17	PREDOCUMENTNUMBER	☐	PRENR	DOKNR	CHAR	25	0	Document number of superior document	*
18	PREDOCUMENTVERSION	☐	PREVR	DOKVR	CHAR	2	0	Document version of superior document
19	PREDOCUMENTPART	☐	PRETL	DOKTL	CHAR	3	0	Document Part of Superior Document
20	PREDOCUMENTTYPE	☐	PREAR	DOKAR	CHAR	3	0	Document type of the superior document	*
21	AUTHORITYGROUP	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
22	DOCFILE1	☐	FILEP	TEXT255	CHAR	255	0	Original of document
23	DATACARRIER1	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	TDWD
24	WSAPPLICATION1	☐	DAPPL	DAPPL	CHAR	3	0	Application	TDWP
25	DOCFILE2	☐	FILEP	TEXT255	CHAR	255	0	Original of document
26	DATACARRIER2	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	TDWD
27	WSAPPLICATION2	☐	DAPPL	DAPPL	CHAR	3	0	Application	TDWP
28	VRLDAT	☐	VRLDAT	DATUM	DATS	8	0	Due Date
29	USERDEFINED1	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
30	USERDEFINED2	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
31	USERDEFINED3	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
32	USERDEFINED4	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
33	SAVEDOCFILE1	☐	FILEP	TEXT255	CHAR	255	0	Original of document
34	SAVEDATACARRIER1	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
35	SAVEDOCFILE2	☐	FILEP	TEXT255	CHAR	255	0	Original of document
36	SAVEDATACARRIER2	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
37	CREATEDATE	☐	ADATUM	DATUM	DATS	8	0	Output date for document
38	REFDOCUMENTNUMBER	☐	DOKNR_VL	DOKNR	CHAR	25	0	Document Number of Source Document	*
39	REFDOCUMENTPART	☐	DOKTL_VL	DOKTL	CHAR	3	0	Document part of source document
40	REFDOCUMENTVERSION	☐	DOKVR_VL	DOKVR	CHAR	2	0	Document version of source document
41	FILESIZE1	☐	ORLN	NUM12	NUMC	12	0	File length of original
42	FILESIZE2	☐	ORLN	NUM12	NUMC	12	0	File length of original
43	CMFIXED	☐	DMS_CM_FIXED	XFELD	CHAR	1	0	Document fixed
44	CMRELEVANCE	☐	DE_CM_RELEVANCE_FLAG	DO_CM_RELEVANCE_FLAG	CHAR	1	0	Relevant for Configuration Management
45	GUID_IDENT	☐	CSMSYSGUID	SYSUUID_C	CHAR	32	0	System GUID for ABAP Systems or Other Systems
46	GUID_PRED	☐	CSMSYSGUID	SYSUUID_C	CHAR	32	0	System GUID for ABAP Systems or Other Systems
47	LOCATION_IDENT	☐	LOCATION_BOM		CHAR	6	0	Item within a BOM
48	LOCATION_PRED	☐	LOCATION_BOM		CHAR	6	0	Item within a BOM
49	FLG_STKO	☐	FLAG	FLAG	CHAR	1	0	General Flag
50	COLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
51	ACTUAL_VERSION	☐	FLAG	FLAG	CHAR	1	0	General Flag
52	VIRTUAL	☐	FLAG	FLAG	CHAR	1	0	General Flag
53	MESSAGE	☐	BAPI_MSG	TEXT220	CHAR	220	0	Message Text
54	CAD_MODIFIED	☐	FLAG	FLAG	CHAR	1	0	General Flag
55	CAD_DATE	☐	SDOK_CHTST	SDOK_TSTMP	NUMC	14	0	Time of change (UTC)
56	DELETEVALUE	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
57	ORIGINALTYPE	☐	DMS_APPNR	CHAR5	CHAR	5	0	Application number
58	SOURCEDATACARRIER	☐	DTTRG	DTTRG	CHAR	10	0	Name of Data Carrier	*
59	STORAGECATEGORY	☐	CV_STORAGE_CAT	CHAR10	CHAR	10	0	Storage category for original files
60	WSAPPLICATION	☐	DAPPL	DAPPL	CHAR	3	0	Application	*
61	DOCPATH	☐	DMS_PATH	TEXT255	CHAR	255	0	Path for original file
62	DOCFILE	☐	FILEP	TEXT255	CHAR	255	0	Original of document
63	APPLICATION_ID	☐	SDOK_LOID	SDOK_DOCID	CHAR	32	0	Logical document
64	FILE_ID	☐	SDOK_PHID	SDOK_DOCID	CHAR	32	0	Physical document
65	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
66	CHECKEDIN	☐	DMS_BAPI_CHECKEDIN	XFELD	CHAR	1	0	Document is cheked In
67	ACTIVE_VERSION	☐	CV_FILE_ACT_VERSION	XFELD	CHAR	1	0	Active version of the original
68	CREATED_AT	☐	SDOK_CHTST	SDOK_TSTMP	NUMC	14	0	Time of change (UTC)
69	CHANGED_AT	☐	SDOK_CHTST	SDOK_TSTMP	NUMC	14	0	Time of change (UTC)
70	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
71	MATDESCRIPTION	☐	MAKTX	TEXT40	CHAR	40	0	Material description
72	MATERIALX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	DOSTX	☐	DOSTX	TEXT16	CHAR	16	0	Description of document status
74	DOSAR	☐	DOSAR	DOSAR	CHAR	1	0	Document status type
75	FRKNZ	☐	FRKNZ	XFELD	CHAR	1	0	Indicator: released
76	MESSAGE_TYPE	☐	BAPI_MTYPE	SYCHAR01	CHAR	1	0	Message type: S Success, E Error, W Warning, I Info, A Abort
77	MESSAGE_ID	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
78	MESSAGE_NUMBER	☐	SYMSGNO	SYMSGNO	NUMC	3	0	Message Number
79	COPYLINKS	☐	CDESK_COPYLINKS	COPYLINKS	INT1	3	0	Indicator for Type of Copy of Object Link
80	DISKEY	☐	CDESK_DISKEYS	CHAR40	CHAR	40	0	Short Form of Document Key Fields
81	DISPL_FILE_TYPE	☐	COPY_TEXT	TEXT14	CHAR	14	0	Title Text: Copy/Original
82	DISPL_STD_PART	☐	DISFLAG	CHAR001	CHAR	1	0	Flag for Display in ALVgrid
83	DISPL_CAD_TYPE	☐	COPY_TEXT	TEXT14	CHAR	14	0	Title Text: Copy/Original
84	OBJECT_TYPE	☐	CDESK_OBJ_TYPE	CHAR14	CHAR	14	0	CAD Object Type
85	REL_TYPE	☐	CDESK_RELATION_TYPE	CHAR10	CHAR	10	0	Type of Relationship Between CAD Documents (Sort Field)
86	QUANTITY	☐	INT4	INT4	INT4	10	0	Natural number
87	ACTION_NR	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
88	ACTION_STATE	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
89	IS_SELECTED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
90	NODE_REFRESH	☐	XFELD	XFELD	CHAR	1	0	Checkbox
91	CHECKED_IN_ICON	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
92	VERSION_ICON	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
93	OBJ_TYPE_ICON	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
94	GUID_REF	☐	CSMSYSGUID	SYSUUID_C	CHAR	32	0	System GUID for ABAP Systems or Other Systems
95	ACTUAL_ICON	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
96	INDEX	☐	TTIDX	TABIX	INT4	10	0	Index in category table
97	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	*
98	POSNR	☐	SPOSN	SPOSN	CHAR	4	0	BOM Item Number
99	ITEM_NODE	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
100	ITEM_COUNT	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
101	MATERIAL_ICON	☐	CHAR32	CHAR32	CHAR	32	0	Character field, length 32
102	REL_TYPE_ICON	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
103	NO_DISPLAY_AUTH	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
104	.INCLUDE	☐				0	0
105	.INCLUDE	☐				0	0	Document Info Record Fields CDesk PLM7
106	DUMMY	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PLM_DOCUMENT	DATACARRIER1	TDWD	DTTRG
2	PLM_DOCUMENT	DATACARRIER2	TDWD	DTTRG
3	PLM_DOCUMENT	DOCUMENTTYPE	TDWA	DOKAR
4	PLM_DOCUMENT	ECNUMBER	AENR	AENNR
5	PLM_DOCUMENT	LABORATORY	T024L	LABOR
6	PLM_DOCUMENT	WSAPPLICATION1	TDWP	DAPPL
7	PLM_DOCUMENT	WSAPPLICATION2	TDWP	DAPPL

History

Last changed by/on	SAP	20140121
SAP Release Created in	46C