C_PCSrvcReqRcvdData

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_PCSrvcReqRcvdData.
-- 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: CPCSRRCVDDATA

CREATE VIEW C_PCSrvcReqRcvdData AS
SELECT
  PCSrvcReqRcvdDataUUID,
  ProdCmplncServiceRequestUUID,
  PCSrvcReqRcvdDataType,
  PCDataIntegSet,
  PCDataIntegSetType,
  LastChangeDateTime,
  cast( '' as cmplrqrsltprocessingstatusname ) AS CmplRqRsltProcessingStatusName,
  _CmplRqVersEnhanced.CmplRqPattern AS CmplRqPattern,
  _CmplRqVersEnhanced.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  CmplRqRsltUUID,
  cast( ' ' as pcdataintegsemnavigationobject preserving type ) AS PCDataIntegSemNavigationObject,
  cast( ' ' as pcdataintegsemnavigationaction preserving type ) AS PCDataIntegSemNavigationAction,
  cast( ' ' as pcdataintegsemnavgnkeyname preserving type ) AS PCDataIntegSemNavgnKeyName,
  PCDataIntegSetUUID
FROM P_PCSrvcReqRcvdData
LEFT OUTER JOIN I_PCDataIntegSetTypeText AS _PCDataIntegSetTypeText ON _PCDataIntegSetTypeText.PCDataIntegSetType = PCDataIntegSetType AND _PCDataIntegSetTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PCSrvcReqRcvdDataType AS _PCSrvcReqRcvdDataTypeText ON _PCSrvcReqRcvdDataTypeText.PCSrvcReqRcvdDataType = PCSrvcReqRcvdDataType AND _PCSrvcReqRcvdDataTypeText.Language = $session.system_language  -- association [0..1]
;