C_ChgImpactMfgProcDefDet

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_ChgImpactMfgProcDefDet.
-- 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: CCHGIMPCTMPD

CREATE VIEW C_ChgImpactMfgProcDefDet AS
SELECT
  Document.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  Document.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  Document.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  Document.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  _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.DocInfoRecdIsMarkedForDeletion AS DocInfoRecdIsMarkedForDeletion,
  cast( Document.IsDocInfoRecdCreatedFromCAD as xfeld ) AS DocumentIsCreatedByCAD,
  cast( Document.DocInfoRecdIsMarkedForDeletion as xfeld ) AS DocInfoRecdIsDeleted,
  Document.CreatedByUser AS CreatedByUser,
  Document.ResponsiblePersonName AS ResponsiblePersonName,
  Document._UserDetails.UserDescription AS ResponsiblePersonFullName,
  Document.LastChangedByUser AS LastChangedByUser,
  Document._ChangedUser.UserDescription AS LastChangedByUserFullName,
  Document.CreationDateTime AS CreationDateTime,
  Document.ChangedDateTime AS ChangedDateTime,
  Document.AuthorizationGroup AS AuthorizationGroup,
  Document._ChangedUser AS _ChangedUser,
  Document._UserDetails AS _UserDetails,
  Document._DocType AS _DocType,
  Document._Indicator AS _Indicator,
  Document._DocStatus AS _DocStatus
FROM I_DocumentInfoRecord 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 I_DocumentInfoRecordDocTypeT AS _DocumentTypeText ON DocumentInfoRecordDocType = _DocumentTypeText.DocumentInfoRecordDocType  -- association [0..*]
;