CDS Views for Document Management System (CA-DMS)

CDS View NameDescriptionSQL View Name
A_DOCINFORECDOBJLINKBOMBill of Material Object LinksADIROBJBOM
A_DOCINFORECDOBJLINKCHGRECDChange Record Object LinksADIROBJCR
A_DOCINFORECDOBJLINKPRODUCTProduct Object LinksADIRPROD
A_DOCUMENTINFORECORDDocument Info RecordADIRHDR
A_DOCUMENTINFORECORDATTCHAttachments for Document Info RecordADIRATTCH
A_DOCUMENTINFORECORDDESCDocument Info Record DescriptionADIRDESC
A_DOCUMENTINFORECORDDOCSTSVHDocument Status Value HelpADIRSVH
C_DOCINFORECDDocument Info Record Header DetailsCCVDOCINFORECD
C_DOCINFORECDATTCHDETFORBUSOBJDocumentInfoRecord file details for BOCCVOBJFILES
C_DOCINFORECDOBJECTLINKDocument Info Record Object Link DetailsCCVDOCOBJLNK
C_DOCINFORECDOBJLINKATTCHDETDocumentInfoRecord ObjLink Attach DetailCCVDOCOBJATTCHDE
C_DOCINFORECDORIGINALSTATUSDocument Info Record Original StatusCCVDOCORIGSTAT
C_DOCUMENTINFORECDVERSDocument Info Record VersionCDOCINFORECVERS
C_DOCUMENTINFORECORDDELINDConsumption View for IndicatorCDOCINFORECIND
C_DOCUMENTINFORECORDDESCTPDocument Info Record Description TPCDOCINFRECDESC
C_DOCUMENTINFORECORDDESCVHDocument Info Record Description VHCDIRDESCVH
C_DOCUMENTINFORECORDOBJLINKTPDocument Info Record Object Link TPCDOCINFRECOBJ
C_DOCUMENTINFORECORDSTATUSVHDocument Info Record Status VHCDIRSTATUSVH
C_DOCUMENTINFORECORDTPDocument Info Record TPCDOCINFRECD
C_DOCUMENTINFORECORDVERSIONDocument Info Record Version FacetCDOCINFORECVER
ESH_N_DOCINFORECORDAnchor view -DOCINFORECORDESH_L_DOCINFOREC
ESH_S_DOCINFORECORDSearch view -DOCINFORECORDESH_U_DOCINFOREC
ESH_S_DOCUMENT_ATTACHMENTDocument File ModelESHDOCATTACH
I_DOCINFORECDDocument Info Record DetailsICVDOCINFORECD
I_DOCINFORECDATTCHDETFORBUSOBJDocuments with files for Business ObjectICVOBJFILES
I_DOCINFORECDAUTHGROUPAuthorization Group DetailsICVAUTHGRP
I_DOCINFORECDAUTHGRPTEXTAuthorization Group DescriptionICVAUTHGRPTEXT
I_DOCINFORECDBOMLINKDocument Info Record For BOMICVDIRBOMLINK
I_DOCINFORECDBUSOBJATTACHCNTNTDIR Business Object Attachment ContentICVDOCBUSOBJATCN
I_DOCINFORECDCADSTATUSDocument Info Record CAD StatusICVDOCCAD
I_DOCINFORECDCADSTATUSTEXTCAD Status DescriptionICVCADSTATTEXT
I_DOCINFORECDDELETESTATUSDocument Info Record Delete StatusICVDOCDELETE
I_DOCINFORECDDELETESTATUSTEXTDelete Status DescriptionICVDELSTATTEXT
I_DOCINFORECDDESCRIPTIONDocument Info Record DescriptionICVDOCINFRECDESC
I_DOCINFORECDDOCNMBRSTDVHDocument Info Record Document NumberICVDOCNMBR_VH
I_DOCINFORECDDOCPRTSTDVHDocument Info Record Document PartICVDOCPRT_VH
I_DOCINFORECDDOCTYPESTDVHDocument Info Record Document TypeICVDOCTYPE_VH
I_DOCINFORECDDOCUMENTPARTDocument Part Value HelpICVDOCUMENTPART
I_DOCINFORECDDOCUMENTSTATUSDocument StatusICVDOCUMENSTATUS
I_DOCINFORECDDOCUMENTTYPEDocument Type Value HelpICVDOCUMENTTYPE
I_DOCINFORECDDOCUMENTTYPETEXTDocument Type DescriptionICVDOCUTYPETEXT
I_DOCINFORECDDOCUMENTVERSIONDocument Version Value HelpICVDOCVERSION
I_DOCINFORECDDOCVERSSTDVHDocument Info Record Document VersionICVDOCVERS_VH
I_DOCINFORECDINDICATORSTATUSDocument Indicator StatusICVDOCINDISTATUS
I_DOCINFORECDINDISTATUSTEXTDocument Indicator Status DescriptionICVDOCINDSTATXT
I_DOCINFORECDLABOFFICELaboratory Design OfficeICVLABOFFICE
I_DOCINFORECDLABOFFICETEXTLaboratory Design Office DescriptionICVLABOFFICETEXT
I_DOCINFORECDNUMBERDocument Info Record Value HelpICVDOCINFRECDNUM
I_DOCINFORECDOBJECTLINKDocument Info Record Object Link DetailsICVDOCOBJLINK
I_DOCINFORECDOBJECTLINKCOUNTObject Link CountICVDOCOBJCNT
I_DOCINFORECDOBJECTLINKTEXTObject Link DescriptionICVDOCOBJLNKDESC
I_DOCINFORECDOBJLINKATTCHDETDocumentInfoRecord ObjLink Attach DetailICVDOCOBJATTCHDE
I_DOCINFORECDOBJLINKBOMDIR Object Link Bill Of MaterialIDIROBJBOM
I_DOCINFORECDOBJLINKBOMTPDoc Info Recd Obj Link BOM TPIDIROBJBOMWODRTP
I_DOCINFORECDOBJLINKCHGRECDDIR Object Link Change RecordIDIROBJCHGREC
I_DOCINFORECDOBJLINKCHGRECDTPCDS View for Change Record Object LinkIDOCOBJCRWODRTP
I_DOCINFORECDOBJLINKPRODTPDoc Info Recd Obj Link Prod TPIDIROBJPRDWODRTP
I_DOCINFORECDOBJLINKPRODUCTDocument Info Record Object Link ProductIPRODOBJLNK
I_DOCINFORECDOBJLINKSTDVHDocument Info Record ObjectLinkValueHelpICVDOCOBJLINK_VH
I_DOCINFORECDOBJTYPETODOCTYPEDocument types associated to object typeICVDOCTYPEOBJ
I_DOCINFORECDORIGCHKOUTUSEROriginals Checked Out User DetailsICVDOCORIGSTACHK
I_DOCINFORECDORIGINALDocument Original DetailsICVDOCUORIGINAL
I_DOCINFORECDSTATUSOFORIGINALOriginal Status ValuesICVDOCORIGSTATUS
I_DOCINFORECDSTATUSOFORIGTEXTOriginal Status DescriptionICVORIGSTATUSTXT
I_DOCINFORECDSTATUSSEARCHHELPDocument Status Search HelpICVDOCSTATUSHELP
I_DOCINFORECDSTATUSTEXTDocument Status DescriptionICVDOCSTATUSTEXT
I_DOCINFORECDSTRUCTSTATUSTEXTDocument Structure DescriptionICVSTRUCSTATTXT
I_DOCINFORECDSTRUCTUREDocument Structure Header DetailsICVDOCSTRUCT
I_DOCINFORECDSTRUCTUREITEMDocument Stucture Item DetailsICVDOCSTRUCTITEM
I_DOCINFORECDSTRUCTURESTATUSDocument StructureICVDOCSTRUC
I_DOCINFORECORDATTCHSWITHCNTNTDocument Info Record Attachment (ESH)ICVDOCATTACHCNTN
I_DOCINFORECORDDESCRIPTIONTPCDS TP View for Doc Info Record DescIDIRDESCWODRTP
I_DOCINFORECORDOBJLINKADDLINFODocument Info Record Object Link ( ESH )ICVDOCINFORECOLN
I_DOCINFORECORDTPCDS TP View for Document Info RecordIDIRHDRWODRTP
I_DOCUMENTINFORECORDDocument Info Record DetailsICVDOCINFOREC
I_DOCUMENTINFORECORDATTACHMENTDocument Info Record AttachmentICVDOCATTACH
I_DOCUMENTINFORECORDATTCHDocument Info Record for AttachmentICVDOCATT
I_DOCUMENTINFORECORDATTCHSTSDocument Info Record Attachment StatusICVDOCATTCHSTS
I_DOCUMENTINFORECORDATTCHSTSTDocument Info Record Attach Status TextICVDOCATTCHSTST
I_DOCUMENTINFORECORDAUTHZNGRPDocument Info Record Authorization GroupICVDOCAUTHGRP
I_DOCUMENTINFORECORDAUTHZNGRPTDocument Info Record Authzn Group TextICVDOCAUTHGRPT
I_DOCUMENTINFORECORDCADSTSDocument Info Record CAD StatusICVDOCCADSTS
I_DOCUMENTINFORECORDCADSTSTDocument Info Record CAD Status TextICVDOCCADSTSTEXT
I_DOCUMENTINFORECORDCNTNTMGMTDocument Info Record Content ManagementICVDOCCNTNTMGMT
I_DOCUMENTINFORECORDDELTNSTSDocument Info Record Delete StatusICVDOCDELTNSTS
I_DOCUMENTINFORECORDDELTNSTSTDelete Status DescriptionICVDOCDELSTSTEXT
I_DOCUMENTINFORECORDDESCDocument Info Record DescriptionICVDOCDESC
I_DOCUMENTINFORECORDDESCTPDocumentInfoRecdDescriptionTransactionalICVDOCDESCTP
I_DOCUMENTINFORECORDDOCNUMBERDocument Info Record Document NumberICVDOCNUMBER
I_DOCUMENTINFORECORDDOCPRTDocument Info Record Document PartICVDOCPRT
I_DOCUMENTINFORECORDDOCPRTVHDocument Info Record Document Part VHICVDOCPRTVH
I_DOCUMENTINFORECORDDOCSTATUSDocument Info Record Document StatusICVDOCSTATUS
I_DOCUMENTINFORECORDDOCSTATUSTDocument Info Record Document StatusTextICVDOCSTATUST
I_DOCUMENTINFORECORDDOCSTSVHDocument Info Record StatusValueHelpICVDOCSTSVH
I_DOCUMENTINFORECORDDOCTYPEDocument Info Record Document TypeICVDOCTYPE
I_DOCUMENTINFORECORDDOCTYPETDocument Info Record Document Type TextICVDOCTYPETEXT
I_DOCUMENTINFORECORDDOCTYPEVHDocument Info Record Document Type VHICVDOCTYPEVH
I_DOCUMENTINFORECORDDOCVERSIONDocument Info Record Document VersionICVDOCUMENTVERS
I_DOCUMENTINFORECORDDOCVERSVHDocument Info Record Document Version VHICVDOCVERSVH
I_DOCUMENTINFORECORDINDSTSDocument Indicator StatusICVDOCINDSTS
I_DOCUMENTINFORECORDINDSTSTDocument Indicator Status DescriptionICVDOCINDSTSTEXT
I_DOCUMENTINFORECORDLBTRYOFFCDocument Info Record Laboratory OfficeICVDOCLBTRYOFFC
I_DOCUMENTINFORECORDLBTRYOFFCTDocument Info Record Laboratory Offc TxtICVDOCLBTRYOFFCT
I_DOCUMENTINFORECORDOBJECTLINKDocument Info Record Object LinkICVDOCOBJECTLINK
I_DOCUMENTINFORECORDOBJLINKCNTDocument Info Record Object Link CountICVDOCOBJLINKCNT
I_DOCUMENTINFORECORDOBJLINKTDocument Info Record Object Link TextICVDOCOBJLINKT
I_DOCUMENTINFORECORDOBJLINKTPObject Link Transactional ViewICVDOCOBJLINKTP
I_DOCUMENTINFORECORDOBJLINKVHDocument Info Record ObjectLinkValueHelpICVDOCOBJLINKVH
I_DOCUMENTINFORECORDRESERVEDocument Info Record Reserved fieldsICVDOCINFORECRES
I_DOCUMENTINFORECORDSRCHMODELDocument Info Record ( ESH )ICVDOCINFRCSRCHM
I_DOCUMENTINFORECORDSTRUCSTSDocument Info Record Structure StatusICVDOCSTRUCSTS
I_DOCUMENTINFORECORDSTRUCSTSTDocument Info Record Struc Status TextICVDOCSTRUCSTST
I_DOCUMENTINFORECORDSTSLOGDocument Info Record Status Log (ESH)ICVDOCSTSLOG
I_DOCUMENTINFORECORDTPDocument Info Record TransactionalICVDOCINFORECTP
I_DOCUMENTINFORECORDUSERSTDVHDocument Info Record User Value HelpICVDOCUSR_VH
I_DOCUMENTINFORECORDUSERVHDocument Info Record User Value HelpICVDOCUSRVH
P_DOCINFORECDDocument Info RecordsPCVDOCINFORECD
P_DOCINFORECDBOMLINKDocument Info Records For The Bill Of MaterialsPCVDIRBOMLINK
P_DOCINFORECDOBJECTLINKObject Links For Document Info RecordsPCVDIROBJLINK
P_DOCINFORECDORIGINALOriginals Of Document Info RecordsPCVORIGINAL
P_DOCUMENTINFORECORDDocument Info Record DetailsPCVDOCINFOREC
P_DOCUMENTINFORECORDATTACHMENTDocument Info Record AttachmentPCVDOCATTACH
P_DOCUMENTINFORECORDCALCFIELDSDocument Info Record Calculation FieldPDOCINFORECCALC
P_DOCUMENTINFORECORDOBJECTLINKDocument Info Record Object LinkPCVDOCOBJLINK
SHSM_DMS_USERUser Value HelpSHSMDMSUSER
SHSM_DRADCDS view for search help of DRAD tableSHSMDRAD
SHSM_DRAD_DRAWValue help for search help CV01OSHSMDRADDRAW
SHSM_DRATCDS view for search help CV01TSHSMDRAT
SHSM_DRAT_DOSTCDS view for search help CV01BSHSMDRATDOST
SHSM_DRAWCDS View for DRAW TableSHSMDRAW
SHSM_TDWASearch help for TDWA tableSHSMTDWA

Other CDS Views