I_DocumentInfoRecordUserVH

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_DocumentInfoRecordUserVH.
-- 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: ICVDOCUSRVH

CREATE VIEW I_DocumentInfoRecordUserVH AS
SELECT
  document.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  document.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  document.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  document.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  document.ResponsiblePersonName AS ResponsiblePersonName,
  UserDetail.name_first AS FirstName,
  UserDetail.name_last AS LastName,
  RespUser.UserDescription AS ResponsiblePersonFullName,
  document.LastChangedByUser AS LastChangedByUser,
  ChangedUser.UserDescription AS LastChangedByUserFullName,
  RespUser.AddressPersonID AS PersonNumber
FROM P_DocumentInfoRecord AS document
LEFT OUTER JOIN I_User AS RespUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS ChangedUser ON /* join condition not captured in parsed metadata */
INNER JOIN adrp AS UserDetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecordDocTypeT AS _DocTypeText ON DocumentInfoRecordDocType = _DocTypeText.DocumentInfoRecordDocType  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordDocType AS _DocType ON DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocNumber AS _DocNumber ON DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocVersion AS _DocVersion ON DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion  -- association [1..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 [1..1]
;