C_DocInfoRecd

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 C_DocInfoRecd.
-- 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: CCVDOCINFORECD

CREATE VIEW C_DocInfoRecd AS
SELECT
  _DocumentPart.DocumentDescription AS DocInfoRecdShortText,
  document.InternalDocumentStatus AS InternalDocumentStatus,
  _Indicators._IndicatorText.DeleteStatusDescription AS DeleteStatusDescription,
  _Indicators._IndicatorText.DocInfoRecdStrucDescription AS DocInfoRecdStrucDescription,
  _Indicators._IndicatorText.CADStatusDescription AS CADStatusDescription,
  Document._ChangedUserVH AS _ChangedUserVH,
  Document._CreatedUserVH AS _CreatedUserVH,
  Document._UserDetailsVH AS _UserDetailsVH
FROM I_DocInfoRecd AS document
LEFT OUTER JOIN I_DocInfoRecdDocumentType AS _DocumentType ON DocumentType = _DocumentType.DocumentType  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentPart AS _DocumentPart ON DocumentType = _DocumentPart.DocumentType AND DocumentPart = _DocumentPart.DocumentPart AND DocumentInfoRecord = _DocumentPart.DocumentInfoRecord AND DocumentVersion = _DocumentPart.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdStatusSearchHelp AS _DocumentStatusHelp ON ExternalDocumentStatus = _DocumentStatusHelp.ExternalDocumentStatus AND InternalDocumentStatus = _DocumentStatusHelp.InternalDocumentStatus  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentStatus AS _StatusText ON DocumentType = _StatusText.DocumentType AND InternalDocumentStatus = _StatusText.InternalDocumentStatus  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserDetails ON ResponsiblePersonName = _UserDetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDescription AS _DocumentDescription ON DocumentPart = _DocumentDescription.DocumentPart AND DocumentType = _DocumentDescription.DocumentType AND DocumentVersion = _DocumentDescription.DocumentVersion AND DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord AND DocInfoRecdShortText = _DocumentDescription.DocumentDescription  -- association [0..*]
LEFT OUTER JOIN C_DocInfoRecdObjectLink AS _ObjectLink ON DocumentPart = _ObjectLink.DocumentPart AND DocumentType = _ObjectLink.DocumentType AND DocumentVersion = _ObjectLink.DocumentVersion AND DocumentInfoRecord = _ObjectLink.DocumentInfoRecord  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecdDocumentTypeText AS _DocumentTypeText ON DocumentType = _DocumentTypeText.DocumentType  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecdLabOffice AS _LabOffice ON LaboratoryOrDesignOffice = _LabOffice.LaboratoryOrDesignOffice  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdAuthGroup AS _AuthGroup ON AuthorizationGroup = _AuthGroup.AuthorizationGroup  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdIndicatorStatus AS _Indicators ON DocumentType = _Indicators.DocumentType AND DocumentInfoRecord = _Indicators.DocumentInfoRecord AND DocumentVersion = _Indicators.DocumentVersion AND DocumentPart = _Indicators.DocumentPart  -- association [1..1]
;