I_ColltrlREPartDocument

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_ColltrlREPartDocument.
-- 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.

CREATE VIEW I_ColltrlREPartDocument AS
SELECT
  prt_doc_guid AS ColltrlREPartDocumentUUID,
  obj_prt_guid AS CollateralRealEstatePartUUID,
  part_id AS CollateralRealEstatePartID,
  doc_referenceid AS ColltrlDocumentReferenceNumber,
  doc_type AS CollateralDocumentType,
  doc_date AS CollateralDocumentDate,
  physical_locn AS CollateralDocPhysicalLocation,
  cast( substring(doc_valid_from, 2, 8 ) as cms_dte_date ) AS ColltrlDocumentValidFromDate,
  cast( substring(doc_valid_to, 2, 8 ) as cms_dte_date ) AS CollateralDocumentValidToDate,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  processing_src AS ColltrlRELastChangedSource
FROM cms_re_prt_doc
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstatePartUUID = _CollateralRealEstatePart.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralDocumentType AS _ColltrlRealEstatePartDocType ON CollateralDocumentType = _ColltrlRealEstatePartDocType.CollateralDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREPartDocPhysicalLoc ON CollateralDocPhysicalLocation = _ColltrlREPartDocPhysicalLoc.CollateralAttributeIndType AND _ColltrlREPartDocPhysicalLoc.CollateralAttributeIndCat = 'DOC001'  -- association [0..1]
;