C_ProdCmplncServiceRequest

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_ProdCmplncServiceRequest.
-- 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: CPRODCMPLSERVREQ

CREATE VIEW C_ProdCmplncServiceRequest AS
SELECT
  ServiceRequest.ProdCmplncServiceRequestUUID AS ProdCmplncServiceRequestUUID,
  ServiceRequest.ProdCmplncServiceRequestType AS ProdCmplncServiceRequestType,
  ServiceRequest._ProdCmplncSrvcReqType._Text[1: Language = $session.system_language].ProdCmplncSrvcReqTypeName AS ProdCmplncSrvcReqTypeName,
  ServiceRequest.ProdCmplncServiceRequestOrigin AS ProdCmplncServiceRequestOrigin,
  ServiceRequest._ProdCmplncSrvcReqOrigin._Text[1: Language = $session.system_language].ProdCmplncSrvcReqOriginName AS ProdCmplncSrvcReqOriginName,
  ServiceRequest.ProdCmplncServiceRequestStatus AS ProdCmplncServiceRequestStatus,
  ServiceRequest._ProdCmplncSrvcReqStatus._Text[1: Language = $session.system_language].ProdCmplncSrvcReqStatusName AS ProdCmplncSrvcReqStatusName,
  ServiceRequest.ProdCmplncSrvcReqExtStatus AS ProdCmplncSrvcReqExtStatus,
  ServiceRequest._ProdCmplncSrvcReqExtStatus._Text[1: Language = $session.system_language].ProdCmplncSrvcReqExtStatusName AS ProdCmplncSrvcReqExtStatusName,
  ServiceRequest._ProdCmplncSrvcReqExtStatus.ProdCmplncSrvcReqExtStsCritlty AS ProdCmplncSrvcReqExtStsCritlty,
  ServiceRequest.ProdCmplncSrvcReqFailureReason AS ProdCmplncSrvcReqFailureReason,
  ServiceRequest._ProdCmplncSrvcReqFailureRsn._Text[1: Language = $session.system_language].ProdCmplncSrvcReqFailureRsnLbl AS ProdCmplncSrvcReqFailureRsnLbl,
  ServiceRequest.LastChangeDateTime AS LastChangeDateTime,
  ServiceRequest.CreatedByUser AS CreatedByUser,
  ServiceRequest.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  ServiceRequest.SubstanceUUID AS SubstanceUUID,
  ServiceRequest.ProdCmplncProductOrCompName AS ProdCmplncProductOrCompName,
  ServiceRequest.SubstanceInternalName AS SubstanceInternalName,
  ServiceRequest.ProdCmplncServiceRequestNote AS ProdCmplncServiceRequestNote,
  ServiceRequest.CASNumber AS CASNumber,
  ServiceRequest.ECNumber AS ECNumber,
  cast( '' as prodcmplncsrvcreqchgisneeded preserving type ) AS ProdCmplncSrvcReqChgIsNeeded,
  _CreatedByUserContactCard.LastName AS LastName,
  _CreatedByUserContactCard.FirstName AS FirstName,
  ServiceRequest._ProdCmplncSrvcReqType AS _ProdCmplncSrvcReqType,
  ServiceRequest._ProdCmplncSrvcReqOrigin AS _ProdCmplncSrvcReqOrigin,
  ServiceRequest._ProdCmplncSrvcReqStatus AS _ProdCmplncSrvcReqStatus,
  ServiceRequest._ProdCmplncSrvcReqExtStatus AS _ProdCmplncSrvcReqExtStatus,
  ServiceRequest._ProdCmplncSrvcReqFailureRsn AS _ProdCmplncSrvcReqFailureRsn
FROM I_ProdCmplncServiceRequest AS ServiceRequest
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChemicalComplianceInfo ON _ChemicalComplianceInfo.ChmlCmplncInfoUUID = ServiceRequest.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_Substance AS _Substance ON _Substance.SubstanceUUID = ServiceRequest.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncSrvcReqSendData AS _ProdCmplncSrvcReqSendData ON _ProdCmplncSrvcReqSendData.ProdCmplncServiceRequestUUID = ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqFailureReasonReq AS _PCSrvcReqFailureReasonReq ON _PCSrvcReqFailureReasonReq.ProdCmplncServiceRequestUUID = ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqReqSftyDataSht AS _PCSrvcReqReqSftyDataSht ON ProdCmplncServiceRequestUUID = _PCSrvcReqReqSftyDataSht.ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_PCSrvcReqRcvdData AS _PCSrvcReqRcvdData ON ProdCmplncServiceRequestUUID = _PCSrvcReqRcvdData.ProdCmplncServiceRequestUUID  -- association [0..*]
LEFT OUTER JOIN C_ProdCmplncServiceRequestProd AS _RecentProductData ON ChmlCmplncInfoUUID = _RecentProductData.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ProdCmplncServiceReqSubst AS _RecentPrivateSubstanceData ON SubstanceUUID = _RecentPrivateSubstanceData.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
;