ESH_N_DOCINFORECORD

DDL: ESH_N_DOCINFORECORD SQL: ESH_L_DOCINFOREC Type: view
62 Fields 1 Data Sources

ESH_N_DOCINFORECORD is a CDS View in SAP S/4HANA. It reads from 1 data source (I_DOCUMENTINFORECORDSRCHMODEL) and exposes 62 fields with key fields DOCUMENTINFORECORDDOCNUMBER, DOCUMENTINFORECORDDOCPART, DOCUMENTINFORECORDDOCTYPE, DOCUMENTINFORECORDDOCVERSION.

Data Sources (1)

SourceAliasJoin Type
I_DOCUMENTINFORECORDSRCHMODEL I_DOCUMENTINFORECORDSRCHMODEL from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KEYDATE SYDATE

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ESH_L_DOCINFOREC view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY DOCUMENTINFORECORDDOCNUMBER DOCUMENTINFORECORDDOCNUMBER Document
KEY DOCUMENTINFORECORDDOCPART DOCUMENTINFORECORDDOCPART Document Part
KEY DOCUMENTINFORECORDDOCTYPE DOCUMENTINFORECORDDOCTYPE Document Type
KEY DOCUMENTINFORECORDDOCVERSION DOCUMENTINFORECORDDOCVERSION Doc. Version
AUTHORIZATIONGROUP AUTHORIZATIONGROUP AuthorizGroup
AUTHORIZATIONGROUPNAME AUTHORIZATIONGROUPNAME
CADSTATUSDESCRIPTION CADSTATUSDESCRIPTION
CHANGEDBY CHANGEDBY User Name
CHANGEDDATETIME CHANGEDDATETIME Time Stamp
DOCUMENTINFORECORDCHANGENUMBER _CHANGEMASTER CHANGENUMBER Change Number
OBJECTLINKCHANGENUMBER
CHARACTERISTIC
CHARCDESCRIPTION
CHARCFROMNUMERICVALUE
CHARCINTERNALID
CHARCVALUE
CHARCVALUEDESCRIPTION
CLASSIFICATIONCLASS
CLASSDESCRIPTION
CLASSINTERNALID
CLASSKEYWORDTEXT
CLASSIFICATIONCLASSTYPE
CLFNSTATUS
CREATEDBYUSER CREATEDBYUSER User Name
CREATEDBYUSERDESCRIPTION CREATEDBYUSERDESCRIPTION Description
CREATIONDATE CREATIONDATE Time Stamp
DELETESTATUSDESCRIPTION DELETESTATUSDESCRIPTION
DOCINFORECDISMARKEDFORDELETION DOCINFORECDISMARKEDFORDELETION Deletion ind.
DOCINFORECDRESERVEFIELD1 _DOCUMENTINFORECORDRESERVE DOCINFORECDRESERVEFIELD1
DOCINFORECDRESERVEFIELD2 _DOCUMENTINFORECORDRESERVE DOCINFORECDRESERVEFIELD2
DOCINFORECDRESERVEFIELD3 _DOCUMENTINFORECORDRESERVE DOCINFORECDRESERVEFIELD3
DOCINFORECDRESERVEFIELD4 _DOCUMENTINFORECORDRESERVE DOCINFORECDRESERVEFIELD4
DOCUMENTDESCRIPTION DOCUMENTDESCRIPTION Doc. Name
DOCUMENTINFORECORD DOCUMENTINFORECORD Document
DOCUMENTINFORECORDSTSFILELGDTE _DOCUMENTINFORECORDSTSLOG DOCUMENTINFORECORDSTSFILELGDTE
DOCUMENTSTATUSNAME DOCUMENTSTATUSNAME Status Text
DOCUMENTTYPEDESCRIPTION DOCUMENTTYPEDESCRIPTION
EXTERNALDOCUMENTSTATUS EXTERNALDOCUMENTSTATUS Status
FILEDESCRIPTION _DOCINFORECDATTCHCNTNTWTHDESC FILEDESCRIPTION Description
FILENAME _DOCINFORECDATTCHCNTNTWTHDESC FILENAME URL or Filenam Path
INTERNALDOCUMENTSTATUS INTERNALDOCUMENTSTATUS Status
ISDOCINFORECDCREATEDFROMCAD ISDOCINFORECDCREATEDFROMCAD CAD Indicator
LABORATORYORDESIGNOFFICE LABORATORYORDESIGNOFFICE Lab/Office
LABORATORYORDESIGNOFFICENAME LABORATORYORDESIGNOFFICENAME
LASTCHANGEDBYUSERDESCRIPTION LASTCHANGEDBYUSERDESCRIPTION Description
LINKEDSAPOBJECT _DOCINFORECORDOBJLINKADDLINFO LINKEDSAPOBJECT Object
LINKEDSAPOBJECTKEY _DOCINFORECORDOBJLINKADDLINFO LINKEDSAPOBJECTKEY SAP Object Key
LOGACCMCONTEXT LOGACCMCONTEXT
PHYSDOCCNTNTTEXT _DOCINFORECDATTCHCNTNTWTHDESC PHYSDOCCNTNTTEXT
OBJECTLINKLONGTEXT
PLANT PLANT Valuation Area
PLANTNAME _PLANT PLANTNAME Plant Name
RECIPE
RESPONSIBLEPERSONNAME RESPONSIBLEPERSONNAME User
SPECIFICATION
STORAGECATEGORY _DOCINFORECDATTCHCNTNTWTHDESC STORAGECATEGORY Category
USERDESCRIPTION USERDESCRIPTION Full Name
CHARACTERISTICENDDATE
CLASSIFICATIONENDDATE
CHARACTERISTICSTARTDATE
CLASSIFICATIONSTARTDATE
WORKSTATIONAPPLICATION _DOCINFORECDATTCHCNTNTWTHDESC WORKSTATIONAPPLICATION Applic.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_DOCINFORECORD.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_DOCINFOREC
-- Parameters: P_Language : abap.lang, P_KEYDATE : SYDATE

CREATE VIEW ESH_N_DOCINFORECORD AS
SELECT
  DOCUMENTINFORECORDDOCNUMBER,
  DOCUMENTINFORECORDDOCPART,
  DOCUMENTINFORECORDDOCTYPE,
  DOCUMENTINFORECORDDOCVERSION,
  AUTHORIZATIONGROUP,
  AUTHORIZATIONGROUPNAME,
  CADSTATUSDESCRIPTION,
  CHANGEDBY,
  CHANGEDDATETIME,
  _CHANGEMASTER.CHANGENUMBER AS DOCUMENTINFORECORDCHANGENUMBER,
  _DOCINFORECORDOBJLINKADDLINFO._CHANGEMASTEROBJLINK.CHANGENUMBER AS OBJECTLINKCHANGENUMBER,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE).CHARACTERISTIC AS CHARACTERISTIC,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICDESC(P_KEYDATE : $parameters. P_KEYDATE)[1: LANGUAGE = $parameters. P_Language].CHARCDESCRIPTION AS CHARCDESCRIPTION,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMNUMERICVALUE AS CHARCFROMNUMERICVALUE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCINTERNALID AS CHARCINTERNALID,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCVALUE AS CHARCVALUE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICVALUE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICVALUEDESC(P_KEYDATE : $parameters. P_KEYDATE)[1: LANGUAGE = $parameters. P_Language].CHARCVALUEDESCRIPTION AS CHARCVALUEDESCRIPTION,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE).CLASS AS CLASSIFICATIONCLASS,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE)._CLASSDESCRIPTION(P_KEYDATE : $parameters. P_KEYDATE)[1: LANGUAGE = $parameters. P_Language].CLASSDESCRIPTION AS CLASSDESCRIPTION,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CLASSINTERNALID AS CLASSINTERNALID,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE)._CLASSKEYWORD(P_KEYDATE : $parameters. P_KEYDATE)[1: LANGUAGE = $parameters. P_Language].CLASSKEYWORDTEXT AS CLASSKEYWORDTEXT,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE).CLASSTYPE AS CLASSIFICATIONCLASSTYPE,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CLFNSTATUS AS CLFNSTATUS,
  CREATEDBYUSER,
  CREATEDBYUSERDESCRIPTION,
  CREATIONDATE,
  DELETESTATUSDESCRIPTION,
  DOCINFORECDISMARKEDFORDELETION,
  _DOCUMENTINFORECORDRESERVE.DOCINFORECDRESERVEFIELD1 AS DOCINFORECDRESERVEFIELD1,
  _DOCUMENTINFORECORDRESERVE.DOCINFORECDRESERVEFIELD2 AS DOCINFORECDRESERVEFIELD2,
  _DOCUMENTINFORECORDRESERVE.DOCINFORECDRESERVEFIELD3 AS DOCINFORECDRESERVEFIELD3,
  _DOCUMENTINFORECORDRESERVE.DOCINFORECDRESERVEFIELD4 AS DOCINFORECDRESERVEFIELD4,
  DOCUMENTDESCRIPTION,
  DOCUMENTINFORECORD,
  _DOCUMENTINFORECORDSTSLOG.DOCUMENTINFORECORDSTSFILELGDTE AS DOCUMENTINFORECORDSTSFILELGDTE,
  DOCUMENTSTATUSNAME,
  DOCUMENTTYPEDESCRIPTION,
  EXTERNALDOCUMENTSTATUS,
  _DOCINFORECDATTCHCNTNTWTHDESC.FILEDESCRIPTION AS FILEDESCRIPTION,
  _DOCINFORECDATTCHCNTNTWTHDESC.FILENAME AS FILENAME,
  INTERNALDOCUMENTSTATUS,
  ISDOCINFORECDCREATEDFROMCAD,
  LABORATORYORDESIGNOFFICE,
  LABORATORYORDESIGNOFFICENAME,
  LASTCHANGEDBYUSERDESCRIPTION,
  _DOCINFORECORDOBJLINKADDLINFO.LINKEDSAPOBJECT AS LINKEDSAPOBJECT,
  _DOCINFORECORDOBJLINKADDLINFO.LINKEDSAPOBJECTKEY AS LINKEDSAPOBJECTKEY,
  LOGACCMCONTEXT,
  _DOCINFORECDATTCHCNTNTWTHDESC.PHYSDOCCNTNTTEXT AS PHYSDOCCNTNTTEXT,
  _DOCINFORECORDOBJLINKADDLINFO._TEXTOBJECTPLAINLONGTEXT[1: LANGUAGE = $parameters. P_Language].PLAINLONGTEXT AS OBJECTLINKLONGTEXT,
  PLANT,
  _PLANT.PLANTNAME AS PLANTNAME,
  _DOCINFORECORDOBJLINKADDLINFO._RECIPEFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).RECIPE AS RECIPE,
  RESPONSIBLEPERSONNAME,
  _DOCINFORECORDOBJLINKADDLINFO._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS SPECIFICATION,
  _DOCINFORECDATTCHCNTNTWTHDESC.STORAGECATEGORY AS STORAGECATEGORY,
  USERDESCRIPTION,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).VALIDITYENDDATE AS CHARACTERISTICENDDATE,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).VALIDITYENDDATE AS CLASSIFICATIONENDDATE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).VALIDITYSTARTDATE AS CHARACTERISTICSTARTDATE,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).VALIDITYSTARTDATE AS CLASSIFICATIONSTARTDATE,
  _DOCINFORECDATTCHCNTNTWTHDESC.WORKSTATIONAPPLICATION AS WORKSTATIONAPPLICATION
FROM I_DOCUMENTINFORECORDSRCHMODEL
;

Learn More