ESH_N_DOCINFORECORD

Anchor view -DOCINFORECORD | view: ESH_L_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, 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_LAST_CHANGE, DMS_DOC_FILES, DMS_PHF_CD1, DMS_PH_CD1, DRAD_LAST_CHANGE, /PLMB/RCP_RECIPE, /PLMI/SPC_TYPVAL
Column Name Description
DOCUMENTINFORECORDDOCNUMBER Document number
DOCUMENTINFORECORDDOCPART Document Part
DOCUMENTINFORECORDDOCTYPE FK Document Type
DOCUMENTINFORECORDDOCVERSION Document Version
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
DOCINFORECDISMARKEDFORDELETION Deletion Indicator Show values
ISDOCINFORECDCREATEDFROMCAD CAD Indicator Show values
Column Name Description Domain name
AUTHORIZATIONGROUP Authorization Group BEGRU
AUTHORIZATIONGROUPNAME Description TEXT20
CADSTATUSDESCRIPTION Short Text for Fixed Values DDTEXT
CHANGEDBY Last Changed By CHAR12
CHANGEDDATETIME Time last change was made TZNTSTMPS
OBJECTLINKCHANGENUMBER Change Number AENNR
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 SUIDTECHDESC
CREATIONDATE Time Document Was Created TZNTSTMPS
DELETESTATUSDESCRIPTION Short Text for Fixed Values DDTEXT
DOCINFORECDRESERVEFIELD1 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD2 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD3 Reserve Field DRAW CHAR14
DOCINFORECDRESERVEFIELD4 Reserve Field DRAW CHAR14
DOCUMENTDESCRIPTION Document Description TEXT40
DOCUMENTINFORECORD Document Info Record key in concatenated form
DOCUMENTSTATUSNAME Description of document status TEXT16
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 TEXT30
LASTCHANGEDBYUSERDESCRIPTION User Description SUIDTECHDESC
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 DWNAM
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_N_DOCINFORECORD.CLASSIFICATIONCLASSTYPE == TCLA.KLART
  • ESH_N_DOCINFORECORD.MANDT == TCLA.MANDT
Class Number
  • Internal Class Number
  • Client
  • ESH_N_DOCINFORECORD.CLASSINTERNALID == KLAH.CLINT
  • ESH_N_DOCINFORECORD.MANDT == KLAH.MANDT
Document Type
  • Document Type
  • Client
  • ESH_N_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWA.DOKAR
  • ESH_N_DOCINFORECORD.MANDT == TDWA.MANDT
Document Status
  • Document Type
  • Client
  • Document Status
  • ESH_N_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWS.DOKAR
  • ESH_N_DOCINFORECORD.MANDT == TDWS.MANDT
  • ESH_N_DOCINFORECORD.INTERNALDOCUMENTSTATUS == TDWS.DOKST
Lab/Office
  • Client
  • Laboratory/design office
  • ESH_N_DOCINFORECORD.MANDT == T024L.MANDT
  • ESH_N_DOCINFORECORD.LABORATORYORDESIGNOFFICE == T024L.LABOR
Plant
  • Client
  • Plant
  • ESH_N_DOCINFORECORD.MANDT == T001W.MANDT
  • ESH_N_DOCINFORECORD.PLANT == T001W.WERKS
Category for physical documents ESH_N_DOCINFORECORD.STORAGECATEGORY == SDOKSTCAE.STOR_CAT
Other Relations | to Master Data Relations ↑ Join Conditions
Linked SAP Object
  • Linked SAP Object
  • Document Type
  • Client
  • ESH_N_DOCINFORECORD.LINKEDSAPOBJECT == TDWO.DOKOB
  • ESH_N_DOCINFORECORD.DOCUMENTINFORECORDDOCTYPE == TDWO.DOKAR
  • ESH_N_DOCINFORECORD.MANDT == TDWO.MANDT