P_WorkViewCmplncDataUnion

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 P_WorkViewCmplncDataUnion.
-- 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 P_WorkViewCmplncDataUnion AS
SELECT
  ChmlCmplncInfoUUID,
  ChmlCmplncInfoProperty.PCPrptyNavgnLinkUUID AS ComplianceDataNavgnLinkUUID,
  cast (' ' as ehfnd_legal_area preserving type ) AS ProdCmplncLegalArea,
  cast (hextobin('00000000000000000000000000000000') as ehfnd_crv_uuid) AS CmplRqVersUUID,
  cast ('' as ehfnd_req_identifier) AS ComplianceRequirement,
  cast('' as ehfnd_crr_crv_name) AS CmplRqVersName,
  ChmlCmplncInfoProperty.PCPrptyRootType AS PCPrptyRootType,
  cast (' ' as ehfnd_cci_ccmps_type preserving type ) AS ChmlCompositionType,
  cast (' ' as abap.char( 30 ) ) AS CmplRqPattern,
  ChmlCmplncInfoProperty.PCPrptyInProcProcgSts AS PCPrptyInProcProcgSts,
  ChmlCmplncInfoProperty.PCPrptyReldProcgSts AS PCPrptyReldProcgSts,
  cast (' ' as ehfnd_crr_proc_status) AS ProcessingStatus,
  cast('' as ehpma_processor_name ) AS ProcessorUserName,
  ChmlCmplncInfoProperty._ReleasedByUser.PersonFullName AS ReleasedByUserName,
  ChmlCmplncInfoProperty.WorkViewGroupName AS WorkViewGroupName,
  ChmlCmplncInfoProperty.WorkView AS WorkView,
  ChmlCmplncInfoProperty.WorkViewUUID AS WorkViewUUID,
  PCPrptySequence
FROM P_ChmlCmplncInfoProperty AS ChmlCmplncInfoProperty
-- UNION with additional select branch(es): P_ChmlCmplncInfoComposition, P_ChmlCmplncInfoAssmt
;