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.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.DocumentDescriptionForEdit AS DocumentDescriptionForEdit,
  Document.ExternalDocumentStatusForEdit AS ExternalDocumentStatusForEdit,
  Document.DocumentInfoRecord AS DocumentInfoRecord,
  Document.ChangedDateTime AS ChangedDateTime,
  Document.LastChangedByUser AS LastChangedByUser,
  Document._ChangedUser.UserDescription AS LastChangedByUserFullName,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDateTime AS CreationDateTime,
  Document.ResponsiblePersonName AS ResponsiblePersonName,
  Document._UserDetails.UserDescription AS ResponsiblePersonFullName,
  Document.DocInfoRecdSourceDocPart AS DocInfoRecdSourceDocPart,
  Document.DocInfoRecdSourceDocVersion AS DocInfoRecdSourceDocVersion,
  Document.IsDocInfoRecdStructure AS IsDocInfoRecdStructure,
  Document.DocInfoRecdSourceDocNumber AS DocInfoRecdSourceDocNumber,
  _Desc[1: Language = $session.system_language].DocumentDescription AS DocumentDescription,
  Document._DocType._Text[1: Language = $session.system_language].DocumentTypeDescription AS DocumentTypeDescription,
  Document.InternalDocumentStatus AS InternalDocumentStatus,
  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.IsDocInfoRecdCreatedFromCAD AS IsDocInfoRecdCreatedFromCAD,
  Document._Indicator._Text._CadStatusText[1: Language = $session.system_language].CADStatusDescription AS CADStatusDescription,
  Document.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  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,
  Document.ClassificationSideEffect AS ClassificationSideEffect,
  Document.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  _LabOffice._Text[1: Language = $session.system_language].LaboratoryOrDesignOfficeName AS LaboratoryOrDesignOfficeName,
  Document.AuthorizationGroup AS AuthorizationGroup,
  Document._AuthGroup._Text[1: Language = $session.system_language].AuthorizationGroupName AS AuthorizationGroupName,
  Document.ChangeNumber AS ChangeNumber,
  cast ( 1 as ux_field_control preserving type) AS DescriptionProperty,
  cast ( 'X' as boole_d preserving type ) AS AutoClassificationIsEnabled,
  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]
;