ESH_S_DOCINFORECORD

Search view -DOCINFORECORD | view: ESH_U_DOCINFOREC | Extraction: Not supported | Component: Document Management System
Tables used: DRAT, DRAP, /PLMB/AUTH_OBSID, /PLMB/AUTH_SIDRP, ESH_SR_LTXT, DMS_DOC2LOIO, DMS_PHIO2FILE, DMS_PH_CHKO_CD1, DRAD, AENR, CABN, CABNT, CAWN, CAWNT, KLAH, SWOR, SWOR, AUSP, KSSK, DMS_LODESC_CD1, TBRG, TBRGT, TDWS, TDWST, TDWA, TDWAT, T024L, T024X, DRAW, ESH_FL_FTASK, HRP7600, T001W, /PLMB/RCP_TY_GEN, ESTRH, /PLMB/SAM_NODE_T, USR21, CLF_HDR, DOST, DRAW, DRAW_LAST_CHANGE, DMS_DOC_FILES, DMS_PHF_CD1, DMS_PH_CD1, DRAD_LAST_CHANGE, /PLMB/RCP_RECIPE, /PLMI/SPC_TYPVAL
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DOCUMENTINFORECORDSTSFILELGDTE Date
CLASSIFICATIONENDDATE Valid-to date
CHARACTERISTICENDDATE Valid-to date
CLASSIFICATIONSTARTDATE Valid-From Date
CHARACTERISTICSTARTDATE Valid-From Date
Column Name Description
ISDOCINFORECDCREATEDFROMCAD CAD Indicator Show values
Column Name Description Domain name
AUTHORIZATIONGROUP Authorization Group BEGRU
AUTHORIZATIONGROUPNAME Description
CADSTATUSDESCRIPTION Short Text for Fixed Values
CHANGEDBY Last Changed By CHAR12
CHANGEDDATETIME Time last change was made
OBJECTLINKCHANGENUMBER Change Number
DOCUMENTINFORECORDCHANGENUMBER Change Number AENNR
CHARACTERISTIC Characteristic Name ATNAM
CHARCDESCRIPTION Characteristic Description TEXT30
CHARCFROMNUMERICVALUE Internal floating point from FLTP
CHARCINTERNALID Characteristic Internal ID ATINN_NO_CONV
CHARCVALUE Characteristic Value ATWRT
CHARCVALUEDESCRIPTION Characteristic value description ATWRT
CLASSIFICATIONCLASS Class number KLASSE
CLASSDESCRIPTION Class Description TEXT40
CLASSKEYWORDTEXT Keywords TEXT40
CLFNSTATUS Classification status CHAR1
CREATEDBYUSER Document Creator's Name CHAR12
CREATEDBYUSERDESCRIPTION User Description
CREATIONDATE Time Document Was Created
DELETESTATUSDESCRIPTION Short Text for Fixed Values
DOCINFORECDISMARKEDFORDELETION Deletion Indicator
DOCINFORECDRESERVEFIELD1 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD2 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD3 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD4 Reserve Field DRAW CHAR14
DOCUMENTDESCRIPTION Document Description
DOCUMENTINFORECORD Document Info Record key in concatenated form
DOCUMENTINFORECORDDOCNUMBER Document number DOKNR
DOCUMENTINFORECORDDOCPART Document Part DOKTL
DOCUMENTINFORECORDDOCVERSION Document Version
DOCUMENTSTATUSNAME Description of document status
DOCUMENTTYPEDESCRIPTION Description of Document Type TEXT20
EXTERNALDOCUMENTSTATUS Status of a document (language-dependent) CHAR2
FILEDESCRIPTION Short Description TEXT64
FILENAME null
LABORATORYORDESIGNOFFICENAME Description of the laboratory/engineering office
LASTCHANGEDBYUSERDESCRIPTION User Description
LINKEDSAPOBJECTKEY Document Management Object Key OBJKY
LOGACCMCONTEXT Context CHAR24
PHYSDOCCNTNTTEXT Plain text ESH_D_FL_PLAIN_TEXT
OBJECTLINKLONGTEXT Long Text
PLANTNAME Plant Name TEXT30
RECIPE Recipe ID CHAR20
RESPONSIBLEPERSONNAME Name of Person Responsible
SPECIFICATION Specification /PLMB/SPC_EXT_ID_API
USERDESCRIPTION User Description SUIDTECHDESC
WORKSTATIONAPPLICATION Application DAPPL
Master Data Relations Join Conditions
Class Type
  • Class Type
  • Client
  • ESH_S_DOCINFORECORD.CLASSIFICATIONCLASSTYPE == TCLA.KLART
  • ESH_S_DOCINFORECORD.MANDT == TCLA.MANDT
Class Number
  • Client
  • Internal Class Number
  • ESH_S_DOCINFORECORD.MANDT == KLAH.MANDT
  • ESH_S_DOCINFORECORD.CLASSINTERNALID == KLAH.CLINT
Document Type
  • Document Type
  • Client
  • ESH_S_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWA.DOKAR
  • ESH_S_DOCINFORECORD.MANDT == TDWA.MANDT
Document Status
  • Document Type
  • Client
  • Document Status
  • ESH_S_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWS.DOKAR
  • ESH_S_DOCINFORECORD.MANDT == TDWS.MANDT
  • ESH_S_DOCINFORECORD.INTERNALDOCUMENTSTATUS == TDWS.DOKST
Lab/Office
  • Client
  • Laboratory/design office
  • ESH_S_DOCINFORECORD.MANDT == T024L.MANDT
  • ESH_S_DOCINFORECORD.LABORATORYORDESIGNOFFICE == T024L.LABOR
Plant
  • Client
  • Plant
  • ESH_S_DOCINFORECORD.MANDT == T001W.MANDT
  • ESH_S_DOCINFORECORD.PLANT == T001W.WERKS
Category for physical documents ESH_S_DOCINFORECORD.STORAGECATEGORY == SDOKSTCAE.STOR_CAT
Other Relations | to Master Data Relations ↑ Join Conditions
Linked SAP Object
  • Document Type
  • Linked SAP Object
  • Client
  • ESH_S_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWO.DOKAR
  • ESH_S_DOCINFORECORD.LINKEDSAPOBJECT == TDWO.DOKOB
  • ESH_S_DOCINFORECORD.MANDT == TDWO.MANDT