I_DocumentInfoRecord

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 I_DocumentInfoRecord.
-- 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: ICVDOCINFOREC

CREATE VIEW I_DocumentInfoRecord AS
SELECT
  DocInfo.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  DocInfo.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  DocInfo.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  DocInfo.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  DocInfo.DocumentInfoRecord AS DocumentInfoRecord,
  DocInfo.DocumentInfoRecordDocKey AS DocumentInfoRecordDocKey,
  DocInfo.InternalDocumentStatus AS InternalDocumentStatus,
  _DocStatusVH.ExternalDocumentStatus AS ExternalDocumentStatus,
  DocInfo.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  DocInfo.Plant AS Plant,
  DocInfo.AuthorizationGroup AS AuthorizationGroup,
  DocInfo.ChangeNumber AS ChangeNumber,
  DocInfo.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  DocInfo.IsDocInfoRecdCreatedFromCAD AS IsDocInfoRecdCreatedFromCAD,
  DocInfo.IsDocInfoRecdStructure AS IsDocInfoRecdStructure,
  DocInfo.DocInfoRecdSourceDocNumber AS DocInfoRecdSourceDocNumber,
  DocInfo.DocInfoRecdSourceDocPart AS DocInfoRecdSourceDocPart,
  DocInfo.DocInfoRecdSourceDocVersion AS DocInfoRecdSourceDocVersion,
  DocInfo.ResponsiblePersonName AS ResponsiblePersonName,
  DocInfo.CreationDateTime AS CreationDateTime,
  DocInfo.CreatedByUser AS CreatedByUser,
  DocInfo.ChangedDateTime AS ChangedDateTime,
  DocInfo.LastChangedByUser AS LastChangedByUser,
  DocInfo.DocumentInfoRecordIsFrozen AS DocumentInfoRecordIsFrozen,
  _LogAccMObjSecureIDAssgmt_01._LogAccMSecureIDRepository.LogAccMSecureIDOwnerID AS LogAccMSecureIDOwnerID
FROM P_DocumentInfoRecord AS DocInfo
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocType ON DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocNumber AS _DocNumber ON DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocVersion AS _DocVersion ON DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocPrt AS _DocPart ON DocumentInfoRecordDocType = _DocPart.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _DocPart.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _DocPart.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocPart.DocumentInfoRecordDocVersion  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedUser ON CreatedByUser = _CreatedUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedUser ON LastChangedByUser = _ChangedUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _UserDetails ON ResponsiblePersonName = _UserDetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _CreatedUserVH ON DocumentInfoRecordDocType = _CreatedUserVH.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _CreatedUserVH.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _CreatedUserVH.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _CreatedUserVH.DocumentInfoRecordDocVersion AND CreatedByUser = _CreatedUserVH.ResponsiblePersonName  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _ChangedUserVH ON DocumentInfoRecordDocType = _ChangedUserVH.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _ChangedUserVH.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _ChangedUserVH.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _ChangedUserVH.DocumentInfoRecordDocVersion AND LastChangedByUser = _ChangedUserVH.LastChangedByUser  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _UserDetailsVH ON DocumentInfoRecordDocType = _UserDetailsVH.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _UserDetailsVH.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _UserDetailsVH.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _UserDetailsVH.DocumentInfoRecordDocVersion AND ResponsiblePersonName = _UserDetailsVH.ResponsiblePersonName  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDesc AS _DocDesc ON DocumentInfoRecordDocType = _DocDesc.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocDesc.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocPart = _DocDesc.DocumentInfoRecordDocPart AND DocumentInfoRecordDocVersion = _DocDesc.DocumentInfoRecordDocVersion  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordDocStatus AS _DocStatus ON DocumentInfoRecordDocType = _DocStatus.DocumentInfoRecordDocType AND InternalDocumentStatus = _DocStatus.InternalDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocStsVH AS _DocStatusVH ON DocumentInfoRecordDocType = _DocStatusVH.DocumentInfoRecordDocType AND InternalDocumentStatus = _DocStatusVH.InternalDocumentStatus  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordLbtryOffc AS _LabOffice ON LaboratoryOrDesignOffice = _LabOffice.LaboratoryOrDesignOffice  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordAuthznGrp AS _AuthGroup ON AuthorizationGroup = _AuthGroup.AuthorizationGroup  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordIndSts AS _Indicator ON DocumentInfoRecordDocType = _Indicator.DocumentInfoRecordDocType AND DocumentInfoRecordDocPart = _Indicator.DocumentInfoRecordDocPart AND DocumentInfoRecordDocNumber = _Indicator.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _Indicator.DocumentInfoRecordDocVersion  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordAccMActv AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_DIR'  -- association [0..1]
LEFT OUTER JOIN I_DocInfoRecordAccMSecIDAsgt AS _LogAccMObjSecureIDAssgmt ON DocumentInfoRecord = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_DIR'  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecordAccMSecIDAsgt AS _LogAccMObjSecureIDAssgmt_01 ON DocumentInfoRecordDocKey = _LogAccMObjSecureIDAssgmt_01.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt_01.LogAccMObjectType = 'PLM_DIR'  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordUAuthAccM AS _LogAccMObjectUserAuthzn ON DocumentInfoRecord = _LogAccMObjectUserAuthzn.LogAccMObjectID AND _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_DIR' AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_DIR' AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuthzn.UserID = $session.user )  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordUAuthAccM AS _LogAccMObjectUserAuth ON DocumentInfoRecordDocKey = _LogAccMObjectUserAuth.LogAccMObjectID AND _LogAccMObjectUserAuth.LogAccMObjectType = 'PLM_DIR' AND _LogAccMObjectUserAuth.LogAccMUserAuthznObject = 'PLM_DIR' AND ( _LogAccMObjectUserAuth.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuth.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuth.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuth.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuth.UserID = $session.user )  -- association [0..*]
;