C_DocumentInfoRecordTP

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_DocumentInfoRecordTP.
-- 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: CDOCINFRECD

CREATE VIEW C_DocumentInfoRecordTP AS
SELECT
  / Document.DocumentDescriptionForEdit AS DocumentDescriptionForEdit,
  Document._ChangedUser.UserDescription AS LastChangedByUserFullName,
  Document._UserDetails.UserDescription AS ResponsiblePersonFullName,
  _Desc[1: Language = $session.system_language].DocumentDescription AS DocumentDescription,
  Document._DocType._Text[1: Language = $session.system_language].DocumentTypeDescription AS DocumentTypeDescription,
  Document._DocStatus._Text[1: Language = $session.system_language].DocumentStatusName AS DocumentStatusName,
  Document._DocStatus._Text[1: Language = $session.system_language].ExternalDocumentStatus AS ExternalDocumentStatus,
  cast( '' as abap.numc( 1 )) AS Criticality,
  cast( '' as abap.numc(1)) AS CheckStatusCriticality,
  Document._Indicator._Text._CadStatusText[1: Language = $session.system_language].CADStatusDescription AS CADStatusDescription,
  Document._Indicator._Text._DeltnStatusText[1: Language = $session.system_language].DeleteStatusDescription AS DeleteStatusDescription,
  cast( Document.IsDocInfoRecdCreatedFromCAD as xfeld ) AS DocumentIsCreatedByCAD,
  cast( Document.DocInfoRecdIsMarkedForDeletion as xfeld ) AS DocInfoRecdIsDeleted,
  _LabOffice._Text[1: Language = $session.system_language].LaboratoryOrDesignOfficeName AS LaboratoryOrDesignOfficeName,
  Document._AuthGroup._Text[1: Language = $session.system_language].AuthorizationGroupName AS AuthorizationGroupName,
  cast ( 1 as ux_field_control preserving type) AS DescriptionProperty,
  cast ( 'X' as boole_d preserving type ) AS AutoClassificationIsEnabled,
  Document.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Document.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Document.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  Document.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Document.DocInfoRecdDocNumberForEdit AS DocInfoRecdDocNumberForEdit,
  Document.DocInfoRecdDocTypeForEdit AS DocInfoRecdDocTypeForEdit,
  Document.DocInfoRecdDocPartForEdit AS DocInfoRecdDocPartForEdit,
  Document.DocInfoRecdDocVersionForEdit AS DocInfoRecdDocVersionForEdit,
  Document.ExternalDocumentStatusForEdit AS ExternalDocumentStatusForEdit,
  Document.DocumentInfoRecord AS DocumentInfoRecord,
  Document.ChangedDateTime AS ChangedDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDateTime AS CreationDateTime,
  Document.ResponsiblePersonName AS ResponsiblePersonName,
  Document.DocInfoRecdSourceDocPart AS DocInfoRecdSourceDocPart,
  Document.DocInfoRecdSourceDocVersion AS DocInfoRecdSourceDocVersion,
  Document.IsDocInfoRecdStructure AS IsDocInfoRecdStructure,
  Document.DocInfoRecdSourceDocNumber AS DocInfoRecdSourceDocNumber,
  Document.InternalDocumentStatus AS InternalDocumentStatus,
  Document.IsDocInfoRecdCreatedFromCAD AS IsDocInfoRecdCreatedFromCAD,
  Document.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  Document.ClassificationSideEffect AS ClassificationSideEffect,
  Document.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  Document.AuthorizationGroup AS AuthorizationGroup,
  Document.ChangeNumber AS ChangeNumber,
  Document._ChangedUser AS _ChangedUser,
  Document._CreatedUser AS _CreatedUser,
  Document._UserDetails AS _UserDetails,
  Document._ChangedUserVH AS _ChangedUserVH,
  Document._CreatedUserVH AS _CreatedUserVH,
  Document._UserDetailsVH AS _UserDetailsVH,
  Document._DocNumber AS _DocNumber,
  Document._DocPart AS _DocPart,
  Document._DocType AS _DocType,
  Document._DocVersion AS _DocVersion,
  Document._Indicator AS _Indicator,
  Document._AuthGroup AS _AuthGroup,
  Document._LabOffice AS _LabOffice,
  Document._LogAccMObjectTypeActive AS _LogAccMObjectTypeActive,
  Document._LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn,
  Document._LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt
FROM I_DocumentInfoRecordTP AS Document
LEFT OUTER JOIN C_DocumentInfoRecordDescTP AS _Desc ON DocumentInfoRecordDocType = _Desc.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _Desc.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _Desc.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _Desc.DocumentInfoRecordDocPart  -- association [0..*]
LEFT OUTER JOIN C_DocumentInfoRecordObjLinkTP AS _ObjLink ON DocumentInfoRecordDocType = _ObjLink.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _ObjLink.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _ObjLink.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _ObjLink.DocumentInfoRecordDocPart  -- association [0..*]
LEFT OUTER JOIN C_DocumentInfoRecordVersion AS _DIRVersion ON DocumentInfoRecordDocType = _DIRVersion.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DIRVersion.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion <> _DIRVersion.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DIRVersion.DocumentInfoRecordDocPart  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordDocStatus AS _StatusText ON DocumentInfoRecordDocType = _StatusText.DocumentInfoRecordDocType AND InternalDocumentStatus = _StatusText.InternalDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordObjLinkVH AS _SAPObjectVH ON DocInfoRecdDocTypeForEdit = _SAPObjectVH.DocumentInfoRecordDocType AND _SAPObjectVH.LinkedSAPObject <> 'STKO_DOC'  -- association [0..*]
LEFT OUTER JOIN C_DocumentInfoRecordDelInd AS _CADValueHelp ON DocumentIsCreatedByCAD = _CADValueHelp.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN C_DocumentInfoRecordDelInd AS _DeletionValueHelp ON DocInfoRecdIsDeleted = _DeletionValueHelp.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocTypeT AS _DocTypeText ON DocInfoRecdDocTypeForEdit = _DocTypeText.DocumentInfoRecordDocType  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordDocTypeT AS _DocumentTypeText ON DocumentInfoRecordDocType = _DocumentTypeText.DocumentInfoRecordDocType  -- association [0..*]
LEFT OUTER JOIN C_ChangeMasterVH AS _ChangeMasterVH ON ChangeNumber = _ChangeMasterVH.ChangeNumber  -- association [0..1]
;