R_SrvcDocItemDocumentFlow

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 R_SrvcDocItemDocumentFlow.
-- 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: RSRVCDOCFLWITM

CREATE VIEW R_SrvcDocItemDocumentFlow AS
SELECT
  ServiceDocument,
  ServiceDocumentItem,
  _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey AS CustMgmtPrdcssrTransactionKey,
  ServiceDocumentItmRelationUUID,
  _SrvcDocDocumentFlow.ServiceDocumentIsQuotation AS ServiceDocumentIsQuotation,
  ServiceObjectType,
  ServiceDocumentItemSuccessor,
  I_SrvcDocItmDocumentFlow.ReltdSrvcDocItemIsPredecessor AS ReltdSrvcDocItemIsPredecessor,
  _SrvcDocDocumentFlow.PrdcssrSuccssrDocObjectType AS PrdcssrSuccssrDocObjectType,
  _ServiceDocumentItemEnhcd.ServiceDocumentItemIsQuotation AS ServiceDocumentItemIsQuotation,
  _ServiceDocumentItemEnhcd.ServiceDocumentTemplateType AS ServiceDocumentTemplateType
FROM I_SrvcDocItmDocumentFlow
LEFT OUTER JOIN R_SrvcDocDocumentFlow AS _SrvcDocDocumentFlow ON ServiceDocumentItmRelationUUID = _SrvcDocDocumentFlow.ServiceDocumentRelationUUID AND ServiceDocument != _SrvcDocDocumentFlow.CustMgmtPrdcssrTransactionKey  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ServiceDocumentItemEnhcd ON ServiceDocumentItemSuccessor = _ServiceDocumentItemEnhcd.ServiceDocumentItemCharUUID  -- association [1..1]
;