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
⤷ 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 |