I_ServiceDocumentRefObject

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_ServiceDocumentRefObject.
-- 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_ServiceDocumentRefObject AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS ServiceDocument,
  number_int AS ServiceDocumentItem,
  counter AS ServiceRefObjectSequenceNumber,
  type_object AS ServiceReferenceObjectType,
  guid_object AS ServiceReferenceObjectUUID,
  product_id AS ProductID,
  main_object AS SrvcRefObjIsMainObject,
  product_guid AS ProductUUID,
  serial_number AS SerialNumber,
  equipment_id AS Equipment,
  functional_location_id AS FunctionalLocation,
  ref_product_id AS ReferenceProduct
FROM crms4d_refobj
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON ProductID = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_SrvcReferenceObjectType AS _SrvcReferenceObjectType ON ServiceReferenceObjectType = _SrvcReferenceObjectType.ServiceReferenceObjectType  -- association [1]
;